ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Controls, pages and windows / Spreadsheet functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Display constants used by prefix syntaxes only
The following constants are used by Spreadsheet control functions:
ConstantDescriptionUsed by
mergeCellCenterMerge cells of a Spreadsheet control: merges the cells and centers the contents. SpreadsheetMergeCell
mergeCellMerge cells of a Spreadsheet control: merges the cells without centering the contents. SpreadsheetMergeCell
psheetAlignmentHAttribute to get or set: Horizontal alignmentSpreadsheetStyleSelection
psheetAlignmentVAttribute to get or set: Vertical alignmentSpreadsheetStyleSelection
psheetFontAngleAttribute to get or set: Text rotation angleSpreadsheetStyleSelection
psheetStrikeOutAttribute to get or set: Strikethrough text in the cellSpreadsheetStyleSelection
psheetLoadDefaultXLSX file loading mode: The XLSX file loaded in the Spreadsheet control is opened in write mode.SpreadsheetLoad
psheetLoadUnlinkedXLSX file loading mode: The XLSX file loaded in the Spreadsheet control is loaded in memory only. The ".xlxs" file can be opened by another application.SpreadsheetLoad
psheetLoadKeepPasswordXLSX file loading mode: The password of the XLSX file loaded in the Spreadsheet control is kept in memory. SpreadsheetLoad
psheetBackgroundColorAttribute to get or set: Text background colorSpreadsheetStyleSelection
psheetTextColorAttribute to get or set: Text colorSpreadsheetStyleSelection
psheetOverwriteAllowedFile save mode: If the XLSX file already exists and is not open (in the Spreadsheet control or another application), it is overwritten.SpreadsheetSave
psheetfFormulaFormula bar customization: The control allows you to type the formula for the current cell in the Spreadsheet control.SpreadsheetControlFormula
psheetfSelectionFormula bar customization: The control displays the current selection (cell or range of cells) in the Spreadsheet control.SpreadsheetControlFormula
psheetBoldAttribute to get or set: Bold text in the cellSpreadsheetStyleSelection
psheetTopLeftThe Spreadsheet control displays the specified cell in the upper-left corner of the control's visible area.SpreadsheetPosition
psheetSortInfoWithTitleDesired information: Determines if the selection sorted by the Automatic Application Features (AAFs) in the Spreadsheet control contains a titleSpreadsheetGetSortInfo
psheetInfoSortCriteriaDesired information: Gets the last sort criteria used in the Spreadsheet control.SpreadsheetGetSortInfo
psheetInfoSortSelectionDesired information: Gets the selection that will be sorted via the Automatic Application Features (AAFs) in the Spreadsheet control.SpreadsheetGetSortInfo
psheetItalicAttribute to get or set: Italicized text in the cellSpreadsheetStyleSelection
psheetFontNameAttribute to get or set: Name of font usedSpreadsheetStyleSelection
psheetSearchWithCaseSearch option: Case-sensitive search. SpreadsheetSeek, SpreadsheetReplace
psheetSearchContainSearch option: "Contains" search. SpreadsheetSeek, SpreadsheetReplace
psheetSearchInFormulaSearch option: Search only in formulas. SpreadsheetSeek, SpreadsheetReplace
psheetSearchExactSearch option: Exact-match search. SpreadsheetSeek, SpreadsheetReplace
psheetSearchCurrentWorksheetSearch option: Search in the current worksheet. SpreadsheetSeek, SpreadsheetReplace
psheetSearchNoCaseSearch option: Case-insensitive search. SpreadsheetSeek, SpreadsheetReplace
psheetSearchAnyWorksheetSearch option: Search in all sheets of the workbook. SpreadsheetSeek, SpreadsheetReplace
psheetAutomaticLineWrapAttribute to get or set: Automatic line wrap. SpreadsheetStyleSelection
psheetSelMultiCellType of selection: Several cells are selected. psheetSelection variable
psheetSelMultiHeaderType of selection: Several headers are selected. psheetSelection variable
psheetSelRectCellType of selection: Several cells are selected and they define a rectangle. psheetSelection variable
psheetSelSimpleCellType of selection: A single cell is selected. psheetSelection variable
psheetSelSimpleHeaderType of selection: A single header is selected. psheetSelection variable
psheetSelAllType of selection: The entire worksheet is selected. psheetSelection variable
psheetSelEmptyType of selection: No selection. psheetSelection variable
psheetUnderlinedAttribute to get or set: Underlined text in the cellSpreadsheetStyleSelection
psheetFontSizeAttribute to get or set: Font sizeSpreadsheetStyleSelection
psheetVisibleThe specified cell is visible in the Spreadsheet control. If the specified cell is already visible, the Spreadsheet control does not change.SpreadsheetPosition
The following constants are used by the Spreadsheet control functions (prefix syntax):
ConstantDescriptionUsed by
mergeCellCenterMerge cells of a Spreadsheet control: merges the cells and centers the contents. <Spreadsheet>.MergeCell
mergeCellMerge cells of a Spreadsheet control: merges the cells without centering the contents. <Spreadsheet>.MergeCell
psheetAlignmentHAttribute to get or set: Horizontal alignment<Spreadsheet>.StyleSelection
psheetAlignmentVAttribute to get or set: Vertical alignment<Spreadsheet>.StyleSelection
psheetFontAngleAttribute to get or set: Text rotation angle<Spreadsheet>.StyleSelection
psheetStrikeOutAttribute to get or set: Strikethrough text in the cell<Spreadsheet>.StyleSelection
psheetLoadDefaultXLSX file loading mode: The XLSX file loaded in the Spreadsheet control is opened in write mode.<Spreadsheet>.Load
psheetLoadUnlinkedXLSX file loading mode: The XLSX file loaded in the Spreadsheet control is loaded in memory only. The ".xlxs" file can be opened by another application.<Spreadsheet>.Load
psheetBackgroundColorAttribute to get or set: Text background color<Spreadsheet>.StyleSelection
psheetTextColorAttribute to get or set: Text color<Spreadsheet>.StyleSelection
psheetOverwriteAllowedFile save mode: If the XLSX file already exists and is not open (in the Spreadsheet control or another application), it is overwritten.<Spreadsheet>.Save
psheetfFormulaFormula bar customization: The control allows you to type the formula for the current cell in the Spreadsheet control.<Spreadsheet>.ControlFormula
psheetfSelectionFormula bar customization: The control displays the current selection (cell or range of cells) in the Spreadsheet control.<Spreadsheet>.ControlFormula
psheetBoldAttribute to get or set: Bold text in the cell<Spreadsheet>.StyleSelection
psheetTopLeftThe Spreadsheet control displays the specified cell in the upper-left corner of the control's visible area.<Spreadsheet>.Position
psheetSortInfoWithTitleDesired information: Determines if the selection sorted by the Automatic Application Features (AAFs) in the Spreadsheet control contains a titleSpreadsheetGetSortInfo
psheetInfoSortCriteriaDesired information: Gets the last sort criteria used in the Spreadsheet control.SpreadsheetGetSortInfo
psheetInfoSortSelectionDesired information: Gets the selection that will be sorted via the Automatic Application Features (AAFs) in the Spreadsheet control.SpreadsheetGetSortInfo
psheetItalicAttribute to get or set: Italicized text in the cell<Spreadsheet>.StyleSelection
psheetFontNameAttribute to get or set: Name of font used<Spreadsheet>.StyleSelection
psheetSearchWithCaseSearch option: Case-sensitive search. <Spreadsheet>.Seek, SpreadsheetReplace
psheetSearchContainSearch option: "Contains" search. <Spreadsheet>.Seek, SpreadsheetReplace
psheetSearchInFormulaSearch option: Search only in formulas. <Spreadsheet>.Seek, SpreadsheetReplace
psheetSearchExactSearch option: Exact-match search. <Spreadsheet>.Seek, SpreadsheetReplace
psheetSearchCurrentWorksheetSearch option: Search in the current worksheet. <Spreadsheet>.Seek, SpreadsheetReplace
psheetSearchNoCaseSearch option: Case-insensitive search. <Spreadsheet>.Seek, SpreadsheetReplace
psheetSearchAnyWorksheetSearch option: Search in all sheets of the workbook. <Spreadsheet>.Seek, SpreadsheetReplace
psheetAutomaticLineWrapAttribute to get or set: Automatic line wrap. <Spreadsheet>.StyleSelection
psheetSelMultiCellType of selection: Several cells are selected. psheetSelection variable
psheetSelMultiHeaderType of selection: Several headers are selected. psheetSelection variable
psheetSelRectCellType of selection: Several cells are selected and they define a rectangle. psheetSelection variable
psheetSelSimpleCellType of selection: A single cell is selected. psheetSelection variable
psheetSelSimpleHeaderType of selection: A single header is selected. psheetSelection variable
psheetSelAllType of selection: The entire worksheet is selected. psheetSelection variable
psheetSelEmptyType of selection: No selection. psheetSelection variable
psheetUnderlinedAttribute to get or set: Underlined text in the cell<Spreadsheet>.StyleSelection
psheetFontSizeAttribute to get or set: Font size<Spreadsheet>.StyleSelection
psheetVisibleThe specified cell is visible in the Spreadsheet control. If the specified cell is already visible, the Spreadsheet control does not change.<Spreadsheet>.Position
Minimum version required
  • Version 20
Comments
Click [Add] to post a comment

Last update: 02/23/2024

Send a report | Local help