# Key Features

Learn about the powerful features of Spread Windows Forms in this comprehensive guide

## Content

Spread Windows Forms introduces some powerful features which are described in the following table.

| **Area** | **Overview** | **Reference** |
| ---- | -------- | --------- |
| Designer | Visually design components and create prototype | [Spread Designer Guide](/spreadnet/docs/latest/online-win/overview/spwin-designerguide) |
| @rows=2:Spreadsheet Objects | Status Bar | [Adding a Status Bar](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssojbects/spwin-statusbar) |
| Create multiple viewports (pane) | [Customizing Viewports](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssojbects/spwin-sheetviewports) |
| @rows=7:Sheet | Use multiple sheets | [Working with Multiple Sheets](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-sheetmulti) |
| Change sheet name tab | [Customizing the Sheet Name Tabs](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-appearsheetnames) |
| Add a title and subtitle | [Adding a Title and Subtitle to a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-sheettitle) |
| Customize the top left cell | [Customizing the Sheet Corner Appearance](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-header/spwin-sheetcorner) |
| Set a style using skin | [Customizing the Overall Component Appearance](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-appearcontrol) |
| Add a footer to the bottom of sheet | [Displaying a Footer for Columns or Groups](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-columnfooter) |
| Add a table | [Tables](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-tables) |
| @rows=8:Row and Column | Change background color of odd row only | [Creating Alternating Rows](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-rowcolalt) |
| Display multiple columns and rows in header | [Creating a Header with Multiple Rows or Columns](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-header/spwin-headermulti) |
| Specify a non-scrollable area | [Setting Fixed (Frozen) Rows or Columns](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-rowcol-freeze) |
| Display grouped data | [Managing Grouping of Rows of User Data](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interact-rowcol/spwin-grouping) |
| Filtering the data | [Managing Filtering of Rows of User Data](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interact-rowcol/spwin-filtering) |
| Display supplement information in a row | [Setting up Preview Rows](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-previewrow) |
| Sort data in ascending or descending order | [Managing Sorting of Rows of User Data](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interact-rowcol/spwin-sorting) |
| Create a row range or column range that can be expanded and collapsed | [Managing Outlines (Range Groups) of Rows and Columns](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interact-rowcol/spwin-outline) |
| @cols=1:@rows=6:Cell | Change display character of column header cell |  |
| Use a cell type that matches the format or data type | [Cell Types](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setcelltypes) |
| Search for a specific cell | [Customizing User Searching of Data](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interact-rowcol/spwin-datasearch) |
| Merge multiple cells | [Creating a Span of Cells](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cellspan) |
| Display string in cell's tooltip | [Adding a Note to a Cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cell-note) |
| Determine cell format according to the result of conditional operation | [Using Conditional Formatting of Cells](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-interact-condition) |
| @cols=1:@rows=3:Shape | Add a shape to a sheet | [Customizing Drawing](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactshapes) |
| Capture content in any cell range | [Creating Camera Shapes](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactshapes/spwin-camera) |
| Support for adding and customizing shapes and group shapes | [Working With Shapes (Enhanced Shape Engine)](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactshapes/working-with-shapes) |
| Chart | Add a chart to a sheet | [Chart Control](/spreadnet/docs/latest/online-win/overview/spwin-devguide/fpchart-devguide) |
| @cols=1:@rows=3:Sparklines | Display a small graph in a cell | [Sparklines](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-sparkline) |
| Add Sparklines Using Methods | [Add Sparklines Using Methods](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-sparkline/spwin-sparkadd) |
| Add Sparklines Using Formulas | [Add Sparklines using Formulas](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-sparkline/spwin-sparkline-func) |
| @cols=1:@rows=8:Edit | Allow edit mode remains on for any cell | [Understanding Edit Mode in a Cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cell-focus/spwin-celleditmode) |
| Validate user input | [Using Validation](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cellvalid) |
| Set initial value to a cell | [Placing and Retrieving Data](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-usedata/spwin-dataaddreturn) |
| Perfrom automatic calculation based on input value | [Formulas in Cells](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula) |
| Display formula text box (formula bar) | [Working with the Formula Text Box](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-formulabar) |
| Display name box | [Setting up the Name Box](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-namebox) |
| Perform input by drag and drop | [Filling Cells with Drag and Drop](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cell-dragops/spwin-cell-dragdrop) |
| Define external variable | [Creating and Using External Variable](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-external-variable) |
| @cols=1:@rows=2:Excel | Load an Excel file | [Opening an Excel File](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-usefiles/spwin-openfiles/spwin-open-excelfile) |
| Save to Excel file | [Saving to an Excel File](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-usefiles/spwin-savefiles/spwin-save-excelfile) |
| @cols=1:@rows=2:Print | Print using printing option | [Printing](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing) |
| Print in PDF format | [Printing to PDF](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printactions/spwin-printPDF) |
| @cols=1:@rows=2:Data Binding | Bind a data source | [Binding to Data](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-data-binding/spwin-databind) |
| Display relational data hierarchically | [Working with Hierarchical Data Display](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-data-binding/spwin-databind-hierarchy) |
| @cols=1:@rows=7:User Operation | Allow multiple row selection | [Specifying What the User Can Select](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-interactselection/spwin-selsetuser) |
| Set clipboard data by copy and paste operation | [Customizing Clipboard Operation Options](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-cntrlclipopts) |
| Get cursor position | [Locating the Pointer Using HitTest](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cell-indicators/spwin-cntrl-hittest) |
| Customize the behavior of undo and redo | [Customizing Undo and Redo Actions](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-undoredo) |
| Customize keyboard operation | [Keyboard Interaction](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-mappingkeys) |
| Sort a row by clicking column header | [Allowing the User to Automatically Sort Rows](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interact-rowcol/spwin-sorting/spwin-sort-setuser) |
| Use on a tablet | [Touch Support with the Component](/spreadnet/docs/latest/online-win/overview/spwin-devguide/tsmain) |
| @cols=1:@rows=2:Render | Make it look like a visual style | [Using XP Themes with the Component](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-appearxptheme) |
| Text rendering using GDI | [Text Rendering with GDI](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-feattextrender) |

## See Also

[Understanding the Product](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-concepts)
[Product Overview](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-concepts/spwin-oviewproduct)