Differences between revisions 2 and 3
Deletions are marked like this. Additions are marked like this.
Line 19: Line 19:
  || Formula Component || Meaning || Example Value ||   || '''Formula Component''' || '''Meaning''' || '''Example Value''' ||

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