https://bugs.documentfoundation.org/show_bug.cgi?id=172431
Bug ID: 172431
Summary: DROP function misbehaviour in corner cases
Product: LibreOffice
Version: 26.8.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 207425
--> https://bugs.documentfoundation.org/attachment.cgi?id=207425&action=edit
Sample file showing the issue for DROP function
The Calc DROP function was implemented in bug#150998 and provides the correct
result except for:
* If the number of columns or rows to drop is greater than the number of
columns or rows respectively, the function returns a copy of the source array.
In either case the return should be mathematically a zero-sized array or
better, an error.
In that case, Excel returns a #CALC error.
* The same happens if the numbers are negative and has absolute values greater
than the number of rows/columns of the source array.
Step to reproduce
1) Open sample file
2) Inspect results of dropping 15 rows from an array that has 12 rows.
Expected results
Calc returns an error
Actual results
Calc returns a copy of the source array.
--
You are receiving this mail because:
You are the assignee for the bug.
