1. Matrix is a continuous set of one or several cells (rectangular shape).
2. Expression defining a value of cells in the matrix is the same for all the cells.
3. A change of the expression in a cell must be confirmed by pressing the keys CTRL+SHIFT+ENTER (The consequence of item 2 is the automatic update of all other expressions for all cells in the matrix).
4. To create a matrix:
   1. Select the range (selection of cells).
   2. Press the F2 key and type required expression in a cell (e.g. =1).
   3. To finish editing press the keys CTRL+SHIFT+ENTER.

   The procedure above has created a matrix containing selected cells. Expression is the same in all the cells.

5. Expression for a cell included in a matrix is enclosed between combined brackets in the Formula bar: .
6. Only a whole matrix can be deleted. You must select all the cells of the matrix.
7. For all cells of a matrix, the expression (the same for all the cells) is evaluated just once. If the expression gets a value of Array type, the values of cells in the matrix will correspond to the values of the array.

The function returns an array of required attributes of the archive values (the parameter attribute – see the function D2_GetValue) of defined historical value. The parameters bt and et defines a time order of cells of the matrix. It is important only for matrix containing at once several rows and several columns. If the value of the parameter is TRUE, the values (ascending order by time) are inserted into cells row by row. Otherwise the values are inserted into cells column by column.

The parameter refresh - see the function D2_GetValue.
Value time from the archive is defined by is defined by the relative position of the cell containing the function call and the matrix in which the cell is placed.

the times of individual values in cells, according the matrix range and the parameter bDirectionByRow, will be as follows:

1. The matrix A1:A6, bDirectionByRow=FALSE or TRUE

   

    

2. The matrix A1:B3, bDirectionByRow=FALSE

   

    

3. The matrix A1:B3, bDirectionByRow=TRUE

   

The return value of the function for all the values out of required interval is an error message: #Value, or the value of the cell named SUPP_NO_ARCH_DATA if exists (see the topic Predefined cells).