dsSubRange


The dsSubRange is a special spreadsheet function supplied by Deriscope that creates a data array out of the contents of the specified subset of the source range.
It takes up to 5 arguments and has the following form:

=dsReplace( source, [fromRow], [toRow], [fromColumn], [toColumn] )

The arguments are as follows:

source: The range supplying the original data.

fromRow: Optional integer (default = 1) that identifies the row in the source range that should appear as the top row of the output data. 1 corresponds to the top row of the source range.

toRow: Optional integer (default = 0) that identifies the row in the source range that should appear as the bottom row of the output data. If less than fromRow, the last row of the source range is assumed.

fromColumn: Optional integer (default = 1) that identifies the column in the source range that should appear as the leftmost column of the output data. 1 corresponds to the leftmost column of the source range.

toColumn: Optional integer (default = 0) that identifies the column in the source range that should appear as the rightmost column of the output data. If less than fromColumn, the last column of the source range is assumed.