Apache OpenOffice (AOO) Bugzilla – Issue 11041
Time in formula not used for calculation
Last modified: 2003-09-08 16:55:29 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.
Priority much too high.
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.
Hi, 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 blue. The priority settings are defined by the QA Project and can be found under the Priority Link on this page. Best regards Frank
closed invalid
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.
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. Frank *** This issue has been marked as a duplicate of 5658 ***
closed double