Apache OpenOffice (AOO) Bugzilla – Issue 118061
values not taken into account by sum.if in linked spreadsheets
Last modified: 2014-03-28 00:55:55 UTC
Created attachment 76537 [details] Compressed file including finance.ods and banque1.ods with erroneous values in magenta background A few values are sometimes (not systematically) not taken into account in a sum.if function that operates in 2 linked spreadsheets. To reproduce this issue, open the attached finance.ods and check the values e1p and e2p in magenta. You should should see no value whereas if you check in the attached spreadsheet banque1.ods, there are corresponding values in magenta. If you go to tab "Mars" you'll see that one of the values has been taken into account. I observed this behavior with OpenOffice calc 3.3, 3.4 beta (340m0 build 9583), libreoffice 3.3.2 under Linux ubuntu 64 bits and Windows 7. This issue does not occur with OpenOffice 3.2 (Linux and Windows). Thx a lot for your input.
getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used.
As given in description. AOO410m1(Build:9750) - Rev. 1539999 2013-11-09_04:08:11 - Rev. 1540252 Debian
in the description of phbarbier@free.fr ,If you go to tab "Mars" you'll see that one of the values has been taken into account. but I checked the value ,it is null. AOO410m1(Build:9750) - Rev. 1566593 as the comment of phbarbier@free.fr, it can be found in oo3.3, set change the version.