SpreadsheetGetSortInfo (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

SpreadsheetGetSortInfo (Function)

In french: TableurRécupèreInfoTri

Returns various information about the sort performed in a Spreadsheet control.

Example

// Montre la zone qui va être triée
sSel is string 
sSel = SpreadsheetGetSortInfo(TBLR_Tableur, psheetInfoSortSelection) 
IF sSel = "" THEN
	RETURN // non triable
END
sMin is string = ExtractString(sSel, 1, ":")
sMax is string = ExtractString(sSel, 2, ":")

// Sélectionne la zone 
SpreadsheetSelectPlus(TBLR_Tableur, sMin, sMax)

Syntax

<Result> = SpreadsheetGetSortInfo(<Spreadsheet control> , <Type of information>)

<Result>: Character string

Requested information.

<Spreadsheet control>: Control name

Name of the Spreadsheet control to be used.

<Type of information>: Integer constant

Desired information:
psheetInfoSortCriteria Gets the last sort criteria used in the Spreadsheet control. <Result> has the following format:
"<Name of column1>[;< Option>]" + TAB +
"<Name of column2>" + TAB + ...
where:
<Name of column> is the name of sorted column,
<Option> corresponds to one of the sort constants defined for SpreadsheetSortSelection.
Example: "A<Tab>B;3"
psheetInfoSortSelection Gets the selection that will be sorted via the Automatic Application Features (AAFs) in the Spreadsheet control. Example: "A2:B4".
Note: If the selection does not allow sorting, <Résultat> corresponds to an empty string ("")..
psheetInfoSortWithTitle Determines if the selection sorted by the Automatic Application Features (AAFs) in the Spreadsheet control contains a title. <Result> can correspond to:
1 if the selection to sort includes a title,
0 otherwise.

Component: wd300obj.dll