To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104714 Issue #|104714 Summary|Calc in german wrongly accepts invalid expression Component|Spreadsheet Version|OOo 3.1.1 Platform|PC URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|editing Assigned to|spreadsheet Reported by|sweigel
------- Additional comments from [email protected] Wed Sep 2 08:33:22 +0000 2009 ------- For reproducing this bug you should have OOo in english as well as in german localization. First try with englisch OOo: (1) Open new spreadsheet (2) In A2 enter: =IF((A1>=0.1)AND(A1<1);1;0) (3) Result is: 0 or 1 depending on your value in A1 Ok, so far. (4) In A2 enter: =IF(A1>=0.1AND(A1<1);1;0) (5) Missing brackets lead to result: #NAME? Ok, so far. Now try with german OOo: (1) Open new spreadsheet (2) In A2 enter: =WENN(A1>=0,1UND(A1<1),1,0) (3) Missing brackets do *NOT* lead to an error. (4) Result is: 0 or 1 depending on your value in A1 (5) Save, close and reopen the document (6) You get: =WENN(A1>=0.1and(A1<1);1;0) (7) Formula is not usable anymore. The defect is, that Calc accepted the wrong formula with missing brackets in german step 2. --------------------------------------------------------------------- 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: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
