Spread Designer for Rich Design-time Support
Create your spreadsheet layout and formatting using the rich, familiar design environment of Spread Designer. Easily create forms, and add calculated cells to your spreadsheet templates without writing any code. Load Excel documents, set conditional formatting, add sparklines - all within the designer. Then apply the template to the control in Visual Studio all with just a simple click of the mouse.
Data Visualization and Analysis Support
Let your data tell a story through the enhanced data visualization support in Spread! Recognize trends, isolate out-of-range values, and gain a picture clear understanding of your data. Spread data visualization support includes:
- Sparklines
- Conditional Formatting
- IconSets
- DataBars
- Color Gradients
- Excel-style Grouping
- Filtering with Excel-style dialog support
Sparklines
For even richer data analysis, add sparklines: tiny lightweight charts that are drawn in cells to provide a visual representation of data. Spread supports the Column, Line, and Win/Loss sparkline types and import/export of these sparklines in Excel 2010 files. You can also create custom sparklines and implement classes to define the sparkline settings and draw anything you want in a cell.
Filtering
View only the data you are interested in by filtering using the familiar Excel-style filter dialog.
Range Grouping
Use Excel-style range grouping to logically group ranges, and nested ranges of data.
Rich Data Interaction & Display Support
Customize the look and feel of Spread within your application. Data is integral to your application. The colors, borders, fonts and table-layout elements used to layout your data should support a high level of customization. Spread provides extensive customization at the row, column, and cell level. In addition, Spread provides Excel-style theme support to allow you to create the presentation you desire.
Multiple Header Styling
Define any number of rows and columns for the headers. You can also fully customize the appearance of header cells, including the text, styles, gradients, spans, and height/widths.
Row/Column Freezing
You can freeze (make non-scrolling) any number of rows, columns, or both in a sheet. This includes top rows, called leading rows, left-most columns, called leading columns, and trailing bottom rows or trailing right-most columns.
Cell Borders
Customize the appearance of the cells by setting borders for a cell or range of cells. A border can be displayed on the left, right, top, or bottom, or around all four sides of a cell or cell range. Use any of the built-in styles or define customized borders. You can specify more than one style and color for the same cell, column, row, or block of cells. Different border styles let you set different options.
Style Settings
Spread makes it easy to apply different colors and fonts to any cell, row, column, row header, or column header.
