Implementation

• the name of the column taken into account for the calculation.
• the caption of the row that displays the calculation in the Table control. If this caption does not exist, the row will be created. If this caption exists, the calculation will be displayed in the requested column.
• the name of three procedures. These procedures are used to:
  • initialize the calculation,
  • to perform a calculation for each row of the Table control,
  • perform the final calculation if necessary.

• The custom calculation rows are automatically recalculated as soon as the content of the Table or TreeView Table control changes.
  Tip: The iteration procedure is called for each row: we advise you not to perform slow calculations (avoid the accesses to the database for example).
• TotalsEnabled is used to forbid or force the automatic or custom calculations performed in a Table control.
• The following syntax is used to retrieve the value of custom calculation for a column:
  
  <Champ Table>.<Nom de la colonne>[Numéro ligne]
  where <row number> is the subscript of row returned by the TableFormulaAdd function .

Position of calculation row

1. Display the "General" tab of the Table control (to do so, select the name of the Table control and click the "General" tab).
2. Specify the location of totals. To display the results:
   • in one or more rows directly added after the last control row, check "In the table, after the last row".
     These rows are visible:
     • at the bottom of the Table control if the control includes no vertical scrollbar.
     • when the vertical scrollbar is located at the very bottom if the Table control includes a vertical scrollbar.
   • below the Table control, check "Below the table".
     These rows are always visible.
   • you also have the ability to perform column calculations without displaying them ("No display" option).
3. Validate the description window of Table control.

Customizing the calculation row

• the added row by using the following syntax:
  
  <Champ Table>[Numéro ligne].<Propriété> = <Nouvelle valeur>
• the cell containing the result by using the following syntax:
  
  <Champ Table>.<Nom de la colonne>[Numéro ligne].<Propriété> = <Nouvelle valeur>
  
  Caution: the first column contains the caption of the calculation if it exists.

• row number > corresponds to the subscript of row returned by the TableFormulaAdd function .
• <Property> can correspond to one of the following properties:
  

  Color	Used to find out and modify the color of the text displayed in a calculation cell.
  BackgroundColor	Used to find out and modify the background color of a calculation cell.
  Report	Used to find out and modify the display status of the row containing the calculation cell.
  Height	Used to find out and modify the height of a calculation cell.
  Width	Used to find out and modify the width of a calculation cell.
  Libellé	Used to find out and modify the caption of the row containing a calculation cell.
  nom	Used to find out the name of a calculation cell.
  Note	Used to find out and modify the notes associated with a calculation cell.
  Font	Allows you to find out and modify the font used in a calculation cell.
  FontStrikeOut	Used to find out and modify the "StrikeOut" attribute for a calculation cell.
  FontCondensed	Used to find out whether the characters of column elements are condensed or not, and to condense (or not) the characters of column elements.
  FontExtended	Used to find out whether the characters of column elements are extended or not, and to extend (or not) the characters of column elements.
  FontBold	Used to find out and modify the "Bold" attribute for the column elements.
  FontItalic	Used to find out and modify the "Italic" attribute for the column elements.
  FontLarge	Used to find out whether the characters of column elements are enlarged or not, and to enlarge (or not) the characters of column elements.
  FontName	Used to find out and modify the font used for the column elements.
  FontUnderlined	Used to find out and modify the "Underline" attribute for the column elements.
  FontSize	Used to find out and modify the size of the font used for the column elements.
  Visible	Used to find out whether a column is visible and to make a column visible/invisible.

Deleting the custom calculation rows

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

Export via the WLanguage functions

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

Versions 12 and later TableToClipboard New in version 12 TableToClipboard TableToClipboard	Copies the content of a Table or TreeView Table control into the clipboard.
Versions 09 and later TableToExcel New in version 09 TableToExcel TableToExcel	Creates an Excel file from the data found in a Table or TreeView Table control .
Versions 12 and later TableToText New in version 12 TableToText TableToText	Creates a character string from the data found in a Table or TreeView Table control.
Versions 09 and later TableToWord New in version 09 TableToWord TableToWord	Creates a Word file (.RTF) from the data found in a Table or TreeView Table control.
Versions 09 and later TableToXML New in version 09 TableToXML TableToXML	Creates an XML file from the data found in a Table or TreeView Table control.