Product: Spreadsheet
Type: changed
Title: DATEVALUE and TIMEVALUE now return date or time only
Posted by: [EMAIL PROTECTED]
Affected: sc
TaskId: i94765
<http://www.openoffice.org/issues/show_bug.cgi?id=94765>
Effective from: cws odff05
CWS:
<http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/odff05>
CWS status: new
*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [ ]
UI relevant [ ]
*Description*
-------------
The DATEVALUE and TIMEVALUE spreadsheet functions now return the
numeric value for date repectively time only. In the case of DATEVALUE
only the integer part of the date serial is returned, in the case of
TIMEVALUE only the fractional part is returned. Previously, both
functions returned the combined integer and fractional value.
This change aligns with the behavior of other spreadsheet applications and
the definition given in the OASIS ODFF/OpenFormula specification
available at
http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula
Send feedback to [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
