PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
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
SpreadsheetGetMerge (Function)
In french: TableurRécupèreFusion
Allows you to find out whether a cell found in a Spreadsheet control is merged with other cells and to get the name of merged cells.
Note: This function can only be used on a Spreadsheet control found in a window.
Example
sMerge is string = SpreadsheetGetMerge(PSHEET_Spreadsheet, "B1")
IF sMerge = "" THEN
Info("No merge")
ELSE
sMin is string = ExtractString(sMerge, 1, ":")
sMax is string = ExtractString(sMerge, 2, ":")
Info("Merge between " + sMin + " and " +  sMax)
END
Syntax

Retrieving the characteristics of a merged cell identified by its name Hide the details

<Result> = SpreadsheetGetMerge(<Spreadsheet control> , <Cell>)
<Result>: Character string
  • Empty string ("") if the cell is not merged,
  • Range of merged cells in the following format:
    "<Name top left cell>:<Name bottom right cell>"
    For example: "A2:C5"
<Spreadsheet control>: Control name
Name of Spreadsheet control to use.
<Cell>: Character string (with quotes)
Name of cell to use. For example: "A4".

Retrieving the characteristics of a merged cell identified by its column and by its row Hide the details

<Result> = SpreadsheetGetMerge(<Spreadsheet control> , <Column> , <Row>)
<Result>: Character string
  • Empty string ("") if the cell is not merged,
  • Range of merged cells in the following format:
    "<Name top left cell>:<Name bottom right cell>"
    For example: "A2:C5"
<Spreadsheet control>: Control name
Name of Spreadsheet control to use.
<Column>: Integer
Number of column for the cell to use.
<Row>: Integer
Number of row for the cell to use.
Component : wd240obj.dll
See also
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment