<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Cannot change only part of an array" href="https://bugs.documentfoundation.org/show_bug.cgi?id=89207#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Cannot change only part of an array" href="https://bugs.documentfoundation.org/show_bug.cgi?id=89207">bug 89207</a> from <a class="email" href="mailto:prusselltechgroup@gmail.com" title="russell <prusselltechgroup@gmail.com>"> russell</a> <pre>I just had this problem (expand an array formula) and found this enhancement request. I made a selection over an existing array plus new rows, F2, ctrl-shift-enter, and the array was not expanded to the new rows. They remained empty. Although the previous array was updated to reflect the new range; Actually when the new rows were inserted the array formula range changed. Before: {=C1:C12*D1:D12} Rows: 1-12 After: {=C1:C14*D1:D14} Rows: 1-12, 13-14 Empty Only way to expand an array formula seems to be to delete it and reenter it. LO 6.1.4.2</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>