Key Features

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.