<Spreadsheet>.RestorePositionAndSelection (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

Special cases

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Spreadsheet>.RestorePositionAndSelection (Function)

In french: <Tableur>.RestaurePositionEtSélection

Restores:

the scrollbar position in a Spreadsheet control,
the current worksheet,
the elements selected in the current worksheet of Spreadsheet control.

These elements have been saved by <Spreadsheet>.SavePositionAndSelection.

Example

let MaSauvegarde = TBLR_Tableur1.SauvePositionEtSélection() 

// Met en gras la cellule B1
TBLR_Tableur.SelectPlus("B1")
TBLR_Tableur.StyleSélection(psheetBold, True)

// Restaure la position/sélection 
TBLR_Tableur1.RestaurePositionEtSélection(MaSauvegarde)

Syntax

<Spreadsheet control>.RestorePositionAndSelection([<Save>])

<Spreadsheet control>: Control name

Name of the Spreadsheet control to be used.

<Save>: Optional character string

Backup characteristics returned by function <Spreadsheet>.SavePositionAndSelection.
If this parameter is not specified, the last backup performed by <Spreadsheet>.SavePositionAndSelection on the control is used (if it exists).
An error occurs if no backup was performed or if the specified string is invalid.

Remarks

Special cases

The name of the control used for the save (<Spreadsheet>.SavePositionAndSelection) can differ from the name used for the restore operation. This feature can be useful to duplicate the position and the selection on two Spreadsheet controls displayed alternatively for example.
<Spreadsheet>.RestorePositionAndSelection has no effect if the control is empty.

Component: wd300obj.dll