|
|
|
|
|
|
|
|
|
|
<Spreadsheet>.StyleSelection (Function) In french: <Tableur>.StyleSélection Returns or modifies the style of selected cells in a Spreadsheet control found in a window.
TBLR_Tableur.StyleSelection(psheetBold, True)
PSHEET_Spreadsheet.SelectPlus("B1")
TBLR_Tableur.StyleSelection(psheetBold, True)
sRes is boolean = TBLR_Tableur.StyleSélection(psheetBold)
Syntax
Finding out the selection style Hide the details
<Result> = <Spreadsheet control>.StyleSelection(<Attribute>)
<Result>: Type of expected result Requested attribute. <Spreadsheet control>: Control name Name of the Spreadsheet control to be used. <Attribute>: Integer constant Attribute to find out: | | | psheetAlignmentH | Horizontal alignment. In this case, <Result> can correspond to: - chCentre centered alignment.
- chRight Right alignment.
- chLeft Left alignment.
| | psheetAlignmentV | Vertical alignment. In this case, <Result> can correspond to: - cvBas Bottom alignment.
- cvTop Top alignment.
- cvMiddle Alignment in the middle.
| | psheetAutomaticLineWrap | Automatic line wrap. In this case, <Result> can correspond to: - True to use the automatic line wrap,
- False not to use the automatic line wrap.
| | psheetBackgroundColor | Text background color. In this case, <Result> can correspond to: | | psheetBold | Bold text in the cell. In this case, <Result> can correspond to: - True to display in bold,
- False not to display in bold.
| | psheetFontAngle | Text rotation angle. In this case, <Result> can correspond to an integer included between -180 and +180. | | psheetFontName | Name of font used. In this case, <Result> can correspond to a character string containing the font name. | | psheetFontSize | Font size. In this case, <Result> corresponds to the font size (integer). | | psheetItalic | Italicized text in the cell. In this case, <Result> can correspond to: - True to display in italic,
- False not to display in italic.
| | psheetStrikeOut | Strikethrough text in the cell. In this case, <Result> can correspond to: - True to strike out,
- False not to strike out.
| | psheetTextColor | Text color. In this case, <Result> can correspond to: | | psheetUnderlined | Underlined text in the cell. In this case, <Result> can correspond to: - True to underline,
- False not to underline.
|
Modifying the selection style Hide the details
<Spreadsheet control>.StyleSelection(<Attribute> , <Value>)
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used. <Attribute>: Integer constant Attribute to modify. This element can correspond to: | | | psheetAlignmentH | Horizontal alignment. In this case, <Value> can correspond to: - chCentre centered alignment.
- chRight Right alignment.
- chLeft Left alignment.
| | psheetAlignmentV | Vertical alignment. In this case, <Value> can correspond to: - cvBas Bottom alignment.
- cvTop Top alignment.
- cvMiddle Alignment in the middle.
| | psheetFontAngle | Text rotation angle. In this case, <Value> can correspond to an integer included between -180 and +180. | | psheetStrikeOut | Strikethrough text in the cell. In this case, <Value> can correspond to: - True to strike out,
- False not to strike out.
| | psheetBackgroundColor | Text background color. In this case, <Value> can correspond to: | | psheetTextColor | Text color. In this case, <Value> can correspond to: | | psheetBold | Bold text in the cell. In this case, <Value> can correspond to: - True to display in bold,
- False not to display in bold.
| | psheetItalic | Italicized text in the cell. In this case, <Value> can correspond to: - True to display in italic,
- False not to display in italic.
| | psheetFontName | Name of font used. In this case, <Value> can correspond to a character string containing the font name. | | psheetAutomaticLineWrap | Automatic line wrap. In this case, <Value> can correspond to: - True to use the automatic line wrap,
- False not to use the automatic line wrap.
| | psheetUnderlined | Underlined text in the cell. In this case, <Value> can correspond to: - True to underline,
- False not to underline.
| | psheetFontSize | Font size. In this case, <Value> corresponds to the font size (integer). |
<Value>: Variant Value that will be given to the attribute. 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 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…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|