In addition to providing full functionality of the FlexGrid control, C1FlexSheet provides many more features. Make the most of FlexSheet for WPF by taking advantage of the following key features:

View and Edit Excel Files

FlexSheet for WPF allows you to import, edit, and export the Microsoft Excel files (.xls, .xlsx). FlexSheet manages multiple worksheets with an Excel-like tabbed interface. You can switch between sheets, edit the content directly on a sheet, and update the content via code.

Manage Multiple Sheets Tabbed UI

FlexSheet for WPF provides the ability to manage multiple sheets in a single tabbed User Interface (UI). Users can select, add, remove, move, and rename the sheets, and also perform the same actions from code.

Insert Charts, Images, Sparklines and Comments

FlexSheet for WPF offers the ability to add comments and insert floating objects such as charts, sparklines and images to your worksheets.

Formula Support

FlexSheet for WPF is equipped with a powerful formula engine to analyze and evaluate Excel-style formulas. Several built-in functions are supported such as Aggregate, Statistics, and Trigonometric functions, and references to other sheet/cell values can also be included. When the entered text starts with "=", it will be recognized as a formula. The formula is analyzed by FlexSheet, and the result of the formula will be displayed in the cell.

Styles and Formatting

FlexSheet for WPF provides the ability to customize cell styles including font, color, size, and borders. You can specify the display format, such as numbers, currency, percentage and date. Easily apply styles and formatting to the whole sheet including rows, columns, cell and cell range, to customize your app's appearance.

Manage Worksheets

Easily manipulate sheets contained in a workbook - create new sheets, delete sheets, show/hide sheets, and change the tab order. Also, you can add, delete, and fix the rows/columns in a sheet, and show/hide header and grid lines.