In Google Sheets, I can compose a formula as follows to easily mirror data from one sheet tab into another:
=ARRAYFORMULA(Sheet1!B1:D9)
What is the equivalent of this formula in LibreOffice Calc?
According to Libre Office help page:
Creating Array Formulas
If you create an array formula using the Function Wizard, you must mark the Array check box each time so that the results are returned in an array. Otherwise, only the value in the upper-left cell of the array being calculated is returned.
If you enter the array formula directly into the cell, you must use the key combination Shift+Ctrl+Enter instead of the Enter key. Only then does the formula become an array formula.
Array formulas appear in braces in LibreOffice Calc. You cannot create array formulas by manually entering the braces.
The cells in a results array are automatically protected against changes. However, you can edit or copy the array formula by selecting the entire array cell range.
Source and more about array formulas: Array Functions
So in this particular case all you need to enter is
=$Sheet1.$B$1:$D$9
and press Shift+Ctrl+Enter
Or
Insert -> Function, write your formula and check the box saying Array
=SUM($A$1:$A$3*$A$1:$A$3)
. And as suggested in the original post, if you enter the formula directly into the cell you will need the key combination Shift+Ctrl+Enter
to apply it as an Array. They should produce the same results
ARRAYFORMULA
. In Excel and Calc you just need to apply it.