[sc-features] changed/cws odff05 : DATEVALUE and TIMEVALUE now return date or time only

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[sc-features] changed/cws odff05 : DATEVALUE and TIMEVALUE now return date or time only

eike.rathke


       Product: Spreadsheet
          Type: changed
         Title: DATEVALUE and TIMEVALUE now return date or time only
     Posted by: [hidden email]
      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 [hidden email]



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]