Re: [libreoffice-users] Compatibility issue opening an .xlsx file with calc: Err:509

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
reasons).
Regards from
Tom :)





On 30 June 2014 17:40, Xbot <xbot12@gmail.com> wrote:

> Hi,
>
> I have a compatibility issue opening an .xlsx file with calc (LO
> 4.2.5.2): 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: users+unsubscribe@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

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