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

Hi :)
The XlsX, and other OOXML formats are notoriously unreliable.  Each
different version of MS Office uses slightly different versions.  There are
at least 3 different "transitional" versions of the format and they are not
always compatible with each other.

If you take the XlsX that was saved by MS Office 2013 and try opening it in
another version of MS Office, say 2010 or 2007, or even 365 then you may
well find it's been opened in "Compatibility Mode" or even that it doesn't
work at all in extreme cases.  Chances are that some things will have moved
around or vanished, especially if you have anything in a frame (such as

It makes a bit of sense that a file created with newer software might not
fare too well on older versions of the same program but with XlsX and the
other OOXML formats it even seems to happen the other way around.  Save a
file in MS Office 2007 and you get the same problems trying to open that
file in more recent versions of MS Office.

MS keep the specs for their formats secret.  There is an ISO definition of
OOXML but that doesn't seem to work in any version of MS Office.  MSO 2013
was the first that allowed people to save in "strict" but the resultant
files don't seem to be able to be opened in any version of MS Office.

So pretty much all programs struggle with trying to read or write XlsX or
other OOXML files in any reliable way.  Which version of MS Office should
they aim for?

Actually we had a few times where the LibreOffice user in an office has
been the only person able to open files from colleagues using different
versions of MS Office and has then become a kinda stepping stone for
sharing files between those colleagues.  Similarly with OpenOffice.

Best advice seems to be to use either;
1.  the older MS Office format, Xls (without the X on the end), for MS
Office Xp/2000 and prior or
2.  stick with Ods.

Microsoft, in their 2010 version, refused to use the ODF 1.2 format that
everyone else was using at the time and stuck with a mangled version of the
older 1.0 (even ignoring the 1.1) and somehow that led to Ods appearing to
open just fine but all the formulas got replaced by fixed values.  Their
apparent failure somehow led to people saying that everyone else made bad
spreadsheet programs and everyone should stick with MS.

So it is well worth avoiding XlsX and it is probably best to use their
older Xls format instead - at least if you want to open the spreadsheet on
any machine other than the one with MS Office 2013 on.

Regards from
Tom :)

On 23 April 2015 at 15:03, RamonTavarez <> wrote:


I've experienced the following issue:

The file attached is an .ODS file (1,976 KB).  When seved as  .XLSX file it
expands to more than 15 MB.

If the new .XLSX files is oppened with MSOffice 2013 it will ask for
recovery of information within the file,  after that if we save the
recovered file to the same file type (.XLSX) the file shrinks to 2,393KB.



View this message in context:
Sent from the Users mailing list archive at

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.