Maximum Number of Rows

Discuss the spreadsheet application

Maximum Number of Rows

Postby Letendre » Wed Jan 16, 2008 9:10 pm

Is there any way to get around the 65,000 row limit in Calc?
Letendre
 
Posts: 2
Joined: Wed Jan 16, 2008 9:02 pm

Re: Maximum Number of Rows

Postby Villeroy » Wed Jan 16, 2008 9:12 pm

Yes, take a database. This office has one.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28825
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Maximum Number of Rows

Postby Letendre » Wed Jan 16, 2008 9:27 pm

What do you mean by "take a database?" Thanks!
Letendre
 
Posts: 2
Joined: Wed Jan 16, 2008 9:02 pm

Re: Maximum Number of Rows

Postby Villeroy » Wed Jan 16, 2008 10:11 pm

There are several databases out there without limitation except disk space. Some of them can be used with OOo. As long as you don't need to do complex spreadsheet calculations with >65536 rows *at the same time* you are better off with a database because a database is more safe, performant and it can guarantee a high level of consistency.
If you need to do complex spreadsheet calculations with >65536 rows *at the same time* and you insist on using spreadsheets, I know only one contemporary spreadsheet application where the latest version of 2007 supports more rows and columns -- it's known as Excel.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28825
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Maximum Number of Rows

Postby huw » Thu Jan 17, 2008 11:45 am

Taking your question literally, yes: http://wiki.services.openoffice.org/wik ... er_of_rows
huw
Volunteer
 
Posts: 417
Joined: Wed Nov 21, 2007 1:57 pm


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 13 guests