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
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
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
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 completel
20 ene. 2021 02:56:24 Tor Lillqvist :
>>
>> 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.
>
> Why do you need to know? And why is the amount of RAM interesting and not the
> amount of virtual memory required
Well, trying to do something with such file using an i3 based PC with 4Gb
freezes the software completely. However, an i7 with 16Gb handles it well.
The idea is to find a common ground in between to prevent with hardware.
El mié., 20 de enero de 2021 02:56, Tor Lillqvist escribió:
>
>> Hi, exis
On 2021/01/20 1:56 am, 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.
Calc uses a kind of compression for columns (when there is repeating data), and it depends heavily on what ki
>
>
> 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.
>
Why do you need to know? And why is the amount of RAM interesting and not
the amount of virtual memory required?
--tml
_
