Apologies; I noticed I didn't change the subject in my previous mail a
minute ago
Thanks for the advice Tom.
I'll wait a bit longer and post again if nothing happens.
Also good for my practise of the virtue called patience
Ludo
www.potingue.be
Hi
Errr, sorry you haven't had any responses yet. It often seems to happen
that way as the people here during the week start to drop away and the
weekend crowd are not quite here yet.
It is generally better to start a completely fresh new email when writing
to a mailing list. Even if your post does turn out to be very similar to
an existing issue it might turn out to be different enough that it really
needs a different approach.
In forums it's less of an issue and some mailing lists don't mind it too
much either but the lack of responses suggests it might be good to post as
a new topic fairly soon.
Regards from
Tom
Hi Tom
This is a tongue in cheek way of saying RTFM?
First of all, the section on Calc alone is 438 pages; browsing through the
TOC plus the FAQ also, the answer to my question on importing the correct
way is not there.
Sure, if I wanted to do the job again from scratch, it would be the way to
go, but in my case everything is done already - only in MS_Excel2010
instead of Calc.
Ludo
www.potingue.be
Hi
I tend to find it's best to post first and then start looking through
documentation. If i do find the answer first then it's easy to answer my
own question but the waiting can almost seem painful sometimes.
I'm not sure if the documentation would help with this tbh, because i
haven't read it!
https://wiki.documentfoundation.org/Documentation/Publications
There is an Faq and i think the Calc section might well have been done
already
https://wiki.documentfoundation.org/Faq
Regards from
Tom
"Ludo Beckers":
I don't know much about spreadsheets, but notice some differences:
It is expected, as Excel 2007+ format support is very incomplete. There is a small chance the results will be better importing Excel 2003 format.
Hi Ludo
Ludo Beckers wrote
I made a spreadsheet with a data-table in Excel2010 and opened it at home
with LibreOffice3.5.7.2--snip--
Is this expected behaviour, or should I have imported it in some special
way in LibreOffice?
Why are you using a version released in October 2012? You will probably get
much better results using version 4.2.4 recently released...
There is no need to import. You simply should open the file as with any ODS
spreadsheet.
As you are probably aware LibreOffice's goal is to promote open document
formats (namely ODF). Importing/exporting documents from/to Microsoft's
closed formats is a work in progress (deliberately made difficult by
Microsoft so they can sell a new version every other year)
HTH,
Pedro
I just updated to 4.2.3.3 via ppa (using LinuxMint-KDE) and it solved the
issue of missing data!
I read in fora that ppa for LibreOffice is quite safe, so yes, it helped -
thanks
Ludo
<http://www.potingue.be>