PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
SpreadsheetControlFormula (Function)
In French: TableurChampFormule
Allows you to use a control in order to create a custom formula bar for the Spreadsheet control.
Example
// -- Initialization code of Spreadsheet control
// Removes the default formula bar
PSHEET_MySpreadsheet..FormulaBarVisible = False
// Defines the control used to view
// the coordinates of selected cell in the Spreadsheet control
SpreadsheetControlFormula(PSHEET_MySpreadsheet, psheetfSelection, STC_Selection)
// Defines the control used to enter the formulas in the Spreadsheet control
SpreadsheetControlFormula(PSHEET_MySpreadsheet, psheetfFormula, EDT_Formula)
// -- Click code of button used to validate the formula
ExecuteAAF(PSHEET_MySpreadsheet, aafValidateInputFunc)
// -- Click code of button used to cancel the formula
ExecuteAAF(PSHEET_MySpreadsheet, aafCancelInputFunc)
// -- Click code of button used to validate the formula
// Use ExecuteAAF or AAFExecute
AAFExecute(PSHEET_MySpreadsheet, aafValidateInputFunc)
// -- Click code of button used to cancel the formula
// Use ExecuteAAF or AAFExecute
AAFExecute(PSHEET_MySpreadsheet, aafCancelInputFunc)
Syntax
SpreadsheetControlFormula(<Spreadsheet Control> , <Type> , <Control to Use>)
<Spreadsheet Control>: Control name
Name of Spreadsheet control to use.
<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>: Character string (with or without quotes)
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 ExecuteAAF associated with the aafValidateInputFunc constant. To validate the input in the custom formula bar, you must run AAFExecute (or ExecuteAAF) associated with the aafValidateInputFunc constant.
  • To cancel the input in the custom formula bar, you must run ExecuteAAF associated with the aafCancelInputFunc constant. To cancel the input in the custom formula bar, you must run AAFExecute (or ExecuteAAF) associated with the aafCancelInputFunc constant.
  • This function can only be used on a Spreadsheet control found in a window.
Components
WINDEVReports and Queries wd230obj.dll
Minimum required version
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment