[Overview]

FarPoint Spread for Windows Forms

The world's most popular .NET spreadsheet component

FarPoint Spread for Windows Forms 5 is the award-winning, Microsoft Excel®-compatible spreadsheet component for .NET from GrapeCity. Spread products are high performance, enterprise-strength spreadsheet components, and come battle-tested by over 100,000 registered developers worldwide.
　

Why Buy Spread for Windows Forms?

Today, users expect their applications to provide them with a familiar, intuitive, comfortable user experience. And what is more familiar than Microsoft Excel? We have spent over 18 years perfecting Spread to allow you to provide just such a user experience. Spread allows users to aggregate, analyze, adjust, and share data just like Microsoft Excel, in your own custom application. You can maintain business rules, security, and data integrity,

    • Pioneering .NET Spreadsheet Component with Many Firsts
    • Microsoft Excel Compatible
    • New! Chart Control and Integrated Spreadsheet Charting
    • Almost Unlimited Customization
    • Intuitive Designers for .NET
    • Flexible Data Binding Support
    • Printing/PDF Support
    • Quality Tested by Tens of Thousands of Users
    • Rich Collection of Tools
    • World Class Performance and Quality
    • Rich Product and Public Knowledge Base

Pioneering .NET Spreadsheet Component with Many Firsts
Spread introduced a number of technologies to Microsoft developers all over the world for the very first time, including the first full-featured spreadsheet component for Visual Basic, with the first spreadsheet designer, followed by Microsoft Visual Studio® .NET versions, and an array of new Excel-compatibility features and advanced customizations.

Microsoft Excel Compatible
You can import data from and export data with formatting to Microsoft Excel, for individual spreadsheets and entire workbooks. Spread supports several versions of Excel and several file types, including Excel files (XLS, XLSX), comma-delimited files (CSV), and text files (TXT).

Chart Control and Integrated Spreadsheet Charting
Spread for Windows Forms 5 now includes full-featured 2D and 3D charts. Chart types include Column, Line, Pie, Bar, Area, XY, Bubble, Stock, XYZ, Doughnut, Radar, and Polar. You can add charts using code, the Spread Designer, or the Chart Designer. You can also bind charts and let the end user make changes to the chart at run time. The fully integrated charting support in Spread features built-in menus and dialogs that you can use, and allow your end-users to use, for creating and modifying charts in the spreadsheet just as you would in Microsoft Excel.

Almost Unlimited Customization
Spread is the world's most powerful spreadsheet component for .NET. It offers an extensive code-behind, event-based API, plus the ability to customize almost any element of the user interface or application behavior at run time. Developers have long used Spread to embed advanced Microsoft Excel-compatible spreadsheet features into their .NET applications — features that would otherwise be considered impossible to achieve.

Intuitive Designers for .NET
Spread comes with an easy-to-use, intuitive spreadsheet designer that makes designing detailed spreadsheets and user screens a snap without writing a single line of code. Whether it is designing new screens or editing existing ones, the Designer’s new ribbon tool bar interface makes it easy to do so using a Microsoft Excel-like, visual, drag-and-drop user interface. The provided Chart Designer makes it easy to design stunning charts and spreadsheet dashboards by allowing almost unlimited customization of your charts.

Flexible Data Binding Support
Spread allows you to bind to a variety of data sources — including run-time unbound data. It supports binding spreadsheets to enterprise databases and .NET collections such as data sets, data views, and data tables, and any BindingSource object or other object that implements the IList or IListSource interface. You can also bind a sheet, column, or cell range.

Printing/PDF Support
You can customize the printing of your spreadsheets with many different printing options. For example, you can have colors and images in headers and footers. You can print parts of the sheet as needed. You can also print to a Portable Document Format (PDF) file. You can even take charge of the printing in your code using the owner print drawing support.

Quality Tested by Tens of Thousands of Users
More than a decade ago, Spread became the first spreadsheet component to work inside the Visual Basic IDE. Since then, the COM version — and now the .NET version — have not only been used by tens of thousands of developers, but also have become one of the only spreadsheet components to be successfully localized, sold, and supported in Japan, Europe, and the United States.

