calc: jumbo sheets on windows (never gonna happen)

nicholas ferguson admin at
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] On Behalf Of Dan Lewis
Sent: Tuesday, October 06, 2020 2:59 PM
To: libreoffice at
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the LibreOffice mailing list