[Libreoffice-bugs] [Bug 76324] CALC becomes very slow with 5000+ comments

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=76324

--- Comment #69 from b. <newbie-02 at gmx.de> ---
dear guys, 

this is! a bug, 

it is a big! bug, 

and it's in the program for over 5 years now, still unresolved, 

ok, ranting doesn't help, but points like this are  not a good showpiece for a
program being 'actively developed' ... :-( 

i think i stepped in a variant of (or something left while plastering on) this
bug, i observed performance issues and tried to bring it to the point, it took
me hours and days - see there:
https://bugs.documentfoundation.org/show_bug.cgi?id=125545 and there:
https://bugs.documentfoundation.org/show_bug.cgi?id=124692 till i came to the
point it might be 'comment related'. 

how many people shall spend how many time and collect how many frustration till
somebody takes this point serious and does something against it? 

most people won't do any analysis, when they use comments they will start with
a few, no problem, use some more, no problem, and on continuation they will
observe firstly little, then bigger and in the end major performance problems. 

but nobody tells them the reason, and they have no hint on the source, thus
they will helplessly search around (as i did), be frustrated working with calc,
and either switch to another product or change to other work. 

that's not a good thing! 

my two cents: 

- the issue is partially covered by enhancements in the program and faster
hardware and OS's, but it's still in and 'working' (try changing the pattern in
the first problem file to two cells with different content and different
comments, and fill some area like a chessboard, thus breaking 'shared formulas'
and similarity compression, you'll see massive performance impacts also in very
fast systems, (90 seconds of 'not responding' and 'fan requesting cpu load' for
a simple mouseclick in a sheet with 32k filled cells and 16k comments is not!
'the spreadsheet you ever wanted').

- if the problem comes from the calculation of the size of textboxes ??? -
mentioned somewhere above - *switch it off!!!* while the comments are hidden.
imho the normal use of comments is to have additional info in it which isn't
needed all the time and shouldn't eat the screen, thus invisible and shown on
mouseover. for this use its absolutely sufficient to calculate one! textbox for
the cell actually showing it's comment. 

- in some situations i observed some flickering of comment boxes and
'resistance against the cursor and editing' of text in comments, may be there
is something wrong, may be with new graphics features, may be ... 

- with the stuff provided in this thread it schould be a short and direct way
to the source of the problem in the code, simple files, trivial data, simple
'functioning', there is little chance for the bug hiding against profiling, 

any help appreciated!

would / could somebody with sufficient rights set the importance to major
please?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190529/83dc2c2c/attachment.html>