Re: [libreoffice-users] column limit in libreoffice 4.3.something
On 04/24/2015 02:08 PM, Tom Davies wrote: Hi :) Have you tried Gnumeric for spreadsheet work? It is a dedicated spreadsheet program rather than being part of a suite so there are quite a few advantages to it for serious spreadsheeting work. Regards from Tom :) ...mmmh, does it works in windows too??? I will try.. :-) -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] column limit in libreoffice 4.3.something
Hi :) Have you tried Gnumeric for spreadsheet work? It is a dedicated spreadsheet program rather than being part of a suite so there are quite a few advantages to it for serious spreadsheeting work. Regards from Tom :) On 24 April 2015 at 08:39, yahoo-pier_andreit pier_andr...@yahoo.it wrote: On 04/23/2015 08:53 PM, Luuk wrote: 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 I exported a 2kx2k dataset in csv from a database to be eaten by a python program and I can open it in excel but non in libreoffice calc, and this is bad... :-) :-) - Please, share COMPLETE (version) info, or nothing if you are too lazy to find out ;) I wasn't there when I posted and i supposed that a parameter like numbers of columns doesn't change in subversions... :-) :-) -- To unsubscribe e-mail to: users+unsubscr...@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+unsubscr...@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
Re: [libreoffice-users] column limit in libreoffice 4.3.something
Try importing into Base as csv, pay particular attention formatting on this screen matches your csv. During import keep an eye out for errors. Stop at error, look at last record imported in table. Using text editor, fix that or next record. Delete Base database and re-iterate until no errors found. When complete import occurs, copy table to Calc. This works fairly well for finding import errors and copying from Base to Calc is usually a clean process. Just ran my first Firebird test and it does import much fast than HSQL1.8 Yes, I did have problems importing a csv directly into Calc which showed non-english character set. Hope this helps. On 4/24/2015 3:39 AM, yahoo-pier_andreit wrote: On 04/23/2015 08:53 PM, Luuk wrote: 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 I exported a 2kx2k dataset in csv from a database to be eaten by a python program and I can open it in excel but non in libreoffice calc, and this is bad... :-) :-) - Please, share COMPLETE (version) info, or nothing if you are too lazy to find out ;) I wasn't there when I posted and i supposed that a parameter like numbers of columns doesn't change in subversions... :-) :-) -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] column limit in libreoffice 4.3.something
On 04/23/2015 08:53 PM, Luuk wrote: 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 I exported a 2kx2k dataset in csv from a database to be eaten by a python program and I can open it in excel but non in libreoffice calc, and this is bad... :-) :-) - Please, share COMPLETE (version) info, or nothing if you are too lazy to find out ;) I wasn't there when I posted and i supposed that a parameter like numbers of columns doesn't change in subversions... :-) :-) -- To unsubscribe e-mail to: users+unsubscr...@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
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+unsubscr...@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
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 luu...@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+unsubscr...@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+unsubscr...@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