https://bz.apache.org/ooo/show_bug.cgi?id=86314
Czesław Wolański <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #4 from Czesław Wolański <[email protected]> --- >From a note in ODF spec: "OpenOffice.org 2 splits the difference: Inline Text is converted to a Number (like Excel), but references to Text are always considered 0 (even if they could be converted to a different number, and would be converted to a different number if in-line). Thus, in OOo 2, if B3 has the string value "7", B3+1 is 1, but "7"+1 and (B3&"")+1 are both 8." OOo 3.2.0 introduced a new approach: "While interpreting a formula expression, string content is now converted to numeric values if conversion is unambiguous, or a #VALUE! error is set if no unambiguous conversion is possible.(...)" See: - the 3.2.0 Release Notes http://www.openoffice.org/development/releases/3.2.0.html - Issue 5658 ("Spreadsheet thinks a number is a string (text)" - Calc Help topic "Converting Text to Numbers" The attached .png file demonstrates the difference. Issue fixed, can be closed. -- You are receiving this mail because: You are the assignee for the issue. You are on the CC list for the issue.
