Issue 123635 - [Enhancement] Function VALUE with optional locale argument
Summary: [Enhancement] Function VALUE with optional locale argument
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.0.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-11-05 10:02 UTC by Andreas Säger
Modified: 2017-04-13 12:47 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Attachments
ODF Spreadsheet (13.82 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-01-15 23:50 UTC, Andreas Säger 		no flags Details
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 Andreas Säger 2013-11-05 10:02:20 UTC 
VALUE returns different results under different locale settings.
How about an optional second argument to override the global locale?

=VALUE("1.234";"en-UK") => 1.234
=VALUE("1.234";"de-DE") => 1234
=VALUE("1,234";"de-DE") => 1.234
=VALUE("1/2/34";"en-UK") => 1934-02-01
=VALUE("1/2/34";"en-US") => 1934-01-02
Comment 1 Edwin Sharp 2014-01-15 13:29:22 UTC 
Is this an enhancement request?

Can you please attach real life example?
Comment 2 Andreas Säger 2014-01-15 23:50:23 UTC 
Created attachment 82297 [details]
ODF Spreadsheet

Demonstrating locale dependent conversion from text to number and number to text.
The same formulas return different results in different locale context.
Comment 3 Edwin Sharp 2014-01-16 06:53:22 UTC 
Thank you.

Confirmed with
AOO410m1(Build:9750)  -  Rev. 1557669
2014-01-14_04:11:13 - Rev. 1557927
Debian
Comment 4 Andreas Säger 2014-01-16 14:24:32 UTC 
Additional notes:
Applies to VALUE, DATEVALUE, TIMEVALUE, TEXT which could all have an optional locale argument (POSIX strings like "en-US") with a help file listing the supported locales.
If the optional argument defaults to the current office locale, existing formulas won't break.
For many users importing text and conversion from text to number are most difficult tasks and sometimes they do not really understand the problem nor the existing solutions. Working conversion formulas may help a little bit in this mine field.
Comment 5 Wolfgang Jäger 2017-04-13 12:47:16 UTC 
+1