PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
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
SpreadsheetInputFunction (Function)
In french: TableurSaisieFonction
Inserts a function name at cursor position in the editable cell of a Spreadsheet control found in a window.
Example
// Insert the SUM function as formula
// an opening bracket is added and switch to assisted cell selection
// to choose the cells onto which the sum will be applied
SpreadsheetInputFunction(PSHEET_Spreadsheet, "SUM")
// Insert an entire formula
// The formula in B3 corresponds to : "=SUM(ABS(-25);LOG(10))"
PSHEET_Spreadsheet = "B3"
SpreadsheetInputFunction(PSHEET_Spreadsheet, "SUM")
SpreadsheetInputFunction(PSHEET_Spreadsheet, "ABS")
SendKey("-25);")
SpreadsheetInputFunction(PSHEET_Spreadsheet, "LOG")
SendKey("10)){ENTER}")
Syntax
SpreadsheetInputFunction(<Spreadsheet control> , <Function name>)
<Spreadsheet control>: Control name
Name of Spreadsheet control to use, found in a window.
<Function name>: Character string (with quotes)
Name of the function that will be inserted at cursor position into the cell currently in edit. See The Spreadsheet control: Available formulas for more details.
Remarks
  • Once the function name is inserted, an opening bracket is automatically added and the user is switched to assisted selection of cells onto which the function is applied, like if the function name was typed on the keyboard. The assisted cell selection stops when a character is typed by the user (closing bracket or any other character).
  • If the function name is inserted at the beginning of cell, a " = " sign is inserted before the function name (to indicate that the cell content is a formula).
  • This function switches the Spreadsheet control to edit for the content of current cell (if the Spreadsheet control was not in edit).
  • This function fills the list of functions recently used, available in the ribbon of control.
Component : wd250obj.dll
See also
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment