dsReplace


The dsReplace is a special spreadsheet function supplied by Deriscope that creates a data array by replacing the contents of the specified subset of the source range with those of the target range.
It takes at least 2 arguments with two additional optional arguments and has the following form:

=dsReplace( source, target, [startRow], [startColumn] )

The arguments are as follows:

source: The range supplying the original data before the replacement takes place.

target: The range supplying the data that are used as the replacement for the specified subset of the source data.

startRow: Optional integer (default = 1) that identifies the row of the cell in the source range that will hold the top/left cell of the target range. 1 corresponds to the top row of the source range.

startColumn: Optional integer (default = 1) that identifies the column of the cell in the source range that will hold the top/left cell of the target range. 1 corresponds to the leftmost column of the source range.