SpreadsheetListName (Function)

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

WLanguage functions

Controls, pages and windows

Spreadsheet functions

Spreadsheet constants

Spreadsheet functions

SpreadsheetAddData

SpreadsheetAddFormula

SpreadsheetAddImage

SpreadsheetAddName

SpreadsheetAddWorksheet

SpreadsheetAllowProcedure

SpreadsheetBorderSelection

SpreadsheetClose

SpreadsheetControlFormula

SpreadsheetDeleteAll

SpreadsheetDeleteColumn

SpreadsheetDeleteImage

SpreadsheetDeleteLine

SpreadsheetDeleteName

SpreadsheetDeleteWorksheet

SpreadsheetEndModification

SpreadsheetFreeze

SpreadsheetGetFormula

SpreadsheetGetMerge

SpreadsheetGetSelection

SpreadsheetGetSortInfo

SpreadsheetInputFunction

SpreadsheetInsertColumn

SpreadsheetInsertRow

SpreadsheetInsertWorksheet

SpreadsheetListImage

SpreadsheetListName

SpreadsheetListWorksheet

SpreadsheetLoad

SpreadsheetModifyName

SpreadsheetPosition

SpreadsheetRecalculateAll

SpreadsheetReplace

SpreadsheetRestorePositionAndSelection

SpreadsheetSave

SpreadsheetSavePositionAndSelection

SpreadsheetSeek

SpreadsheetSelectMinus

SpreadsheetSelectPlus

SpreadsheetSelectWorksheet

SpreadsheetSortSelection

SpreadsheetStartModification

SpreadsheetStyleSelection

SpreadsheetTypeAndMaskSelection

New WINDEV 23 feature!

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SpreadsheetListName (Function)

In French: TableurListeNom

Returns the list of names that identify a cell in a Spreadsheet control.

Example

SpreadName is array of strings
SpreadName = SpreadsheetListName(PSHEET_MySpreadsheet)
FOR EACH sDesc1Name OF SpreadName
sName is string = ExtractString(sDesc1Name, 1, TAB)
sCell is string = ExtractString(sDesc1Name, 2, TAB)
sScope is string = ExtractString(sDesc1Name, 3, TAB)
sComment is string = ExtractString(sDesc1Name, 4, TAB)
Trace("Name: " + sName + "; " + "Cell: " + sCell + "; " + ...
"Scope: " + sScope + ";" + "Comment: " + sComment)
END

Syntax

<Result> = SpreadsheetListName(<Spreadsheet Control>)

<Result>: Array

Array of strings containing the description of different cell names found in the control. Each array element has the following format:

<Name>+TAB+<Cell>+TAB+<Scope>+TAB+<Comment>

where:
<Name> corresponds to the cell name.
<Cell> corresponds to the cell identified by the name.
<Scope> corresponds to the scope of cell name:
0 if the scope corresponds to the workbook,
1 if the scope corresponds to the worksheet.
<Comment> corresponds to the comment associated with the cell name.

<Spreadsheet Control>: Control name

Name of Spreadsheet control to use.

Components

wd230obj.dll