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

Hi :)
Don't worry.  The xlsX file probably gives users of other versions of MS
Office (such as 2010, 2007, let alone 2003 and others that can't use it)
similar problems because each version of MS Office that can use xlsX has a
slightly different "transitional" version.  In this particular case though
it's probably a misbehaving macro rather than simply the format.  Many
places block the use of macros because MS Office macros have been used to
spread malware all too often.

You have a limited range of options such as;
1.  try to get someone to use MS Office 2013 to "Save As ..." in the older
MS formats (for MS Office 2003, Xp, '97) = but if it IS a macro then this
wont help (in which case see 3)
2.  buy MS Office 2013 and either buy a computer with Windows already on it
or buy and install Windows (perhaps inside a Virtual Machine?).  Probably
requires at least Win7 or Win8
3.  find some way of opening the macros and re-write, or pay someone to
re-write them for you, these are then highly likely to work smoothly in all
different versions of LibreOffice and OpenOffice

Use of ODF is not some theoretical ethical nicety.  It's about
cost-reduction, interoperability (even cross-platform) and security.  You
have bumped into one of the reasons for rejecting XlsX although whoever you
got the file from will probably claim it's a reason for everyone having to
buy 2013 (and then later on will insist everyone buys 365 for the same
Regards from
Tom :)

On 30 June 2014 17:40, Xbot <> wrote:


I have a compatibility issue opening an .xlsx file with calc (LO instead of different choices in a pull-down menu, I only get
Err:509 when for example I click on the arrow .

For example if I click in the first column (B2), there is a little arrow
on the right. It's supposed to open a pull-down menu if I click it, but
I only see a 509 error. Of course it works flawless in Excel 2013.

I'm not the creator of this file (otherwise it would have been an .ods
one) but I have to find a solution to fill it with LibreOffice

According to LO's help it's related to "Missing operator Operator is
missing, for example, "=2(3+4) * ", where the operator between "2" and
"(" is missing.". But I can't see how to solve it in this file, do you
have an idea?

I've attached the xlsx file, hope it helps.

Best regards

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.