Angular Spreadsheet Menu & Toolbar Tools
The Spreadsheet component provides a variety of built-in tools that help you create, edit, and style the sheet data. To access the built-in tools, use the menu that is located at the top of the Spreadsheet.
Main Menu
The Kendo UI for Angular Spreadsheet component has five menu items. Each menu item contains a set of tools that help users manage their data in the sheets:
- File—Contains tools for importing and exporting from and to
.xlsx
files. Read more about the Data Import and Export... - Home—Contains tools for formatting the Spreadsheet, such as changing the font, alignment, and borders of cells. Read more about the Home menu items...
- Insert—Contains tools for inserting and deleting rows, columns and links. Read more about the Insert menu items...
- Format—Contains tools for increasing and decreasing decimals. Read more about the Format menu items...
- Data—Contains tools for data validation. Read more about the Data menu items...
- View—Contains tools for merging cells and toggling the sheet grid lines. Read more about the View menu items...
To rearrange the order of the menu items or set the active menu item, set the menuItems
property to a SpreadsheetMainMenuItem
object.
The following example demonstrates how to rearrange the default order and set the File menu item as active.
Home Menu Item Tools
The Home menu item of the Spreadsheet contains a variety of built-in tools that help you to format and style the text in a variety of ways and make it more readable and visually appealing. You can use these tools to create a professional-looking Spreadsheet that is easy to read and understand. For example, you can make the header row stand out, highlight important data, or format cells by using predefined formats.
The following example demonstrates the built-in tools of the Home menu item in the Spreadsheet.
Insert Menu Item Tools
The Insert menu item is a useful tool for managing the rows and columns in a Spreadsheet component. You can easily insert or delete rows and columns in various directions.
The following example demonstrates the built-in tools of the Insert menu item of the Spreadsheet.
Format Menu Item Tools
The Format menu item contains tools for managing decimals.
The following example demonstrates the built-in tools of the Format menu item of the Spreadsheet.
Data Menu Item Tools
The Data menu item of the Spreadsheet provides powerful tools for applying data validation to cells or ranges of cells. This feature allows you to define rules for various data types, ensuring that the entered data meets specific criteria. Supported data types include:
Number
—Validate numeric ranges (e.g., between 1 and 100). To specify the criteria, provide the numeric value directly.Text
—Restrict input to specific text patterns or lengths. To specify the criteria, enclose the desired text in quotes. For example,"Correct value"
will validate the cell to accept only the exact textCorrect value
.Date
—Ensure dates fall within a defined range. Specify the criteria by providing valid start and/or end date values in the desired range. For example,DATEVALUE("1/1/1950")
toDATEVALUE("1/1/2025")
will validate the cell to accept only dates within this range.Custom Formulas
—Use formulas to create complex validation rules. For example, you can validate a phone number by using a formula likeAND(ISNUMBER(D6),LEN(D6)<14)
.List
—Simplify data entry by providing predefined options in a dropdown menu. To specify the criteria, provide a comma-separated list of allowed values (Value 1
,Value 2
).
When a rule is applied, and the entered data does not meet the criteria, a popup with a customizable error message appears. If the user ignores the message, the cell is marked as invalid, providing a visual cue for correction.
The following example demonstrates how to use the built-in validation tool to restrict the input to a specific values.
View Menu Item Tools
The View menu items allow you to merge and unmerge cells and toggle the sheet grid lines.
The following example demonstrates the built-in tools of the View menu item of the Spreadsheet.