Apache OpenOffice (AOO) Bugzilla – Issue 105180
Deleting a sheet by API => memory loss
Last modified: 2013-12-19 08:39:26 UTC
Next attachment is a spreadsheet with 100 pages, containing a small Basic macro. If you delete 99 sheets with the user interface, no problem. If you delete 99 pages by API there is a memory loss of 300 Mbytes, recovered when you close or reload the document after execution. Deleting more sheets (e.g. 200) may use all memory. On version 2.4.3 the same code consumes "only" 80Mbytes. No memory consumption with good old version 1.1.5, and it runs quicker. No memory consumption with the equivalent code for Draw.
Created attachment 64842 [details] Spreadsheet with 100 pages and a macro to delete 99
Created attachment 64843 [details] Memory consumption due to page delete by API
Confirmed with AOO410m1(Build:9750) - Rev. 1551017 Rev.1551017 Win 7
Created attachment 82134 [details] Screenshot of Windows Task Manager