Issue 102388 - SUMIF function products Err:504 with external links
Summary: SUMIF function products Err:504 with external links
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOO310m11
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: regression
: 103626 (view as issue list)
Depends on:
Blocks: 101565
  Show dependency tree
 
Reported: 2009-05-30 21:46 UTC by macibro
Modified: 2013-08-07 15:15 UTC (History)
3 users (show)

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

Attachments
Zip file with "a.ods" and "b.ods" files (example) (13.46 KB, text/plain)
2009-05-30 21:49 UTC, macibro 		no flags Details
Stored b.ods with relative URIs enabled to make things testable (12.98 KB, application/x-compressed)
2009-07-03 15:43 UTC, ooo 		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 macibro 2009-05-30 21:46:04 UTC 
If I use SUMIF function who refers to cells of others files, I get an Err:504
error. If I use 3.0.1 everything is OK.

Example:
File "a.ods" has names in A1:A10 and values in B1:B10
In file "b.ods"  I type a name in A1 and then in B1 (using left-click for links)
=SUMIF('file:///C:/a.ods'#$Sheet1.A1:A10;A1;'file:///C:/a.ods'#$Sheet1.B1:B10)

I get Err:504
It works fine with previous release
Comment 1 macibro 2009-05-30 21:49:10 UTC 
Created attachment 62659 [details]
Zip file with  "a.ods" and "b.ods" files (example)
Comment 2 Regina Henschel 2009-05-31 00:16:49 UTC 
I can reproduce it with DEV300m49 on WinXP.

Same error with COUNTIF too.

It might be the same root cause than in issue 101645.
Comment 3 macibro 2009-05-31 12:55:59 UTC 
I saw issue 101645. It seems the same error
Comment 4 grakic 2009-06-09 14:07:51 UTC 
Dragan Milosavljevic sent a description of this bug to users@sr.openoffice.org
mailing list.

This seems to be a regression of new storage mechanism for external sheet data.

COUNT and SUM functions works as expected.
Comment 5 grakic 2009-06-09 14:13:30 UTC 
There is also a short OOoForum thread about this one
http://www.oooforum.org/forum/viewtopic.phtml?p=326608
Comment 6 grakic 2009-06-09 14:29:35 UTC 
Confirming this bug on GNU/Linux (Ubuntu).
Comment 7 Olaf Felka 2009-06-10 10:14:24 UTC 
reassigned
Comment 8 Olaf Felka 2009-06-10 10:16:32 UTC 
confirmed as blocker
Comment 9 jean_francois_philip 2009-06-14 08:16:12 UTC 
I can reproduce it with DEV300m49 on WinXP.

Same error with DSUM too.
Comment 10 oc 2009-06-15 09:09:09 UTC 
*** Issue 102750 has been marked as a duplicate of this issue. ***
Comment 11 ooo 2009-06-18 18:27:27 UTC 
Issue added to CWS dr68ooo311.
Comment 12 ooo 2009-06-26 13:41:49 UTC 
In cws dr68ooo311:

revision 273412
sc/source/core/inc/interpre.hxx
sc/source/core/tool/interpr1.cxx

This fixes SUMIF and COUNTIF.
All D*() database functions,  such as DSUM, DGET, ... are affected as well, but
aren't as easily fixable. I do not want to introduce major invasive changes in a
micro release.
Comment 13 ooo 2009-06-29 13:38:30 UTC 
Also in cws calc51 for OOo3.2:

revision 273474
sc/inc/address.hxx
sc/inc/compiler.hxx
sc/inc/externalrefmgr.hxx
sc/source/core/data/documen4.cxx
sc/source/core/data/table3.cxx
sc/source/core/inc/interpre.hxx
sc/source/core/tool/address.cxx
sc/source/core/tool/compiler.cxx
sc/source/core/tool/interpr1.cxx
sc/source/core/tool/interpr4.cxx
sc/source/ui/docshell/externalrefmgr.cxx
Comment 14 ooo 2009-07-03 15:43:10 UTC 
Created attachment 63353 [details]
Stored b.ods with relative URIs enabled to make things testable
Comment 15 ooo 2009-07-03 16:04:44 UTC 
Reassigning to QA for verification.

Note: the original b.ods of SUMIF.zip was stored with absolute URIs instead of
relative ones and doesn't work , use the second attachment instead.

I created issue 103317 for the relative/absolute URI problem.
Comment 16 oc 2009-07-13 14:34:47 UTC 
verified in internal build cws_dr60ooo311 and cws_calc51
Comment 17 helenrussian 2009-08-05 08:02:17 UTC 
*** Issue 103626 has been marked as a duplicate of this issue. ***
Comment 18 amy2008 2009-08-07 03:21:58 UTC 
Verified in DEV300m54 on WinXP
Closing
Comment 19 jean_francois_philip 2009-08-25 09:50:28 UTC 
It is necessary to create a new Issue for all D*() database functions ? or
re-opened this ?

I can reproduce it with DEV300m55 on WinXP with DSUM.
Comment 20 jean_francois_philip 2009-08-25 10:05:02 UTC 
Reproduced with OOo310m19 too, on WinXP with DSUM.