Calc memory consumption

[Daniel Armando Rodriguez]

El 2021-01-21 17:35, Michael Meeks escribió:
> On 20/01/2021 10:29, Daniel A. Rodriguez wrote:
>>>> Hi, exists some kind of formula to estimate how much RAM a 
>>>> spreadsheet
>>>> could use? For instance 468K rows and columns from A to AG.
>> 
>> Well, trying to do something with such file using an i3 based PC with
>> 4Gb freezes the software completely.
> 
> 	Both Tor and Noel are right; but I collect the 'shape' of pathological
> spreadsheets as a hobby =)
> 
> 	Can you tell me:
> 
> 	+ what data-type is in each column
> 	+ whether the column is sparse (ie, are
> 	  there 'holes' in the data)
> 	+ what formulae are used - and what their shape is ?
> 	 	+ hopefully formulae are normally
> 		  non-confidential

Don't have access to the file so have asked

> 	+ what file format you're using.

XLSX, it's exported from the software the company use

> 
> 	But of course, this really doesn't belong on the dev list, but in a 
> bug
> if you have one ?

Nope, just acting as an intermediate in this case

> 	In case nothing jumps out of the above data, possibly running a
> sampling profiler under Linux like 'perf' might show what's being slow,
> though I imagine it sounds like a memory issue (perhaps even a 
> transient
> memory use) problem.
> 
> 	Thanks ! =)
> 
> 		Michael.

-- 
DAR