Bug 53173 - FORMATTING VALUE() function only honours numbers according to global locale
Summary: FORMATTING VALUE() function only honours numbers according to global locale
Status: CLOSED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.0.4 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:4.1.0
Keywords:
Depends on:
Blocks:
 
Reported: 2012-08-06 16:58 UTC by joaquin
Modified: 2013-07-01 14:02 UTC (History)
0 users

See Also:
Crash report or crash signature:

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

Note You need to log in before you can comment on or make changes to this bug.
Description joaquin 2012-08-06 16:58:10 UTC 
It does not matter if you change the locale for a cell or a sheet, if your decimal separator in your global locale is "," there is no way to get "VALUE()" to create a NUMBER from texts like:

25.23
1,333.33
Comment 1 joaquin 2012-08-06 17:16:13 UTC 
Maybe the VALUE() function can honour locale-settings for a sheet or cel, or else can get an optional "FORMAT" parameter like the TEXT() function?
Comment 2 Eike Rathke 2013-07-01 13:58:15 UTC 
As of LibreOffice 4.1 there will be the NUMBERVALUE function to address this problem.
Comment 3 Eike Rathke 2013-07-01 14:02:02 UTC 
See bug 57180 for feature implementation.