| Deletions are marked like this. | Additions are marked like this. |
| Line 42: | Line 42: |
| ''to be completed'' |
== 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' || |
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' |