TableToArray function

TABLETOARRAY() Description

The TABLETOARRAY() function converts values from a table into an array (1- or 2-dimensional).

Main Features Functions TABLETOARRAY

Syntax:

=TABLETOARRAY(Range; Extent)

Parameters:

• Range: Range with values.
• Extent: Dimensionality of the array (1 or 2-dimensional).

Example Usage

The TABLETOARRAY() function is easy to use. You just need to select the table and specify the dimension of the desired array (1 or 2-dimensional) and LibreOffice Calc will automatically return the array of values:

=TABLETOARRAY(Range; Extent)

Example 1

This example uses the following values:

• Range: A2:D15 - A range containing a table of values.
• Extent: Array size (1) .

Example 2

This example uses the following values:

• Range: A2:D15 - A range containing a table of values.
• Extent: Array size (2) .

Download the extension

You can use the TABLETOARRAY() function by installing the extension "YLC_Utilities.oxt" .

After that, this function will be available in all files that will be opened in LibreOffice Calc.