Issue 57868

Summary: Suggestion for locale-casting functions
Product: Calc Reporter: bobharvey <bobharvey>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

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.