Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Suggestion for locale-casting functions|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
Description bobharvey 2005-11-14 12:25:04 UTC
There have been many remarks and suggestions about the problem of, for example, opening a UK style CSV file in a german-locale installation, or reading swiss number strings in a US spreadsheet. Much has been made of locale spotting or conversion or selection in the CSV import phase, and this is very important. But I want to suggest another enhancement that would also help with cut-and-paste. Why not impliment spreadsheet functions to cast number strings from one locale to another? The obvious conversion from ',' to '.' may not be enough, and the whole locale structure should be involved. How about =cast(from-locale;to-locale;string) as a function definition?
Comment 1 frank 2006-02-17 11:55:51 UTC
One for the requirements team.
Comment 2 bobharvey 2008-09-01 09:54:20 UTC
Following on from issue 53498, that method of numerical representation should also be available with locale casting functions. Someone writing a presentation on a south african machine, could illustrate Indian numbers in his calculation with such functions.