Status report: consultancy team, week 46, 2025

Caolan

Mike

  • Conversion failure: Writer hangs opening ooo82423-1.doc, floating-table-related

    • “Regression” related to floating tables, bisected
    • Debugged
    • Paused
  • Preview and print orientation are incorrect (Portrait instead of Landscape) after choosing another printer destination.

    • Reproduced, replied
  • LibreOffice writer inserting page breaks

    • Regression, bisected
    • Caused by recalculation in SwLayAction::FormatLayout, (re)introduced and updated by a long series of changes … many bugs involved
    • Related to a very awkward SwMovedFwdFramesByObjPos mechanics, that prevent text frames from moving back if moved forward by anchored objects, even when the space on the previous page has cleared
    • The problem is, that the object, when it was on previous page, somehow made incomplete layout of previous frames, so that two different frames got very high because of it, instead of only one - likely because of incomplete layout; that made the object not fit on the page, and move to next; and that isn’t reverted
    • My ideas where to insert removal of “moved by object positioning” flag, led to layout loops
    • Considering now a full re-layout in case the action caused a change in the document’s “moved by object positioning” list …
    • On it
  • Upstream

    • tdf#127675 - reviewed / finished Biff12 support

Tomaz

Calc: Pre-View Spreadsheet Filtering

  • Nothing again this week
  • Rebased the patches for remembering sorting - probably good to integrate this now

XLSX with pivot table fails to open in Calc (regression)

  • Fixed the crash by checking if a dimension actually exists in the vector (not to access it when it ctually doesn’t exist)
    • check the size before and don’t continue with determining the string values, which probably makes PT format not work
  • Digged deeper using the new debug tools that store the pivot table info as an xml and found that the names are present but in a group
    • added a way to get the values from the groupand now it should work as expected
  • Added a test - check opening of the bug document
    • it shouldn’t crash
  • Prepared a patch and it was merged into 25.04
    • but some more issues were found with different documents - looking into it
  • Other unrelated Pivot Table issues:
    • We need to read the whole Pivot Table cache form OOXML
      • The source data isn’t needed by (because it is removed or it’s externally accessible) the pivot table, and the pivot table should still function properly
        • changing the PT layout
      • We don’t support this and we probably need to implement it
      • There is no way to pre-fill the cache currently - this is needed to make this work. But will not tackle this now…
    • Quickly looked into pivot table styles support
      • We could easily add support for this and make pivot tables look better
        • we need to implement the setting the attributes for cells in the ScDPOutput according to the style
      • The style is always using a name (i.e. “PivotTableStyleLight2”)
        • style is not actually defined, how the pivot table should look like is then a convention.
        • style has additional 5 attributes - row or column banding on/off, row/column header
      • We stored the Pivot Table style information in a GrabBag
        • changed that to have a struct - now it’s stored and accessible inside the ScDPObject

Miklos

Worked on: