https://bugs.documentfoundation.org/show_bug.cgi?id=44132
--- Comment #10 from NISZ LibreOffice Team <[email protected]> ---
Rechecking this:
* Saving the example attachment 54800 as XLSX in current Calc 7.1alpha the
exported function is ISEVEN, works the same on reload as the ODS.
* Saving the example attachment 54800 as XLS in current Calc 7.1alpha the
exported function is ISEVEN but on reload it's opened as ISEVEN_ADD, works the
same as the ODS.
Opening these in Excel gives different result in case of the fifth line:
In Excel 13 the IF function gives a different result on IF(ISEVEN(E3)=1;1;0)
and =IF(ISEVEN(E2)=1;1;0) probably only accidentally gives the same result as
in Calc:
IF can evaluate comparison with numbers in Calc as true/false while they seem
always to be false inc Excel.
ISEVEN(E3)=1 as condition of IF is really ISEVEN(2)=1 which makes the condition
TRUE=1
I'm not sure if this is a bug or a feature, in any case it's not clearly
documented at:
https://help.libreoffice.org/7.1/en-US/text/scalc/01/04060105.html?DbPAR=CALC#bm_id3150141
When the ODS is saved in Excel 13 as XLSX and opened in Calc, it opens as
ISEVEN and works the same as the ODS - but Excel cached the result of
IF(ISEVEN(E3)=1;1;0) so a hard recalc is needed (unlike in case of LO-saved
XLSX). All in all this can be considered good on our end.
When the ODS is saved in a Hungarian Excel 13 as XLS and opened in Calc, it
opens as =IF(PÁROSE(E3)=1;1;0) with English locale Calc and as
=HA(PÁROSE(E3)=1;1;0) with Hungarian locale Calc in the input line but the grid
in both cases displays the #ADDIN? error.
This part is annoying, but should be an extremely rare case.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
