# Status report: consultancy team, week 25, 2025

**URL:** <https://forum.collaboraonline.com/t/status-report-consultancy-team-week-25-2025/3799>\
**Category:** Status reports\
**Created:** [June 25, 2025, 1:53pm UTC](https://forum.collaboraonline.com/t/status-report-consultancy-team-week-25-2025/3799 "2025-06-25T13:53:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![vmiklos](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.collaboraonline.com/vmiklos/32/787_2.png) [@vmiklos](https://forum.collaboraonline.com/u/vmiklos)\
**Post date:** [June 25, 2025, 1:53pm UTC](https://forum.collaboraonline.com/t/status-report-consultancy-team-week-25-2025/3799/1 "2025-06-25T13:53:59Z")

</div>

# 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:

- [166319 – Interdependent change tracking improvements](https://bugs.documentfoundation.org/show_bug.cgi?id=166319)
- [167044 – RTF import: bad image size inside shape](https://bugs.documentfoundation.org/show_bug.cgi?id=167044)