4 Replies Latest reply: Apr 15, 2012 1:02 AM by KOENIG Yvan
thlogans Level 1 Level 1 (0 points)

into the numbers app on my 32 gb ipad.  It is 1.9mb, 9 columns by 32,000 rows.  (it is regional sales data for my company).  I don't want to delete any data.  I have tried importing this via itunes and email and get the same error message - too many cells.  Breaking up this file into smaller  parts will defeat the whole purpose of what I am trying to accomplish for our traveling salespeople who want to show customers charts regarding sales history using the ipad.

 

Any suggestions to get this file imported will be very much appreciated!!

  • Barry Level 7 Level 7 (29,210 points)

    The message is pretty clear. There are too many cells.

    That message makes the means of importing the document pretty obvious: Reduce the number of cells.

     

    Regards,

    Barry

     

    Faint Hope clause: You may also want to check the (currently) last post in this thread.

    B

  • thlogans Level 1 Level 1 (0 points)

    But I understand through a previous message in this forum that Numbers supports 65,000 rows and 256 columns.  Is that true?

    BTW, I do understand the message, but am wondering if Numbers thinks I have more cells than I actually do somehow, though I have cleared the contents from the blank cells in case there was a piece of data floating somewhere.

  • Barry Level 7 Level 7 (29,210 points)

    "But I understand through a previous message in this forum that Numbers supports 65,000 rows and OR 256 columns.  Is that true?"

     

    True with the revision shown above.

     

    Numbers '09 tables may have a maximum 65 000 rows (the actual number is a few hundred greater).

    Numbers '09 tables may have a maximum 256 columns.

     

    But Numbers '09 tables do not support a maximum 65 000 rows AND 256 columns in the same table.

     

    Note that those specifications are for Numbers '09, and do not necessarily apply to Numbers for iOS.

     

    "…but am wondering if Numbers thinks I have more cells than I actually do somehow…"

     

    Possibly. see the thread linked in my previous message.

     

    Regards,

    Barry

     

    PS: I've requested this thread be transferred to the iWork for iOS community. If there is a more favourable answer, you're more likely to find it there.

    B

  • Level 8 Level 8 (41,780 points)

    The table size is limited by two features :

     

    (1) the application's code itself which can't work with more than 65525 rows and more than 256 columns.

    It's linked to design choices

     

    (2) the memory available to allow the app to open the doc.

     

    On my mac with 12 Gbytes installed the memory limit never strike.

     

    Some times ago I made extended tests and posted their results in this forum.

     

    Here they are one more time.

    When we import a text file (TSV or CSV) here are the greater tables which may be imported :

     

    65535 x 13 =  851 955 OK

    65431 x 14 =  916 034 cells

    61069 x 15  =  916 035 cells

    57252 x 16  =  916 032 cells

    53884 x 17 =  916 028 cells

    50890 x 18  =  916 020 cells

    48212 x 19  =  916 028 cells

    45801 x 20  =  916 020 cells

    43620 x 21  =  916 020 cells

    3578 x 256 =  915968 cells

     

    Yvan KOENIG (VALLAURIS, France) dimanche 15 avril 2012

    iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.3

    My Box account  is : http://www.box.com/s/00qnssoyeq2xvc22ra4k