Part of Windows Store Spread WinRT

Spreadsheet for WinRT applications

Spread WinRT

Embed Microsoft Excel® spreadsheet functionality into your Windows 8 applications. Perform data analysis using rich, built-in data visualization functionality, create customized spreadsheet templates, and more. Spread WinRT is based on Spread's proven Excel spreadsheet engine for WPF-Silverlight development.

Spread WinRT 7 v4 has arrived! This new release we fixed many bug and make the product more stable. Check out all of the new Features and Enhancements.

Why use Spread WinRT?

  • Pioneering WinRT Spreadsheet Components

    Pioneering WinRT Spreadsheet Components

    Spread introduced a number of technologies to Microsoft developers, including the first full-featured spreadsheet component for Visual Basic originally called FarPoint Spread, and the first spreadsheet designer. The Microsoft Visual Studio® .NET versions added an array of new Excel-compatibility features and advanced customization options. WinRT spreadsheet components continue to deliver this familiar Excel experience to your end users.

  • Native Microsoft Excel Compatibility

    Native Microsoft Excel Compatibility

    Import data from and export data to, with full formatting and formulas preserved, 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

    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.

  • Integrated Spreadsheet Chart

    Integrated Spreadsheet Chart

    Create expressive charts within your spreadsheets. Select from various chart types (30+), including: Column, Line, Pie, Bar, Area, Bubble, Scatter, Radar, Stock. Highly compatible with the Excel chart object, gives the application UI much more rich visualization to demonstrate data intuitively in spread control.

    Add charts at design time using the Spread Designer, or through code using the comprehensive Chart object model. Charts can be also imported from an existing Excel file, and you can allow end-users to make changes to the chart formatting at run time.

  • Visualization for Dashboard and Data Analysis

    Visualization for Dashboard and Data Analysis

    The data visualization functionality provided in Spread gives your data a voice, for example: Sparklines, Chart support, conditional formatting, filtering, and grouping. 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
    • Chart
    • Picture
    • Table
    • Excel-style Grouping
    • Filtering with Excel-style dialog support
  • Extensive Customization Options

    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.

    The Spread WinRT object model allows WinRT developers to customize UI elements and manage the behavior of the control by extending built-in classes and assigning custom objects to Spread. Developers use the Spread WinRT controls to embed advanced Microsoft Excel-compatible spreadsheet features into their WinRT applications - features that would otherwise be considered impossible to achieve.

  • Time-tested by Developers Worldwide

    As the first spreadsheet component on the market for Visual Basic, Spread has been used by tens of thousands of developers worldwide for the past 20 years. It's one of the few components to be successfully localized, sold, and supported in Japan, Europe, United States, and other parts of the world. While Spread has continued to evolve over the years, the development team has stayed true to the legacy and continues to support VB.NET for .NET products, and VB for the Spread COM product.

  • Strong Public Knowledge Base

    When you purchase Spread, you get a market leader. This means you get thorough documentation, technical support, and expert advice. Plus, be confident knowing that for nearly 20 years, over 100,000 developers have adopted and enriched Spread with their experience and skill, and have contributed to a global online knowledge base in the form of forum discussions, articles, and blogs.

Features and Highlights

Appearance

Use Spread WinRT to achieve clear, colorful table layouts, custom spreadsheets, and more. How do you want your spreadsheet to appear today? Customize it to look any way you want with:
  • Fonts/colors
  • Multiple headers
  • Borders
  • Merging
  • Spanning
  • Conditional formatting
Appearance

Array Formula

Use Ctrl+Shift+Enter key to enter an array formula for a range of cells. An array formula is a formula that can perform multiple calculations on one or more of the items in an array. For example, you can use array formula to:
  • Count the number of characters in a range of cells.
  • Sum numbers that meet certain conditions, such as the lowest values in a range or numbers that fall between an upper and lower boundary.
  • Sum every nth value in a range of values.
Array Formula

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. Borders

Conditional Formatting

Conditional formatting changes the appearance of a cell range based on conditions (or criteria). If the condition is true, the cell range is formatted based on that condition; if the condition is false, the cell range is not formatted based on that condition. It is easily add conditional formats to your cells; for example, you may want to change the background color of a cell based on the cell's value. You can use a named style to specify various formatting options such as borders and colors to apply if the condition statement is valid. Moreover, visualization such as data bars, color scales, and icon sets can be used with conditional formatting to help you visually answer specific questions about your data, highlight interesting cells or ranges of cells, emphasize unusual values, and visualize data. Conditional Formatting

Charting

Create impressive charts using code or the Spread Designer. Also, allow the end user to resize the chart and the range of data used in the chart control. There are several visual elements to a chart such as the plot, legend, and label areas; the axis, and the series.
  • The plot area is the area in which data points are drawn.
  • The legend area can be used to help end users identify different chart elements such as the series.
  • The label area contains additional information about the chart.
  • The axis displays the scale for a single dimension of a plot area.
  • Each series is a collection of data points.
Spread supports 9 categories and 30+ chart types:
  • Area
  • Bar
  • Bubble
  • Column
  • Line
  • Pie
  • Radar
  • Stock
  • Scatter
Charting

Cell Merge

Join a cell range into one larger cell and create a label that spans multiple columns or rows. Cell Merge

DataValidation UI Support

Show a drop-down window under the cell for list type criteria of data validation. The end-user can choose valid data from the list for the cell. Also provides the ability to show a red circle on cells which have an invalid value. DataValidation UI Support

Drawing Objects

Easily add any control to a cell or span cell using the new Drawing Object API. Drawing Objects

EXCEL COMPATIBILITY

Import data from and export data (and formatting) to Microsoft Excel, both in individual spreadsheets and entire workbooks. Several Excel document formats are supported, including Excel 97 - Excel 2003 (XLS), Excel 2007 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. EXCEL COMPATIBILITY

Filtering

You can customize the user experience for filtering data on a sheet. With row filtering, you can allow the user to filter the data in columns on a sheet and display only the rows of data which meet criteria from a drop-down list or change the appearance of rows based on that filtering. Use the basic default filtering or customize the filtering. Filtering

Floating Object

Each sheet can have many floating panels that can contain any UI elements. You can use it to add any control into your spreadsheet, for example you can add a path objects to simulate a shape. Floating Object

Formula TextBox

The formula text box control gives you Excel-like formula editing and can be placed anywhere on the form. The end-user can easily select a range reference with the mouse while entering a formula in the formula text box. Each reference has a different color, and we also support this ability in the cell editor. This allows the end-user to edit formulas quickly and easily. Formula TextBox

Frozen Rows & Columns

Freeze columns and rows and keep them displayed regardless of where the user navigates in the sheet. Frozen rows and frozen columns do not scroll when the user uses the scroll bar or navigation keys in the component. This is useful if you need information in non-header rows or columns to stay visible regardless of where the user navigates. Frozen Rows & Columns

Grouping

Create Excel-like range groups to expand or collapse ranges of rows and/or columns in the sheet. There are also APIs to customize background and border of range group panel. Grouping

Multiple Headers

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. Multiple Headers

Picture

Each sheet can have its own picture layer that can contain any image. You can use pictures to draw attention to parts of your spreadsheet or to emphasize some information or process involving the use of the spreadsheet. Picture

PDF Export

Easily export your spreadsheets to PDF documents, including data visualization features such as sparklines, data bars, and icon sets. PDF Export

Rapid Input Mode

If editing mode was triggered by typing a character on the keyboard, the user can still use the navigation keys (such as, arrow keys, TAB, PGUP, PGDN, HOME, END) to end the editing mode and move to active cell. Rapid Input Mode

Sparklines

Sparklines are tiny charts drawn directly inside cells to provide a visual representation of your data, right next to the data itself. 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. Sparklines

Split Box

To see more than one copy of a worksheet in Excel use the split box to divide the screen into panes. Choose from three options:
  • Always - Displays the split box all the time
  • Never - Does not display the split box
  • AsNeeded - Split box will be hidden once the viewport was split
Split Box

Table

Table uses to manage and analyze related data, makes easy to sort, filter, and format data within a sheet. It has built-in styles and appearance is totally same as Excel. Table

Touch Support

Excel 2013 like UI behavior and appearance touch support. This helps the end-user easily operate the spread control by using touch in a WinRT application which runs in a touch-able device. The behavior includes:
  • Resize the selected columns or rows by dragging the resize handler. And also can auto fit selected columns or rows by double tapping on the handler.
  • Panning on viewport to scroll, and also can drag scrollbar by touch.
  • Drag selection handler to change the range of the selection.
  • Use Pinch/Stretch gestures to zoom out/in the cells.
Touch Support

Visual Studio 2012 Support

Complete Visual Studio 2012 integration. Seamlessly integrate design-time functions into IDE, provide ContextMenu actions and file templates for easy document creation, and modify the document in a powerful, rich UI designer which pops up easily from the IDE. Visual Studio 2012 Support

Zoom

You can allow the user to change the scale of the display of the control, in other words to zoom in or zoom out. This allows the user to zoom in or out by pressing the CTRL key and turning the mouse wheel. The user can zoom in up to 400% and out to 10% of the default display. You can also programatically adjust the zoom. Zoom

Five Platforms, One Studio

This new studio includes spreadsheet controls for five platforms: Windows Forms, ASP.NET, WPF, Silverlight, and WinRT. Download and try for yourself.

Resources

Whether you are a customer or just trying us out, we stand behind you. Valuable learning resources such as samples, videos, and forums are free and just a click away.

Ready to start your 30-day, risk-free trial?

Includes free technical support.

Ready to buy?

All licenses are developer-based and there are no limits on the distribution of applications–unlimited, royalty-free, run-time distribution.

Pricing

Need help deciding?

Chat with sales, call or email. We're here to answer all your questions.

1.800.858.2739 | 412.681.4343 sales@componentone.com

Chat with Sales