ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Controls, pages and windows / Spreadsheet functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
<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.
Note: This function can only be used on a Spreadsheet control present in a window.
Example
sFusion is string = TBLR_MonTableur.RécupèreFusion("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> = <Spreadsheet control>.GetMerge(<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>"
    For example: "A2:C5"
<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> = <Spreadsheet control>.GetMerge(<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>"
    For example: "A2:C5"
<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.
Component: wd300obj.dll
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/20/2024

Send a report | Local help