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.

Retrieving the calculation result

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

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

rowCount

Row containing the result of the count.

Versions 22 and later rowMaximum

New in version 22 rowMaximum

rowMaximum

Row containing the maximum value of column cells.

Versions 22 and later rowMinimum

New in version 22 rowMinimum

rowMinimum

Row containing the minimum value of column cells.

rowAverage

Row containing the result of a mean.

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 by programming

WINDEV allows you to modify the characteristics (font, color, ...) of a column result by 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 by 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 whether a column is visible and to make a column visible/invisible.

Exporting the results of calculations

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

The popup menu of Table and TreeView Table controls proposes several options used 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: