ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE
This content has been translated automatically.  Click here  to view the French version.
Help / Developing an application or website / Controls, windows and pages / Controls: Available types / Spreadsheet control
  • Overview
  • "Home" tab
  • Performing a Find/Replace
  • "Insert" tab
  • Inserting an image
  • Inserting, browsing and viewing comments
  • "Formula" tab
  • Formula library
  • Using defined names
  • "Layout" tab
  • "View" tab
  • Encryption of xlsx files using a password
  • Protect the current worksheet
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Overview
The ribbon of the Spreadsheet control proposes several features and it allows you to define several settings.
"Home" tab
The "Home" tab allows you to perform the most common operations on a ".xlsx" file.
Ribbon of Spreadsheet control
This tab contains the following groups:
  • Document: Opens, creates, saves or prints ".xlsx" files.
    Options of the Document group
    It is possible to:
    • Create a new workbook.
    • Open an existing workbook. It is possible to:
      • open an xlsx or xlsm file.
      • open a workbook template ("xltx" and "xltm" files). In this case, a new workbook is automatically created using this template.
      • New in version 2025
        open a CSV file.
    • Save (or save as) a workbook.
      xlsx, xlsm, xltx, xltm and csv formats are supported.
    • Print a workbook. The current worksheet is previewed.
  • Clipboard Allows you to manage the clipboard (copy/paste).
    Options of the Clipboard group
  • Font Font: Allows you to manage the font of the current text.
    Options of the Font group
    It is possible to:
    • manage the font name and size.
    • manage font formatting characteristics: Bold, Italic, Underline, Strikethrough, Exponent, Hint.
    • manage font color: text color and highlight color.
    • manage the cell borders.
    • manage the background color of cell.
  • Alignment Allows you to manage the alignment of different elements:
    Options of the Alignment group
    • : Used to manage the vertical alignment of text in the cell.
    • : Used to manage the text rotation in the cell.
    • Automatic line break: manages the line break when the text exceeds the width specified for the cell.
    • : Used to manage the horizontal alignment of text in the cell.
    • Merge and center: Allows you to merge cells and center the result of the merge..
  • Number: Used to manage selection characteristics:
    Options of the Number group
    • Style to be applied: standard, short date, monetary, time, etc.
    • display the currency unit,
    • display a percentage,
    • use the thousand separator,
    • add or remove a decimal.
  • Styles format as table a range of cells.
  • Cells: Insert, delete or erase cells.
    It is possible to:
    • insert cells, rows, columns or worksheets.
    • delete cells, rows, columns or worksheets.
    • erase everything, the formatting only or the content only.
  • Edition: Searches, replaces and sorts data.

Performing a Find/Replace

To search in a spreadsheet:
  1. On the "Home" tab, in the "Editing" group, click "Find" (or press Ctrl + F).
  2. In the window that is displayed, specify:
    • the word, phrase or value to be found,
    • search options: case-sensitive, in all sheets, in formulas.
  3. Start the search:
    • When you click "Find", the occurrences are highlighted and the first occurrence is selected.
      The "Next" button highlights the next element that matches the search.
    • When you click "Find all", the list of cells that match the search is displayed.
      When you select one of the occurrences in the search window, it is also selected in the worksheet.
To find and replace text in a document:
  1. On the "Home" tab, in the "Editing" group, click "Replace" (or press Ctrl + H).
  2. In the window that is displayed, specify:
    • the word, phrase or value to be found,
    • search options: case-sensitive, in all sheets, in formulas.
    • the new text.
  3. Start the search.
    • When you click "Find", the different occurrences are selected and the first occurrence is highlighted. The "Next" button highlights the next element that matches the search.
    • When you click "Find all", the list of cells that match the search is displayed.
  4. Choose "Replace" to replace only the selected occurrence.
  5. Choose "Replace all" to replace all the occurrences.
"Insert" tab
The "Insert" tab allows you to:
  • insert an image.
  • manage comments.

Inserting an image

To insert an image:
  1. Select a cell.
  2. On the "Insert" tab, in the "Content" group, click "Image".
  3. Select the desired image file and validate.
  4. The image is inserted at the cursor position. It can be selected to be moved or enlarged using the selection handles.
A context menu is available on the selected image. This context menu offers options specific to the selected image:
  • Image Z-order management (moving to the foreground or background).
  • Image change (from a file or image in the clipboard).
  • Image editing, using the image editor. A toolbar with the main features of the image editor appears above the image. It is also possible to open the image in the full image editor.

Inserting, browsing and viewing comments

In an excel sheet, you can associate a comment to each cell. This comment is a simple text displayed as a "tooltip".
A small red triangle in the upper-right corner of the cell lets the user know that a comment is associated with the cell. When the user clicks or hovers over the cell, the comment will be displayed as a tooltip.
Note: The Spreadsheet control only handles "simple" comments (also called "Notes" in some versions of Excel)..
To add a comment:
  1. Select a cell.
  2. On the "Insert" tab, in the "Comments" group, click "New comment".
  3. Enter the text of your comment in the area that appears. You can also resize and reposition the comment display area.
  4. To validate the comment, click another area of the spreadsheet.
