To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96017 Issue #|96017 Summary|Dropped parentheses from IF formula Component|Spreadsheet Version|OOO300m9 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|freeoperant
------- Additional comments from [EMAIL PROTECTED] Sun Nov 9 21:35:39 +0000 2008 ------- I just opened a spreadsheet with OOO3.0, which worked in OOO2.x. When I upgraded to OOO3.0 I received Err:509 in cells with formulas similar to: =IF(VLOOKUP(AG12;$A$12:$B$576;2)=1);1; 0 On further inspection, one level of parentheses was dropped. I corrected it as follows: =IF((VLOOKUP(AG12;$A$12:$B$576;2)=1);1; 0) which got me the correct result. Every cell that used this kind of formula had the same problem. --------------------------------------------------------------------- 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]
