PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
The following constants are used by the functions for managing the Spreadsheet controls:
ConstantAffectsUsed by the functions
psheetAlignmentHAttribute to find or modify: Horizontal alignmentSpreadsheetStyleSelection
psheetAlignmentVAttribute to find or modify: Vertical alignmentSpreadsheetStyleSelection
Versions 23 and later
psheetAutomaticLineWrap
New in version 23
psheetAutomaticLineWrap
psheetAutomaticLineWrap
Attribute to find or modify: Management of automatic line wrap. SpreadsheetStyleSelection
psheetBackgroundColorAttribute to find or modify: Background color of textSpreadsheetStyleSelection
psheetBoldAttribute to find or modify: Bold characterSpreadsheetStyleSelection
psheetfFormulaCustomizing the formula bar: The control allows you to type the formula for the current cell in the Spreadsheet control.SpreadsheetControlFormula
Versions 23 and later
psheetFontAngle
New in version 23
psheetFontAngle
psheetFontAngle
Attribute to find or modify: Rotation angle of textSpreadsheetStyleSelection
psheetFontNameAttribute to find or modify: Name of font usedSpreadsheetStyleSelection
psheetFontSizeAttribute to find or modify: Size of fontSpreadsheetStyleSelection
psheetfSelectionCustomizing the formula bar: The control displays the current selection (cell or range of cells) in the Spreadsheet control.SpreadsheetControlFormula
Versions 23 and later
psheetInfoSortCriteria
New in version 23
psheetInfoSortCriteria
psheetInfoSortCriteria
Requested information: Used to find out the last sort criteria used to sort the Spreadsheet control.
Versions 23 and later
SpreadsheetGetSortInfo
New in version 23
SpreadsheetGetSortInfo
SpreadsheetGetSortInfo
Versions 23 and later
psheetInfoSortSelection
New in version 23
psheetInfoSortSelection
psheetInfoSortSelection
Requested information: Used to find out whether the selection that will be sorted by the AAF (Automatic Application Feature) for sorting the Spreadsheet control.
Versions 23 and later
SpreadsheetGetSortInfo
New in version 23
SpreadsheetGetSortInfo
SpreadsheetGetSortInfo
psheetItalicAttribute to find or modify: Italic 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
psheetOverwriteAllowedMode for saving the file: If the XLSX file already exists and if it is not opened (in the Spreadsheet control or in another application), it is overwritten.SpreadsheetSave
Versions 23 and later
psheetSearchAnyWorksheet
New in version 23
psheetSearchAnyWorksheet
psheetSearchAnyWorksheet
Search option: Search in all worksheets of workbook. SpreadsheetSeek,
Versions 23 and later
SpreadsheetReplace
New in version 23
SpreadsheetReplace
SpreadsheetReplace
Versions 23 and later
psheetSearchContain
New in version 23
psheetSearchContain
psheetSearchContain
Search option: "Contains" search. SpreadsheetSeek,
Versions 23 and later
SpreadsheetReplace
New in version 23
SpreadsheetReplace
SpreadsheetReplace
Versions 23 and later
psheetSearchCurrentWorksheet
New in version 23
psheetSearchCurrentWorksheet
psheetSearchCurrentWorksheet
Search option: Search in the current worksheet. SpreadsheetSeek,
Versions 23 and later
SpreadsheetReplace
New in version 23
SpreadsheetReplace
SpreadsheetReplace
Versions 23 and later
psheetSearchExact
New in version 23
psheetSearchExact
psheetSearchExact
Search option: "Exact" search. SpreadsheetSeek,
Versions 23 and later
SpreadsheetReplace
New in version 23
SpreadsheetReplace
SpreadsheetReplace
Versions 23 and later
psheetSearchInFormula
New in version 23
psheetSearchInFormula
psheetSearchInFormula
Search option: Search in the formulas only. SpreadsheetSeek,
Versions 23 and later
SpreadsheetReplace
New in version 23
SpreadsheetReplace
SpreadsheetReplace
Versions 23 and later
psheetSearchNoCase
New in version 23
psheetSearchNoCase
psheetSearchNoCase
Search option: Search while ignoring the case. SpreadsheetSeek,
Versions 23 and later
SpreadsheetReplace
New in version 23
SpreadsheetReplace
SpreadsheetReplace
Versions 23 and later
psheetSearchWithCase
New in version 23
psheetSearchWithCase
psheetSearchWithCase
Search option: Search while taking the case into account. SpreadsheetSeek,
Versions 23 and later
SpreadsheetReplace
New in version 23
SpreadsheetReplace
SpreadsheetReplace
Versions 23 and later
psheetSelAll
New in version 23
psheetSelAll
psheetSelAll
Type of selection: The entire is selected. psheetSelection type
Versions 23 and later
psheetSelEmpty
New in version 23
psheetSelEmpty
psheetSelEmpty
Type of selection: No selection. psheetSelection type
Versions 23 and later
psheetSelMultiCell
New in version 23
psheetSelMultiCell
psheetSelMultiCell
Type of selection: Several cells are selected. psheetSelection type
Versions 23 and later
psheetSelMultiHeader
New in version 23
psheetSelMultiHeader
psheetSelMultiHeader
Type of selection: Several headers are selected. psheetSelection type
Versions 23 and later
psheetSelRectCell
New in version 23
psheetSelRectCell
psheetSelRectCell
Type of selection: Several cells are selected and they form a rectangle. psheetSelection type
Versions 23 and later
psheetSelSimpleCell
New in version 23
psheetSelSimpleCell
psheetSelSimpleCell
Type of selection: A single cell is selected. psheetSelection type
Versions 23 and later
psheetSelSimpleHeader
New in version 23
psheetSelSimpleHeader
psheetSelSimpleHeader
Type of selection: A single header is selected. psheetSelection type
Versions 23 and later
psheetSortInfoWithTitle
New in version 23
psheetSortInfoWithTitle
psheetSortInfoWithTitle
Requested information: Used to find out whether the selection sorted by the AAF (Automatic Application Feature) for sorting the Spreadsheet control contains a title
Versions 23 and later
SpreadsheetGetSortInfo
New in version 23
SpreadsheetGetSortInfo
SpreadsheetGetSortInfo
psheetStrikeOutAttribute to find or modify: Struck-out characterSpreadsheetStyleSelection
psheetTextColorAttribute to find or modify: Text colorSpreadsheetStyleSelection
psheetTopLeftThe display of Spreadsheet control is modified in order for the specified cell to be positioned in the top left corner of visible control area.SpreadsheetPosition
psheetUnderlinedAttribute to find or modify: Underlined characterSpreadsheetStyleSelection
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
Minimum required version
  • Version 20
Comments
Click [Add] to post a comment