To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=110079
Issue #|110079
Summary|Formula calculation
Component|Formula editor
Version|OOo 3.2
Platform|Opteron/x86_64
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|ui
Assigned to|mru
Reported by|sultanao
------- Additional comments from sulta...@openoffice.org Fri Mar 12 14:01:13
+0000 2010 -------
Please use Calc and define a sheet with the following data:
A1: "8.00"
B1: "13.00"
C1: "13.40"
D1: "17.00"
E1 (italian notation):
=SE(O(VAL.VUOTO(A1);VAL.VUOTO(D1));"0.00";D1-SE(O(VAL.VUOTO(B1);VAL.VUOTO(C1));"0.00";SE(C1-B1<ORARIO.VALORE("0.30");"0.30";C1-B1))-A1)
This works fine and I can read "8.20" on E1.
Now put the following data:
A2: "8.00"
B2: "13.00"
C2: "13.20"
D2: "17:00"
E2 (italian notation):
=SE(O(VAL.VUOTO(A2);VAL.VUOTO(D1));"0.00";D2-SE(O(VAL.VUOTO(B2);VAL.VUOTO(C2));"0.00";SE(C2-B2<ORARIO.VALORE("0.30");"0.30";C2-B2))-A2)
This works fine with OO 3.1.1 and the result on E2 is "8.40". But the same does
not work with OO 3.2: in this case the result on E2 is #VALORE.
I tried on an INTEL machine with Windows XP O.S. and Italian version of OO. It
seems a regression.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sw.openoffice.org
For additional commands, e-mail: issues-h...@sw.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
