<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - FILESAVE XLSX XLS =ISEVEN() formula does not work when saving in .xls and .xlsx formats" href="https://bugs.documentfoundation.org/show_bug.cgi?id=44132#c10">Comment # 10</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - FILESAVE XLSX XLS =ISEVEN() formula does not work when saving in .xls and .xlsx formats" href="https://bugs.documentfoundation.org/show_bug.cgi?id=44132">bug 44132</a> from <a class="email" href="mailto:libreoffice@nisz.hu" title="NISZ LibreOffice Team <libreoffice@nisz.hu>"> NISZ LibreOffice Team</a> <pre>Rechecking this: * Saving the example <a href="http://bugs.documentfoundation.org/attachment.cgi?id=54800" name="attach_54800" title="ods format - All works fine">attachment 54800</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=54800&action=edit" title="ods format - All works fine">[details]</a> as XLSX in current Calc 7.1alpha the exported function is ISEVEN, works the same on reload as the ODS. * Saving the example <a href="http://bugs.documentfoundation.org/attachment.cgi?id=54800" name="attach_54800" title="ods format - All works fine">attachment 54800</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=54800&action=edit" title="ods format - All works fine">[details]</a> 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: <a href="https://help.libreoffice.org/7.1/en-US/text/scalc/01/04060105.html?DbPAR=CALC#bm_id3150141">https://help.libreoffice.org/7.1/en-US/text/scalc/01/04060105.html?DbPAR=CALC#bm_id3150141</a> 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>