PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Allows you to use a control in order to create a custom formula bar for the Spreadsheet control.
Example
// -- Code d'initialisation du champ Tableur
// Enlève la barre de formule par défaut
TBLR_MonTableur.BarreDeFormuleVisible = False
// Définit le champ permettant de visualiser
// les coordonnées de la cellule sélectionnée dans le champ Tableur
SpreadsheetControlFormula(TBLR_MonTableur, psheetfSelection, LIB_Sélection)
// Définit le champ permettant de saisir les formules dans le champ Tableur
SpreadsheetControlFormula(TBLR_MonTableur, psheetfFormula, SAI_Formule)
// -- Code de clic du bouton permettant de valider la formule
// Utilisation de la fonction FAAExécute
AAFExecute(TBLR_MonTableur, aafValidateInputFunc)
// -- Code de clic du bouton permettant d'annuler la formule
// Utilisation de la fonction FAAExécute
AAFExecute(TBLR_MonTableur, 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:
psheetfFormulaThe control allows you to enter the formula for the current cell in the Spreadsheet control.
Caution: the control used MUST be an edit control.
psheetfSelectionThe 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.
Component: wd270obj.dll
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment