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 <xbo...@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+unsubscr...@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+unsubscr...@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