https://bz.apache.org/ooo/show_bug.cgi?id=126656
--- Comment #4 from orcmid <[email protected]> --- The fact that these conversions from text to numbers are locale-sensitive is part of the definition of OpenFormula. Limiting automatic text->number conversion to integer cases is a way to avoid the interchange problems involved in the handling of separators in the text form. The VALUE( ) operation is defined to be locale-dependent. Conveying numbers via text values will have this problem in the absence of some way to know what the locale of the entry was. There may be provisions for that in ODF. I don't know that they are adequate for interchange across locales. The best way to have locale-neutral handling of numbers is to have the numbers be entered into number-format cells. The numeric value used for calculation is communicated in the document file in a local-independent format, regardless of how it was entered and how it is later displayed. This goes for dates, times, and currency values also. An alternative *technical* approach is to use a "."-less, ","-less format. For example, write ="22E-1"*2. That is a text syntax that will convert correctly regardless of locale. This is not something that users would likely do, and it leaves open the case of data obtained as already-prepared text values using locale-specific decimal and separator codes. I wonder how this is handled in Canada and other bi-lingual communities. -- You are receiving this mail because: You are the assignee for the issue.
