FarPoint Spread for ASP.NET

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Easily present, edit, and update your ASP.NET data. Spread for ASP.NET (previously Spread for Web Forms) is a spreadsheet component to add full-featured spreadsheet capabilities or highly advanced grid functionality to your ASP.NET applications. 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. Written from the ground up in C#, Spread for ASP.NET will provide your ASP.NET user with an easy and reliable, feature-rich, user-friendly online experience while giving you the extensive spreadsheet feature set.

From

$934.07

Best Seller

  |  

Top Download

Our regular prices are shown below. Please logon to see your discounted prices.

Spread for ASP.NET V4.0

Spread for ASP.NET with one year Maintenance V4.0 - Includes all updates, major upgrades, email and forum support, and unlimited support calls for one year

Spread for ASP.NET - Maintenance Renewal

Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase.  All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed above including volume licensing and previous versions.

Our regular prices are shown above. Please logon to see your discounted prices.

What's New in FarPoint Spread for ASP.NET V4?

• Excel XLS 97-2007 import and export
• Microsoft Excel 2007 XML (Office Open XML) support
• Print to PDF
• Sleek new predefined skins and custom skins
• Multi-column listbox cell type
• Editing templates
• Support for AJAX Extenders
• Title/Subtitles for a sheet
• Drag/Move multiple columns
• New Designer and Wizards
• drag-and-drop integration with Visual Studio
• Display a single record on multiple rows
• Preview Row and row templates
• Add client side event handler through property window
• Display totals, data aggregation in the row/column footers

What's New in FarPoint Spread for ASP.NET V3.0?

• Support for Outlook-style grouping (any number of levels)
• Microsoft ASP.NET AJAX tested and AJAX support
• Load-on-demand paging (virtual mode)
• Additional page navigation
• CSS support for sheet name tabs
• Databinding to combo box cells
• Drag and drop column capability
• More client-side methods
• Additional selection operation modes
• Get merged cells - The GetMergeCell and GetMergeCells methods allow you to get a merged cell range (similar to GetSpanCell method which returns a spanned range).
• Customize style of the focus rectangle border - The FocusRectangleBorderColor and FocusRectangleBorderStyle properties allow you to set the border color and style for the focus rectangle (when ShowFocusRectangle is True).
• Customize grouping bar style - The FpSpread.DragColumnCssClass and GroupColumnHeaderCssClass properties allow you to set the style for group bar headers and transparent column headers (for display during a drag operation).
• Allow more grouping flexibility - A user can cancel the grouping by dragging and dropping a column back from the group bar to the column headers and a user can swap the column on the group bar with a drag and drop.#
• Reset the sort order - With SheetView.ResetViewColumnIndexes and SheetView.ResetViewRowIndexes methods, you can reset (or re-initialize) the sort order of rows.
• Option to import/export data only to/from Excel - Ability to import/export only cell's data. ExcelOpenFlags enumeration already has a “DataOnly” parameter; now the ExcelSaveFlags enumeration has one too.
• Conditional format a range of cells - Ability to set conditional format to a cell range.
• New events on client-side scripting, onColumnDragMove and onColumnDragMoveCompleted, have been added.
• New events on client-side scripting, onColWidthChanged and onRowHeightChanged, have been added.
• The FixedPoint property has been added for currency, double, and percent cells to allow you to display placeholding zeros.
• The MinimumValue and MaximumValue properties have been added to the percent cell type to allow you to set minimum and maximum values.
• Customize the SmartTag Spread Identifier - A text box on SmartTag allows you to change the FarPoint Spread identifier from "FPSpread1" to something else.

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. Please, read the 'Optimizing Web Applications with AJAX and Spread for Web Forms' Whitepaper on the 'evals and downloads' section for more information.

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

• Normal Allows users to perform default spreadsheet selecting and editing
• ReadOnly Allows users to see the data but not to select or edit any cell or row in the sheet
• RowMode Allows users to select (highlight) a single row only and to edit an individual cell in that row
• SingleSelect Allows users to select (highlight) a single row only but not to edit any cell
• MultiSelect Allows the user to select multiple contiguous rows in the spreadsheet (as one would in a multiple-select list box)
• ExtendedSelect Allows the user to select multiple discontiguous rows in the spreadsheet (as one would in an extended-select list box)

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:

• Use style sheets
• Use State Management
• Program against the Models instead of Helper Objects
• Use Named Styles

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. Think of the new opportunities you now have!

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.

Support

Spread for ASP.NET Maintenance Package includes all updates, major upgrades, email and forum support, and unlimited support calls for one year.