Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Dec 2009
    Location
    Down Under
    Posts
    78
    Thanks
    14
    Thanked 2 Times in 2 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
    10,019
    Thanks
    423
    Thanked 1,609 Times in 1,453 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,354
    Thanks
    4
    Thanked 229 Times in 210 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
    Star Lounger
    Join Date
    Dec 2009
    Location
    Down Under
    Posts
    78
    Thanks
    14
    Thanked 2 Times in 2 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
  •