[Bug 124448] New: OFFSET function don't works with negative height

[bugzilla]

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

            Bug ID: 124448
        Issue Type: DEFECT
           Summary: OFFSET function don't works with negative height
           Product: Calc
           Version: 4.0.1
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: code
          Assignee: issues@openoffice.apache.org
          Reporter: jeff...@orange.fr
                CC: issues@openoffice.apache.org

Hi developpers,

In a new speadsheet, in A1:A5, input numeric data 1 to 5.

1) In A6, input formula :
=OFFSET(A5,,,-3)
And matrix validation with Ctrl+Shift+Enter
Expect result : the matrix fonction in C6 return range A3:A5
Result : the matrix fonction return only A5

2) in A6, input formula :
=SUM(OFFSET(A5,,,-3))
and valid with Enter
Expect result : the fonction return 12 (the sum of the range A3:A5)
Result : the fonction return only 5

This OFFSET syntaxe is good in Excel, but not with Calc, we must use :
=OFFSET(A5,-2,,3) with matrix validation
and
=SUM(OFFSET(A5,-2,,3)) with classic validation

Same defect with width parameter

Best regards

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.