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. Sent from BlueMail On Oct 6, 2020, 6:22 PM, at 6:22 PM, nicholas ferguson <ad...@wingarch.digitalspacemail28.net> wrote: >Can I ask what kind of platform would you use for 16 million rows that >involve calculations? > >From: LibreOffice [mailto:libreoffice-boun...@lists.freedesktop.org] On >Behalf Of Dan Lewis >Sent: Tuesday, October 06, 2020 2:59 PM >To: libreoffice@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@lists.freedesktop.org >https://lists.freedesktop.org/mailman/listinfo/libreoffice > > >------------------------------------------------------------------------ > >_______________________________________________ >LibreOffice mailing list >LibreOffice@lists.freedesktop.org >https://lists.freedesktop.org/mailman/listinfo/libreoffice
_______________________________________________ LibreOffice mailing list LibreOffice@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice