Issue 118061 - values not taken into account by sum.if in linked spreadsheets
Summary: values not taken into account by sum.if in linked spreadsheets
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 3.4.1
Hardware: PC Linux, all
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: zhaoshzh
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-05-21 19:16 UTC by phbarbier
Modified: 2014-03-28 00:55 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Compressed file including finance.ods and banque1.ods with erroneous values in magenta background (179.06 KB, application/x-gzip)
2011-05-21 19:16 UTC, phbarbier 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description phbarbier 2011-05-21 19:16:21 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.
Comment 1 Oliver-Rainer Wittmann 2012-06-13 12:29:54 UTC 
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 2 Edwin Sharp 2013-11-23 18:19:02 UTC 
As given in description.

AOO410m1(Build:9750)  -  Rev. 1539999
2013-11-09_04:08:11 - Rev. 1540252
Debian
Comment 3 zhaoshzh 2014-03-26 02:21:43 UTC 
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.