https://bugs.freedesktop.org/show_bug.cgi?id=66965
Priority: medium
Bug ID: 66965
Assignee: [email protected]
Summary: Array constraint in changing a formula is very
inconvenient.
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.0.4.2 release
Component: Spreadsheet
Product: LibreOffice
An array formula cannot be changed or deleted. The only way is to Undo the
formula and key the entire formula again with the desired change.
Example:
=if(isnumber(dollars),dollars/$A$1,0) must Undo and be keyed as
=if(isnumber(dollars),dollars/$A$1," ")
just to change the zero (0) to a blank.
This seems wrong, allow the change in the formula and press Ctrl + Shift +
Enter to complete the operation.
In addition, allow the Delete key to delete the formula at any time because
several other things may have been done that would also have to be Undone and
rekeyed, etc.
'dollars' array and the resulting array (Hours) are 24 columns x 32 rows.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
