[Issue 125082] New: OFFSET function returns wrong number of rows, if the first cell of external range is empty

[bu...@apache.org]

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: issues@openoffice.apache.org
          Reporter: kg_ooohelp@ashisuto.co.jp

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.

[Issue 125082] OFFSET function returns wrong number of rows, if the first cell of external range is empty

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=125082

--- Comment #2 from HD <kg...@ashisuto.co.jp> ---
Sorry, there is a typo in the Description.

In [Behavior], the cell name must be "D3" not "D4".

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 125082] OFFSET function returns wrong number of rows, if the first cell of external range is empty

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=125082

--- Comment #1 from HD <kg...@ashisuto.co.jp> ---
Created attachment 83541
  --> https://issues.apache.org/ooo/attachment.cgi?id=83541&action=edit
referenced file

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 125082] OFFSET function returns wrong number of rows, if the first cell of external range is empty

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=125082

mroe <mr...@gmx.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |DUPLICATE

--- Comment #3 from mroe <mr...@gmx.net> ---
see issue 117389

*** This issue has been marked as a duplicate of issue 117389 ***

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.