I tried opening a large spreadsheet on my iPad and got the error that I had too many cells. I know in excel the limit is per number of rows but does anyone know what the limit is in numbers? Is it different for the ipad that it is for my mac?
iPad
On the mac a table is restricted to 256 columns and 65535 rows.
Here you are in a forum dedicated to Numbers on OSX.
For question about Numbers for iOS, better ask in :
https://discussions.apple.com/community/app_store/iwork_for_ios
Yvan KOENIG (VALLAURIS, France) jeudi 8 septembre 2011 13:41:08
iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0
My iDisk is : <http://public.me.com/koenigyvan>
Please : Search for questions similar to your own before submitting them to the community
The number of populated cells Numbers can deal with, depends on the installed memory of your System. Look there --> http://support.apple.com/kb/HT1017
A Excel 2007 or 2010 spreadsheet contain 1,048,576 rows and 16,384 columns.
A Numbers spreadsheet contains 65535 rows and 256 colums like the older Excel up to Excel 2003
So you may get an error trying to open a 1.048.576 row and 16.384 columns sheet in Numbers, especially if there are populated cells outside the 65535 x 256 range of Numbers.
Or if the number of populated cells in the sheet you want to open is not supported by your system memory.
Cheers - Lupunus
lupunus wrote:
A Excel 2007 or 2010 spreadsheet contain 1,048,576 rows and 16,384 columns.
A Numbers spreadsheet Table contains 65535 rows and 256 columns like the older Excel up to Excel 2003
For Numbers, "spreadsheet" refers to the document itself, which may have several Tables. Each Table has a maximum size of 65535 rows by 255 columns.
In practical terms, though, row counts far less than the maximum will make Numbers very slow.
Regards,
Barry
what is the maximum number of cells allowed?
