<Spreadsheet>.StyleSelection (Function) In french: <Tableur>.StyleSélection Returns or modifies the style of selected cells in a Spreadsheet control found in a window.
// CLICK on [BOLD]
PSHEET_Spreadsheet.StyleSelection(psheetBold, True)
// Displays the B1 cell in bold
PSHEET_Spreadsheet.SelectPlus("B1")
PSHEET_Spreadsheet.StyleSelection(psheetBold, True)
sRes is boolean = PSHEET_Spreadsheet.StyleSelection(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 Spreadsheet control to use. <Attribute>: Integer constant Attribute to find out: | | | psheetAlignmentH | Horizontal alignment. In this case, <Result> can correspond to: - haCenter: Centered alignment.
- haRight: Right alignment.
- haLeft: Alignment to left.
| | psheetAlignmentV | Vertical alignment. In this case, <Result> can correspond to: - vaBottom: Alignment at bottom.
- vaTop: Alignment at top.
- vaMiddle: Alignment in the middle.
|  Versions 23 and laterpsheetFontAngle New in version 23psheetFontAngle | Rotation angle of text. In this case, <Result> can correspond to an integer included between -180 and +180. | | psheetStrikeOut | Struck-out character. In this case, <Result> can correspond to: - True to strike out,
- False not to strike out.
| | psheetBackgroundColor | Background color of text. In this case, <Result> can correspond to: | | psheetTextColor | Text color. In this case, <Result> can correspond to: | | psheetBold | Bold character. In this case, <Result> can correspond to: - True to display in bold,
- False not to display in bold.
| | psheetItalic | Italic character. In this case, <Result> can correspond to: - True to display in italic,
- False not to display in italic.
| | psheetFontName | Name of font used. In this case, <Result> can correspond to a character string containing the font name. | Versions 23 and laterpsheetAutomaticLineWrap New in version 23psheetAutomaticLineWrap psheetAutomaticLineWrap | Management of 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.
| | psheetUnderlined | Underlined character. In this case, <Result> can correspond to: - True to underline,
- False not to underline.
| | psheetFontSize | Font size. In this case, <Result> corresponds to the font size (integer). |
Modifying the selection style Hide the details
<Spreadsheet control>.StyleSelection(<Attribute> , <Value>)
<Spreadsheet control>: Control name Name of Spreadsheet control to use. <Attribute>: Integer constant Attribute to modify. This element can correspond to: | | | psheetAlignmentH | Horizontal alignment. In this case, <Value> can correspond to: - haCenter: Centered alignment.
- haRight: Right alignment.
- haLeft: Alignment to left.
| | psheetAlignmentV | Vertical alignment. In this case, <Value> can correspond to: - vaBottom: Alignment at bottom.
- vaTop: Alignment at top.
- vaMiddle: Alignment in the middle.
| Versions 23 and laterpsheetFontAngle New in version 23psheetFontAngle psheetFontAngle | Rotation angle of text. In this case, <Value> can correspond to an integer included between -180 and +180. | | psheetStrikeOut | Struck-out character. In this case, <Value> can correspond to: - True to strike out,
- False not to strike out.
| | psheetBackgroundColor | Background color of text. In this case, <Value> can correspond to: | | psheetTextColor | Text color. In this case, <Value> can correspond to: | | psheetBold | Bold character. In this case, <Value> can correspond to: - True to display in bold,
- False not to display in bold.
| | psheetItalic | Italic character. 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. | Versions 23 and laterpsheetAutomaticLineWrap New in version 23psheetAutomaticLineWrap psheetAutomaticLineWrap | Management of 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 character. 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 modify operation is added into the list of operations to cancel: the user can cancel this operation via the popup 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…
|
|
|