Functionality - Invantive Product Documentation

The syntax of a cell reference expression is: $C{RotationMethod, Block, Worksheet, Column 1, Row 1, Column 2, Row 2}. The meaning of the components is: | Component | Required | Description | | --------------- | :------: | --------------------------------------------------------------------------------------------- | | Rotation method | Yes | The starting point of the range. | | Block | Yes | The block from which the values are copied, configured in [Blocks](invantive-control-blocks). | | Worksheet | Yes | The worksheet to which the reference refers. | | Column 1 | Yes | The column to which the expression refers. | | Row 1 | Yes | The row to which the expression refers. | | Column 2 | No | The second column can be used to specify the range of the column. | | Row 2 | No | The second row can be used to specify the range of the row. | The following options are available: | Component | Options | Additional option | Explanation | | --------------- | ---------------------------------- | ----------------- | -------------------------------------------------------------------------------------------------------------------- | | Rotation method | D E | | First cell and first row As specified for the block | | Block | . ‘Block name’ | | The current block Name of the block | | Worksheet | . ‘Worksheet name’ ^ $ | +/-n | Current worksheet Name of the worksheet First worksheet Last worksheet | | Column 1 | . ‘Column name 1’ ^ $ | +/-n | Current column Column name as it appears in the block First column of the block Last column of the block | | Row 1 | . ‘Row name 1’ ^ $ | +/-n | Current row Row name as it appears in the block First row of the block Last row of the block | | Column 2 | . ‘Column name 2’ ^ $ | +/-n | Current column Name of the column First column Last column | | Row 2 | . ‘Row name 1’ ^ $ | +/-n | Current row Name of the row as it appears in the block First row of the block Last row of the block | Example of using a cell reference expression: | Component | Example | Explanation of example | | --------------- | ------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------- | | Rotation method | D E | First cell and first row As specified for the block | | Block | . ‘Projects’ | The current block The ‘Projects’ block | | Worksheet | . ‘Worksheet name’ ^ $ | The current worksheet The ‘Worksheet 1’ worksheet The second worksheet The penultimate worksheet | | Column 1 | .-1 ‘Project code’ ^+2 $ | The current column minus one The ‘Project code’ column The third column of the block The last column of the block | | Row 1 | .+1 ‘Project code’ ^-1 $ | The current row plus one The ‘Project code’ row The row above the block The last row of the block | | Column 2 | . ‘Project code’ +2 ^+3 $-2 | The current column Two columns to the right of the ‘Project code’ column The fourth column The second-to-last column | | Row 2 | .+2 ‘Project code’ ^-1 $ | The current row plus two The ‘Project code’ row The row above the block The last row of the block | A commonly used cell reference expression is $C{E,.,.,^,.}: the first column of the current row. For the components Worksheet, Column 1/2 and Row 1/2, it is also possible to specify - or + followed by a natural number in the additional options. The additional option ensures that the number is subtracted from or added to the option. Cell reference expression properties: - Case-sensitive; - Also works within SQL functions, such as SUM, COUNT, AVG, etc.