https://bugs.documentfoundation.org/show_bug.cgi?id=157948
Bug ID: 157948
Summary: Offset function using negative numbers
Product: LibreOffice
Version: 7.6.2.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: ctpl...@gmail.com
Description:
In offset func:
Height is a positive integer value, or a reference to a cell containing such a
value, that specifies the total number of rows required in the modified
reference. If omitted, a default value of 1 is applied.
Width is a positive integer value, or a reference to a cell containing such a
value, that specifies the total number of columns required in the modified
reference. If omitted, a default value of 1 is applied.
in excel width and height can be negative.
integrating the possibility of using negative values for height and width
would allow calculations to be made using cells above the reference value
(example: sum).
Actual Results:
now is not possibile use negative value
Expected Results:
now is not possibile use negative value
Reproducible: Always
User Profile Reset: No
Additional Info:
My bug is a request for a new feature.
--
You are receiving this mail because:
You are the assignee for the bug.
