ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage functions / Controls, pages and windows / Spreadsheet functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Display only constants used by prefix syntaxes
The following constants are used by the functions for managing Spreadsheet controls:
ConstantDescriptionUsed by
mergeCellCenterMerge cells in a Spreadsheet control: merge cells by centering the content.. SpreadsheetMergeCell
mergeCellSpreadsheet control: merge cells without centering content. SpreadsheetMergeCell
psheetAlignmentHAttribute to know/modify: Horizontal alignmentSpreadsheetStyleSelection
psheetAlignmentVAttribute to know/modify: Vertical alignmentSpreadsheetStyleSelection
psheetFontAngleAttribute to know/modify: Text rotation angleSpreadsheetStyleSelection
psheetStrikeOutAttribute to know/modify: Strikethrough cell TextSpreadsheetStyleSelection
psheetLoadDefaultXLSX file loading mode: The XLSX file loaded in the Spreadsheet control is open for writing.SpreadsheetLoad
psheetLoadUnlinkedXLSX file loading mode: The XLSX file loaded in the Spreadsheet control is loaded into 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 stored in memory.. SpreadsheetLoad
psheetBackgroundColorAttribute to know/modify: Text background colorSpreadsheetStyleSelection
psheetTextColorAttribute to know/modify: 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
psheetfFormulaCustomize the formula bar: This field lets you enter the formula for the current cell in the Spreadsheet control.SpreadsheetControlFormula
psheetfSelectionCustomize formula bar: The field displays the current selection (cell or cell range) in the Spreadsheet control.SpreadsheetControlFormula
psheetBoldAttribute to know/modify: Bold cell TextSpreadsheetStyleSelection
psheetTopLeftThe Spreadsheet control displays the specified cell in the upper-left corner of the control's visible area.SpreadsheetPosition
psheetSortInfoWithTitleInformation sought: Allows you to find out whether the selection sorted by the Spreadsheet control's FAA (Automatic Functionality of Your Applications) sorting function contains a title.SpreadsheetGetSortInfo
psheetInfoSortCriteriaSearched information: Shows the last sort criteria used to sort the Spreadsheet control.SpreadsheetGetSortInfo
psheetInfoSortSelectionSearched information: Allows you to find out which selection will be sorted by the Spreadsheet control's Automatic Application Functionality (AAF).SpreadsheetGetSortInfo
psheetItalicAttribute to know/modify: Italic cell TextSpreadsheetStyleSelection
psheetFontNameAttribute to know/modify: Name of font usedSpreadsheetStyleSelection
psheetSearchWithCaseSearch option: Case-sensitive search. SpreadsheetSeek, SpreadsheetReplace
psheetSearchContainSearch option: "Contains" type search. SpreadsheetSeek, SpreadsheetReplace
psheetSearchInFormulaSearch option: Search only in formulas. SpreadsheetSeek, SpreadsheetReplace
psheetSearchExactSearch option: Exact search. SpreadsheetSeek, SpreadsheetReplace
psheetSearchCurrentWorksheetSearch option: Search in current sheet. SpreadsheetSeek, SpreadsheetReplace
psheetSearchNoCaseSearch option: Case-insensitive search. SpreadsheetSeek, SpreadsheetReplace
psheetSearchAnyWorksheetSearch option: Search in all sheets of the workbook. SpreadsheetSeek, SpreadsheetReplace
psheetAutomaticLineWrapAttribute to know/modify: Automatic line feed-back management. SpreadsheetStyleSelection
psheetSelMultiCellSelection type: Several boxes are selected. psheetSelection variable
psheetSelMultiHeaderSelection type: Several headers are selected. psheetSelection variable
psheetSelRectCellSelection type: several boxes are selected and form a rectangle. psheetSelection variable
psheetSelSimpleCellSelection type: A single box is selected. psheetSelection variable
psheetSelSimpleHeaderSelection type: A single header is selected. psheetSelection variable
psheetSelAllSelection type: The entire sheet is selected. psheetSelection variable
psheetSelEmptySelection type: No selection. psheetSelection variable
psheetUnderlinedAttribute to know/modify: Underlined cell TextSpreadsheetStyleSelection
psheetFontSizeAttribute to know/modify: 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 in a Spreadsheet control: merge cells by centering the content.. <Spreadsheet>.MergeCell
mergeCellSpreadsheet control: merge cells without centering content. <Spreadsheet>.MergeCell
psheetAlignmentHAttribute to know/modify: Horizontal alignment<Spreadsheet>.StyleSelection
psheetAlignmentVAttribute to know/modify: Vertical alignment<Spreadsheet>.StyleSelection
psheetFontAngleAttribute to know/modify: Text rotation angle<Spreadsheet>.StyleSelection
psheetStrikeOutAttribute to know/modify: Strikethrough cell Text<Spreadsheet>.StyleSelection
psheetLoadDefaultXLSX file loading mode: The XLSX file loaded in the Spreadsheet control is open for writing.<Spreadsheet>.Load
psheetLoadUnlinkedXLSX file loading mode: The XLSX file loaded in the Spreadsheet control is loaded into memory only.. The ".xlxs" file can be opened by another application.<Spreadsheet>.Load
psheetBackgroundColorAttribute to know/modify: Text background color<Spreadsheet>.StyleSelection
psheetTextColorAttribute to know/modify: 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
psheetfFormulaCustomize the formula bar: This field lets you enter the formula for the current cell in the Spreadsheet control.<Spreadsheet>.ControlFormula
psheetfSelectionCustomize formula bar: The field displays the current selection (cell or cell range) in the Spreadsheet control.<Spreadsheet>.ControlFormula
psheetBoldAttribute to know/modify: Bold cell Text<Spreadsheet>.StyleSelection
psheetTopLeftThe Spreadsheet control displays the specified cell in the upper-left corner of the control's visible area.<Spreadsheet>.Position
psheetSortInfoWithTitleInformation sought: Allows you to find out whether the selection sorted by the Spreadsheet control's FAA (Automatic Functionality of Your Applications) sorting function contains a title.SpreadsheetGetSortInfo
psheetInfoSortCriteriaSearched information: Shows the last sort criteria used to sort the Spreadsheet control.SpreadsheetGetSortInfo
psheetInfoSortSelectionSearched information: Allows you to find out which selection will be sorted by the Spreadsheet control's Automatic Application Functionality (AAF).SpreadsheetGetSortInfo
psheetItalicAttribute to know/modify: Italic cell Text<Spreadsheet>.StyleSelection
psheetFontNameAttribute to know/modify: Name of font used<Spreadsheet>.StyleSelection
psheetSearchWithCaseSearch option: Case-sensitive search. <Spreadsheet>.Seek, SpreadsheetReplace
psheetSearchContainSearch option: "Contains" type search. <Spreadsheet>.Seek, SpreadsheetReplace
psheetSearchInFormulaSearch option: Search only in formulas. <Spreadsheet>.Seek, SpreadsheetReplace
psheetSearchExactSearch option: Exact search. <Spreadsheet>.Seek, SpreadsheetReplace
psheetSearchCurrentWorksheetSearch option: Search in current sheet. <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 know/modify: Automatic line feed-back management. <Spreadsheet>.StyleSelection
psheetSelMultiCellSelection type: Several boxes are selected. psheetSelection variable
psheetSelMultiHeaderSelection type: Several headers are selected. psheetSelection variable
psheetSelRectCellSelection type: several boxes are selected and form a rectangle. psheetSelection variable
psheetSelSimpleCellSelection type: A single box is selected. psheetSelection variable
psheetSelSimpleHeaderSelection type: A single header is selected. psheetSelection variable
psheetSelAllSelection type: The entire sheet is selected. psheetSelection variable
psheetSelEmptySelection type: No selection. psheetSelection variable
psheetUnderlinedAttribute to know/modify: Underlined cell Text<Spreadsheet>.StyleSelection
psheetFontSizeAttribute to know/modify: 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: 09/30/2024

Send a report | Local help