On July 1, 2012, ComponentOne and GrapeCity joined forces, creating ComponentOne, a division of GrapeCity.
The US GrapeCity PowerTools division was renamed to ComponentOne.
Spread for .NET Bundle is now available as part of Spread.NET.
If you require more information please visit the pages above or Contact Us for pricing and availability.
Easily present, edit and update tabular data in Windows Forms and ASP.NET applications. Spread for .NET Bundle, also known as Spread Suite for .NET, includes Spread for Windows Forms and Spread for ASP.NET. Spread for Windows Forms is a comprehensive spreadsheet component for Windows Forms applications that combines grid capabilities, spreadsheet functionality, fully integrated charting support and includes the ability to bind to data sources. Spread for Windows Forms supports Microsoft Excel import/export. Spread for ASP.NET supports bound or unbound modes (no dataset needed), AJAX, native Microsoft Excel import/export, in-cell editing, multiple edits on multiple rows without server round trips, client-side column/row resizing, multiple sheets, searching, filtering, multiple cell types, validations, cell spans, multiple headers, sorting, complete customization at the cell level, over 300 built-in calculation functions, hierarchical display, Print to PDF and much more.
What’s new in Spread for ASP.NET V5?
Visualize your spreadsheet data using charts inside of Spread. Spread for ASP.NET now includes fully integrated charting support with many different chart types and a built-in user interface for creating and customizing charts. You can present your data in Charts that are integrated in Spread and present your data in Charts using the FpChart stand-alone Control (outside of Spread).
You can use the Chart Designer and integrated menus and dialogs to create and manipulate charts in your Spread dashboards without writing code. You can also use the Change Chart Type and Select Data dialogs to create and modify your charts at design time.
Enhanced Microsoft Excel compatible spreadsheet features
Get a fast start with the new Quick Start Wizard and begin designing user interfaces today
Additional enhancements for these existing features
What's New in FarPoint Spread for Windows Forms 5?
Visualize your spreadsheet data using charts inside of Spread with FarPoint Chart for .NET
Use Chart Designer and integrated menus and dialogs to create and manipulate charts in your Spread dashboards without writing code
Leverage the enhanced Microsoft Excel-compatible spreadsheet features
Simplify your development using new Spread Designer capabilities to design powerful user interfaces
Get a fast start with the new Quick Start Wizard
Perform advanced Calculations using these new functions
Enhance your user experience with these new and improved usability features
Additional enhancements for these existing features
What's New in FarPoint Spread for ASP.NET V4?
Spread for .NET Bundle includes Spread for Windows Forms and Spread for ASP.NET
Spread for ASP.NET Overview
Spread for ASP.NET offers excellent design time support for rapid development using the innovative Spread Designer and supports in-cell editing and validation. Complied against both the 2.0 and 3.5 Frameworks, Spread for ASP.NET supports bound or unbound modes (no dataset needed), AJAX, native Microsoft Excel import/export, in-cell editing, multiple edits on multiple rows without server round trips, client-side column/row resizing, multiple sheets, searching, filtering, multiple cell types, validations, cell spans, multiple headers, sorting, complete customization at the cell level, over 300 built-in calculation functions, hierarchical display and much more.
Spread for ASP.NET Main Features
AJAX Support: You can add AJAX support to the FpSpread component by setting the EnableAjaxCall property. This affects several features including expanding and collapsing child sheets in a hierarchical display, column sorting, inserting rows, paging, searching, filtering, and formula updates. If the ClientAutoCalculation property is true, then after a cell value is changed, an AJAX call is made to the FpSpread component. Then the component calculates the formulas and sends the values to the client side. The component then updates the values at the client side.
Microsoft Excel Compatibility: You can import data from and export data and formatting to Microsoft Excel in its native format, both individual spreadsheets and entire workbooks. You can save data to an Excel-formatted (BIFF8 format) file or stream. There are several SaveExcel methods each with several options. For instance, you can specify whether headers are saved with the data using the setting of the IncludeHeaders enumeration. You do not need Excel on the server for Spread to display your Excel files.
Row 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. You can use the basic default filtering or you can customize practically every aspect of the filtering.
Spread for ASP.NET Formula Support: Spread includes a powerful calculation engine that allows you to quickly add formulas to your web applications by using any of over 300 pre-defined functions or you can add your own custom functions. Spread also supports cross-sheet formula referencing.
Frozen Rows & Columns: You can 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 in the sheet the user navigates. Frozen rows and frozen columns are currently only supported with Microsoft Internet Explorer (IE) 5.5 and higher.
Spread for ASP.NET Grouping: You can set up the display to allow Outlook-style grouping of rows. For large amounts of data, this is helpful to display the data in the order the user needs. The user selects columns by which to sort and the component then organizes and displays the data in a hierarchy with rows organized accordingly.
Spread for ASP.NET Hierarchical View: Spread makes it easy to display and edit your hierarchical data. Simply set up your dataset with relations and set the HierarchicalView property to True. That's all it takes to display your data. You have full customization at the child level if you want to hide columns, change colors, etc. You can also choose from two hierarchy views: Hierarchical View and Parent Row View.
Spread for ASP.NET Importing and Exporting: Like any good spreadsheet, Spread supports the loading and saving of data. You can import/export Microsoft Excel 97 and higher files, text files (comma delimited, tab delimited, etc), and Spread files. This allows you to view or load your data in your favorite desktop application or, for example, you could create and load company templates on the fly.
Interaction: You can customize the Paging settings and the CommandBar settings that control how the user can interact with the spreadsheet.
Load on Demand: You can allow the Web page to load on demand -- as the user scrolls further down the spreadsheet the FarPoint Spread for ASP.NET component on the client loads another page of rows from the server as needed. This is similar to what was called "virtual mode" in the COM version of the product. You can specify the number of rows to load initially and how many are added in subsequent loads. You can specify these properties at the component level (for FpSpread) or at the sheet level.
Move Columns: Spread for ASP.NET allow your users to click on the header of a column and drag it to another location on the spreadsheet. You can set this with the AllowColumnMove property in the FpSpread class
Spread for ASP.NET Operation Modes: With these enumerations, you can set how much the user can interact with the sheet by controlling the ability to select a row and to edit a cell. Member Description
Optimizing Performance: The default behavior of Spread for ASP.NET makes it very easy to quickly publish your information on-line. However, there may be times when you need to fine tune Spread's behavior when working with large amounts of data to present it to your customer in the quickest possible time. Spread for ASP.NET provides several methods to dramatically increase the performance of your web applications and decrease the size of the download page:
Order Entry Sample: Spread for ASP.NET is ideal for any internal online order entry system or external shopping cart. After selecting an ID below, Spread for ASP.NET does an AJAX call back to the server, grabs the requested information, then passes the needed data back into Spread...all without a full page refresh. You can also adjust the pricing, discounts, or quantities and again, Spread will make an AJAX call and update the data accordingly.
Spread for ASP.NET Searching: You can search for data in any of the cells in the workbook by specifying the sheet and the string of data for which to search. You also have several searching options you can choose from.
Multiple Sheets: Each control can contain multiple sheets, similar to Microsoft Excel, allowing you to organize your information on one convenient web page.
You can add and remove sheets at design-time or run-time. You can set the background color and gridline color for each sheet or apply a built-in or custom "skin". You can also hide or show sheet tabs at run-time.
Sorting: You can sort the data displayed in the sheet by column or by row. You can sort in ascending order (A to Z, zero to 9) or descending order (Z to A, 9 to zero) and you can select which values to use as a key when sorting the data.
Spread for ASP.NET also provides an AllowSort property that will automatically sort the data by double-clicking on column header. The appropriate sort indicator will be displayed.
Spread for ASP.NET Designer: Spread includes the robust Spread Designer, a user-friendly design-time environment that allows you or your web designers to quickly configure the look and feel of the Spread control with no coding required.
You can easily assign cell types, color, text, etc for any cell using the Spread Designer's WYSIWYG implementation. This allows for faster design of your applications by your developers or you can even give the Spread control to your graphic designers to configure and create "skins" that can be used across multiple spreadsheets or even across multiple applications for a consistent look.
Unbound Mode: If you're using the MS Grid, you are required to use it in bound mode. But if your situation requires being able to use it in unbound mode, Spread for ASP.NET flexible data model makes this an easy task.
Spread for Windows Forms is a comprehensive spreadsheet component for Windows Forms applications that combines grid capabilities, spreadsheet functionality, and includes the ability to bind to data sources. This control may be dropped on a Windows Form and customized for a range of applications. You can control the appearance and control the user interaction in a variety of ways. With a built-in Designer, you can quickly create a prototype or customize your finished design. With most of the Spreads appearance and functionality based on underlying models, the advanced developer has complete control over the component. Import and export capabilities provide another source of flexibility when developing and exchanging designs.
For more information please refer to the help file in the Evals & Demos section.
Spread for Windows Forms introduces some powerful features.
Spread Maintenance Package includes all updates, major upgrades, email and forum support, and unlimited support calls for one year.