https://bugs.documentfoundation.org/show_bug.cgi?id=158620
Bug ID: 158620
Summary: TRANSPOSE() function does not provide a message when
bounds exceeded
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
TRANSPOSE() function produces an result which is incorrect and should warn when
operation can not be performed due to being out of bounds.
Steps to Reproduce:
1. In cells XFC1:XFD4, enter 1, 2, 3, 4, 5, 6, 7, 8
2. In cell XFC6, enter the formula =transpose(XFC1:XFD4)
3. Press Enter
4. Cell XFC6 shows the value 1, and there are no other elements in the
transpose matrix as the matrix would be outside the bounds of the sheet
Should there be a warning or an error message when the operation can not be
done due to the values extending beyond the boundary of the Sheet?
Actual Results:
1. Produces an incorrect value. The result is a value in only 1 cell which is
not a transpose of the matrix.
2. No feedback provided when operation can not be performed.
Expected Results:
1. Should show an error value in cell instead of 1.
2. Feedback message when operating can not be performed due to out of bounds.
Reproducible: Always
User Profile Reset: No
Additional Info:
Thank you
--
You are receiving this mail because:
You are the assignee for the bug.
