Return-Path: X-Original-To: apmail-incubator-ooo-issues-archive@minotaur.apache.org Delivered-To: apmail-incubator-ooo-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 34B75C552 for ; Thu, 17 May 2012 23:51:07 +0000 (UTC) Received: (qmail 64560 invoked by uid 500); 17 May 2012 23:51:07 -0000 Delivered-To: apmail-incubator-ooo-issues-archive@incubator.apache.org Received: (qmail 64531 invoked by uid 500); 17 May 2012 23:51:07 -0000 Mailing-List: contact ooo-issues-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ooo-issues@incubator.apache.org Delivered-To: mailing list ooo-issues@incubator.apache.org Received: (qmail 64522 invoked by uid 99); 17 May 2012 23:51:07 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 May 2012 23:51:06 +0000 X-ASF-Spam-Status: No, hits=-1997.8 required=5.0 tests=ALL_TRUSTED,HTML_MESSAGE X-Spam-Check-By: apache.org Received: from [140.211.11.123] (HELO sif.zones.apache.org) (140.211.11.123) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 May 2012 23:51:05 +0000 Received: by sif.zones.apache.org (Postfix, from userid 80) id 5CC8847A0; Thu, 17 May 2012 23:50:45 +0000 (UTC) From: bugzilla@apache.org To: ooo-issues@incubator.apache.org Subject: [Bug 119374] New: Incorrect TIME function Date: Thu, 17 May 2012 23:50:41 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: spreadsheet X-Bugzilla-Component: ui X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: aguelzow@pyrshep.ca X-Bugzilla-Status: UNCONFIRMED X-Bugzilla-Priority: P3 X-Bugzilla-Assigned-To: ooo-issues@incubator.apache.org X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: priority bug_id assigned_to short_desc bug_severity cf_bug_type classification op_sys reporter rep_platform bug_status version component product Message-ID: Content-Type: multipart/alternative; boundary="1337298645.FC221.62084"; charset="us-ascii" X-Bugzilla-URL: https://issues.apache.org/ooo/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --1337298645.FC221.62084 Date: Thu, 17 May 2012 23:50:45 +0000 MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" 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. --1337298645.FC221.62084--