Summary: | Hiding rows or columns in Calc causes severe lag | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | lunarsoulschain |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | CC: | buzea.bogdan, miguelangelrv |
Priority: | medium | ||
Version: | 7.4.0.3 release | ||
Hardware: | All | ||
OS: | Windows (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 115930, 136524 | ||
Attachments: | A Calc spreadsheet with columns AA-onward hidden |
Description
lunarsoulschain
2024-04-29 00:58:47 UTC
Please test in safe mode, Menu/Help/Restart in Safe Mode Please attach a sample file. Created attachment 193900 [details]
A Calc spreadsheet with columns AA-onward hidden
(In reply to m_a_riosv from comment #1) > Please test in safe mode, Menu/Help/Restart in Safe Mode > > Please attach a sample file. Testing in Safe Mode produced the same results. I have attempted to create and attach a suitable sample file. Seems a bit slower than without them Version: 7.6.6.3 (X86_64) / LibreOffice Community Build ID: d97b2716a9a4a2ce1391dee1765565ea469b0ae7 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded almost imperceptible with Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: ea43cbbb7371a743f470d949762a0e92f196e652 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded and Version: 24.2.2.2 (X86_64) / LibreOffice Community Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: default; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded I have mentioned this behavior in other reports. STR: 1. Open attachment 193900 [details]. 2. [CTRL]+[HOME]. 3. During 10 seconds, press and hold the [PageDown] key. 4. At the 10 seconds stopper/timer, release the [PageDown] key and take note of the row number of the active cell. 5. Select All cells – click the area at the intersection between Column headers and Row headers. 6. Menu Format > Columns > Show. Now we repeat the procedure: 7. [CTRL]+[HOME]. 8. During 10 seconds, press and hold the [PageDown] key. 9. At the 10 seconds stopper/timer, release the [PageDown] key and take note of the row number of the active cell. Now compare the row numbers, between step 4 and step 9. For me, the current ratio is around 1:8 approximately. So, without having hidden columns at the "end" of the worksheet (inactive area), Calc scrolls 7/8 times faster than when I have the inactive area hidden. A similar test can be performed when having the "inactive" rows as hidden instead of hidden columns. Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: ea43cbbb7371a743f470d949762a0e92f196e652 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL threaded |