https://bugs.freedesktop.org/show_bug.cgi?id=83779
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Hardware|Other |All OS|Windows (All) |All Status|UNCONFIRMED |NEW Summary|FILESAVE: Error in saving |FILESAVE: Error in saving |as Excel files - ISNUMBER |as Excel files - logical |function |boolean type of FALSE and | |TRUE values not preserved | |during input Version|4.2.5.2 release |Inherited From OOo Ever confirmed|0 |1 --- Comment #1 from Eike Rathke <[email protected]> --- Calc does not have a distinct boolean type, whereas Excel does and expects it and does not convert numeric type to boolean type. The expression IF(ISNUMBER(XX)=FALSE,...) or IF(ISNUMBER(XX)=0,...) can be rewritten as IF(ISNUMBER(XX)=FALSE(),...) or IF(NOT(ISNUMBER(XX)),...) so that both applications understand it. It may be desirable to preserve input and imported FALSE and TRUE values by converting them to FALSE() and TRUE() functions. -- 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
