Status report: consultancy team, week 9, 2026

Status reports
1

Caolan

Mike

  • Crash when changing table cell background color in Collabora Office Impress 25.4.x

    • More cases of incorrect VclPtr usage found and fixed

  • Preview and print orientation are incorrect (Portrait instead of Landscape) after choosing another printer destination.

    • They reported it’s still unfixed
    • Found another problem, using the new testcase
    • The “use settings from dialog” feature introduced in Making sure you're not a bot! is highly problematic
    • Created a change (not using “settings from dialog” when using automatic orientation; could also be problematic - asked Tibor to review)

  • TTT (gave a talk on VclPtr)

Tomaz

Calc: Pre-View Spreadsheet Filtering

  • Fixed OverwriteContent, so it handles tab relative (and absolute) references correctly
    • In Calc it is possible to have relative tab references
      • For example “=Sheet1.A1” is a relative tab reference and “$Sheet1.A1” would be an absolute one
      • Not supported in MSO - all are absolute
    • So the issue is when ding OverwriteContent, the relative reference have to be changed
      • If you have a value in Tab0.A1 and Tab3.A1 and you use in Tab1 this values in a formula (=Tab0.A1 + Tab3.A1 for example)
      • In Tab0 would be written as relative ref -1 and Tab3 would be +2
      • If you run OverwriteContent Tab1 to Tab2 the relative references would be copied unmodified
      • So in Tab2 the reference would point to -1 = Tab1 and to +2 Tab4 if it exists - this is a problem
      • We need to modify the relative references to point to correct tabs
    • Added tests for OverwriteContent tab references
    • Added same tests for CopyTab, which shares the content with OverwriteContent
      • Found an issue with CopyTab referencing to a backward reference
      • With CopyTab it’s a similar scenario
      • Tab0.A1 and Tab2.A1 are cells with a value - again in Tab1 =Tab0.A1 + Tab2.A1
      • You copy Tab1 into a new tab - Tab1_1, so now the relative references in Tab1 and Tab1_1 need to be adjusted + the absolute references
      • In this scenario Tab0.A1 relative reference was not adjusted
      • Fixed that
  • Removed redirection in ViewData
    • Now all the sheet views are just tabs with some additional meta-data
    • Invalidation doesn’t need to be specially handled anymore
    • Only thing is on the UI we need to do the hiding and showing of the correct tabs when you add / switch to sheet views
  • Import and Export almost fully done
    • Can load and save the sheet view specific sort and filter data
  • Removed obsolete functionality
    • No more going to previous / next sheet view
    • We have the combo box to select the sheet view, so this is not needed anymore

Miklos

Worked on: