El 2021-01-22 08:18, Daniel Armando Rodriguez escribió:
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.
About the file, it's just a log from month activity. No formulas
involved.
--
DAR
_______________________________________________
LibreOffice mailing list
LibreOffice@xxxxxxxxxxxxxxxxxxxxx
https://lists.freedesktop.org/mailman/listinfo/libreoffice
