[Libreoffice-bugs] [Bug 126609] LibreOffice Calc seems to struggle to handle field graphs
https://bugs.documentfoundation.org/show_bug.cgi?id=126609 BogdanB changed: What|Removed |Added CC||buzea.bog...@libreoffice.or ||g Summary|LibreOffice Calc seems to |LibreOffice Calc seems to |struggle to handle field|struggle to handle field |graphs. |graphs Blocks||136524, 90486 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=90486 [Bug 90486] [META] Chart bugs and enhancements https://bugs.documentfoundation.org/show_bug.cgi?id=136524 [Bug 136524] [META] Performance/hang/lag/high CPU issues -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 126609] LibreOffice Calc seems to struggle to handle field graphs.
https://bugs.documentfoundation.org/show_bug.cgi?id=126609 Buovjaga changed: What|Removed |Added CC||ilmari.lauhakangas@libreoff ||ice.org Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #11 from Buovjaga --- (In reply to guillaume.ameline from comment #7) > Comment on attachment 153066 [details] > sheet and graph only, no formula, plain text. > > test case 2.ods Tested with this and it does take minutes to save (forced exit). Arch Linux 64-bit Version: 7.0.0.0.alpha0+ Build ID: 6a9c7409ee617b79c327dd7ea4de432f448b6006 CPU threads: 8; OS: Linux 5.6; UI render: default; VCL: kf5; Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US Calc: threaded Built on 24 April 2020 -- 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
[Libreoffice-bugs] [Bug 126609] LibreOffice Calc seems to struggle to handle field graphs.
https://bugs.documentfoundation.org/show_bug.cgi?id=126609 --- Comment #10 from guillaume.amel...@gmail.com --- Thank you Xisco Fauli. -- 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
[Libreoffice-bugs] [Bug 126609] LibreOffice Calc seems to struggle to handle field graphs.
https://bugs.documentfoundation.org/show_bug.cgi?id=126609 Xisco Faulí changed: What|Removed |Added Severity|enhancement |normal CC||xiscofa...@libreoffice.org Keywords||perf --- Comment #9 from Xisco Faulí --- it's a bug, not an enhancement -- 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
[Libreoffice-bugs] [Bug 126609] LibreOffice Calc seems to struggle to handle field graphs.
https://bugs.documentfoundation.org/show_bug.cgi?id=126609 --- Comment #8 from guillaume.amel...@gmail.com --- Judt a quick update : I could observe the same heavy behaviour with LibreOffice 6.3.0.4 on Windows 10 Home 1903. -- 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
[Libreoffice-bugs] [Bug 126609] LibreOffice Calc seems to struggle to handle field graphs.
https://bugs.documentfoundation.org/show_bug.cgi?id=126609 --- Comment #7 from guillaume.amel...@gmail.com --- Comment on attachment 153066 --> https://bugs.documentfoundation.org/attachment.cgi?id=153066 sheet and graph only, no formula, plain text. test case 2.ods -- 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
[Libreoffice-bugs] [Bug 126609] LibreOffice Calc seems to struggle to handle field graphs.
https://bugs.documentfoundation.org/show_bug.cgi?id=126609 --- Comment #6 from guillaume.amel...@gmail.com --- Created attachment 153066 --> https://bugs.documentfoundation.org/attachment.cgi?id=153066=edit sheet and graph only, no formula, plain text. -- 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
[Libreoffice-bugs] [Bug 126609] LibreOffice Calc seems to struggle to handle field graphs.
https://bugs.documentfoundation.org/show_bug.cgi?id=126609 guillaume.amel...@gmail.com changed: What|Removed |Added Hardware|All |x86-64 (AMD64) OS|Linux (All) |All Version|6.0.7.3 release |6.2.5.2 release --- Comment #5 from guillaume.amel...@gmail.com --- Hi again, Replacing INDIRECT with INDEX will take me a tremendous amout of time, even though I am working on it. Meanwhile, I did something quicker. Windows 10 LibreOffice 6.2.5.2 I replaced every formula with plain text, and deleted every sheet except Map. Exiting graph edit mode is now as fast as expected. But saving the file still took 10 minutes with an i3 mobile CPU. The problem definitely seems to be in the way graphs handle a high number of curves, because when you delete the graph and save the file, saving is very fast. OpenCL is activated, here are my OpenGL details on this other computer : Rendereur: Intel(R) HD Graphics 520 Fournisseur: Intel Mémoire: 1024 MO Version: 4.4.0 - Build 21.20.16.4550 Version GLSL: 4.40 - Build 21.20.16.4550 I uploaded a new test file : "test case 2.ods" -- 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
[Libreoffice-bugs] [Bug 126609] LibreOffice Calc seems to struggle to handle field graphs.
https://bugs.documentfoundation.org/show_bug.cgi?id=126609 m.a.riosv changed: What|Removed |Added Ever confirmed|1 |0 Status|REOPENED|UNCONFIRMED --- Comment #4 from m.a.riosv --- Please test the change of the INDIRECT by INDEX, maybe those being part of chart's data are the source of the issue. -- 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
[Libreoffice-bugs] [Bug 126609] LibreOffice Calc seems to struggle to handle field graphs.
https://bugs.documentfoundation.org/show_bug.cgi?id=126609 guillaume.amel...@gmail.com changed: What|Removed |Added Status|NEEDINFO|REOPENED -- 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
[Libreoffice-bugs] [Bug 126609] LibreOffice Calc seems to struggle to handle field graphs.
https://bugs.documentfoundation.org/show_bug.cgi?id=126609 --- Comment #3 from guillaume.amel...@gmail.com --- Hi m.a.riosv, I tried with LibreOffice 6.2.5.2 on Windows 10, with openCL activated. The result is the same. something like 5 minutes to save or exit the editing mode on the graph on "Map" sheet. Thank you for your advice about replacing INDIRECT with INDEX. I will take a closer look at this. On the other hand, the culprit is definitely the graph because when you delete it, saving the file only takes few seconds. -- 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
[Libreoffice-bugs] [Bug 126609] LibreOffice Calc seems to struggle to handle field graphs.
https://bugs.documentfoundation.org/show_bug.cgi?id=126609 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #2 from m.a.riosv --- Please can you test with a newer version 6.2.5. Verify if you can activate Menu/Tools/Options/LibreOffice/OpenCL OTOH the file has a lot of INDIRECT() functions, it is a volatile function, so every time something change they are recalculated. I think in you case they are easily replaceable with the INDEX() function no volatile and quicker for calculations and for maintenance with no direct text in the function. Comparaisons.G2: INDEX(Tableau.F:F;Filtragevent.$G$2) INDEX(extractionBADA.F:F;C2) -- 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
[Libreoffice-bugs] [Bug 126609] LibreOffice Calc seems to struggle to handle field graphs.
https://bugs.documentfoundation.org/show_bug.cgi?id=126609 --- Comment #1 from guillaume.amel...@gmail.com --- Created attachment 153049 --> https://bugs.documentfoundation.org/attachment.cgi?id=153049=edit This is my test case Many things are written in French in this document (comments, names...). Please tell me if you would like a translated version, or specific explanations. -- 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