incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 119374] New: Incorrect TIME function
Date Thu, 17 May 2012 23:50:41 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=119374

          Priority: P3
            Bug ID: 119374
          Assignee: ooo-issues@incubator.apache.org
           Summary: Incorrect TIME function
          Severity: normal
        Issue Type: DEFECT
    Classification: Application
                OS: All
          Reporter: aguelzow@pyrshep.ca
          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.

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