Differences between revisions 4 and 5

Excel Integration - Internal Documentation and Implementation Notes

Contents

Client Site

Example formula:

    _^^revCT0_^^row_-_^^revCVersandDelta1_^^row

The formula is split on the '_' character, which results in the following array:

Formula Component	Meaning	Example Value
`^^revCT0`	The column for the field revCT0	AB
`^^row`	The current row number	27
-	Minus sign	-
`^^revCVersandDelta1`	The column for the field revCVersandDelta1	BD
`^^row`	The current row number	27

For the example values given above, the result is the following formula:

to be completed

Deletions are marked like this.	Additions are marked like this.
Line 2:	Line 2:
	* [[ExcelIntegration\|Back]]