PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

New WINDEV 23 feature!
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Returns various information about the sort performed in a Spreadsheet control.
Example
// Shows the area that will be sorted
sSel is string
sSel = SpreadsheetGetSortInfo(PSHEET_Spreadsheet, psheetInfoSortSelection)
IF sSel = "" THEN
RETURN // not sortable
END
sMin is string = ExtractString(sSel, 1, ":")
sMax is string = ExtractString(sSel, 2, ":")

// Selects the area
SpreadsheetSelectPlus(PSHEET_Spreadsheet, sMin, sMax)
Syntax
<Result> = SpreadsheetGetSortInfo(<Spreadsheet Control> , <Type of Information>)
<Result>: Character string
Requested information.
<Spreadsheet Control>: Control name
Name of Spreadsheet control to use.
<Type of Information>: Integer constant
Sought information:
psheetInfoSortWithTitleUsed to find out whether the selection sorted by the AAF (Automatic Application Feature) for sorting the Spreadsheet control contains a title. <Result> can correspond to:
  • 1 if the selection to sort includes a title,
  • 0 otherwise.
psheetInfoSortCriteriaUsed to find out the last sort criteria used to sort 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 Used to find out whether the selection that will be sorted by the AAF (Automatic Application Feature) for sorting the Spreadsheet control. Example: "A2:B4".
Note: If the selection does not allow the sort, <Result> corresponds to an empty string ("").
Components
WINDEVReports and Queries wd230obj.dll
Minimum required version
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment