https://bugs.freedesktop.org/show_bug.cgi?id=44132
Bug #: 44132
Summary: =ISEVEN() formula does not work when saving in .xls
and .xlsx formats
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.0 Beta2
Platform: x86-64 (AMD64)
OS/Version: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 54800
--> https://bugs.freedesktop.org/attachment.cgi?id=54800
ods format - All works fine
If you open a new LibreOffice Calc file, fill E2 cell with a number and Use
=ISEVEN(E2) formula, it gives the adequate response (TRUE if even number, FALSE
otherwise).
(1)If you save the file in .ods format, everything works as expected.
(2) The problem starts if you save and close the document and reopen again. In
this case, it gives a #MACRO? error.
If you Edit cell (E2) and press INTRO, same error.
If you Edit cell (E2), move cursor (Left or right arrow) and press INTRO,
OK.
If you open the document in Spanish version of MS Excel 2007 or 2010, works
fine. Converts formula to =ES.PAR(E2).
(3)If you save the document in the Spanish version of MS Excel 2010 in .xls
format and open it again in LibreOffice, it gives #ADDIN? error. Formula has
changed to =ES.PAR(E2).
(4)If you save the document in the Spanish version of MS Excel 2010 in
.xlsx format and open it again in LibreOffice, it works OK. Formula has changed
to =ISEVEN_ADD(E2).
Attaching 4 files:
(1)LibreofficeTest.ods - All works fine
(2)LibreofficeTestLinux.xls - saved in LO as .xls - #MACRO? error
(3)LibreofficeTest.xls - saved in MS2010 as .xls - #ADDIN? error
(4)LibreofficeTest.xlsx - saved in MS2010 as .xlsx - OK
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
