To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=5658
User er changed the following:
What |Old value |New value
================================================================================
Status|STARTED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |FIXED
--------------------------------------------------------------------------------
------- Additional comments from e...@openoffice.org Wed Sep 2 14:14:06 +0000
2009 -------
In cws odff06:
revision 275712
sc/source/core/inc/interpre.hxx
sc/source/core/tool/interpr2.cxx
sc/source/core/tool/interpr4.cxx
Converts string content to numeric value, or sets #VALUE! error if no
unambiguous conversion is possible.
Converted are only integer numbers including exponent, and ISO 8601
dates and times in their extended formats with separators. Anything
else, especially fractional numeric values with decimal separators or
dates other than ISO 8601 would be locale dependent and is a no-no.
Leading and trailing blanks are ignored.
The following ISO 8601 formats are converted:
CCYY-MM-DD
CCYY-MM-DDThh:mm
CCYY-MM-DDThh:mm:ss
CCYY-MM-DDThh:mm:ss,s
CCYY-MM-DDThh:mm:ss.s
hh:mm
hh:mm:ss
hh:mm:ss,s
hh:mm:ss.s
The century CC may not be omitted and the two-digit year setting is not
taken into account. Instead of the T date and time separator exactly one
blank may be used.
If a date is given, it must be a valid Gregorian calendar date. In this
case the optional time must be in the range 00:00 to 23:59:59.99999...
If only time is given, it may have any value for hours, taking elapsed
time into account; minutes and seconds are limited to the value 59 as
well.
NOTES:
The conversion is done for single arguments, either referenced cell
content or inline string, cell range arguments are not affected, so
SUM(A1:A2) now will differ from A1+A2 if at least one of the cells
contain a convertible string, as in Excel ...
Because the conversion is also done for formula inline strings, such as
="1999-11-22"+42, calculations involving inline localized dates now
return an error, e.g. with "11/22/1999" or "22.11.1999".
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