Rich Collection of Tools
When you buy Spread for Windows Forms 5, you get access to not just a powerful Windows Forms component, but a number of additional tools and features. These include the Spread Designer Tool, complete with Microsoft Office 2007-style look and feel, the Chart Designer, FormulaTextBox and FormulaProvider, Microsoft Visual Studio-integrated designers and property editors, charts, Microsoft Excel import/export APIs, and a comprehensive SDK.

World Class Performance and Quality
If you admired Spread for its world-class quality, powerful features, and tools, you will love version 5 even more. The new version contains a number of improvements to enhance the performance and quality of the spreadsheet engine, making it better, faster, and smarter than ever before.

Rich Product and Public Knowledge Base
When you buy Spread products, you are getting a market leader. You are getting thorough documentation. You are getting technical support and expert advice. You are getting the confidence of knowing that for the last decade, over 100,000 developers have adopted and enriched the product with their experience and skills, and have contributed to a global online knowledge base in the form of innumerable forum discussions, articles, comparisons, blogs, and emails.

　

[Features]

Explore the power that Spread gives you. Press the arrow above to begin the tour or select the features that interest you the most from the above dropdown list or feature list below.
　

<Native Microsoft® Excel® Support>

Spread for Windows Forms provides the industry's best native Excel support. You can import data from and export data (and formatting) to Microsoft Excel, including XLS, XLSX, CSV, and TXT files, all without needing Excel installed on the user's machine...royalty-free and run-time free.

   • Excel-compatibility

   • Document Caching
   • Password Protected Files
   • Formulas

   • Formula textbox

<Charting Support>

Add impressive charts to your spreadsheets using the new Chart control. Easily design charts using the included Chart Designer. Spread now support 12 chart types with 85 chart views, including 2D and 3D.

   • Column
   • Line
   • Pie
   • Bar
   • Area
   • XY
   • Bubble
   • Stock
   • XYZ
   • Doughnut
   • Radar
   • Polar


　

<Data Handling>

Spread provides the familiar sheets and workbooks you know from Microsoft Excel, as well as formula support, including cross-sheet references. You or your users can search, sort, filter, and group data, including providing outline grouping similar to Microsoft Excel. In addition, Spread can display data in hierarchies.

   • Sheets
   • Sorting
   • Filtering
   • Grouping

   • Outline grouping
   • Hierarchy
   • Searching

<Interaction>

Whether your users need to zoom, view multiple panes of data, drag-and-drop data, drag fill data in cells, or view cell notes, Spread can do it, and more. Offer users autocomplete options, undo and redo capabilities, frozen rows and columns, and different selection options, as needed.

   • Viewports (Panes)
   • Zoom
   • Drag-drop

   • Drag fill
   • Freezing rows and columns
   • Moving rows and columns
   • Operation modes (Selection options)

   • Undo/redo
   • Autocomplete
   • Cell notes
　

<Data Acquisition>

Spread for Windows Forms 5 works with data any way you need to provide it. You can bind to a data source or use unbound data. It can import data in many formats. And you can set up the data at run time or at design time using the convenient Quick Start wizard or in a WYSIWYG environment in the provided Spread Designer.

   • Data binding
   • Unbound data
   • I mport files

<Output>

Distributing the data can be just as, if not more, important than simply displaying it. You can export the data to different file formats, including native Excel files, delimited files, PDF, and printed reports.

   • Export
   • Printing
   • Printing to PDF
   • Reporting

<Appearance>

How do you want your spreadsheet to appear today? Any way you want! Use Spread to achieve clear, colorful table layouts, custom spreadsheets, and more.

   • Fonts/colors
   • Multiple headers
   • Borders
   • Merging
   • Spanning
   • Conditional formatting

<Layers and Drawing>

Spread includes several different layers for you to work with, including the the Data layer (on which cells with data appear), the Control layer (to place child controls on), and the Drawing layer (on which shapes and other graphical elements appear). and the Drawing layer (on which shapes and other graphical elements appear).

   • Control layer
   • Drawing layer - Shapes
　

<Cell Types>

Spread offers eight editable cell types and thirteen graphical cell types, which provide just about any interaction or data display you need. You can customize cells with spin buttons and provide pop-up calendars and clocks and other editors as needed.

   • Cell Types

<Designers and Wizards>

Spread makes it easy to create a prototype quickly or to customize your finished designs using the built-in Designers and Wizards.
　

    • Spread Designer

   • Quick Start Wizard

   • Chart Designer