AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Este contenido se ha traducido automáticamente.  Haga clic aquí  para ver la versión en inglés.
Ayuda / WLanguage / Funciones WLanguage / Controles, páginas y ventanas / Funciones Hoja de cálculo
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Otros
Procedimientos almacenados
Returns or modifies the style of selected cells in a Spreadsheet control found in a window.
Ejemplo
// CLIC sur [GRAS]
SpreadsheetStyleSelection(TBLR_Tableur, psheetBold, True)

// Met en gras la cellule B1
SpreadsheetSelectPlus(TBLR_Tableur, "B1")
SpreadsheetStyleSelection(TBLR_Tableur, psheetBold, True)
sRes is boolean = SpreadsheetStyleSelection(TBLR_Tableur, psheetBold)
Sintaxis

Finding out the selection style Ocultar los detalles

<Result> = SpreadsheetStyleSelection(<Spreadsheet control> , <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:
psheetAlignmentHHorizontal alignment.
In this case, <Result> can correspond to:
  • haCenter: Centered alignment.
  • haRight: Right alignment.
  • haLeft: Alignment to left.
psheetAlignmentVVertical alignment.
In this case, <Result> can correspond to:
  • vaBottom: Alignment at bottom.
  • vaTop: Alignment at top.
  • vaMiddle: Alignment in the middle.
psheetAutomaticLineWrapManagement 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.
psheetBackgroundColorText background color.
In this case, <Result> can correspond to:
psheetBoldBold cell text.
In this case, <Result> can correspond to:
  • True to display in bold,
  • False not to display in bold.
psheetFontAngleText rotation angle.
In this case, <Result> can correspond to an integer included between -180 and +180.
psheetFontNameName of font used.
In this case, <Result> can correspond to a character string containing the font name.
psheetFontSizeFont size.
In this case, <Result> corresponds to the font size (integer).
psheetItalicItalic cell text.
In this case, <Result> can correspond to:
  • True to display in italic,
  • False not to display in italic.
psheetStrikeOutCell text crossed out.
In this case, <Result> can correspond to:
  • True to strike out,
  • False not to strike out.
psheetTextColorText color.
In this case, <Result> can correspond to:
psheetUnderlinedUnderlined cell text.
In this case, <Result> can correspond to:
  • True to underline,
  • False not to underline.

Modifying the selection style Ocultar los detalles

SpreadsheetStyleSelection(<Spreadsheet control> , <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:
psheetAlignmentHHorizontal alignment.
In this case, <Value> can correspond to:
  • haCenter: Centered alignment.
  • haRight: Right alignment.
  • haLeft: Alignment to left.
psheetAlignmentVVertical alignment.
In this case, <Value> can correspond to:
  • vaBottom: Alignment at bottom.
  • vaTop: Alignment at top.
  • vaMiddle: Alignment in the middle.
psheetFontAngleText rotation angle.
In this case, <Value> can correspond to an integer included between -180 and +180.
psheetStrikeOutCell text crossed out.
In this case, <Value> can correspond to:
  • True to strike out,
  • False not to strike out.
psheetBackgroundColorText background color.
In this case, <Value> can correspond to:
psheetTextColorText color.
In this case, <Value> can correspond to:
psheetBoldBold cell text.
In this case, <Value> can correspond to:
  • True to display in bold,
  • False not to display in bold.
psheetItalicItalic cell text.
In this case, <Value> can correspond to:
  • True to display in italic,
  • False not to display in italic.
psheetFontNameName of font used.
In this case, <Value> can correspond to a character string containing the font name.
psheetAutomaticLineWrapManagement 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.
psheetUnderlinedUnderlined cell text.
In this case, <Value> can correspond to:
  • True to underline,
  • False not to underline.
psheetFontSizeFont size.
In this case, <Value> corresponds to the font size (integer).
<Value>: Variant
Value that will be given to the attribute.
Observaciones
  • The modify operation is added into the list of operations to cancel: 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.
Componente: wd290obj.dll
Versión mínima requerida
  • Versión 20
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 24/02/2024

Señalar un error o enviar una sugerencia | Ayuda local