Created attachment 79703 [details] sample with 66000 points in the chart Description from #i121058 (https://issues.apache.org/ooo/show_bug.cgi?id=121058): Open the sample file with large chart, it takes too much time on loading, looks like freeze. And sometimes a warning dialog pops up with warning msg "Main memory shortage. Please quit other applications or close some windows before continuing.", click "OK" button on this dialog, then pops up an error dialog and AOO crashes. AOO solution isn't that good because it only works for numeric data, not for text data. Besides, as Kohei suggested, it should be done in the chart engine, not in calc
Thank you for your bug report, I can reproduce this bug running libreoffice Version: 4.1.0.0.beta1 Build ID: 3a2c2d2417101e45fe07cfd8358acf2204a98f3 on Mac osx 10.8.3 and version 4.0.3.3. Loading does take like 2 minute and I get the spinning wheel on my mac. Wen I look at my system use LibreOffice uses 98.9% of my cpu. after loading just 0.2%
It's the same problem with version 3.6.7.2. May be from Aoo? I am wondering how this chart was created, as when I was trying to create a chart from data which contains 10K+ rows, it's really slow, and when you try to rezise the chart, calc will freeze. Also, when attachment 79703 [details] finished loading finally in Calc, if you scroll, there is secious lag/delay. There is a saperate bug report regard this issue: Bug 81230. I added as see also.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (4.4.1 or later): https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-07-18
This issue is still reproducible with Version: 4.4.4.3 Build ID: 2c39ebcf046445232b798108aa8a7e7d89552ea8. It took me 3 minutes and 10 seconds to open the file under Window 7
Yeah, freezy, but not entirely. Should probably try a callgrind on Linux later.. Win 7 Pro 64-bit Version: 5.3.0.0.alpha0+ Build ID: 28ac6fdc11559b58ac62089300aa99530b0b822d CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@42, Branch:master, Time: 2016-07-18_02:54:20 Locale: fi-FI (fi_FI); Calc: CL
Created attachment 126287 [details] Callgrind with 5.3 Callgrind of opening the file an scrolling just a little bit. Arch Linux 64-bit, KDE Plasma 5 Version: 5.3.0.0.alpha0+ Build ID: ab1b351840160655a9f0caedbb35e9fdf203c5a0 CPU Threads: 8; OS Version: Linux 4.6; UI Render: default; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on July 16th 2016
In Version: 5.4.0.0.alpha0+ Build ID: 193f8966135064a32164c9da08d01dab9c1fc15d CPU threads: 4; OS: Linux 4.8; UI render: default; VCL: gtk2; Locale: ca-ES (ca_ES.UTF-8); Calc: group it takes real 0m48.947s user 0m32.280s sys 0m1.480s approximately. I think we can delete the crask work from the summary.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
it takes real 0m30,883s user 0m21,790s sys 0m0,984s in Version: 7.0.0.0.alpha0+ Build ID: 9163755e9f64a0b1dd5f2090e0702c19e31c12c9 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded I think we can reduce its priority
30 sec stopwatch time here Version: 7.3.0.0.alpha1+ (x64) / LibreOffice Community Build ID: 5c5f36aa73b11356a3bff0a9cc8b5fe8d1a776b9 CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: default; VCL: win Locale: fi-FI (fi_FI); UI: en-US Calc: threaded
32 sec (Intel Core2Quad 9450) in Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 1be170d0629cf761f0ee4173007a3c021966546e CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/56cd3b2b5d395165cd4add2f46ac4ba25a4ea4af tdf#64914 slow opening large chart It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/06b7f930a51d396bf9e3b6b8d0b3fcbd034730b4 tdf#64914 small improvements It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/cf201db990e8973f801ba6c44f74605330a4af74 tdf#64914 elide some dynamic_cast It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
(In reply to Roman Kuznetsov from comment #11) > 32 sec (Intel Core2Quad 9450) in > > Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community > Build ID: 1be170d0629cf761f0ee4173007a3c021966546e > CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: > Skia/Raster; VCL: win > Locale: ru-RU (ru_RU); UI: en-US > Calc: CL Today it took only 18 sec on the same hardware in Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 2c6f5ebfe69c3031af7b4903637226bd8a3dde62 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: ru-RU Calc: CL Jumbo MS Excel 2007 opens it for 5 sec, btw
(In reply to Roman Kuznetsov from comment #15) > (In reply to Roman Kuznetsov from comment #11) > > 32 sec (Intel Core2Quad 9450) in > > > > Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community > > Build ID: 1be170d0629cf761f0ee4173007a3c021966546e > > CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: > > Skia/Raster; VCL: win > > Locale: ru-RU (ru_RU); UI: en-US > > Calc: CL > > Today it took only 18 sec on the same hardware in > > Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community > Build ID: 2c6f5ebfe69c3031af7b4903637226bd8a3dde62 > CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: > Skia/Raster; VCL: win > Locale: ru-RU (ru_RU); UI: ru-RU > Calc: CL Jumbo > > MS Excel 2007 opens it for 5 sec, btw Hi Roman, What's the time if you don't use Jumbo sheets ?
(In reply to Xisco Faulí from comment #16) > Hi Roman, > What's the time if you don't use Jumbo sheets ? it took absolutely the same time
Dear Xisco Faulí, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug