|
|
|
|
|
|
|
|
|
|
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 present in a window. sFusion is string = SpreadsheetGetMerge(TBLR_MonTableur, "B1")
IF sFusion = "" THEN
Info("Aucune fusion")
ELSE
sMin is string = ExtractString(sFusion, 1, ":")
sMax is string = ExtractString(sFusion, 2, ":")
Info("Fusion entre " + sMin + " et " + 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,
- Merged cell range in the following format:
"<Name top left cell>:<Name bottom right cell>"
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used. <Cell>: Character string Name of the cell to be used. 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,
- Merged cell range in the following format:
"<Name top left cell>:<Name bottom right cell>"
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used. <Column>: Integer Column number of the specified cell. <Row>: Integer Row number of the cell to be used.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|