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: libreoffice-bugs@lists.freedesktop.org Reporter: andis.lazd...@gmail.com 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs