To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107098 Issue #|107098 Summary|sum.if gives an invalid results Component|Spreadsheet Version|OOO310m19 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|code Assigned to|spreadsheet Reported by|phb48
------- Additional comments from ph...@openoffice.org Sat Nov 21 13:22:18 +0000 2009 ------- Hi, I am using a worksheet "Finance" which contains several tabs corresponding to months. Let's simplify with January, February and March tabs which are enough to reproduce the bug. In each tab, I have a column that performs "sum.if" calculations based on a value located in another document "Bank1" which also contains tabs corresponding to the months. This allows me to compute sums based on accounting references for each month of the year. For example in Finance.January, I'll sum all lines of 1 column of Bank1 where a column will contain the value "aut" in Bank1.January. The same for all minths. New to version 3.1, my computations fail as soon as they are done for a month greater than January. This means they work for the first tab of the worksheet but not for the other ones. From February to December the values are exactly the same as the January values as if it was impossible for Calc to "go to" the tabs (or sub-worksheets) of the document. I reproduced this bug with 2 simplified worksheets and put colors and comments to highlight the problem which once visualized is easy to understand. I'll try to send them with this (first) bug report. This issue did not happen in the previous OpenOffice versions prior to 3.0.1. (I've been using OO from version 1.0 until now). Best regards, Philippe --------------------------------------------------------------------- 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...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org