I did not find a method to edit arrays directly, is need to delete the entire array then type again the formula.
Then, how to edit arrays directly?
test01 jtmsplit.ods (15.4 KB)
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 12; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: es-PE (es_PE); UI: en-US
Calc: threaded
If you talk about a Array-formula wich expands to a Cellrange, you should select the whole Cellrange and you should also do the Editing in the Formula-wizard-dialog!
for me its exactly Ctrl+Ă· which is the divide-key above 8 on the numberblock.
someone could share a video how edit array step to step?
For future readers of the topic.
As always, hotkeys may vary between operating systems.
To find a shortcut key to highlight the range that an array formula belongs to:
Menu / Tools / Customize, Tab Keyboard.
Functions: select array formula. Then see control Keys.
Could you upload your file?
When I selected and edit the array is not possible redimension of the array.
Yes. You cannot change the size of the array that an array formula refers to.
You can change the size of the array, by selecting it as for editing, and dragging by selecting at the bottom right of the last cell of the array.
But that does not change the formula, only the range where it is displayed.
Anyone could do any sample? I can not change the array formula and array size. simple I did not find the method.
If you follow the comment #2 @sokol92, with the link to the help, there is an explanation on how to edit arrays.
And after having changed the size, keep the selection, press F2 to edit the formula and close with Ctrl+Enter.
Since that I trying migrated since Excel to Libreoffice I never noticed that Dynamic Arrays is very necessary
I hadn’t any Excel at hand for at least 20 years now, and needed to ask for “Dynamic Array”. As usual when asking for anything concerning MS software the results were doubtable,
However, as far as I understood or guessed correctly, “dynamic arrays” are exactly like “legacy arrays” with the marginal difference that they resize their output range automatically if the complement of the old range in the new range didn’t contain anything in advance. Otherwise you get an allert.
What would happen if the resizing resulted i a shrinking, you use one of the no longer locked cells for someting else, but may need an upsize of the “dynamic array” next day, now blocked by the changed usage?
The only advantage I can see is the dismissal of the N/A alerts in locked cells that are currently unused.
Should there be at least a function returning the dimensions of the currently used range? I feel badly informed.
