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 < [email protected]>: > 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 > [email protected] > https://lists.freedesktop.org/mailman/listinfo/libreoffice >
_______________________________________________ LibreOffice mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice
