https://bz.apache.org/ooo/show_bug.cgi?id=126440
Issue ID: 126440
Issue Type: DEFECT
Summary: Editing of Formula TRANSPOSE impossible
Product: Calc
Version: 4.1.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P5
Component: programming
Assignee: [email protected]
Reporter: [email protected]
Created attachment 84851
--> https://bz.apache.org/ooo/attachment.cgi?id=84851&action=edit
TRANSPOSE cannot be edited nor replaced without a prior deletion
A vertical sequence can be TRANSPOSEd, but the formula as such cannot be
edited:
"You cannot only change part of an array"
While this is true if I only change a part of the array, it still isn't
possible (and the same message appears) when I change the whole array.
Example: attachment shows 5 values transposed. Marking these 5, it still is
impossible to modify the range, e.g. from A3:A7 to A2:A6.
It is even impossible to mark the array of 5 transposed cells, and call
TRANSPOSE again, marking A2:A6. It still gives the same message.
The only way is to clear the formula for all fields, and then insert a new one.
--
You are receiving this mail because:
You are the assignee for the issue.
