Handsontable Features

• Accessibility - Be able to use screen readers and navigate between cells.
• Alignment - Decide where the content is placed within the cell or a range of cells.
• Autocomplete - Choose one of the suggested options while typing or entering a custom value.
• Binding rows with headers - Bind rows with headers to lock the row number and always display one beside the other.
• Checkbox - Add a checkbox to a cell to indicate binary choices.
• Collapsing columns - Expand and collapse columns to better fit the content.
• Column summary - Make pre-defined calculations and display the results in Handsontable.
• Comments - Provide an additional note about the cell to help better understand its content.
• Conditional formatting - Define how specific cells are formatted depending on their values.
• Context menu - Invoke a shortcut menu to choose an action related to the selected object.
• Copying - copy data with and without headers.
• Custom borders - Apply custom border style around cells or range of cells.
• Custom buttons- Insert and remove column or row using custom action buttons.
• Custom Cell Types - Use Handsontable itself as a custom cell editor.
• Custom HTML - Display HTML content in a cell or header.
• Data validation - Control what values can be entered into a cell.
• Date - Use a date picker to select a date.
• Dialog/Loading - Display modal dialogs, alerts, and loading indicators.
• Disable cell editing - Make cell non-editable or enable read-only mode.
• Drag-down - Drag the fill handle (a square in the bottom right corner of the cell) to fill cells with data series.
• Dropdown - Create an advanced dropdown list of choices in a cell.
• Dropdown menu - Add a menu to the heading to enable additional operations for the columns.
• Export to file - Export data to a flat file like CSV or a string.
• Filtering - Display rows that meet your criteria and hide the rest.
• Fixed rows and columns - Define which rows or columns are visible while scrolling down or across the table.
• Formulas - perform extensive calculation capabilities based on formulas using the spreadsheet notation.
• Freezing - Create freeze columns to keep them visible while scrolling.
• Hiding columns - Hide specific columns and show the rest.
• Hiding rows - Hide specific rows and show the rest.
• Highlighting current - Indicate the entire active column or row.
• Internationalization - Change the text of the UI for the purpose of translating it to specific languages.
• Merge cells - Display cells across multiple rows or columns.
• Moving - Drag rows or columns to swap them within the table.
• Navigable headers - Use keyboard navigation to navigate between table elements and execute operations.
• Navigation - navigate between cells and headers
• Nested headers - Create a nested, hierarchical structure of headers to get your data into groups.
• Numeric - Type a custom number format in a cell.
• Pagination - Limit the number of records being displayed in a single view with a panel to adjust page size and ease to navigate between the pages
• Password - Use asterisks to mask the value in a cell.
• Pre-populating new rows - Create empty cells with predefined types or values
• Read-only - Lock the cell or a range of cells to disallow altering them.
• Resizing - Drag the sizing handle to change the size of column or row.
• RTL Support - Support RTL mode for the whole table.
• Scrolling - Use native scrollbars to navigate within the table.
• Search for values - Search through the content with the search field.
• Select - Create a simple dropdown list of choices in a cell.
• Selection - select and deselect multiple cells
• Sorting/multi column sorting - Sort data in ascending or descending order throughout the column or multiple columns.
• Stretching - Allow columns to the parent container width.
• Themes - use predefined themes with light and dark mode or use our tools to create a new theme
• Trimming rows - Exclude specific rows from the rendering process so they won't be displayed.