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-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
