calc: jumbo sheets on windows (never gonna happen)

[Andrew Pitonyak]

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 <admin at 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-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
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>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/e85a00e4/attachment.htm>