ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / Automatic Application Features (AAF)
  • Overview
  • Context menu of Spreadsheet control
  • Overview
  • Settings
  • Toolbar and formula bar
  • Toolbar
  • Formula bar
  • Entering values and formulas
  • Manage cells
  • Managing worksheets
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Automatic Application Features (AAF) of Spreadsheet controls
Overview
The Spreadsheet control multiple several Automatic Application Features (AAF) in order to simplify the use of the control.
The main AAFs affect:
Context menu of Spreadsheet control

Overview

Each Spreadsheet control in a window offers the user a menu by default.
This menu, available without programming, includes several actions:
  • Cancel/Restore the last action.
  • Cut / Copy / Paste: These options can be applied to a cell, a column, a row or a selection of cells..
  • Undo zoom: This option cancels the zoom performed, for example, with Ctrl + Mouse wheel..
  • Insert: This option inserts a row or column..
  • Delete: This option deletes the contents of a cell, row or column.. Warning: all content is immediately deleted (value, formula, etc.)..
  • Save as: This option saves the contents of the Spreadsheet control in a new xlsx file..
Note: It is possible to add choices to this menu by programming. To do so, use the ContextMenu property.

Settings

The context menu of Spreadsheet control can be disabled. To configure the display of context menu associated with the Spreadsheet control, you must:
  1. Open the Spreadsheet control description window.
  2. Select the "UI" tab.
  3. Choose the desired menu in the "Context menu" combo box. It is possible to:
    • "Display the AAF menu (System)": In this case, the context menu displayed will be the Spreadsheet control's automation menu.. For more details on how to configure this menu, see Configuring the AAF menu.
    • "Add a context menu": If this option is checked, you can select the custom context menu to be displayed..
Remarks:
  • If both options are checked, the custom context menu can be added before or after the AAF menu.
  • If no option is selected, no context menu will be selected. The <Disabled> option will be displayed in the description window.
  • The ContextMenu property is also used to remove the AAF-specific context menu and restore the standard Windows menu for a given control.
  • Some specific options can be disabled by AAFDisable.
Toolbar and formula bar
The Spreadsheet control includes a toolbar and a formula bar.

Toolbar

The toolbar allows the end user to perform the most common formatting operations:
  • Cancel/Restore
  • Font name
  • Font size
  • Zoom of the selection
  • Cell formatting: Bold, Italic, Underline, Strikethrough
  • Border and color of the border
  • Background color
  • Text color
  • Text alignment: Left-aligned, Centered, Right-aligned
  • Merge of cells
  • Cell format
You can:

Formula bar

The formula bar allows the end user to identify the selected cells and to enter the formula or the value associated with a cell.
Two buttons are used to validate or cancel the input.
You can:
Note: A formula begins with '='.. When typing the '=' sign, all the available functions are displayed in the formula. To use a function, all you have to do is select it.
Entering values and formulas
The input of values and formulas is performed:
  • in the cell directly.
  • in the formula bar of current cell if this one is visible.
Note: If the Spreadsheet control allows values to be entered, the end user will be able to add, modify or delete values in the cells.. The end user can also add rows and columns. To allow the input of values:
  • in the editor: "Allow value entry" option in the "Detail" tab of the field description.
  • by programming: property InputValue.
A formula always starts with '='. A formula can include:
  • a function,
  • one or more cells coming from the current worksheet or from another worksheet. To reference a cell in a calculation, simply click on the desired cell: the cell name is displayed in the formula bar..
Manage cells
The Spreadsheet control allows you to:
  • Select a cell.
  • Select a range of cells.
  • Select several cells.
The different toolbar options can be applied to these cells.
You also have the ability to:
  • create formulas containing different cells.
  • copy cells. For example:
    • Select a cell containing a value or a formula.
    • Select the copy handle (square at the bottom of the selection) and move it: the initial value is copied to the selected cells.
  • perform an incremental copy of a group of cells. For example:
    • Select two vertical cells containing two values of a series ("1" and "2" for example).
    • Select the copy handle (square at the bottom of the selection) and move it downwards: the various values in the selected cells are updated.
Special case: Cells containing links:
If a cell contains a link:
  • a simple click opens the link,
  • a long click selects the cell.
Managing worksheets
The Spreadsheet control can be multi-worksheet and manage the different worksheets of an xlsx file.
In this case:
  • The different worksheets are displayed at the bottom left of Spreadsheet control.
    The "+" button is used to add new worksheets.
  • A context menu allows end users to manage the different worksheets:
    It is possible to:
    • Insert a worksheet.
    • Delete the current worksheet.
    • Rename the current worksheet.
    • Protect the current worksheet.
    Note: The options in this menu can be configured in the same way as the Spreadsheet control context menu..
Tip: If several worksheets are displayed, you can use the arrow buttons to dequeue the various tabs corresponding to the sheets..
  • To display the tab of first worksheet, press Ctrl + click on the left arrow.
  • To display the tab of last worksheet, press Ctrl + click on the right arrow.
Minimum version required
  • Version 20
Comments
Click [Add] to post a comment

Last update: 09/30/2024

Send a report | Local help