PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
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 the functions for managing Spreadsheet controls:
ConstantDescriptionUsed by the functions
psheetAlignmentHAttribute to find or modify: Horizontal alignmentSpreadsheetStyleSelection
psheetAlignmentVAttribute to find or modify: Vertical alignmentSpreadsheetStyleSelection
psheetFontAngleAttribute to find or modify: Text rotation angleSpreadsheetStyleSelection
psheetStrikeOutAttribute to find or modify: Struck-out characterSpreadsheetStyleSelection
psheetLoadDefaultMode for loading the XLSX file: The XLSX file loaded in the Spreadsheet control is opened in write mode.SpreadsheetLoad
psheetLoadUnlinkedMode for loading the XLSX file: The XLSX file loaded in the Spreadsheet control is loaded in memory only. The ".xlxs" file can be opened by another application.SpreadsheetLoad
psheetLoadKeepPasswordMode for loading the XLSX file: The password of the XLSX file loaded in the Spreadsheet control is kept in memory. SpreadsheetLoad
psheetBackgroundColorAttribute to find or modify: Background color of textSpreadsheetStyleSelection
psheetTextColorAttribute to find or modify: Text colorSpreadsheetStyleSelection
psheetOverwriteAllowedMode for saving the file: If the XLSX file already exists and is not open (in the Spreadsheet control or another application), it is overwritten.SpreadsheetSave
psheetfFormulaCustomizing the formula bar: The control allows you to type the formula for the current cell in the Spreadsheet control.SpreadsheetControlFormula
psheetfSelectionCustomizing the formula bar: The control displays the current selection (cell or range of cells) in the Spreadsheet control.SpreadsheetControlFormula
psheetBoldAttribute to find or modify: Bold characterSpreadsheetStyleSelection
psheetTopLeftThe display of Spreadsheet control is modified in order for the specified cell to be positioned in the upper-left corner of visible control area.SpreadsheetPosition
psheetSortInfoWithTitleRequested information: Used to know whether the selection sorted by the AAF (Automatic Application Features) for sorting the Spreadsheet control contains a titleSpreadsheetGetSortInfo
psheetInfoSortCriteriaRequested information: Used to find out the last sort criteria used to sort the Spreadsheet control.SpreadsheetGetSortInfo
psheetInfoSortSelectionRequested information: Used to know selection that will be sorted by the AAF (Automatic Application Features) for sorting the Spreadsheet control.SpreadsheetGetSortInfo
psheetItalicAttribute to find or modify: Italic characterSpreadsheetStyleSelection
psheetFontNameAttribute to find or modify: Name of font usedSpreadsheetStyleSelection
psheetSearchWithCaseSearch option: Search while taking the case into account. SpreadsheetSeek, SpreadsheetReplace
psheetSearchContainSearch option: "Contains" search. SpreadsheetSeek, SpreadsheetReplace
psheetSearchInFormulaSearch option: Search in the formulas only. SpreadsheetSeek, SpreadsheetReplace
psheetSearchExactSearch option: "Exact" search. SpreadsheetSeek, SpreadsheetReplace
psheetSearchCurrentWorksheetSearch option: Search in the current worksheet. SpreadsheetSeek, SpreadsheetReplace
psheetSearchNoCaseSearch option: Search ignoring the case. SpreadsheetSeek, SpreadsheetReplace
psheetSearchAnyWorksheetSearch option: Search in all worksheets of workbook. SpreadsheetSeek, SpreadsheetReplace
psheetAutomaticLineWrapAttribute to find or modify: Management of 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 find or modify: Underlined characterSpreadsheetStyleSelection
psheetFontSizeAttribute to find or modify: Font sizeSpreadsheetStyleSelection
psheetVisibleThe display of Spreadsheet control is modified in order for the specified cell to be visible in the Spreadsheet control. The display of control is not modified if the specified cell is already visible in the Spreadsheet control.SpreadsheetPosition
The functions for managing Spreadsheet controls use the following constants (prefix syntax):
ConstantDescriptionUsed by the functions
psheetAlignmentHAttribute to find or modify: Horizontal alignment<Spreadsheet>.StyleSelection
psheetAlignmentVAttribute to find or modify: Vertical alignment<Spreadsheet>.StyleSelection
psheetFontAngleAttribute to find or modify: Text rotation angle<Spreadsheet>.StyleSelection
psheetStrikeOutAttribute to find or modify: Struck-out character<Spreadsheet>.StyleSelection
psheetLoadDefaultMode for loading the XLSX file: The XLSX file loaded in the Spreadsheet control is opened in write mode.<Spreadsheet>.Load
psheetLoadUnlinkedMode for loading the XLSX file: 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 find or modify: Background color of text<Spreadsheet>.StyleSelection
psheetTextColorAttribute to find or modify: Text color<Spreadsheet>.StyleSelection
psheetOverwriteAllowedMode for saving the file: If the XLSX file already exists and is not open (in the Spreadsheet control or another application), it is overwritten.<Spreadsheet>.Save
psheetfFormulaCustomizing the formula bar: The control allows you to type the formula for the current cell in the Spreadsheet control.<Spreadsheet>.ControlFormula
psheetfSelectionCustomizing the formula bar: The control displays the current selection (cell or range of cells) in the Spreadsheet control.<Spreadsheet>.ControlFormula
psheetBoldAttribute to find or modify: Bold character<Spreadsheet>.StyleSelection
psheetTopLeftThe display of Spreadsheet control is modified in order for the specified cell to be positioned in the upper-left corner of visible control area.<Spreadsheet>.Position
psheetSortInfoWithTitleRequested information: Used to know whether the selection sorted by the AAF (Automatic Application Features) for sorting the Spreadsheet control contains a titleSpreadsheetGetSortInfo
psheetInfoSortCriteriaRequested information: Used to find out the last sort criteria used to sort the Spreadsheet control.SpreadsheetGetSortInfo
psheetInfoSortSelectionRequested information: Used to know selection that will be sorted by the AAF (Automatic Application Features) for sorting the Spreadsheet control.SpreadsheetGetSortInfo
psheetItalicAttribute to find or modify: Italic character<Spreadsheet>.StyleSelection
psheetFontNameAttribute to find or modify: Name of font used<Spreadsheet>.StyleSelection
psheetSearchWithCaseSearch option: Search while taking the case into account. <Spreadsheet>.Seek, SpreadsheetReplace
psheetSearchContainSearch option: "Contains" search. <Spreadsheet>.Seek, SpreadsheetReplace
psheetSearchInFormulaSearch option: Search in the formulas only. <Spreadsheet>.Seek, SpreadsheetReplace
psheetSearchExactSearch option: "Exact" search. <Spreadsheet>.Seek, SpreadsheetReplace
psheetSearchCurrentWorksheetSearch option: Search in the current worksheet. <Spreadsheet>.Seek, SpreadsheetReplace
psheetSearchNoCaseSearch option: Search ignoring the case. <Spreadsheet>.Seek, SpreadsheetReplace
psheetSearchAnyWorksheetSearch option: Search in all worksheets of workbook. <Spreadsheet>.Seek, SpreadsheetReplace
psheetAutomaticLineWrapAttribute to find or modify: Management of 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 find or modify: Underlined character<Spreadsheet>.StyleSelection
psheetFontSizeAttribute to find or modify: Font size<Spreadsheet>.StyleSelection
psheetVisibleThe display of Spreadsheet control is modified in order for the specified cell to be visible in the Spreadsheet control. The display of control is not modified if the specified cell is already visible in the Spreadsheet control.<Spreadsheet>.Position
Minimum version required
  • Version 20
Comments
Click [Add] to post a comment