|
|
|
|
<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. 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 the Spreadsheet control to be used. <Cell>: Character string 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 the Spreadsheet control to be used. <Column>: Integer Number of column for the cell to use. <Row>: Integer Row number of the cell to be used.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|