Note: You can also add a comment via a cell's context menu (right-click), option "Add comment".
To edit a comment:
  1. Select a cell associated with a comment (with a small red triangle).
  2. On the "Insert" tab, in the "Comments" group, click "Edit comment".
  3. The comment is displayed. You can change the text, size and position of the comment.
  4. To validate the changes, click another area of the spreadsheet.
Note: It is also possible to modify a cell's comment, via the cell's context menu (right-click), option "Modify comment".
To browse through comments:
  1. Edit a comment:
    • Select a cell associated with a comment (with a small red triangle).
    • On the "Insert" tab, in the "Comments" group, click "Edit comment".
  2. Click:
    • "Previous comment", to display the previous comment in edit mode.
    • "Next comment", to display the next comment in edit mode.
To delete a comment:
  1. Select a cell associated with a comment (with a small red triangle).
  2. On the "Insert" tab, in the "Comments" group, click "Delete".
  3. The comment is deleted.
Note: It is also possible to delete a cell's comment, via a cell's context menu (right-click), option "Delete comment".
To show all the comments:
  1. On the "Insert" tab, in the "Comments" group, click "Show comments".
  2. All comments in the current worksheet are displayed.
To hide them, click "Show comments" again.
Note: It is also possible to hide or show a cell's comment, via a cell's context menu (right-click), option "Show/Hide comment".
"Formula" tab
The "Formulas" tab allows you to access all available calculations and formulas. This pane can also be used to manage the naming of cells.
This tab contains the following groups:
  • Library: This group contains formula libraries, grouped by theme.
  • Defined names: This group is used to manage the names given to different cells..

Formula library

The Spreadsheet control offers many formulas that can be used in the cells of a Spreadsheet control.
To use the "Automatic sum" option, simply:
  • Select the range of cells to be added.
  • Click on the "Automatic sum" option: the sum is automatically calculated in the last empty cell of the selection..
To use one of the library formulas, simply:
  • Position yourself on an empty cell.
  • Click on the desired library to view the different formulas available.
  • Select the formula to use. The formula appears in the cell and the formula bar.
  • Complete the formula by clicking on the cells that must be taken into account.

Using defined names

The Spreadsheet control allows you to define names for the cells. It is thus possible to use these named cells in the formulas (instead of the traditional identification of the cells).
To name a cell:
  1. Select cell.
  2. Click "Define a name".
  3. In the window that is displayed, specify:
    • The name of the cell.
    • The scope of the name, i.e. in which elements this name can be used (sheet or workbook).
    • The cell description.
  4. Validate.
The name manager allows you to see all the named cells of the current xlsx file. to use the name manager:
  1. Click "Name manager".
  2. The window that appears shows the different named cells of the current document with their characteristics.
    It is possible to:
    • Create a named cell.
    • Modify a named cell.
    • Delete a named cell.
"Layout" tab
The "Layout" tab allows you to set the layout of the xlsx file displayed in the Spreadsheet control. This layout is used especially when printing the file.
This tab contains the following groups:
  • "Layout": manages the layout of the xlsx file.
  • "Sheet options": manage layout options for the current sheet:
    • Display and print the grid (or not).
    • Display and print the headers (or not).
The options in the "Layout" group allow you to:
  • Know the page format and customize it if necessary ( "Margins" option):
  • Modify the page orientation. The "Orientation" option allows you to switch from Portrait to Landscape mode.
  • Configure scaling.
"View" tab
The "Display" tab contains the display options of the xlsx file in the Spreadsheet control.
This tab contains the following groups:
  • Display: formula bar, header and gridlines management.
  • Zoom: zoom management for displaying the xlsx file in the Spreadsheet control field.
  • Freeze panes: manage a display with panes (useful for xlsx files displaying a large amount of data).
  • Encryption: manage file protection/encryption options.

Encryption of xlsx files using a password

It is possible to encrypt an xlsx file with a password.
To encrypt an xlsx file using a password:
  1. Click "Password".
  2. In the window that appears, enter and confirm the password.
  3. Validate. The password will be used the next time the file is saved.
Note: When the xlsx file is opened, the password is automatically requested before it is displayed..

Protect the current worksheet

You can prevent users from making changes to worksheet of an xlsx file with a password.
To protect the current worksheet of the xlsx file with a password:
  1. Click "Protect worksheet".
  2. In the window that appears, enter and confirm the password.
  3. Validate. The worksheet is protected.
To unprotect the current worksheet in an xlsx file:
  1. Click "Unprotect worksheet".
  2. In the window that appears, enter the protection password.
  3. Validate. The worksheet can be modified.
See also
Minimum version required
  • Version 23
Comments
Click [Add] to post a comment

Last update: 11/01/2024

Send a report | Local help