|
|
|
|
|
<Spreadsheet>.BorderSelection (Function) In french: <Tableur>.CadreSélection Makes it possible to know and modify the border of the selected cells in a Spreadsheet control found in a window. // Defines the border to draw xBorder is Border xBorder.Thickness = 2 xBorder.Color = Black  // Selects the cells to frame PSHEET_Spreadsheet.SelectPlus("A3", "B12") // Traces the border of the group of cells PSHEET_Spreadsheet.BorderSelection(xBorder, False)
Syntax
Modifying the characteristics of the borders Hide the details
<Spreadsheet control>.BorderSelection(<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> = <Spreadsheet control>.BorderSelection()
<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 modify operation is added into the list of operations to cancel: the user can cancel this operation via the context menu or via Ctrl + Z.
- 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…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|