https://bugs.documentfoundation.org/show_bug.cgi?id=172023
Bug ID: 172023
Summary: Column/Row Highlighting of active cell causes
extremely slow sheet navigation in cell storage with
rep-cells far past logical used range
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 206995
--> https://bugs.documentfoundation.org/attachment.cgi?id=206995&action=edit
Reproduction ODS file
Open the attached .ODS and navigate around with arrows/PgUP/PgDn.
Calc's GUI and UNO API both report a sane used range in the test file:
ScCellCursor.gotoEndOfUsedArea returns column 10, row 9960; Ctrl+End lands on
K9962. Yet content.xml carries trailing `<table:table-cell
table:number-columns-repeated="N"/>` runs on most rows that extend out to
column XFD (16,383). The total stored cell footprint was 158 million cells
across 9962 rows, of which only ~55,000 had real data.
With Tools → Options → LibreOffice Calc → View → "Highlight column/row of
selected cells" enabled, arrow-key navigation produces visibly delayed
column/row highlight overlay redraws. Each cursor movement takes hundreds of
ms. Also, opening the file appeared ~50% slower than after trimming the
trailing rep-cells past the last column with real data on each row.
Trimming trailing empty rows past the last data row didn't seem to affect perf.
Workaround:
1. Click the Name Box in the top-left
2. Type `L1:XFD9962` and press Enter. The selection jumps to the empty trailing
range even though Ctrl+End cannot reach it and the GUI doesn't normally
consider it part of the used range.
3. Press Ctrl+M (Format → Clear Direct Formatting).
Compounding issue: toggling View → Comments parked draw-shape connector lines
WAY farther down the file and froze their positions on save. Even after
deleting all comments, row-record artifacts persisted. I can submit an
intermediate file obtained during a
https://wiki.documentfoundation.org/WikiAction/history/QA/Bugzilla/Sanitizing_Files_Before_Submission
pass to reproduce this if interested.
Affected build: LibreOfficeDev/26.8.0.0.alpha0 Linux_X86_64,
LibreOffice_project/5c49e021ac7cfbb82eb7197746e3b51008d23a45 (also reproduces
on stable 26.2.2.2).
--
You are receiving this mail because:
You are the assignee for the bug.
