Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Down Under
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Just wondering what the maximum number of rows is in Open Office Calc 3.2 - can I replace MS Office Prof 2007 and handle the same number of rows?

  2. #2
    Star Lounger
    Join Date
    Dec 2009
    Location
    Mexico City, D.F., Mexico
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Calc 3.2 only supports 65,536 rows in its windows version. The Ubuntu version supports one million rows, like Excel 2007.
    This eco-post is made of recycled electrons

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    I'd be real interested in hearing from anyone out there who is using more that 65K rows in a single sheet.
    What I'd like to know is:
    How many Rows
    How many Cols per row
    How much memory do you have in the machine
    What processor are you using
    How large is the file on disk.

    Finally....How many years does it take to calculate

    Seriously, I would really be interested if anyone could provide this information.

    RG
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. #4
    Star Lounger
    Join Date
    Dec 2009
    Location
    Mexico City, D.F., Mexico
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I just created a sample file with the formula =RAND() in cells A1:A1000000. It took about 7 seconds to calculate. I then transformed the formulas into fixed values, then sorted the million cells, another 6 seconds. I filled in cells B1:L1000000 with the text "qwe", then saved the file: 11 MB but the uncompressed content is 300 MB. It took a minute to save or re-open. I have 3 GB and an Intel Dual Core T3400.
    This eco-post is made of recycled electrons

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    I quite often get sent data files with hundreds of thousands of rows. Of course, the first thing I do is stick them into a database where they belong!
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    New Lounger
    Join Date
    Dec 2009
    Location
    Down Under
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Rory,

    absolutely right - then again, some databases need to be worked on with respect to deduping records or merging two sets of records. One of the programs we use for this purpose requires the import of these records as xls files.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •