In This Topic
FlexSheet offers many advanced features beyond simple data management. These features are listed below:
- Built-in Formula Support
Work with nearly 100 built-in formulas supported by FlexSheet's calculation engine, together with the advantage of auto-completion. Our formula operations are aligned with Microsoft Excel, including the operations for aggregation, mathematics, logic and text.
- Multiple Sheets
Add multiple separated worksheets to your application, which are represented by tabs that flip between pages.
- Cell Style
Customize your FlexSheet cells by applying styles to each cell. You can easily set desired data format, font, horizontal alignment, fore color, fill color, etc. to the cells in FlexSheet.
- Merge Cells
Easily merge two or more adjacent cells of your FlexSheet control. The merged cells will contain data from upper-left most cell only. FlexSheet enables you to merge any group of adjacent cells, unlike FlexGrid which allows content-driven merging only.
- Undo/Redo
Undo/redo multiple operations of editing cells, inserting/removing rows or columns, applying cell styles, merging cells, resizing rows/columns, dragging and dropping rows/columns, etc.
- Drag and Drop
Drag and drop rows/columns to move or copy current rows/columns to another rows/columns.
- Column Selection
Select an entire column by simply clicking the column header.
- Fill Data Automatically
Fill cells automatically with data, that follows a pattern, by dragging the bottom right corner of the cell.