Created attachment 145214 [details]
2. Open the Report.ods. enable content. Memory will hover between 300 and 350 mb.
3. On the Header sheet, change the value (1- 12) of cell C3
4. On the sheet Dashboard, press control + shift + f9 to hard calculate.
5. Monitor the memory usage for 10 mins. It will drop to 150 - 200 mb level.
6. Repeat step 3. memory will not increase.
Memory should not exceed 200 mb upon opening.
i can not find a "Report.ods" inside the attachted *.zip archiv.
there is only a .~lock.Report.ods# inside.
can you plaese add the file?
Created attachment 145249 [details]
Build ID: 12b3395330953384bb80904fee489389db1e0cfc
CPU threads: 4; OS: Windows 10.0; UI render: default;
TinderBox: Win-x86@42, Branch:libreoffice-6-1, Time: 2018-09-23_16:09:50
Locale: en-PH (en_PH); Calc: CL
under this version, I cannot replicate the ram usage. 6.1.3 is even faster in updating the external links. The ram usage peaked at 185mb.
with LO 6.1.2 on my win 10 notebook i can confirm:
- ram usage goes up to 500 mb
- hard recalc takes a long time (several minutes)
- with Tools/Options.../LibreOfffice Calc/Formula "Always recalculate"
loading takes a long time too
to be more precise:
selecting [Enable Content] from "Automatic update of external links has
been disabled" bar will increase memory usage (lo 6.2 ~ 330 mb, lo 6.1.2 ~ 500mb)
Calculation time it's because in sheet 'Actual' you have the whole columns of external file to do a conditional sum. Reducing the end of range, reduce drastically the time calculation.
(In reply to m.a.riosv from comment #6)
> Calculation time it's because in sheet 'Actual' you have the whole columns
> of external file to do a conditional sum. Reducing the end of range, reduce
> drastically the time calculation.
The point of raising this issue is the weird memory consumption of LO in a spreadsheet with quite number of linkages and formulas. My take on this is that if a LO spreadsheet will consume 300MB of memory, until the file is closed or saved, it will retain the 300MB. However in the current setup, after 10 - 15 mins of opening the file, the memory consumption went down and even if we hard recalculate all formulas, consumption is still lower compared to the first 10/15 minutes.
There are a lot of linked files, that need to be opened and I think it's not only LibreOffice, but also an OS matter, how they are released from memory.
Test reopening the file after break all link Menu/Edit/Links
(In reply to m.a.riosv from comment #8)
> There are a lot of linked files, that need to be opened and I think it's not
> only LibreOffice, but also an OS matter, how they are released from memory.
> Test reopening the file after break all link Menu/Edit/Links
Does this mean that this behavior is beyond "repair"? And on the instruction to test reopening after breaking all links, NO! The very purpose of raising this issue is to identify/solve the weird memory consumption on a spreadsheet with multiple linkages. Your instruction is not helping in solving the "possible" problem in the memory handling of LO. Breaking all the external links means that as if I am working only with a single spreadsheet file.