I think that the important point is that people do it in excel. They then try to open the file and they cannot. I have certainly been handled really large files perhaps it is simply a CSV file with lots of rows and I know how to deal with the spreadsheet so that's how I open it. Quick and dirty and off we go.
In general, these types of files come from a client so what are you going to do. I cannot tell you the number of times that someone has said hey we want to be able to open that in a spreadsheet program.
how often I see it is highly dependent on which projects I happen to be working at the time period. I think it's crazy? Yes. Do people do it successfully? Yes.
On Oct 6, 2020, at 6:22 PM, nicholas ferguson < admin@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Can I ask what kind of platform would you use for 16 million rows that involve calculations?
From: LibreOffice [mailto:libreoffice-bounces@xxxxxxxxxxxxxxxxxxxxx] On Behalf Of Dan Lewis
Sent: Tuesday, October 06, 2020 2:59 PM
To: libreoffice@xxxxxxxxxxxxxxxxxxxxx
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: 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.
_______________________________________________ LibreOffice mailing list LibreOffice@xxxxxxxxxxxxxxxxxxxxx https://lists.freedesktop.org/mailman/listinfo/libreoffice
LibreOffice mailing list
LibreOffice@xxxxxxxxxxxxxxxxxxxxx
https://lists.freedesktop.org/mailman/listinfo/libreoffice
|
_______________________________________________
LibreOffice mailing list
LibreOffice@xxxxxxxxxxxxxxxxxxxxx
https://lists.freedesktop.org/mailman/listinfo/libreoffice
