https://bz.apache.org/ooo/show_bug.cgi?id=126656
orcmid <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |CONFIRMED Ever confirmed|0 |1 --- Comment #5 from orcmid <[email protected]> --- As has been revealed in these comments, the behavior is by design. VALUE("v") conversion is locale-dependent. For "v" (text) appearing where a number is required, OpenOffice only accepts values with no "," and "." characters. Furthermore, the formulas and values in an OpenOffice Calc spreadsheet are conveyed in ODF OpenFormula format when stored in .ods files and when read from such files. It is clear there are usability issues as well as interchange pitfalls where "," and "." are involved. The usability issued that inspired this bugzilla has to do with numbers carried in text not being interpreted as expected. On the other hand, interpreting them in the locale of the reader can lead to serious incorrect treatment. SHORT TERM: How do we provide guidance to users about how this works and what to watch out for? Is it about explaining how #VALUE can arise and how to trouble-shoot those cases? LONGER TERM: Much harder: What can we do to provide a better treatment that works between ODF implementations (i.e., has some level of "standard" support in ODF files between the different supporting products) and also works up/down versions of Apache OpenOffice? -- You are receiving this mail because: You are the assignee for the issue.
