[Issue] Maximum sheets exceeded in spreadsheet

Discuss the spreadsheet application

[Issue] Maximum sheets exceeded in spreadsheet

Postby tony » Sun Dec 23, 2007 11:59 pm

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?
tony
 
Posts: 1
Joined: Sun Dec 23, 2007 11:54 pm

Re: maximum sheets exceeded in spreadsheet

Postby Bill » Mon Dec 24, 2007 1:48 am

Bill
Volunteer
 
Posts: 7392
Joined: Sat Nov 24, 2007 6:48 am

Re: maximum sheets exceeded in spreadsheet

Postby Corfy » Mon Dec 24, 2007 2:15 am



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.
---
Laugh at life or life will laugh at you.
OOo 2.4 on K/Ubuntu Hardy Heron 8.04 and WinXP Pro and Home
Repossess your computer!
User avatar
Corfy
Volunteer
 
Posts: 35
Joined: Mon Oct 08, 2007 1:30 am
Location: near Indianapolis, IN, USA

Re: maximum sheets exceeded in spreadsheet

Postby Hagar Delest » Tue Dec 25, 2007 1:12 pm

There is an enhancement request here : Issue 19440 - Increase number of sheets and columns. 4 years old and only 3 votes !
AOO 4.1.7 on Xubuntu 19.10 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28590
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: MSN [Bot] and 15 guests