Calc memory consumption

[Svante Schubert]

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>