Ignite UI Spreadsheet
The most powerful feature of any spreadsheet is the ability to create formulas based on the spreadsheets data. The Spreadsheet component includes a formula bar that allows users to see formula definitions. The Spreadsheet component supports custom formulas and provides dozens of built-in functions, including simple formulas such as SUM, MEAN, and MEDIAN, in addition to more complex formulas such as GEOMEAN and HARMEAN. The Formula Bar is also resizable, making it easier to see long or complex formulas.
The Spreadsheet component provides many options to manage how users work with and consume the data presented to them. You can programmatically hide the gridlines, headings, and the formula bar. The spreadsheet also supports zooming and text formatting (bold, italics, underline). These features work in real-time, so your users can change these settings on the fly. Users can also split the spreadsheet into scrollable panes and freeze the first column or row.View Sample
Import and Save Data to Excel
Excel Editing and Formatting
The igSpreadsheet is built on top of our existing Excel framework and provides an interactive control to our powerful Excel document capabilities. Editing and cell formatting features include conditional formatting, and sorting and filtering, all without requiring Excel to be installed.
Worksheet Sorting and Filtering
Table and worksheet-level sorting and filtering capabilities let you define and sort or filter an area by text, number, date, or color formatting within a worksheet or outside a table. Choose from a list of filters or create specific filters to customize your view. With the Custom Sort Dialog, Top 10 Filter Dialog, and Format Cells Dialog, you can secondary sort, sort by the top ten (or bottom ten) records, and adjust the way a spreadsheet displays data in a cell. You can also choose from a list of filters or create customized ones.
Table Creation and Management
Improved features let you copy and paste entire tables, expand and edit tables, navigate between rows, choose common formulas, and use the context menu to add rows, columns, and data to a table.
Render all the conditional formatting features available in Microsoft Excel, including presets for data bars, color scales with two- or three-color gradients, and icons.
Format Cells Dialog
Right-click on a cell to use the Format Cells dialog box to format cell data. Modify number display, alignment, font, shading and borders, and protection of your worksheet data.