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:
- Validate the XLSX: https://archive.codeplex.com/?p=ooxmlvalidator (collect the results)
- Anonymize the document, e.g. exchanging business data via https://github.com/Motorrat/anonyxel
- Check if the problem still occurs being anonymized, otherwise please switch some relevant data back until it occurs (or remove sensitive data manually) ;-)
- 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@xxxxxxxxxxxxxxxxxxxxxx>:
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@xxxxxxxxxxxxxxxxxxxxx
https://lists.freedesktop.org/mailman/listinfo/libreoffice
_______________________________________________ LibreOffice mailing list LibreOffice@xxxxxxxxxxxxxxxxxxxxx https://lists.freedesktop.org/mailman/listinfo/libreoffice
