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: firstname.lastname@example.org
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy