Status report: consultancy team, week 25, 2025

Mike

  • Tracked Changes Extraction (Who, What, When) for Writer
    • Documentation prepared
  • Review mode
    • Made required core-side changes (commit c4f3d75567d5664259e01ff14a75e6f3e952ac9a)
    • Prepared Online-side changes (PR#12198)

Tomaz

Calc: Pre-View Spreadsheet Filtering

  • Refactored the access to filtered and hidden cols/rows, so they are more contained (outside ScTable)
  • Checked what the best architecture would be to store the “Sheet View”
    • Looking at the implementation in Excel I like how separated it is from the actual “view”
    • You can create new “Sheet views” but they aren’t bound to your view
  • you just happen to have your view associated to a “sheet view”.
    • Doing the same thing essentially - created a sc::SheetView class and a sc::SheetViewManager which are stored in ScTable
      • This way if a ScTable is removed - so are all SheetViews
    • But then the only association that a view needs to store is which SheetView the table is using.
    • Finally have a good plan in mind
  • Added a function to create a new “SheetView”
  • There is also Sorting that is view dependent in Excel
    • This makes it more complicated - you can sort but main view not (or vice versa)
    • If you change a cell in your view, it changes the differently sorted data in main view
    • We will need to remember how the cells got sorted, which is not trivial
    • Not even making a ScTable clone will help with this issue
    • Will address this once we have filters working
    • We can still make views read-only if they are sorted (in a worst case scenario)

Miklos

Worked on: