|
|
|
|
|
|
|
|
|
|
SpreadsheetBorderSelection (Function) In french: TableurCadreSélection Makes it possible to know and modify the border of the selected cells in a Spreadsheet control found in a window.
xCadre is Border
xCadre.Thickness = 2
xCadre.Color = Black
SpreadsheetSelectPlus(TBLR_Tableur, "A3", "B12")
SpreadsheetBorderSelection(TBLR_Tableur, xCadre, False)
Syntax
Modifying the characteristics of the borders Hide the details
SpreadsheetBorderSelection(<Spreadsheet control> , <Border> [, <Selection>])
<Spreadsheet control>: Control name Name of the Spreadsheet control used. <Border>: Border variable Name of the Border variable containing the characteristics of the border to be used. <Selection>: Optional boolean - True if the border must be applied to each selected cell,
- False (default value) if the border must be applied to all selected cells.
Finding out the characteristics of the border Hide the details
<Border> = SpreadsheetBorderSelection(<Spreadsheet control>)
<Border>: Border variable Name of the Border variable containing the characteristics of the border. <Spreadsheet control>: Control name Name of the Spreadsheet control used. Remarks - The modification operation is added to the list of operations to be undone: the user can undo this operation via the context menu or by pressing the Ctrl + Z key combination..
- This function can only be used on a Spreadsheet control found in a window.
Related Examples:
|
Unit examples (WINDEV): The Spreadsheet control
[ + ] Using the Spreadsheet control. This example explains how to: - load an xlsx file in a spreadsheet control, - save the spreadsheet in a file, - fill the control with data coming from the database, - insert rows, columns, - access the cells and handle them (modify their value, their style, ...), - enter formulas, - ...
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|