Apache OpenOffice (AOO) Bugzilla – Issue 124448
OFFSET function don't works with negative height
Last modified: 2014-03-17 15:13:20 UTC
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
See: http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018434_715980110 =OFFSET(A5;;;-3) is wrong because newWidth > 0 (-3 not allowed).
The expected result should then be an error value. Is that one or the other may be an enhancement ? For compatibility's reasons with Excel, this issue can it remain open? (not a DEFECT, but ENHANCEMENT) Regards
Reopened.
Confirming for lack of error. AOO410m14(Build:9760) - Rev. 1573062 2014-03-01_04:11:01 - Rev. 1573123 Debian