https://bugs.documentfoundation.org/show_bug.cgi?id=125619
--- Comment #31 from Buovjaga <[email protected]> --- (In reply to b. from comment #22) > Created attachment 165379 [details] > file with macro to test 'comment performance' in LO calc, > > it gets better gradually, but the processing of comments in calc is still a > huge problem, > > i have attached a sheet with a small macro, it should be self-explanatory, > fresh loaded you likely have to activate the form control toolbar via [view > - toolbars - form controls] and deactivate 'edit mode' there, otherwise the > macro button won't work, > > with '1' and '0' in A2 and A3 you can time the generation of 10.000 cells > without comments, and with '1' and '1' the time for the same with comments, > > with higher numbers in A2 more cells are created and it takes longer, > > i find that 1 second for 150.000 and 4 seconds for 2.000.000 cells without > comments, compared to 411 seconds for 150.000 cells with comments, shows > that the handling of comments in calc is still 'not very effective' ... > > the problem gets much worse after the first (auto-)save, the memory usage is > more than doubled after that, maybe this is an indication, > > similar delays occur in the handling of 'normal' files with many comments, > to one of the many threads about it someone had attached a Lenovo article > list with 25.000 comments, useless for everyday work :-( I don't observe a delay or abnormal memory use. b.: can you test again with latest master? Btw. to run the macro, I had to change commas to semicolons in time formats like: lKey = oNumberFormats.queryKey("HH:MM:SS;00", oLocalSettings , true) Arch Linux 64-bit Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 5effa8d0977ac9ce13a8e66cbd2302e585c41c6d CPU threads: 8; OS: Linux 6.16; UI render: default; VCL: gtk3 Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: CL threaded Built on 22 September 2025 -- You are receiving this mail because: You are the assignee for the bug.
