PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • "Home" pane
  • Performing a Find/Replace
  • "Insertion" pane
  • Inserting an image
  • Encryption of xlsx files using a password
  • "Formula" pane
  • Formula library
  • Using defined names
  • "Layout" pane
  • "Display" pane
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
Overview
The ribbon of the Spreadsheet control proposes several features and it allows you to define several settings.
"Home" pane
The "Home" pane allows you to perform the most common operations on a ".xlsx" file.
This pane proposes the following groups:
  • Document: Used to open, create, save or print a ".xlsx" file.
    You can:
    • Create a new workbook.
    • Open an existing workbook.
    • Save (or save as) a workbook.
    • Print a workbook. The current worksheet is previewed.
  • Clipboard: Used to manage the clipboard (copy/paste).
  • Font: Used to manage the font of current text.
    You can:
    • manage the font name and size.
    • manage the formatting characteristics of font: Bold, Italic, Underlined, Strikeout, Superscript, Subscript.
    • manage the font color: text color and highlighting color.
    • manage the cell borders.
    • manage the background color of cell.
  • Alignment: Used to manage the alignment of different elements:
    • : Used to manage the vertical alignment of text in the cell.
    • : Used to manage the text rotation in the cell.
    • Automatic line wrap: used to manage the line wrap when the text exceeds the width specified for the cell.
    • : Used to manage the horizontal alignment of text in the cell.
    • Merge and center: Used to merge cells and to center the merge result.
  • Number: Used to manage the selection characteristics:
    • Style to apply: standard, short date, currency, time, ...
    • display the currency unit,
    • display a percentage,
    • use the thousand separator,
    • add or remove a decimal.
  • Styles: Used to display a range of cells in array format.
  • Cells: Used to insert, delete or erase cells.
    You can:
    • insert cells, rows, columns or worksheets.
    • delete cells, rows, columns or worksheets.
    • erase everything, the formatting only or the content only.
  • Edit: Used to perform searches and replacements, and to sort data.

Performing a Find/Replace

To perform a search in a workbook:
  1. On the "Home" pane, in the "Edit" group, click "Find" (or press Ctrl + F).
  2. In the window that is displayed, specify:
    • the sought word, value or expression,
    • the search options: sensitivity to the case, in all the worksheets, in the formulas.
  3. Validate the search:
    • When clicking "Find", the corresponding elements are highlighted and the first one is selected.
      The "Next" button is used to highlight the next element corresponding to the search.
    • When clicking "Find all", the list of cells corresponding to the search is displayed.
      Selecting a result in the search window is used to select this result in the worksheet.
To perform a search with replacement in a document:
  1. On the "Home" pane, in the "Edit" group, click "Replace" (or press Ctrl + H).
  2. In the window that is displayed, specify:
    • the sought word, value or expression,
    • the search options: sensitivity to the case, in all the worksheets, in the formulas.
    • the replacement text.
  3. Validate the search.
    • When clicking "Find", the corresponding elements are selected and the first one is highlighted. The "Next" button is used to highlight the next element corresponding to the search.
    • When clicking "Find all", the list of cells corresponding to the search is displayed.
  4. The "Replace" button is used to perform the replacement in the selected result.
  5. The "Replace all" button is used to replace all the results found.
"Insertion" pane
The "Insertion" pane allows you to:
  • insert an image.
  • encrypt a file.
Versions 23 and later

Inserting an image

To insert an image:
  1. Select a cell.
  2. On the "Insertion" pane, 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 popup menu is available on the selected image. This popup 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.
New in version 23

Inserting an image

To insert an image:
  1. Select a cell.
  2. On the "Insertion" pane, 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 popup menu is available on the selected image. This popup 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 an image

To insert an image:
  1. Select a cell.
  2. On the "Insertion" pane, 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 popup menu is available on the selected image. This popup 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.
Versions 24 and later

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 the password and confirm it.
  3. Validate. The password will be used the next time the file is saved.
Note: When opening the xlsx file, the password will be automatically requested before the file displayed.
New in version 24

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 the password and confirm it.
  3. Validate. The password will be used the next time the file is saved.
Note: When opening the xlsx file, the password will be automatically requested before the file displayed.

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 the password and confirm it.
  3. Validate. The password will be used the next time the file is saved.
Note: When opening the xlsx file, the password will be automatically requested before the file displayed.
"Formula" pane
The "Formula" pane is used to access al available calculations and calculation formulas. This pane can also be used to mange the naming of cells.
This pane proposes the following groups:
  • Library: This group proposes libraries of formulas, grouped by theme.
  • Defined names: This group allows you to manage the names given to the 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 "Automatic sum": 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 the 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.
    You can:
    • Create a named cell.
    • Modify a named cell.
    • Delete a named cell.
"Layout" pane
The "Layout" pane allows you to manage the layout of the xlsx file displayed in the Spreadsheet control. This layout is used especially when printing the file.
This pane proposes the following groups:
  • "Layout": xlsx file layout management.
  • "Worksheet options": management of current sheet layout options:
    • 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.
"Display" pane
The "Display" pane provides options for displaying the xlsx file in the Spreadsheet control
This pane contains the following groups:
  • Display: management of the formula bar, headers and grid.
  • Zoom: zoom management to display the xlsx file in the Spreadsheet control.
  • Freeze the panes: management of a display with panes (useful for xlsx files displaying a large amount of data).
Minimum required version
  • Version 23
Comments
Click [Add] to post a comment