Created attachment 113208 [details] 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
Apparently this feature has never existed, so changing this to enhancement. Tested on: Win 7 Pro 64-bit, LibO Version: 4.4.0.3 Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645d7 Locale: fi_FI Ubuntu 14.10 64-bit LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4
Hi! Expanding of array formulas in the proposed way will be really new feature, but the reported bug is a message saying that array cannot be selected, if it is edited without complete rewrite of the formula. Some time ago it was possible to select and delete manually edited array formulas, now it is possible only through undo operation. There is a way to expand array formulas using ranges, but it is not very convenient way, if there are thousands of array formulas.
(In reply to andis.lazdins from comment #2) > Expanding of array formulas in the proposed way will be really new feature, > but the reported bug is a message saying that array cannot be selected, if > it is edited without complete rewrite of the formula. Some time ago it was > possible to select and delete manually edited array formulas, now it is > possible only through undo operation. You should create a new report for your second issue. We keep it one issue per report. Thanks.
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
From the doc: Array Functions - https://help.libreoffice.org/6.0/he/text/scalc/01/04060107.html ====================== Editing Array Formulas Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press Ctrl+/, where / is the Division key on the numeric keypad. Either press F2 or position the cursor in the input line. Both of these actions let you edit the formula. After you have made changes, press Ctrl+Shift+Enter. Adjusting an Array Range If you want to edit the output array, do the following: Select the cell range or array containing the array formula. Below the selection, to the right, you will see a small icon with which you can zoom in or out on the range using your mouse. Note Icon When you adjust the array range, the array formula will not automatically be adjusted. You are only changing the range in which the result will appear. ======================
After several years, Libreoffice Calc still has no option to update the array size automatically. This is essential in some scenarios. Google Sheet for example has no problem to update the range of cells with the array content automatically. Is there a possibility to add this functionality? Thank you very much!