calc: jumbo sheets on windows (never gonna happen)

[nicholas ferguson]

Can I ask what kind of platform would you use for 16 million rows that involve calculations?
 
From: LibreOffice [mailto:libreoffice-bounces at lists.freedesktop.org] On Behalf Of Dan Lewis
Sent: Tuesday, October 06, 2020 2:59 PM
To: libreoffice at lists.freedesktop.org
Subject: Re: calc: jumbo sheets on windows (never gonna happen)
 
>From my perspective, one needs to learn how to create a database in Base including tables, queries, forms and report when working with this much data. It is designed to handle large amounts of it. MySQL, Postgresql, and Oracle can be used as a backend  for Base being the front end.
Dan
On 10/6/20 12:09, Noel Grandin wrote:
Hi
 
i.e. very large spreadsheets of up to 16 million rows.
 
So I did some more investigation into this. In various places, we need to accumulate things like row-heights and other things, numbers which, with jumbo sheets, easily exceed 32-bits.
 
HOWEVER
 
All over the place, we pass these values through sal_uLong/sal_Long/long/unsigned long.
 
Which is 32-bits on Windows. Doh!
 
Honestly, the only solution I can think of (and one I confidently expect us to reject), is that we declare a flag day, and search and replace sal_Long/sal_uLong/long/unsigned long with a 64-bit type across the ENTIRE code base.
 
Regards, Noel Grandin.
 



_______________________________________________
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/20201006/b3a3b7b9/attachment.htm>