|
|
|
|
|
SpreadsheetControlFormula (Function) In french: TableurChampFormule Allows you to use a control in order to create a custom formula bar for the Spreadsheet control.
TBLR_MonTableur.BarreDeFormuleVisible = False
SpreadsheetControlFormula(TBLR_MonTableur, psheetfSelection, LIB_Sélection)
SpreadsheetControlFormula(TBLR_MonTableur, psheetfFormula, SAI_Formule)
AAFExecute(TBLR_MonTableur, aafValidateInputFunc)
AAFExecute(PSHEET_MySpreadsheet, aafCancelInputFunc)
Syntax
SpreadsheetControlFormula(<Spreadsheet control> , <Type> , <Control to use>)
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used. <Type>: Integer constant Control use: | | psheetfFormula | The control allows you to enter the formula for the current cell in the Spreadsheet control. Warning: the field used MUST be an Edit control field.. | psheetfSelection | The control displays the current selection (cell or range of cells) in the Spreadsheet control. |
<Control to use>: Control name Name of the window control that will be used to customize the display of the formula or selection. Remarks - After the execution of this function, the controls found in the default formula bar are not used anymore. We advise you to disable the display of the default formula bar with FormulaBarVisible.
- To validate the input in the custom formula bar, you must run AAFExecute associated with the aafValidateInputFunc constant.
- To cancel the input in the custom formula bar, you must run AAFExecute associated with the aafCancelInputFunc constant.
- This function can only be used on a Spreadsheet control found in a window.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|