Description: When rows or columns are hidden in Calc, if the end of the sheet is visible onscreen, the entire sheet lags out tremendously. Scrolling and input are nearly impossible. This lag has gotten to the point where I cannot use some larger sheets at all because the rows or columns were hidden before this problem began. If one such sheet is open along with another Calc window, both spreadsheets are affected. Steps to Reproduce: 1. Create a new Calc spreadsheet 2. Hide enough columns or rows that the end of the sheet is visible onscreen Actual Results: Scrolling (both vertical and horizontal) and input lag immediately affect the spreadsheet Expected Results: Scrolling and input should have no lag Reproducible: Always User Profile Reset: No Additional Info: Version: 7.6.5.2 (X86_64) / LibreOffice Community Build ID: 38d5f62f85355c192ef5f1dd47c5c0c0c6d6598b CPU threads: 12; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded
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