Apache OpenOffice (AOO) Bugzilla – Issue 66963
Excel file with large graphic crashes calc for memory usage
Last modified: 2013-02-24 21:18:47 UTC
1. Use file-open from another OOo app (e.g. Draw) or from the quickstarter 2. Navigate to this excel spreadsheet 3. A window with a frame, a grey body, and a status line is drawn. 4. The status line shows "Opening document" and a blue progress bar, which vanishes once complete 5. The status line shows "Adapt row height" and a blue progress bar, which vanishes once complete 6. The body of the window remains grey, and no menus or spreadsheet are drawn. The status line remains blank. 7. In the task manager soffice.bin uses 98% CPU and counts up to 897,828K of memory (the machine has 2Gbyte of physical memory) 8. A dialogue appears which says "Memory shortage. Please quite other applications or close some windows before continuing. At this point Task manager says Physical memory 2086960, available 861768 system cache 795704 (kernel 86768 paged 74500 nonpaged 12268) 9. Click OK on memory shortage dialgoue. 10. Blank window vanishes. 11. get a crash analysis "Due to an undexpected error, openoffice.org crashed. All the files you were working on will be saved now. The next time openoffice.org is launched, your files will be recovered automatically. The following files will be recovered: [the list is empty] 12. Click on OK 13. The previous OOo application starts. When it is closed, the memory held by the application is released and task manager says Total 2086960 available 1723608 system cache 794404 If the quickstarter is used at 1. then step 8. does not occur, and it goes straight to 10. Opening the same file in excel 2003, takes a few seconds and uses a lot of CPU, but the memory stats are as follows: total 2086960 avaialble 1678420 system cache 169608 (kernel 73016 paged 64196 nonpaged 8820). The memory usage barely appears on the task manager graph (see attached pdf). The difference in performance between Calc and Excel is marked. (Background: the sheet is for demonstrating Harmonic distortion, and a large number of data points are used so that the data can be exported to a commercial power quality analysis package)
Created attachment 37463 [details] The excel spreadsheet that causes the problem
Created attachment 37464 [details] Annotated memory usage from task manager, showing difference between Excel and Calc on the same file
Just spotted the 1Mb fle limit for attachments. Even zipped my sheet is 6Mb. I will email it to anyone who asks
Hi, no need to do so, the file is uploaded. Basically a Chart problem and maybe fixed for the new Chart implementation. BTW using such a lot data points isn't a good idea. all these little curves just show a big colored line paralell to the x Axis and you cant even see a single point on it. If you reduce the number of lines shown you probably will not get such problems. Re-assigned to owner of selected subcomponent. Frank
Seems to be an double. *** This issue has been marked as a duplicate of 16280 ***
closed as duplicate
fst wrote: >BTW using such a lot data points isn't a good idea. >all these little curves just show a big colored line paralell >to the x Axis and you cant even see a single point on it. >If you reduce the number of lines shown you probably will >not get such problems Not so - It's intended to enter various amplitude and phases in the list at the top, and in certain combinations the effects on the various "little curves" are very obvious - as in the "diode pulse" example. And anyway, excel handles it flawlessly and rapidly. We are supposdely making something as good as the competition, and this isn't
I agree that the crash is not at all a duplicate to the performance issue. -> reopen this task.
The crash seems to not occur anymore in the ongoning chartreimplementation (CWS chart2mst3). Will check again, when reimplementation is finished. The performance problem does still occur. It will not be handled in this issue but in issue 16280 .
I take it, to check again later
Thanks. Hope the example proves useful before the next issue.
Hello Community. Hours ago, a pair of messages was received by the list “users@es.openoffice.org†talking about to that OpenOffice.org 2.0.4rc2 consumes much ram memory and the orthographic revision automatic delay of 2 to 3 minutes to draw the dialogue picture. In such messages, the sender (not I, but a new Hispanic user) also has problems with the installation of dictionaries for es_CO (Spanish for Colombia) as much using the Assistant as in manual form, not thus with the one of Spain. The connections (in Spanish) http://es.openoffice.org/servlets/ReadMsg?list=users&msgNo=4241 http://es.openoffice.org/servlets/ReadMsg?list=users&msgNo=4242
Hello Community It is a automatic translation by Google of the original message sended by John Freddy Rojas Hernandez about excesive memory consume in OOo 2.0.4rc2 running above a computer with Windows 2000 professional and 112MB RAM + 16MB for video. Date: Tue, 26 Sep 2006 23:11: -0500 (09 CDT) From: John Freddy Rojas Hernandez <jfx82 AT yahoo.com> Content-Type: text/plain; charset=iso-8859-1 Subject: When doing orthographic correction OO.org is blocked Hello to all, I am new in this list, and my restlessness goes to the following thing: I have installed Openoffice.org the last stable version which they suggest to unload from the Web in Spanish (2.0.4), and installed the package of Spanish language for the interface and by all means I have installed the spelling dictionary echo, that is to say, the one of Spanish-Colombia. Nevertheless, the automatic revision did not work either neither using asistende of installation of dictionaries nor of manual form, so that I proved to install the Spanish-Spain dictionary which if it worked. Nevertheless in the automatic revision taking too much time (2 to 3 minutes approx) to unfold the picture completely, soon is left a gray window without controls, the hard disk sample activity during that time and the memory use is consumed completely, if I click in some other part of the window, appears the message in the bar of title “does not respondâ€, equal the application blocks when I click for the contextual menu in a word with possible orthographic error, in addition this happens thus are 2 or 3 words contained in the text. OO.org I have it installed in an equipment with Windows 2000 professional and 112MB RAM + 16MB for video. I thank for the aid that can offer me.
@alejandro_ar: please stop posting into this issue as it has nothing to do with orthographic correction. Instead this issue is about a crash of the attached excel file. Please create a separat issue for your different problem. Thanks.
changed target to 2.3
I am not completely sure about the state of this issue. Reopen and retarget due to limited resources.
reset to accepted
adding crash keyword. and p2, because Crashs or freezes during normal operations of the application. I hope it can be fixed soon, as this is a crash. Thanks
I am not sure whether the crash does occur with the new chart. But this document loads endless. After more than an hour it still wasn't loaded on my PC. So I made some performance improvements: 1) Line charts with many data points should be much faster now during view creation. 2) Spline charts (smoothed curves) with many data points should be much faster now during view creation in addition. On my PC the document now loads in 1 minutes and does not crash. The memory consumption seems not to be extraordinary anymore also.
Fixed in CWS chart15. Thomas, please verify.
Wow, thankyou very much. Hope now the Chart 2 is really shine, after this fixes. because it is much faster than before. again. Thanks
@utomo99: Sounds like you have check (verify) it. Have you?
> Kla. Sorry I still not yet test it. as I still wait for the build. if you can share me the download link, I will test it. but I am really happy with the news that the performance is much faster. Thanks But I still see many performance problems, which exist from 2003 and 2004. and still not yet fixed until now. This can be found easily using "slow" keyword on issuzilla, we have many issue there.
No crash anymore and it is much faster than before. ( On my PC the document now loads in round about 1.5 minutes) -> verified
File open takes about 1 Min Verified fixed in OOH680_m5; closing