Description: Even in the new version 7.1.0.3 save command is very very slow. When I try to save my spreadsheet, the program inform that "not responding" and I have to wait half a minute before the file is saved. OS Windows 10 Home 64 bit, version 20H2, 19042.844. Actual Results: Whenever I add new data and try to save the file, this happens Expected Results: I have to wait almost half minute Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: fi Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no
Created attachment 170342 [details] Accounting
confirm some delay in Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: d8ed3bda462b351d2b98ec57cfdb879e0eec0010 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL
Luboš Luňák committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/9c7f3ddf5b3c23de0fed08fa3ebdfa2a95fec588 optimize XclExpRowBuffer::GetOrCreateRow() (tdf#140893) It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Go to second sheet, hit Ctrl+End and you'll find the document has a value in the last row.
Ctrl+End and Ctrl+left afterwards, anyway.
*** Bug 95346 has been marked as a duplicate of this bug. ***
I see it reasonably fast now, maybe from 16 to 8 seconds.