Spread WinRT Features
Native Microsoft Excel Compatibility
Import data from and export data to Excel in your Windows 8 applications. Several Microsoft Excel document formats are supported, including Excel 97 - Excel 2003 (XLS), Excel 2007 - Excel 2010 XML (XLSX), comma-delimited (CSV) and tab-delimited (TXT). Open an entire multiple-sheet Excel file into the Spread component, or specify a particular sheet (either by name or number) and open it into a specific sheet in Spread.
Spread Designer for Rich Design-time Support
Create your spreadsheet layout and formatting using the rich, familiar design environment of the 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
Recognize trends, isolate out-of-range values and gain a picture clear understanding of your data. Spread data visualization support includes sparklines, conditional formatting, icon sets, data bars, color gradients, Excel-style grouping and filtering.
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 to 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 familiar Excel-style filter dialogs. Use the basic default filtering or customize the filtering.
Range Grouping
Use Excel-style range grouping to logically group ranges and nested ranges of data. Expand or collapse ranges of rows and/or columns in the sheet.
Rich Data Interaction and Display Support
Customize the look and feel of Spread within your application. 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 any number of rows, columns or both in a sheet.
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, 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 for WinRT makes it easy to apply different colors and fonts to any cell, row, column, row header or column header.
