Versions Compared

Old Version 1

changes.mady.by.user SRP Support

Saved on

compared with

New Version Current

changes.mady.by.user SRP Support

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The format for the formula results will be the same as the entire column, but if you wish to format the formula results separately, you can use the ColumnFormulaFormat property.

Example

Code Block
// Calculate sub totals and totals in column 4
Set_Property(@Window:".OLE_REPORTTABLE", "OLE.ColumnFormula[4]", "SUM")

// Calculate averages dollar amounts in column 2 and format it
Set_Property(@Window:".OLE_REPORTTABLE", "OLE.ColumnFormula[2]", "AVG")
Set_Property(@Window:".OLE_REPORTTABLE", "OLE.ColumnFormulaFormat[2]", "Average: $#,##0.00")

See Also

ColumnFormulaFormat