Excel Integration - Internal Documentation and Implementation Notes
Contents
Client Site
Header Structure
Formula definitions
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:
AB27-BD27
Forms
VBA Modules
Server Side
Proposal for processing valid revisions server side
- Legacy browser data is problematic for the new excel tool. The excel tool expects the following revision pattern.
'VA' |
'VA, ZF' |
'VA, ZF, FR' |
'VA, ZF, GA' |
'ZF' |
'ZF, FR' |
'ZF, GA' |