https://issues.apache.org/ooo/show_bug.cgi?id=125082
Issue ID: 125082
Issue Type: DEFECT
Summary: OFFSET function returns wrong number of rows, if the
first cell of external range is empty
Product: Calc
Version: 4.1.0
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: major
Priority: P3
Component: editing
Assignee: [email protected]
Reporter: [email protected]
Created attachment 83540
--> https://issues.apache.org/ooo/attachment.cgi?id=83540&action=edit
OFFSET refering external file
1.Load attached 2 files "test1.ods" and "test2.ods"
2.Go to cell "C3" in "test1.ods", OFFSET refers external cell range "B2:B11" in
"test2.ods".
[Expected result]
Formula SUM(OFFSET) should return "54".
[Current result]
Formula SUM(OFFSET) returns wrong result "44", because "B2" (first cell of
range) in "test2.ods" is empty.
[Behavior]
-OFFSET in "C3"
When the first cell of external range is empty, OFFSET removes a cell from the
back of the range.
-OFFSET in "D4"
When the first and second cell of external range are empty, OFFSET removes 2
cells from the back of the range.
[Workaround]
Enter "0" in first empty cell of external range.
OFFSET returns correct range.
FYI, it works fine in LibreOffice 4.1.6 and 4.2.4
Operating System: Windows 7
Version: Apache OpenOffice 4.1.0, 3.4.1
Regards.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
