Bug 133880 - 2^20 Table Rows, in this age of (supposedly) 64 bit Software? I need well over two (2) Million!
Summary: 2^20 Table Rows, in this age of (supposedly) 64 bit Software? I need well ove...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-large-spreadsheets
  Show dependency treegraph
 
Reported: 2020-06-10 21:45 UTC by David Halliday
Modified: 2020-06-11 14:28 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description David Halliday 2020-06-10 21:45:26 UTC
Congratulations, y'all! LibreOffice Calc is no better than Microsoft Excel!

Is that intentional?

Just like Excel, LibreOffice Calc cannot deal with Table of over 2^20 Rows!

Why do we still have such limits, in this age of (supposedly) 64 bit Software?

I have an official US Document with over two (2) Million Data Rows!
Comment 1 Aron Budea 2020-06-11 02:26:56 UTC
Hey! That's a rather weird way of kindly asking others to solve a problem you're having for you.

(In reply to David Halliday from comment #0)
> Is that intentional?

There probably wasn't much demand for it, plus these tend to be non-trivial amount of work, eg. here's the commit from 10 years ago that increased the limit to 1 million rows:
https://cgit.freedesktop.org/libreoffice/core/commit/?id=b3579d71c6536ab1d03cc47249d582a574fd054a
(it's actually not that bad compared to the much more complex case of increasing the column limit to 16k that is being worked on)

> Just like Excel, LibreOffice Calc cannot deal with Table of over 2^20 Rows!
> 
> Why do we still have such limits, in this age of (supposedly) 64 bit
> Software?

I don't know, what did Microsoft say? Jokes aside, I'd say mostly memory, maybe the average amount of memory in computers increased 4- to 8-fold in ten years, which isn't a lot compared to the increase in addressable space you're comparing to.

I'll leave the actual assessment of the feature request to a Calc expert.
Comment 2 V Stuart Foote 2020-06-11 14:28:34 UTC
Actually yes does with the 7.0.0 release for work on bug 50916

Supporting 2^24 rows and column count of 2^14