You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/11/05 11:02:20 UTC
[Bug 123635] New: [Enhancement] Function VALUE with optional locale
argument
https://issues.apache.org/ooo/show_bug.cgi?id=123635
Bug ID: 123635
Issue Type: DEFECT
Summary: [Enhancement] Function VALUE with optional locale
argument
Product: Calc
Version: 4.0.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: editing
Assignee: issues@openoffice.apache.org
Reporter: villeroy@t-online.de
CC: issues@openoffice.apache.org
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
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123635] [Enhancement] Function VALUE with optional locale
argument
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123635
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords|needmoreinfo |
Status|UNCONFIRMED |CONFIRMED
Latest|--- |4.1-dev
Confirmation on| |
Ever confirmed|0 |1
--- Comment #3 from Edwin Sharp <el...@apache.org> ---
Thank you.
Confirmed with
AOO410m1(Build:9750) - Rev. 1557669
2014-01-14_04:11:13 - Rev. 1557927
Debian
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123635] [Enhancement] Function VALUE with optional locale
argument
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123635
--- Comment #4 from Andreas Säger <vi...@t-online.de> ---
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.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123635] [Enhancement] Function VALUE with optional locale
argument
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123635
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needmoreinfo
CC| |elish@apache.org
--- Comment #1 from Edwin Sharp <el...@apache.org> ---
Is this an enhancement request?
Can you please attach real life example?
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123635] [Enhancement] Function VALUE with optional locale
argument
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123635
--- Comment #2 from Andreas Säger <vi...@t-online.de> ---
Created attachment 82297
--> https://issues.apache.org/ooo/attachment.cgi?id=82297&action=edit
ODF Spreadsheet
Demonstrating locale dependent conversion from text to number and number to
text.
The same formulas return different results in different locale context.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.