https://bugs.documentfoundation.org/show_bug.cgi?id=89207
Bug ID: 89207
Summary: Cannot change only part of an array
Product: LibreOffice
Version: 4.4.0.3 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 113208
--> https://bugs.documentfoundation.org/attachment.cgi?id=113208&action=edit
Problems expanding array formulas
I'm not sure if it is bug or new feature, but was introduced already in
previous versions. I can only expand array formulas through deleting and
rewriting the formula.
Steps to repeat:
1. open attached file.
2. select array formula in B7:AF7 by "Ctrl" and "/"
3. change "AF2" in formula to "AP2" (=B2:AF2*B4 to =B2:AP2*B4)
4. enter formula by "Ctrl", "Shift" and "Enter"
The first issue - formula didn't expanded to area between AG7 and AP7. Second
issue:
1. try now select the array formula by "Ctrl" and "/"
2. try select formula in formula bar
3. Error message "Cannot change only part of an array" appears
The only way to get rid of the formula is to press "Undo" until the initial
stage is reached. The only way to change array formula is to delete it and to
write again with new parameters. Normally (and in previous versions) there
should not be any problems to expand this formula by replacing parameters, in
ideal case using simple find and replace function.
Ubuntu 14.04, 32 bit, Libreoffice 4.4.0 and 4.3.6
--
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
