Page 1 of 1
[Issue] Maximum sheets exceeded in spreadsheet
Posted: Sun Dec 23, 2007 11:59 pm
by tony
i am new to this program and just trying it out for the first time. When i try to import an excel spreadsheet into open office, I get an error message that says that it has exceeded the maximum number of sheets. What is the maximum number of sheets that can be used/imported or Is this a setting that can be changed?
Re: maximum sheets exceeded in spreadsheet
Posted: Mon Dec 24, 2007 1:48 am
by Bill
Re: maximum sheets exceeded in spreadsheet
Posted: Mon Dec 24, 2007 2:15 am
by Corfy
I had a hard time finding the answer on that page, and I knew the answer.
The maximum number of sheets that a Calc spreadsheet can support is 256. Other specs are:
Maximum number of rows: 65,536
Maximum number of columns: 256
I don't know what to do about spreadsheets that have more rows, more columns, or more sheets than is the maximum, but it is not a setting that can be changed.
Re: maximum sheets exceeded in spreadsheet
Posted: Tue Dec 25, 2007 1:12 pm
by Hagar Delest
There is an enhancement request here :
Issue 19440 - Increase number of sheets and columns. 4 years old and only 3 votes !