Issue 57868 - Suggestion for locale-casting functions
Summary: Suggestion for locale-casting functions
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-11-14 12:25 UTC by bobharvey
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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.