Bug 139688 - Increase maximum number of rows
Summary: Increase maximum number of rows
Status: RESOLVED DUPLICATE of bug 50916
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-01-16 22:54 UTC by Jonny Grant
Modified: 2021-01-17 15:50 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jonny Grant 2021-01-16 22:54:41 UTC 
When I open a large TSV file I get this error

"The data could not be loaded completely because the maximum number of rows per sheet was exceeded."

Request:

* Can this message be updated to say what that limit is? And how many rows were skipped? Is it just 1 Million? 1,048,756 to be precise.

* Can this row limit be dramatically increased?

I'm running on a machine with 16GB ram, and Calc is using 3.7% of my total RAM.
I'd personally not impose any limit, it could easily load 20M rows on my computer.
Comment 1 m_a_riosv 2021-01-17 11:30:24 UTC 
It is in development, and you can access it if you enable Menu/Tools/Options/LibreOffice/Advances - Enable experimental features.

*** This bug has been marked as a duplicate of bug 50916 ***
Comment 2 Jonny Grant 2021-01-17 14:48:56 UTC 
(In reply to m.a.riosv from comment #1)
> It is in development, and you can access it if you enable
> Menu/Tools/Options/LibreOffice/Advances - Enable experimental features.
> 
> *** This bug has been marked as a duplicate of bug 50916 ***

Hello
Thank you for this suggestion.

I enabled, but same error :

"The data could not be loaded completely because the maximum number of rows per sheet was exceeded."


"Menu/Tools/Options/LibreOffice/Advances - Enable experimental features."

Maybe my v6.4.6.2 on latest Ubuntu is out of date.
Comment 3 [REDACTED] 2021-01-17 15:46:39 UTC 
(In reply to Jonny Grant from comment #2)

> 
> Maybe my v6.4.6.2 on latest Ubuntu is out of date.

You need latest version for that (7.0.4 available via Launchpad PPA "sudo add-apt-repository ppa:libreoffice/ppa --yes") and you also need to activate
"Tools -> Options -> LibreOffice Calc -> Defaults -> Option: [x] Enable very large spreadsheets (16m rows, 16384 cols)". This option is only available after having activated experimental features.
Comment 4 Jonny Grant 2021-01-17 15:50:51 UTC 
(In reply to Uwe Auer from comment #3)
> (In reply to Jonny Grant from comment #2)
> 
> > 
> > Maybe my v6.4.6.2 on latest Ubuntu is out of date.
> 
> You need latest version for that (7.0.4 available via Launchpad PPA "sudo
> add-apt-repository ppa:libreoffice/ppa --yes") and you also need to activate
> "Tools -> Options -> LibreOffice Calc -> Defaults -> Option: [x] Enable very
> large spreadsheets (16m rows, 16384 cols)". This option is only available
> after having activated experimental features.

Hello Uwe

My TSV file has 34M rows. But only two columns, is there any way to let us specify our own row limit?