Apache OpenOffice (AOO) Bugzilla – Issue 107098
sum.if gives an invalid results
Last modified: 2009-11-23 14:53:41 UTC
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
Created attachment 66227 [details] Bug reproduction
In OOo3.1.1 the links are not actualized when opening the document. After Edit > Link > Update the spreadsheets show the correct result. There is no error in OOo3.2Beta and no error in DEV300 m64. Therefore I think, that the bug is fixed already. Please try the newest versions. http://download.openoffice.org/
Hello, Thanks a lot for your answer. Unfortunately with my OOo version 3.1.1 updating the links does not help me to get the right results for spreadsheets february and march (January is always OK as I tried to describe) My exact version is OpenOffice.org 3.1.1 OOO310m19 (Build:9420) got from the packages of Ubuntu 9.10 64 bits. Both OO and Calc are in French. Best regards, Philippe
Hello again, I just found out something interesting when building a new virtual machine to debug this issue: If you go to the March spreadsheet if edit/link/update the link, the March spreadsheet gets the correct values but the January and February spreadsheets values are just replaced by the March values ! This is why you suggested me to edit/link/update and as I did it being on the January spreadsheet, it just updated it and gave its values to February and March which was incorrect. More generaly, if you edit/link updtae 1 spreadsheet, it updates all the other ones with its values ! In reality I have this with a complex spreadsheet on the 12 months of the year ! The exact latest version I used WITHOUT this bug was 3.0.1 OOO300m15 (Build:9379) coming with Ubuntu 9.04. Thanks a lot in advance to help me debug this issue. If the attachment of my first note is not enough, please tell me what you need. Best regards, Philippe
Yes, the problem is known for OOo3.1.1. The fix is already integrated and will be available with OOo3.2. You can try it in http://download.openoffice.org/next/other.html#dev1 *** This issue has been marked as a duplicate of 101639 ***
Thanks a lot again for your quick answer. I could not have one of the dev 3.2 versions work successfuly on my syste (they crashed) and had to donwgrade it to get back with OO 3.0.1 that works fine. I hope this sum.if / link issue is actually a duplicate and will be fixed in 3.2. If it's not the case I'll open a new ticket then. Closing. Best regards Philippe
A last feedback: I checked with ooo320m5 for Windows and it worked fine ;-)