https://issues.apache.org/ooo/show_bug.cgi?id=119374
Priority: P3
Bug ID: 119374
Assignee: [email protected]
Summary: Incorrect TIME function
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: [email protected]
Hardware: PC
Status: UNCONFIRMED
Version: version58
Component: ui
Product: spreadsheet
Created attachment 77560
--> https://issues.apache.org/ooo/attachment.cgi?id=77560&action=edit
sample test file (also available in the document repository of the OASIS OIC
TC)
ODF 1.2 Part 2 Section 6.10.17 defines the TIME function as follows:
-------------------------------------------------------------------------------
Summary: Constructs a time value from hours, minutes, and seconds.
Syntax: TIME( Number hours ; Number minutes ; Number seconds )
Returns: Time
Constraints: None.
Evaluators may first perform INT() on the hour, minute, and second before doing
the calculation.
Semantics: Returns the fraction of the day consumed by the given time, i.e.:
((hours*60*60)+(minutes*60)+seconds)/(24*60*60)
Time is a subtype of number, where a time value of 1 = 1 day = 24 hours.
Hours, minutes, and seconds may be any number (they shall not be limited to the
ranges 0..24, 0..59, or 0..60 respectively).
-------------------------------------------------------------------------------
Specifically the expressions
=(TIME(48;0;0)=2)
and
=(TIME(-48,0,0)=-2)
should evaluate to TRUE when enetered in cells of Apache OpenOffice Calc.
I am attaching a sample test file for the TIME function.
--
You are receiving this mail because:
You are the assignee for the bug.
