Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


Hello!

I've run into problems converting from MS Excel .xls files to Open
Document .ods files. I want to use the localc -convert-to in command
line, so that the resulting document looks exactly the same when I
open the .xls file by hand, and click on Save As.


I thought, that this should do the job
localc -convert-to ods sani.xls

1) First problem is that the resulting file is many times bigger than
the "Save As" method. During the process, it also says that:

Warning: at xsl:stylesheet on line 2 of
file:///usr/lib/libreoffice/basis3.3/share/xslt/odfflatxml/odfflatxmlexport.xsl:
  Running an XSLT 1.0 stylesheet with an XSLT 2.0 processor

I found out that the resulting file is almost identical to file from
"Save As > .fods". So I (also by the message) conclude, that flat xml
format is used, where it should not be. (I think that specifiing a
filter name in -convert-to ods:"Magic Open Document Filter Name" could
work, but I could not find no list of filters).

2) Secondly, I noticed that the resulting (from localc -convert-to)
.ods (.fods) files have different range of visible cells. In original
.xls document (and in the Save As version) the "active cells" are
limited to first, say, 12 columns and 70 rows, whereas the converted
files show rows up to infinity. (the content is the same, size of
columns as well).

By diffing the Save As > .fods and -convert-to fods (= -convert-to
ods), I noticed that the files are almost the same, except for some
view tags that look like this:
<config:config-item-map-indexed config:name="Views">...

Is it possible to include this "view tags" in the console version to
achieve really exactly the same effect as the Save As method?



Thank very much for any help!

Regards,
Joe M.

-- 
For unsubscribe instructions e-mail to: users+help@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.