Les matrius dinàmiques faciliten el treball amb diversos valors en una sola fórmula. Aquest comportament dinàmic significa que, a diferència de les fórmules matricials clàssiques, el resultat s'adapta automàticament: si canvia la grandària de la matriu d'entrada o dels arguments d'una funció, la grandària de la matriu resultant també canvia. No és necessari tornar a introduir la fórmula matricial quan les dades d'entrada i sortida augmenten o disminueixen.
Dynamic arrays are produced automatically by functions that return arrays of data, where the resulting array's dimensions depend on the function's calculations.
These functions return an array of data automatically, so there is no need to enter them using the Ctrl+Shift+Enter keyboard shortcut.
The dynamic array is said to spill in the spreadsheet when data is inserted as the result of the above functions. You can reference the resulting array data by writing the reference of the first element of the resulting array suffixed by the spill range symbol #.

Range A2:A11 is the source data.
Range B2:B11 is a dynamic array spilled as result of the SORT function. Every cell in B2:B11 has formula =SORT(A2:A11).
Range C2:C11 is a dynamic array referenced the # spill suffix to the range B2:B11. Every cell in the range C2:C11 has formula =B2#
Cell D2 shows reference error #REF! since range A2:A11 is not a dynamic array.
Range E2:E11 is also a dynamic array referencing another dynamic array.
If the spill range is blocked by other data, Calc returns the #SPILL! error. After clearing the space for spilling, the formula will automatically spill.