https://bugs.freedesktop.org/show_bug.cgi?id=75886
--- Comment #5 from Eike Rathke <[email protected]> --- Indeed, Gerard made a good point why using a string concatenation with a localized TRUE() result is not advisable. Thinking of this, changing the behavior may also break documents that rely on the current numerical value. (In reply to comment #3) > Is there any motivation (apart from simpler implementation of LibreOffice) > for not having a boolean type? An earlier motivation was that Excel back in older versions could not calculate with boolean values, e.g. =1+(1<2) was not possible (it is now in at least Excel2013), there wasn't much sense in mimicking all the Excel behavior. > E.g. does the ODF standard say something about this? It explicitly states that both is possible, see http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#LogicalNumber 4.3.7 and 4.5 > If adding a real boolean type is not feasible then I suspect this > inconsistency will not be fixed because the possible solutions you mention > sound like they would add quite a bit of overhead. There's even more to it, for example Excel has some odd behavior where in sorted data boolean values appear. -- 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
