https://bugs.freedesktop.org/show_bug.cgi?id=64229
Priority: medium
Bug ID: 64229
Assignee: [email protected]
Summary: : SUMIF function gives Err:504 for external references
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.0.2.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 78870
--> https://bugs.freedesktop.org/attachment.cgi?id=78870&action=edit
Example local (a.ods) and external (b.ods) references in SUMIF.
Problem description: This appears to be a regression from v3.5.7.2/v3.6.6.2 to
the v4.0 series. Bug #33002 was originally raised against the v3.3 series for
the same problem. The attached pair of spreadsheets for that bug illustrate the
same issue, however I have created a new pair of spreadsheets under v4.0.2.2 to
ensure it is not related to the creating version.
Range and Sum Range references to an external spreadsheet (ODS file) within the
SUMIF function produce an "Err:504" result. This does not occur if b.ods opened
using v3.5.7.2, and reportedly v3.6.6.2 as indicated here:
http://en.libreofficeforum.org/node/5859.
a.ods shows examples of using local references within the COUNTIF and SUMIF
functions. Example text and numeric Range/Criteria are offered. In addition,
Criteria both manually encoded (e.g., "yes" or "1") as well as cell references
(e.g., C3 containing "yes" and E3 containing "1") are included.
b.ods shows examples of using external references (to a.ods) within the COUNTIF
and SUMIF functions. The sames types (text and numeric) of example
Range/Criteria and form of referencing (manual and cell) are offered. In
addition, external references to Criteria (e.g.,
'file:///home/oweng/doc/a.ods'#$Sheet1.C3 rather than C3) are included.
Steps to reproduce:
1. Unzip contents of attached to local directory.
2. Open the attached b.ods file under v4.0.2.2.
3. Confirm update of links.
4. Observe "Err:504" in all cells D6:D8 and F6:F8.
5. Close file (without updating).
6. Open the attached b.ods file under v3.5.7.2 (or v3.6.6.2).
7. Confirm update of links.
8. Observe correctly calculated cell values (4) in D6:D8 and F6:F8.
Current behavior:
Under v4.0.2.2 the external SUMIF cell references in the form:
=SUMIF('file:///home/oweng/a.ods'#$Sheet1.C$6:C$8,"yes",'file:///home/oweng/a.ods'#$Sheet1.D$6:D$8)
produce "Err:504". Under v3.5.7.2, and reportedly v3.6.6.2, the correctly
calculated value (4 in all cases) is displayed.
Expected behavior:
The correctly calculated value (4 in all cases) is displayed.
If possible, can someone please confirm behaviour of the attached under
v3.6.6.2.
Operating System: All
Version: 4.0.2.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
