Arrays need to automatically populate when adding a row
When you have an array as describe in your heldesk https://helpcenter.onlyoffice.com/docs/userguides/spreadsheet_editor/InsertArrayFormulas.aspx
whenever you add a new row, the formula is not added to the new row. You have to copy everything manually. Whenever you have an array, it should populate the cells automatically.
3
votes
Ondrej Maly
shared this idea
Idea discussion. Check comments.
-
AdminConstantine
(Admin, ONLYOFFICE)
commented
You cannot change an array, thus it is not clear what is meant by "add a new row". If a row is added right after the array it does not count as a part of it, just like in other processors.
As a workaround, you can simply select previous array with new cells and use CTRL+SHIFT+Enter two times again to "expand" the array.
If I'm mistaken, please share any references for better understanding.