https://bugs.documentfoundation.org/show_bug.cgi?id=127758
Bug ID: 127758
Summary: EDITING, CRASH: performance problem regarding comments
significantly mitigated in ver. 6.2.7.1 under windows
but persistent in linux version
Product: LibreOffice
Version: 6.2.7.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: newbie...@gmx.de
Description:
for some month now i am 'investigating' in an old bug, #76324, 'calc becoming
slow once you have too many comments in a sheet'.
>>> this bug refers to that old bug, it is not! a duplicate of it as it
>>> describes a significantly changed behaviour, thus pls. take it serious
>>> instead pulling it out of sight as duplicate <<<
anyone can be lucky once and again, i found one specific version of libreoffice
where this problem is mitigated. funnily enough it's better in the windows x64
version of 6.2.7.1, while still massively present in in the parallel version
for linux.
i kindly ask for help:
- could someone retest and confirm this,
- when confirmed, could someone dig into the code or just compare the win and
linux version to find the difference, (would that work with bibisect?).
- once found, could someone implement the enhancements from the win version in
all development streams, (the performance issue is! still present in all 6.3
versions i tested).
once confirmed i hope it's possible for the developers to dig for the
differences either in code or in handling by the OS, and to improve the buggy
versions.
Steps to Reproduce:
1. in ver. 6.2.7.1 for windows start with an empty sheet,
2. add any comment to cell A1,
3. copy and paste that cell to a bigger region, say A1:AX50, that'll be 2.5 k
commented cells,
4. observe the program performing normal. (ok, it will take some time, it
depends on your system, and it's unnormal long compared to just copying cells
without comments, but it'll finish in an acceptable time.)
5. do the same in ver. 6.2.7.1 for linux (concrete info below),
6. observe system load e.g. in a terminal window running 'top'. on my system
about 45 minutes to finish the insert, and 100% cpu load for all that time.
(linux version tested is slightly exotic, 'kali', but behaves normal on plenty
other tasks i ran on it, as well as with plenty calc spreadsheets without or
with only a few comments).
Actual Results:
win version much! faster than linux, linux version nearly dying from the system
load, (that is not the performance of 'the spreadsheet you ever wanted')
Expected Results:
both versions with better speed, especially under linux,
wishlist: handling of a cell with comments should be as performant as handling
of any other cell.
Reproducible: Always
User Profile Reset: No
Additional Info:
Windows version with significantly enhanced performance:
Version: 6.2.7.1 (x64)
Build ID: 23edc44b61b830b7d749943e020e96f5a7df63bf
CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win;
Locale: de-DE (de_DE); UI-Language: en-US
Calc: *unthreaded*
Linux version still buggy:
Version: 6.2.7.1
Build ID: 23edc44b61b830b7d749943e020e96f5a7df63bf
CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: gtk3;
Locale: de-DE (en_US.UTF-8); UI-Language: en-US
Calc: *unthreaded*
stress-test to see that also the enhanced win version is still buggy:
0. any version of lbreoffice calc,
1. empty sheet,
2. enter '1' in A1 - without the quotes,
3. copy A1 - ctrl-c,
4. mark column A - by click on the header,
5. paste - ctrl-v,
6. observe 'done on the fly',
7. delete all that content - 'del',
8. add comment '1' to cell A1 - without the quotes,
9. copy A1 - crtl-c,
10. mark the whole column a - by click on the header,
11. gallows humor: kiss your program goodnight, it won't talk to you anymore
12. paste - crtl-v,
13. observe 'program dead',
14. try the same procedure with ver. 6.2.7.1 win-x64,
15. observe 'dead too',
16. if you find any version not dying on step 12 please give me a note.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
