https://bz.apache.org/ooo/show_bug.cgi?id=126754
mroe <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|NOT_AN_ISSUE |--- Latest|--- |4.1.2 Confirmation in| | Status|RESOLVED |UNCONFIRMED --- Comment #5 from mroe <[email protected]> --- Sorry, oooforum. I see it as a misbehaviour that Calc tries text to read as numbers. This was introduced to do it like Excel, but now Calc is defective in the same way. But the TEXT() function gives also wrong results (in my opinion): TEXT("3a","0") = "3a" The result should be 0, because text has per definition the value 0! TEXT("3e","0") = "3" It should be also 0, but it is "3" because "3e" is interpreted as the value 3e0 = 3E+0 = 3*(10^0) = 3 -- You are receiving this mail because: You are the assignee for the issue.
