Differences between revisions 3 and 4
Deletions are marked like this. Additions are marked like this.
Line 19: Line 19:
  || '''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 ||
  || '''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       ||

Excel Integration - Internal Documentation and Implementation Notes

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

to be completed

ExcelIntegrationInternals (last edited 2012-01-25 15:55:11 by sleightholm)

Copyright 2008-2014, SoftXS GmbH, Switzerland