Issue 11041 - Time in formula not used for calculation
Summary: Time in formula not used for calculation
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
Depends on:
Reported: 2003-01-29 13:27 UTC by Unknown
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-01-29 13:27:17 UTC
A1 contains a value    = 10:00
A2 contains a value    = 20:00
A3 contains a formula  = =if(A2-A1>0;"0:30";0)
A4 contains a formula  = =(A1+A2)-A3

Excel says: 29:30
OOo says:   30:00

German built. Locale said to german. 
AutoSpelling off, Check WordsWithNumbers off.
Comment 1 peter.junge 2003-04-10 18:56:55 UTC
Priority much too high.
Comment 2 Unknown 2003-04-10 19:44:08 UTC
How is the priority being decided? This issue stops my client from
embracing OpenOffice. The importance in this issue raises due to the
fact that NO error is being issued. The user is receiving wrong
information without being aware. It caused big tumult at the clients
site due to decisions nearly made upon wrong information.

A crash is not good, but the user is aware of a problem. Silently
producing wrong information undermines trust in a product.
Comment 3 frank 2003-04-11 08:46:56 UTC

this is not a bug !

Calc does not calculate with text !

The expression you gave us set's the value "0:30" as text. To achieve
what you want, you have to enter it in one of the following ways :

1. =IF($C$4-$C$3>0;VALUE("0:30");0)
2. =IF($C$4-$C$3>0;0:30;0) which will change automatically to the
third point.
3. =IF($C$4-$C$3>0;0,0208333333333333;0)

To check if a cell content is text or a number, just hit CTRL + F8.
Text will display in black, formula results are green and numbers are

The priority settings are defined by the QA Project and can be found
under the Priority Link on this page.

Best regards

Comment 4 frank 2003-04-11 08:47:11 UTC
closed invalid
Comment 5 Unknown 2003-04-11 16:54:32 UTC
OOo claims Excel compatibility. The formula works under MS Excel
without a problem for a couple of years now. It is not a matter of
finding a workaround, it is a matter, of silently producing other
results, than originally.
If you discard this bug as being invalid, OOo should stop claiming
compatibilty with Excel. The compatibility is of no use, if the
results of a calculation are different. 

If a formula can not be interpreted by OOo, it should return ERROR and
not 0. That way, the user is aware of a problem. Otherwise the user
must assume the information given to him by OOo is as valid, as the
information given to him by Excel.

Maybe the bug is not in the interpretation of the formula, but lies in
the fact of not reporting an erroneous formula. 

Nevertheless, this issue had caused lots of trouble. The way this
issue is dealt with at this point in time, stears one away from
suggesting to clients the use of OOo, which IMO, and in the light of
the work that has been put into this project, be very unfortunate.
Comment 6 frank 2003-04-14 10:47:41 UTC
No one ever said that we are 100% compatible and viewed from the
logical site you never can calculate with text.

Nevertheless I set this one as duplicate to Issue 5658 that deals with
the calculation mode for textvalues.


*** This issue has been marked as a duplicate of 5658 ***
Comment 7 frank 2003-04-14 10:47:56 UTC
closed double