Issue 102388 - SUMIF function products Err:504 with external links
Summary: SUMIF function products Err:504 with external links
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
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: ---

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

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.

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)

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
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
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
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

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
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 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
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.