<Spreadsheet>.GetMerge (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Spreadsheet>.GetMerge (Function)

In french: <Tableur>.Ré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.

Remark: This function can only be used on a Spreadsheet control found in a window.

Example

sMerge is string = PSHEET_Spreadsheet.GetMerge("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> = <Spreadsheet control>.GetMerge(<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> = <Spreadsheet control>.GetMerge(<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 : wd250obj.dll