SpreadsheetInputFunction (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / WLanguage functions / Controls, pages and windows / Spreadsheet functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

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

// Insertion de la fonction SOMME pour formule
// une parenthèse ouvrante est ajoutée et on passe en sélection assistée de cellules 
// pour choisir les cellules sur lesquelles s'applique la somme
SpreadsheetInputFunction(TBLR_Tableur, "SOMME")

// Insertion d'une formule complète
// La formule en B3 correspond à  : "=SOMME(ABS(-25);LOG(10))"
TBLR_Tableur = "B3"
SpreadsheetInputFunction(TBLR_Tableur,"SOMME")
SpreadsheetInputFunction(TBLR_Tableur, "ABS")
SendKey("-25);")
SpreadsheetInputFunction(TBLR_Tableur, "LOG")
SendKey("10)){ENTREE}")

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 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: wd300obj.dll