Page History
...
The ColumnFormulaFormat property determines how the column's formula results are displayed. Formulas are added to a column using the ColumnFormula property. Only columns of type Number support formulas, so only number formatting is explained here. For a complete list of of column types, seeColumnList. For formatting other column types, see ColumnFormat.
Number Formatting
Numbers are stored as floating point values within the Report Table. Thus, if your data contains decimal values, make sure you include the decimal when you load the Report Table. In other words, there is no equivalent MD2 format for the Report Table. Instead, the Report Table uses an Excel-like syntax to format and round off decimal numbers.
...
Code Block |
---|
// Format the subtotals as currency Set_Property(@Window:".OLE_REPORTTABLE", "OLE.ColumnFormulaFormat[2]", "$#,##0.00") // Format the subtotals with some literal text Set_Property(@Window:".OLE_REPORTTABLE", "OLE.ColumnFormulaFormat[2]", "Total Amt: $#,##0.00") |