incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject [Bug 119374] New: Incorrect TIME function
Date Thu, 17 May 2012 23:50:41 GMT

          Priority: P3
            Bug ID: 119374
           Summary: Incorrect TIME function
          Severity: normal
        Issue Type: DEFECT
    Classification: Application
                OS: All
          Hardware: PC
            Status: UNCONFIRMED
           Version: version58
         Component: ui
           Product: spreadsheet

Created attachment 77560
sample test file (also available in the document repository of the OASIS OIC

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.:
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 
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.

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message