| Summary: | calc is very slow in updating liks to other calc files | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | pier <procustex> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED INVALID | ||
| Severity: | normal | CC: | sasha.libreoffice |
| Priority: | medium | ||
| Version: | 3.3.1 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | when I expand the B2 cell to all the formulas it is slow | ||
testing again I discovered (suggested by Tom Davies in libo'-user mail list :-) that if all the source files are opened the process is very fast [This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html Please, verify: in 3.5.0 still so slow? Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian |
Created attachment 45181 [details] when I expand the B2 cell to all the formulas it is slow on my 3GHz-2GB of ram PC with windows XP with libreoffice 3.3.0 and on my dell latitude E6510 i7-4Gb of ram with opensuse 11.4 and libreoffice 3.3.1, I have a calc worksheet with about 40 links (=(DDE("soffice";... etc etc..) to other 10 calc files, it takes about **10minutes** to update all the links. I tested a bit and it seems that the time depends on how big and complicate the source files are. -1) If I open a CALC or a WRITER file with 10 links to 10 *10Kb* CALC files (in total 100 links) it asks me to update links, I answer YES, it takes about few seconds. 2-) If I open a CALC or a WRITER file with 10 links to 10 *800Kb* CALC files (in total 100 links) it asks me to update links, I answer YES, it takes about 1 minute, and it is accettable. 3-) If I open a CALC (attached) file with 10 links to 10 *10Kb* CALC files (in total 100 links) it asks me to update links, I answer NO, then I expand formulas in the 100 cells (for expand I intend dragging the small black square in the lower right angle of B2 cell first horizontally (it takes few seconds) then vertically in the resulting selection) it takes about *1 minute*, and it accettable 4-) If I open a CALC (attached) file with 10 links to 10 *800Kb* CALC files (in total 100 links) it asks me to update links, I answer NO, then I expand formulas in the 100 cells it takes about *9 minutes*, and it seems to me too much :-) Ciao Pier P.S. if it is useful I can attach 10 example files of 800Kb each