Product: Spreadsheet
Type: changed
Title: TIME function returns values 00:00:00 <= x <= 23:59:59.999
Posted by: [email protected]
Affected: sc
TaskId: i97169
<http://www.openoffice.org/issues/show_bug.cgi?id=97169>
Effective from: cws dr78
CWS:
<http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/dr78>
CWS status: new
*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [ ]
Performance test [ ]
Translation [ ]
UI relevant [ ]
*Description*
-------------
The TIME spreadsheet function returns values between 00:00:00 and
23:59:59.999... inclusive and wraps values equal to or greater than
24:00:00. Previous releases may have returned values equal to or
greater than 24:00:00. For example, TIME(24;59;59) now returns
00:59:59 whereas previously the value returned was 24:59:59.
This change aligns behavior with the ODF 1.2 OpenFormula specification
and other spreadsheet implementations.
Send feedback to [email protected]
--
------------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected] with Subject: help
