|
|
|
|
|
|
|
|
|
|
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. // Defines the border to draw
xBorder is Border
xBorder.Thickness = 2
xBorder.Color = Black
Â
// Selects the cells to frame
SpreadsheetSelectPlus(PSHEET_Spreadsheet, "A3", "B12")
// Traces the border of the group of cells
SpreadsheetBorderSelection(PSHEET_Spreadsheet, xBorder, 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 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…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|