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
Specifies a name to identify a cell found in a Spreadsheet control.
Example
// Creates a formula that references A1 and A2 with clearer names
SpreadsheetAddName(PSHEET_Spreadsheet1, "PriceBT", "$A$1")
SpreadsheetAddName(PSHEET_Spreadsheet1, "VAT", "$A$2")
SpreadsheetAddFormula(PSHEET_Spreadsheet1, "A3", "PriceBT*VAT")
Syntax
SpreadsheetAddName(<Spreadsheet control> , <Cell name> , <Cell> [, <Range> [, <Comment>]])
<Spreadsheet control>: Control name
Name of the Spreadsheet control to be used.
<Cell name>: Character string
Name that will be given to the cell.
Caution:
  • This parameter must not correspond to a cell name ("A1" for example) or to a function name ("SUM" for example).
  • This parameter must contain no space character.
  • SpreadsheetAddName fails if the specified name is invalid or if it already exists: the ErrorOccurred variable is set to True and ErrorInfo returns the details of the error.
<Cell>: Character string
Cell to name.
Caution: Absolute coordinates must be used to identify the cell (for example: "$A$1").
Indeed, the coordinates are relative in a cell name. Using the notation "A1", "A2", ... may trigger errors of circular references.
<Range>: Optional integer
Number of the worksheet where the name can be used. If this parameter is not specified or if it is set to 0, the name can be used in all the worksheets.
<Comment>: Optional character string
Comment associated with the cell name (up to 255 characters).
Remarks
The names are not case sensitive (uppercase/lowercase characters)
Component: wd290obj.dll
Minimum version required
  • Version 22
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help