[Libreoffice-bugs] [Bug 44132] FILESAVE XLSX XLS =ISEVEN() formula does not work when saving in .xls and .xlsx formats

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=44132

--- Comment #10 from NISZ LibreOffice Team <libreoffice at nisz.hu> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200826/a048ffd4/attachment.htm>