Re: [libreoffice-users] column limit in libreoffice 4.3.something

I am using LO version 4.3.5.2.

Its spreadsheet size is "limited" to 1G cells (1K columns by 1M rows) per sheet. I don't know how 
many sheets are allowed. YMMV but I know that these spreadsheet size limits are currently quite 
sufficient for my needs. I also know that I currently have no desire to use anything bigger since 
the speed of adding a data value in a single cell at a time was abysmal when I had 4K rows on each 
of four sheets and used less than 100 columns on any single sheet. I trimmed the document back to 
about 1200 rows per sheet for now but I expect it will grow to between 4000 and 5000 by the end of 
the year when I'll start a fresh document with a couple hundred rows. 

Of course much of the processing time was most likely spent evaluating some reasonably (or maybe 
unreasonably) complex formulas. I'm working on formula simplification but this is difficult since I 
often make use of the OFFSET() function to reference dynamically defined ranges of cells.

-- 
Jim

-----Original Message-----
From: Luuk <luuk34@gmail.com>
To: users@global.libreoffice.org
Sent: Thu, 23 Apr 2015 11:54
Subject: Re: [libreoffice-users] column limit in libreoffice 4.3.something

On 23-4-2015 20:39, yahoo-pier_andreit wrote:
> today I encountered a problem opening an excel file with libreoffice
> 4.3.something regarding maximum number of column, why number of columns
> is so low in libreoffice ???
> many thanks, ciao :-) pier

- Please, define 'so low'

i see 1024 columns in 4.4.something and also in 4.1.something

- Please, share COMPLETE (version) info, or nothing if you are too lazy 
to find out.... ;)





-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted