To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115841 Issue #|115841 Summary|IF statement incorrectly resolved Component|Spreadsheet Version|OOO320m19 Platform|Unknown URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|code Assigned to|spreadsheet Reported by|murrayin
------- Additional comments from [email protected] Tue Nov 30 15:28:39 +0000 2010 ------- A (.xls) spreadsheet, in use for several years, both under EXCEL and OOO, includes separate sheets for income and expenditure. Next to each item of income or expenditure is a code allocating it to a particular category (column), each column being headed by the same code . The correct allocation is controlled by IF statements in each cell which compare the column's code to the income/expenditure code e.g. =IF($G8=H$3,$D8,0). Up to and including 320m18 (build 9502) this has produced the expected results. With Build 320m19 (build 9505 under Mint 10, GNOME) amounts are allocated to multiple contiguous columns, making the spreadsheet unusable. I have .xls and .pdf files to illustrate the problem but, this being my first issue, have not yet discovered how to attach them. My system is an IBM NetVista pentium 4 --------------------------------------------------------------------- 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]
