Windows Forms - Spreadsheet

Built on top of our existing Excel Framework, the spreadsheet provides an interactive control to our powerful Excel document capabilities. Advanced editing, cell formatting, and conditional formatting features are included, without the need for Excel to be installed on the user's machine.

The Windows Forms spreadsheet renders charts in a worksheet and includes support for over 36 chart types, including area, column stacked, bubble, scattered, bar stacked, and many more. When the dataset for the chart changes, the chart will update to reflect any changes in the values.

Table and worksheet-level sorting and filtering capabilities let you define and sort or filter an area by text, number, date, or color within a worksheet or outside a table. 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.

Updated list data validation capabilities include a dropdown button that displays a list of values for validation.

Select an active cell and display a drop-down of the text/string values immediately above and below it.

Improved controls 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.

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.