Status report: consultancy team, week 44, 2025

Caolan

Mike

  • DOCX Document that fails to convert to ODT

    • Need to finish
  • Nondeterministic result when saving ODG as PNG with Win 11 24H2

    • A very strange problem, related to GDI’s anti-aliasing
  • Windows Explorer Document Preview

    • Checked the implementation of CSOActiveX, read documentation
    • Estimated
  • Some regressions

    • Writer layout fixes never go without a regression: tdf#166871 caused tdf#169158; in fact, it only revealed pre-existing bug

Tomaz

Calc: Pre-View Spreadsheet Filtering

  • Working on resorting again
    • Check the auto filter and store the sorting only if the auto-filter is sorted
    • Added tests cases for this
  • Call with Michael regarding tile invalidation
    • We don’t change the sheets when changing to a sheet view, just use another sheet to hold the data
      • this is a problem for the invalidations, because the content of a sheet view can differ a lot to the default sheet or between sheet views
      • but we can’t communicate properly distinguish between sheet views and default view - we assume it’s the same
    • Agreed to change approach here - will abandon sheet views on ViewData level, and instead do it in UI (better approach down the road)
    • So a sheet view will change the sheet in the background to another sheet associated with the sheet view, but pretend on the UI to still be the original sheet
    • This should avoid tile invalidation issue, but the code needs to be rewritten now
  • COOL UI
    • looked a bit why the CI fails, maybe unrelated but
    • eventually it did pass
    • got the change in so the sheet views are in as experimental

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

  • Interesting case of a pivot table - has a field “Months”, which is automatically added in MSO for a date field
    • But the data in the sheet doesn’t exist, so we run completely from cache
    • We try to access the Month field but it’s not in LO cache, so this was crashing
    • For PT Format we need the information, so need to find a better way
    • Maybe good to properly implement reading from OOXML pivot table cache
    • But a quick fix is to just skip pivot table format in such cases - would still show the pivot table data correctly just like before

Miklos

Worked on 168916 – Fileopen DOCX: cannot open file with tables