You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Dwight Hines <dw...@gmail.com> on 2018/12/22 15:52:38 UTC
Mac vs Linux -- Limits on number of rows in spreadsheets?
Mac vs Linux --Limits on number of rows in spreadsheets?
How to increase?
Re: Mac vs Linux -- Limits on number of rows in spreadsheets?
Posted by Brian Barker <b....@btinternet.com.INVALID>.
At 10:52 22/12/2018 -0500, Dwight Hines wrote:
>Mac vs Linux --Limits on number of rows in spreadsheets?
See
https://wiki.openoffice.org/wiki/Documentation/FAQ/Calc/Miscellaneous/What%27s_the_maximum_number_of_rows_and_cells_for_a_spreadsheet_file%3F
- which says 1,048,576, i.e.2^20. It makes no distinction between
operating systems.
The above will be for saving in OpenOffice's native Open Document
Format format, i.e. .ods; saving in other formats may have other
limitations. Recent versions of Microsoft Excel have the same limit
for number of rows, but this appears to apply only to its newer .xlsx
format. Older version of Microsoft Excel were limited to 65,536 (i.e.
2^16) rows. I'm guessing that if you save from OpenOffice in .xls
format, you will be limited to this smaller value as well. Even if
you are not, it may be that Microsoft Excel (any version?) will not
be able to open an .xls file with more rows than this smaller limit.
Remember that if you are passing your documents to others, any limits
of whatever spreadsheet software they use will apply.
>How to increase?
Use different spreadsheet software. Write your own? Redesign your
spreadsheet? Use a database?
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Mac vs Linux -- Limits on number of rows in spreadsheets?
Posted by Wade Smart <wa...@gmail.com>.
I send and get sheets from people who use Mac and
never noticed a limit on rows.
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
On Sat, Dec 22, 2018 at 9:52 AM Dwight Hines <dw...@gmail.com> wrote:
>
> Mac vs Linux --Limits on number of rows in spreadsheets?
> How to increase?
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Mac vs Linux -- Limits on number of rows in spreadsheets?
Posted by Wade Smart <wa...@gmail.com>.
> OpenOffice Calc is listed as supporting 1048576 rows and 1024 columns
>
> It may be that a dataset of such size needs a completely different method of processing than a spreadsheet.
>
> Rory
Hmm I havent got to 1 million rows yet.
I cant say Ive even tested the limit then HAHHAH
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Mac vs Linux -- Limits on number of rows in spreadsheets?
Posted by Rory O'Farrell <of...@iol.ie>.
On Sat, 22 Dec 2018 18:04:39 +0000
chuck ef <ch...@hotmail.com> wrote:
> I am not aware of a limit on rows in an .ods file but then I have never tried to find one. And why, if one exists, it would be unique to Mac systems is a mystery to me.
>
> I use Macs frequently.
OpenOffice Calc is listed as supporting 1048576 rows and 1024 columns
It may be that a dataset of such size needs a completely different method of processing than a spreadsheet.
Rory
>
>
> ________________________________
> >From: Dwight Hines <dw...@gmail.com>
> Sent: Saturday, December 22, 2018 9:52 AM
> To: users@openoffice.apache.org
> Subject: Mac vs Linux -- Limits on number of rows in spreadsheets?
>
> Mac vs Linux --Limits on number of rows in spreadsheets?
> How to increase?
--
Rory O'Farrell <of...@iol.ie>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Mac vs Linux -- Limits on number of rows in spreadsheets?
Posted by chuck ef <ch...@hotmail.com>.
I am not aware of a limit on rows in an .ods file but then I have never tried to find one. And why, if one exists, it would be unique to Mac systems is a mystery to me.
I use Macs frequently.
________________________________
From: Dwight Hines <dw...@gmail.com>
Sent: Saturday, December 22, 2018 9:52 AM
To: users@openoffice.apache.org
Subject: Mac vs Linux -- Limits on number of rows in spreadsheets?
Mac vs Linux --Limits on number of rows in spreadsheets?
How to increase?