Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | SUMIF function products Err:504 with external links | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | macibro <maci> | ||||||
Component: | programming | Assignee: | oc | ||||||
Status: | CLOSED FIXED | QA Contact: | issues@sc <issues> | ||||||
Severity: | Trivial | ||||||||
Priority: | P3 | CC: | grakic, issues, jbf.faure | ||||||
Version: | OOO310m11 | Keywords: | regression | ||||||
Target Milestone: | --- | ||||||||
Hardware: | All | ||||||||
OS: | All | ||||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||
Developer Difficulty: | --- | ||||||||
Issue Depends on: | |||||||||
Issue Blocks: | 101565 | ||||||||
Attachments: |
|
Description
macibro
2009-05-30 21:46:04 UTC
Created attachment 62659 [details]
Zip file with "a.ods" and "b.ods" files (example)
I can reproduce it with DEV300m49 on WinXP. Same error with COUNTIF too. It might be the same root cause than in issue 101645. I saw issue 101645. It seems the same error 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. There is also a short OOoForum thread about this one http://www.oooforum.org/forum/viewtopic.phtml?p=326608 Confirming this bug on GNU/Linux (Ubuntu). reassigned confirmed as blocker I can reproduce it with DEV300m49 on WinXP. Same error with DSUM too. *** Issue 102750 has been marked as a duplicate of this issue. *** Issue added to CWS dr68ooo311. 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. 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 Created attachment 63353 [details]
Stored b.ods with relative URIs enabled to make things testable
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. verified in internal build cws_dr60ooo311 and cws_calc51 *** Issue 103626 has been marked as a duplicate of this issue. *** Verified in DEV300m54 on WinXP Closing 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. Reproduced with OOo310m19 too, on WinXP with DSUM. |