Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | calc produces unneccessary? cpu load in files with plenty comments | ||
---|---|---|---|
Product: | Calc | Reporter: | b. <newbie-02> |
Component: | ui | Assignee: | AOO issues mailing list <issues> |
Status: | CLOSED DUPLICATE | QA Contact: | |
Severity: | Normal | ||
Priority: | P5 (lowest) | CC: | knmc, oooforum |
Version: | 3.3.0 or older (OOo) | ||
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
b.
2019-06-02 23:52:08 UTC
Already reported *** This issue has been marked as a duplicate of issue 109276 *** @oooforum (fr): sorry, sorry, sorry, me bad, pls. beliiieeeve me i did! do a search before posting, didn't find that ... ??? typo? ??? see below list of issues and retests today, still an issue, happy: i'm not alone, sad: something affecting the fun to work with OO and LO in a massive negative way is 'still in' after *10* years, ecological: just an assumption: 8 billion people worldwide, 4 billions awake, 1 billion using computers, 10 % (100 millions) using spreadsheets, 20 % (20 millions) LO or OO (maybe the bug is in e$x$cel as well), 50 % using comments (10 millions), theese wasting 20 watt of cpu-power for comments ... the impact is 200 Megawatt!, about one sixth of a usual big nuclear power plant :-(, with german average prices 60.000 EUR per hour? (since ten years?) ... besides massive wasting time of users ... what i *dislike* abut that bug (deepl'ed): it creeps in unnoticed, gradually increases with the amount of data until users notice a problem, but then there's no clue what the cause is, they're wasting time on research, or slow work, or switch to another program. And even before using comments, there was no hint: 'Beware!, too many comments can drastically slow down your system!'. searched again today and found three the same issues: Issue 109276 - Calc is extremely slow when spreadsheet has many notes (comments) reported *2010*-02-15 09:20 UTC by cianoz status today: Status: UNCONFIRMED tested today: hard work for system to copy content, errors like 'no space to copy here', lightning fast after stripping comments, thus: still issue, Issue 117348 - freeze or out of memory , when paste a lot of cells with comment. reported *2011*-03-12 04:12 UTC by paz_ohhashi status today: Status: UNCONFIRMED tested today: Issue 117348: high load and delay and 'not responding' on copying the row with comments, had to kill the task, thus: still issue, Issue 127715 - Changes in spreadsheet with many notes (comments) extremely slow reported 2018-02-26 12:26 UTC by orion status today: Status: UNCONFIRMED tested today: visible delays alredy with very small amounts of data and comments, thus: still issue, and even more domino-like after noticing that comments are called 'notes' as well: Issue 102716 - Calc is very slow for some operations (with many notes) reported *2009*-06-12 13:20 UTC by sukender this is at least Status: CONFIRMED tested today: deleting a line, heavy load and 'not responding', thus: still issue, Issue 111390 - OOo Calc 3.0.1 and higher --> Notes bug reported: *2010*-05-05 09:12 UTC by jsteenks despite being confirmed in: https://bz.apache.org/ooo/show_bug.cgi?id=111390#c2 status today: Status: CLOSED *IRREPRODUCIBLE* but some useful info in: https://bz.apache.org/ooo/show_bug.cgi?id=111390#c4 tested today: small sheet, few comments, first no problem, maybe i didn't get the functionality of the sheet, unfolded invisible rows and cols, added 75k cells with '1' in it commented '1', dead, sorry, fnished and came back to live after ~10 minutes, 13 % of cpu-load on hovering with the mouse over the sheet, thus: still issue, Issue 111037 - An example of XLS/ODS file which slows down OOo reported: *2010*-04-21 11:10 UTC by hiddenman this is at least Status: CONFIRMED tested today: visible delays, graphics fu**ed after deleting one column, 15 times faster after strippung comments, thus: still issue, i'd stop listing here, my impression, there is a 'big bug', and one will find plenty other complaints about performance which did not get the boildown to the root 'comments' or 'notes', but which do rely on theese effects and you'll see it once you test 'em against this issue. so please again beliiieeeve me, there is an issue, this bug is! a duplicate of more than one others, as they are still unresolved it's an appeal to take this issue seriously ... reg. b. This was closed as a duplicate for a reason as there is already a previous report all comments should be added to that open report to keep all pertinent information in a single place. I will mark issue 109276 as reconfirmed in AOO 4.1.6. *** This issue has been marked as a duplicate of issue 109276 *** |