calc: jumbo sheets on windows (never gonna happen)
admin at wingarch.digitalspacemail28.net
Tue Oct 6 21:10:36 UTC 2020
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.
On 10/6/20 12:09, Noel Grandin wrote:
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.
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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the LibreOffice