New to Kendo UI for AngularStart a free 30-day trial

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.

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.

Change Theme
Theme
Loading ...

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.

Change Theme
Theme
Loading ...

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.

Change Theme
Theme
Loading ...

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.

Change Theme
Theme
Loading ...

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 text Correct 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") to DATEVALUE("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 like AND(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.

Change Theme
Theme
Loading ...

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.

Change Theme
Theme
Loading ...