Calc memory consumption
Svante Schubert
svante.schubert at gmail.com
Fri Jan 22 12:04:34 UTC 2021
Hi Daniel,
I share Michael's hobby of collecting 'shapes' of pathological spreadsheets.
Could you please ask someone with access to this interesting XLSX document
to be so gentle to:
1. Validate the XLSX: https://archive.codeplex.com/?p=ooxmlvalidator
(collect the results)
2. Anonymize the document, e.g. exchanging business data via
https://github.com/Motorrat/anonyxel
3. Check if the problem still occurs being anonymized, otherwise please
switch some relevant data back until it occurs (or remove sensitive data
manually) ;-)
4. Attach the anonymized XSLX & prior validation results to an issue:
https://wiki.documentfoundation.org/QA/BugReport
Thanks in advance, Daniel.
Svante
Am Fr., 22. Jan. 2021 um 12:18 Uhr schrieb Daniel Armando Rodriguez <
drodriguez at documentfoundation.org>:
> 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
> _______________________________________________
> LibreOffice mailing list
> LibreOffice at lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20210122/15ec605b/attachment.htm>
More information about the LibreOffice
mailing list