ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Controls, pages and windows / Spreadsheet functions
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
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
Name of the function that will be inserted at cursor position into the cell currently in edit. For more details, see The Spreadsheet control: Available formulas.
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: wd290obj.dll
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help