Las matrices dinámicas facilitan el trabajo con varios valores en una sola fórmula. Este comportamiento dinámico significa que, a diferencia de las fórmulas matriciales clásicas, el resultado se adapta automáticamente: si cambia el tamaño de la matriz de entrada o de los argumentos de una función, el tamaño de la matriz resultante también cambia. No es necesario volver a introducir la fórmula matricial cuando los datos de entrada y salida aumentan o disminuyen.
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.