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
Spreadsheet functions
The following functions are used to handle the Spreadsheet control:
SpreadsheetAddDataAdds a data into a Spreadsheet control found in a window.
SpreadsheetAddFormulaAdds a calculation formula into a Spreadsheet control found in a window.
Versions 23 and later
SpreadsheetAddImage
New in version 23
SpreadsheetAddImage
SpreadsheetAddImage
Adds an image into the current worksheet of a Spreadsheet control.
SpreadsheetAddNameSpecifies a name to identify a cell found in a Spreadsheet control.
SpreadsheetAddWorksheetAdds a worksheet into a Spreadsheet control found in a window.
SpreadsheetAllowProcedureAllows the use of a WLanguage function/procedure in a formula of a Spreadsheet control.
SpreadsheetBorderSelectionModifies the border of selected cells in a Spreadsheet control found in a window.
SpreadsheetCloseCloses the XLXS document that was opened by SpreadsheetLoad.
SpreadsheetControlFormulaAllows you to use a control in order to create a custom formula bar for the Spreadsheet control.
SpreadsheetDeleteAllDeletes the entire data from a Spreadsheet control found in a window (cells, formulas, size and header layouts).
SpreadsheetDeleteColumnDeletes a column from a Spreadsheet control
Versions 23 and later
SpreadsheetDeleteImage
New in version 23
SpreadsheetDeleteImage
SpreadsheetDeleteImage
Deletes an image from the current worksheet in a Spreadsheet control.
SpreadsheetDeleteLineDeletes a row from a Spreadsheet control.
Versions 23 and later
SpreadsheetDeleteName
New in version 23
SpreadsheetDeleteName
SpreadsheetDeleteName
Deletes one of the names used to identify a cell found in a Spreadsheet control.
SpreadsheetDeleteWorksheetDeletes a worksheet from a Spreadsheet control found in a window.
Versions 23 and later
SpreadsheetEndModification
SpreadsheetEndModification
Signals the end of grouping for a set of operations on a Spreadsheet control in a single event (management of "undo/redo").
SpreadsheetFreezeUsed to freeze the display of a row or column in a Spreadsheet control.
SpreadsheetGetFormulaRetrieves the calculation formula of a cell found in a Spreadsheet control of a window.
SpreadsheetGetMergeUsed to find out whether a cell is merged with other cells and to get the name of merged cells.
SpreadsheetGetSelectionRetrieves the list of cells selected in a Spreadsheet control found in a window.
Versions 23 and later
SpreadsheetGetSortInfo
New in version 23
SpreadsheetGetSortInfo
SpreadsheetGetSortInfo
Returns various information about the sort performed in a Spreadsheet control.
Versions 23 and later
SpreadsheetInputFunction
New in version 23
SpreadsheetInputFunction
SpreadsheetInputFunction
Inserts a function name at cursor position in the editable cell of a Spreadsheet control found in a window.
SpreadsheetInsertColumnInserts an empty column into a Spreadsheet control found in a window.
SpreadsheetInsertRowInserts an empty row into a Spreadsheet control found in a window.
SpreadsheetInsertWorksheetInserts a worksheet into a Spreadsheet control found in a window.
Versions 23 and later
SpreadsheetListImage
New in version 23
SpreadsheetListImage
SpreadsheetListImage
Lists the images found in the current worksheet of a Spreadsheet control.
Versions 23 and later
SpreadsheetListName
New in version 23
SpreadsheetListName
SpreadsheetListName
Returns the list of names that identify a cell in a Spreadsheet control.
Versions 23 and later
SpreadsheetListWorksheet
New in version 23
SpreadsheetListWorksheet
SpreadsheetListWorksheet
Returns the list of worksheets found in a Spreadsheet control.
SpreadsheetLoadLoads a file in XLSX format in a Spreadsheet control found in a window.
Versions 23 and later
SpreadsheetModifyName
New in version 23
SpreadsheetModifyName
SpreadsheetModifyName
Modifies the name used to identify a cell in a Spreadsheet control.
SpreadsheetPositionDisplays the specified cell in a Spreadsheet control found in a window:
  • either the visible area of the Spreadsheet control is moved to display the cell.
  • or the cell is displayed in the top left corner of the visible area of the Spreadsheet control.
SpreadsheetRecalculateAllRecalculates all the formulas of a Spreadsheet control found in a window (including the formulas that use WLanguage functions/procedures).
Versions 23 and later
SpreadsheetReplace
New in version 23
SpreadsheetReplace
SpreadsheetReplace
Finds and replaces a value in a Spreadsheet control.
SpreadsheetRestorePositionAndSelectionRestores:
  • the position of scrollbar in a Spreadsheet control,
  • the current worksheet,
  • the elements selected in the current worksheet of Spreadsheet control.
These elements have been saved by SpreadsheetSavePositionAndSelection.
SpreadsheetSaveSaves the content of a Spreadsheet control in a file in XLSX format.
SpreadsheetSavePositionAndSelectionSaves:
  • the position of scrollbar in a Spreadsheet control for the current worksheet,
  • the current worksheet in the Spreadsheet control,
  • the elements selected in the Spreadsheet control for the current worksheet.
SpreadsheetSeekSeeks a value in the cells of a Spreadsheet control found in a window.
SpreadsheetSelectMinusDeselects one or more cells in a Spreadsheet control found in a window.
SpreadsheetSelectPlusSelects one or more cells in a Spreadsheet control found in a window.
SpreadsheetSelectWorksheetSelects a worksheet (identified by its name) in a Spreadsheet control.
Versions 23 and later
SpreadsheetSortSelection
New in version 23
SpreadsheetSortSelection
SpreadsheetSortSelection
Sorts the values selected in a Spreadsheet control.
Versions 23 and later
SpreadsheetStartModification
SpreadsheetStartModification
Signals the start of grouping for a set of operations on a Spreadsheet control in a single event (management of "undo/redo").
SpreadsheetStyleSelectionReturns or modifies the style of selected cells in a Spreadsheet control found in a window.
SpreadsheetTypeAndMaskSelectionReturns or modifies the type and mask of the cells selected in a Spreadsheet control.
Other functions can also be used to handle the coordinates of a cell:
Versions 20 and later
xlsCoordinatesToName
New in version 20
xlsCoordinatesToName
xlsCoordinatesToName
Retrieves the name of a cell, XLS worksheet or Spreadsheet control according to its coordinates.
Versions 20 and later
xlsNameToCoordinates
New in version 20
xlsNameToCoordinates
xlsNameToCoordinates
Returns the coordinates of a cell, XLS file or spreadsheet control according to its name.
Related Examples:
The Spreadsheet control Unit examples (WINDEV): The Spreadsheet control
[ + ] Using the Spreadsheet control.
This example explains how to:
- load an xlsx file in a spreadsheet control,
- save the spreadsheet in a file,
- fill the control with data coming from the database,
- insert rows, columns,
- access the cells and handle them (modify their value, their style, ...),
- enter formulas,
- ...
Minimum required version
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment