Programming automatic calculations in the columns of a Table control

When are the calculations performed?

The calculations are performed:

when initializing the Table control.

when a process performs an addition or modification in a Table control with calculations:

the totals are re-calculated at the end of process (or when using Multitask).

if the value of a calculation is requested (see next paragraph), the calculation is instantly rerun.

TotalsEnabled is used to forbid or force the calculations performed in a Table control.

Caution: If the DisplayEnabled property is used on the Table control and is set to False, the automatic calculations are not updated.

Retrieving the calculation result

The result of calculations performed in a Table control can be handled through programming.

Several constants are used to identify the calculation row of a column:

rowAverage

Row containing the result of a mean.

rowCount

Row containing the result of the count.

rowMaximum

Row containing the maximum value of column cells.

rowMinimum

Row containing the minimum value of column cells.

rowTotal

Row containing the result of a total.

To retrieve the value of a calculation, use the following syntax:

<Column name>[<Type of calculation>]

Example:

// Retrieve the result for the average calculated in the COL_GRADE column Trace(COL_GRADE[rowAverage])

Modifying the characteristics of calculations through programming

WINDEV allows you to modify the characteristics (font, color, ...) of a column result through programming with several WLanguage properties. The WLanguage properties can be used to modify the color of result, its background color, its font, ... However, the content of result cell cannot be modified through programming.

To use a WLanguage property on the result of a column, the following syntax must be used:

<Column name>[<Type of calculation>].<Property>

Example:

// Color the mean result in red. The background is colored in blue COL_GRADE[rowAverage].Color = LightRed COL_GRADE[rowAverage].BackgroundColor = LightBlue

Properties that can be used on the calculation cells of columns

Used to find out and modify the width of a calculation cell.

Exporting the results of calculations

Export via the AAF (Automatic Application Features) of Table control

The context menu of Table and TreeView Table controls contains several options to export the control content.

During this export, the results of automatic calculations are exported.

Remarks:

Only the value is exported, not the caption.

During the export in Excel, the cell corresponding to the calculation contains the corresponding Excel formula.

Export via the WLanguage functions

Several WLanguage functions can be used to export the content of a Table control in a specific format (Word, Excel, XML, ...). During this export, the rows corresponding to calculations are also exported by default.

To avoid exporting the calculation rows, all you have to do is specify the taNoTotal constant in the following functions: