Issue 6233 - Ignored calculations - somewhat serious defect
Summary: Ignored calculations - somewhat serious defect
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-07-01 15:50 UTC by Unknown
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2002-07-01 15:50:48 UTC 
Calculations are sometimes silently ignored. Try this:

Cell A2: 07:00
Cell B2: 
16:20
Cell C2: =IF((B2-A2)>TIME(8;44;0);"0:45";IF((B2-A2)>TIME(6;29;0);"0:30";IF((B2-
A2)>TIME(4;14;0);"0:15";"0:00")))
Cell D2: =B2-A2-C2

That's it. Result incorrectly 
shows 09:20 when it should be 08:35 (correct in excel).
Comment 1 frank 2002-07-02 10:11:12 UTC 
Hi Hundri Magusin,

this is not a bug ! Calc doesn't calculate with text values. 

Your IF Statements set the time values as Text ("0:45"). If you set
these values without quotationmarks, you will get numbers as the
function result and the correct value in D2.

So I have to close it but set it as duplicate to Issue 5658 which
deals with the same case.

Best regards

Frank

*** This issue has been marked as a duplicate of 5658 ***
Comment 2 frank 2002-07-02 10:11:46 UTC 
duplicate