https://bz.apache.org/ooo/show_bug.cgi?id=126656
bmarcelly <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from bmarcelly <[email protected]> --- Yes, confirmed with Locale Setting French (France) =VALUE("2,2")*2 works where "," is the decimal separator. And of course does not work with Locale setting English (USA). Writing a formula like =VALUE("2,2")*2 is ambiguous: its result depends on the user Locale setting. Just change it and re-evaluate the formula, the result changes. A more striking example : =VALUE("2,345")*2 Locale en-US gives value : 4690 because , is a thousands separator Locale fr-FR gives value : 4.69 because , is a decimal separator (the value is displayed as 4,69) And of course writing ="2,2"*2 has the same fundamental problem : it is an incorrect formula. -- You are receiving this mail because: You are the assignee for the issue.
