Farpoint Spread for Web Forms - Summary

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

Summary

Farpoint Spread for Web Forms by FarPoint Technologies

Easily present, edit, and update your ASP.NET data. Spread for Web Forms is a spreadsheet component that offers intuitive customer usability along with a wealth of grid functionality. With Spread for Web Forms you have the ability to make multiple edits on multiple rows without round trips to the server. You have exceptional client-side validation to alert your user of invalid data immediately and simple client-side keyboard navigation. Written from the ground up in C#, Spread for Web Forms will provide your user with an easy and reliable, feature-rich, user-friendly online experience. Now includes Outlook-style grouping (any number of levels), Microsoft ASP.NET AJAX tested, Load-on-demand paging (virtual mode) and AJAX support, including real-time updating of formula results.

Spread for Web Forms offers excellent design time support for rapid development using the innovative Spread Designer and supports in-cell editing and validation. Complied against both the 1.1 and 2.0 Frameworks, Spread for Web Forms 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.

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.

Main Features

Hierarchy

Display data in a hierarchical format by binding Spread to a dataset with relationships

More than 200 Built-in Functions

Use the Calc Engine to add calculations to your web applications. Take advantage of over 200 included math functions or add your own custom functions

Inserting and Editing - Allow or disable the inserting and editing of data

Error Messages - Display custom error messages when invalid data has been entered (for example, entering text into a Date cell)

Command Bar - The CommandBar provides an easy and intuitive way for your users to edit, delete, and insert data, control sheet navigation, and control paging

Pager - Use the Pager to customize the navigation of multiple pages of data by displaying page numbers, next and previous arrows, or both. The pager can be positioned on the top and/or bottom or on the Command Bar

Sheets - Each control can contain multiple sheets, similar to Microsoft Excel, allowing you to organize your information on one convenient screen

Binding - Bind Spread to a dataset to quickly display and easily allow your users to edit the information. Spread can automatically update the dataset with the changes

Unbound - Use in unbound mode to populate Spread cells, rows or columns using your own data and custom formatting

Text Tips - Display custom text tips over any row, column or cell to display additional help information for your user

Multiple Data Changes - Allow multiple data changes, even on multiple rows, without a having to round trip to the server to save your changes

Data validation - Client-side data validation reduces unnecessary round trips to the server by validating the entered data on the client side before it gets posted back

Named Appearance Styles - Create Named Styles to define a certain style (for example; fonts, colors, cell types, etc.) and share the style with other cells. This greatly reduces the coding and allows you to easily modify the master style and it will update all related styles accordingly

Predefined and Custom Skins - Easily and quickly configure the appearance of Spread using predefined skins or create and save your own custom skins. Custom skins can easily be shared with everyone in your development team, allowing a consistent look of the control across multiple pages and applications

Sort - Automatically sort any column in ascending or descending order by double clicking on the header

Client Scripting - Create a rich user experience for your users using the client scripting, allowing the editing of values without having to round trip to the server, as well as many other user-friendly benefits

HTML tables - Use Spread as a replacement for HTML tables, giving you full access to Spreads' advanced formatting options

Customization - Customize the gridlines, odd/even row colors, colors of the selected item, and cell spacing

Operation Modes - Use the Operation Modes to control what selections can be made: Normal, ReadOnly, RowMode, or SingleSelect

Objects - You have complete control over the design of Spread by using the Sheet, Row, Column and Cell objects

Spans - Add spans to headers, rows, columns or cells

Multiple Headers - Add multiple rows and columns to the headers

Cell Customization - Complete customization at the cell level, including setting cell types, tags, alignment, borders, colors, font and margins

Spread Designer - Use the Spread Designer to reduce development time by allowing you to fully customize the look and feel of the control at design time using an intuitive, easy-to-use interface

Import / Export Data - Import/export Microsoft Excel 97 and higher files and text files

Export to Spread XML

Publish Excel Workbooks Online - Easily publish your existing or new Microsoft Excel 97 and higher workbooks online by using Spread's Excel import and export feature

Dual Programming Models - Program directly against Spread's data and style models for maximum control and speed or use the included Helper Objects for a more intuitive approach

Cross Browser Compatibility

Cell Types - Use any of 14 predefined cell types to control what type of data is allowed to be entered in a cell or create your own cell type to display data:

Button

Check Box

Combo Box

Currency

DateTime

Double

General

Hyperlink

Image

Integer

Label

List Box

Radio Button

Regular Expression

What's New in FarPoint Spread for Web Forms 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.

What's New in FarPoint Spread for Web Forms V2.5?

AJAX support, including real-time updating of formula results

Searching

Row Filtering

Over 300 built-in functions for formulas; Database, Date and Time, Engineering, Financial, Information, Logical, Look Up, Math and Trigonometry, Statistical, Text

Freeze any number of rows and columns from scrolling using Microsoft Internet Explorer 5.5 +

Client-side scripting support for Mozilla Firefox

Enhanced printing support

What's New in V2.0

The following lists the new features and enhancements that have been added to Spread for Web Forms V2:

More Cell-Level Control of Data

Cell referencing across sheets (cross-sheet referencing)

Allow automatic merging of cells with identical content

Over 300 built-in functions for formulas; Date and Time, Engineering, Financial, Information, Logical, Look Up, Math and Trigonometry, Statistical, Text

Adding a cell span now supports zero-width anchor cells

More Cell Type Features

Percent cell type for percent values

Cell type can have background image

Allow postback of combo box and check box cells

More Sheet-Level Control of Data

Save to and load from Excel stream object

Printing an entire sheet

Hiding an entire sheet

Hierarchical view support for collections

More Customization of the Interface

Command bar can be at top or bottom of control

Scroll bar colors can be customized

Hierarchy expand and collapse image can be customized

Sort indicator image can be customized

Allow hiding buttons (while not disabling them)

Manage ability of user to expand rows in hierarchical display

Manage ability of user to use tab key for advancing

More Client-Side Scripting Features

Event notifying scrolling of sheet

Event notifying active cell changing

ActiveCol and ActiveRow properties are read/write

Method to hide a column by setting width to zero

Method to set column width

Method to put Spread into edit mode

PartNumbers: PC-513244-129447 513244-129447 PC-513244-129467 513244-129467 PC-513244-129471 513244-129471 PC-513244-129528 513244-129528 PC-513244-129451 513244-129451 PC-513244-129455 513244-129455 PC-513244-129487 513244-129487 PC-513244-129459 513244-129459 PC-513244-129498 513244-129498 PC-513244-129500 513244-129500 PC-513244-129529 513244-129529 PC-513244-129495 513244-129495 PC-513244-129506 513244-129506 PC-513244-129512 513244-129512 PC-513244-129514 513244-129514 PC-513244-129463 513244-129463 PC-513244-129502 513244-129502 PC-513244-129504 513244-129504 PC-513244-129531 513244-129531 PC-513244-129516 513244-129516 PC-513244-129518 513244-129518 PC-513244-129524 513244-129524 PC-513244-129526 513244-129526

Publisher PartNumbers: SSE01 SSW01 SWB01 SWB02 SWB06

PurchaseOptions: Spread for Web Forms V3.0 1 Developer License , Spread for Web Forms V3.0 4 Developer Team License , Spread for Web Forms V3.0 6 Developer Team License , Spread for Web Forms V3.0 1 Developer Upgrade License from Spread for Web Forms V2.5 , Spread for Web Forms V3.0 1 Developer Upgrade License from Spread for Web Forms V2 , Spread for Web Forms V3.0 1 Developer Upgrade License from Spread for Web Forms V1.x , Spread for Web Forms V3.0 1 Developer Upgrade License from any Farpoint product , Spread for Web Forms Subscription V3.0 1 Developer Subscription License - includes all updates/upgrades for one year , Spread for Web Forms Subscription V3.0 4 Developer Team Subscription License - includes all updates/upgrades for one year , Spread for Web Forms Subscription V3.0 6 Developer Team Subscription License - includes all updates/upgrades for one year , Spread for Web Forms Subscription V3.0 1 Developer Subscription License Upgrade from Spread for Web Forms V2.5 - includes all updates/upgrades for one year , Spread for Web Forms Subscription V3.0 1 Developer Subscription License Upgrade from Spread for Web Forms V2.0 - includes all updates/upgrades for one year , Spread for Web Forms Subscription V3.0 1 Developer Subscription License Upgrade from Spread for Web Forms V1.x - includes all updates/upgrades for one year , Spread for Web Forms Subscription V3.0 1 Developer Subscription License Upgrade from any Farpoint product - includes all updates/upgrades for one year , Spread for Web Forms Subscription V3.0 1 Subscription Renewal License - includes all updates/upgrades for one year , Spread for Web Forms Enterprise V3.0 1 Developer Enterprise License - includes all updates/upgrades, priority support and unlimited support calls for one year , Spread for Web Forms Enterprise V3.0 4 Developer Team Enterprise License - includes all updates/upgrades, priority support and unlimited support calls for one year , Spread for Web Forms Enterprise V3.0 6 Developer Team Enterprise License - includes all updates/upgrades, priority support and unlimited support calls for one year , Spread for Web Forms Enterprise V3.0 1 Developer Enterprise License Upgrade from Spread for Web Forms V2.5 - includes all updates/upgrades, priority support and unlimited support calls for one year , Spread for Web Forms Enterprise V3.0 1 Developer Enterprise License Upgrade from Spread for Web Forms V2.0 - includes all updates/upgrades, priority support and unlimited support calls for one year , Spread for Web Forms Enterprise V3.0 1 Developer Enterprise License Upgrade from Spread for Web Forms V1.x - includes all updates/upgrades, priority support and unlimited support calls for one year , Spread for Web Forms Enterprise V3.0 1 Developer Enterprise License Upgrade from any Farpoint product - includes all updates/upgrades, priority support and unlimited support calls for one year , Spread for Web Forms Enterprise V3.0 1 Enterprise Renewal License - includes all updates/upgrades, priority support and unlimited support calls for one year

Resources: Read the Spread for Web Forms help file, Read the Spread for Web Forms End User License Agreement (EULA), Read the 'Optimizing Web Applications with AJAX and Spread for Web Forms' Whitepaper - Requires Acrobat Reader, Download the FarPoint Spread for Web Forms V3.0 evaluation on to your computer - Expires After 30 Days

Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows 2000, Windows NT 4.0

Architecture of Product: 32Bit

Product Type: Component

Component Type: ASP.NET WebForms, ASP.NET AJAX (ATLAS), .NET Class, 100% Managed Code, JavaScript, AJAX

Compatible Containers: Microsoft Visual Studio 2005, Microsoft Visual Studio .NET 2003, Microsoft Visual Studio .NET, Microsoft Visual Basic 2005, Microsoft Visual Basic .NET 2003, Microsoft Visual Basic .NET, Microsoft Visual C++ 2005, Microsoft Visual C++ .NET 2003, Microsoft Visual C++ .NET, Microsoft Visual C# 2005, Microsoft Visual C# .NET 2003, Microsoft Visual C# .NET, Microsoft Internet Information Server 5.0, Microsoft Internet Explorer 6.0, .NET Framework 2.0, .NET Framework 1.1, .NET Framework 1.0

Product Class: User Interface Components

Search Items: New Product Jan 05

Keywords: Spreadsheet spread sheet worksheet workbook excel lotus 123 1-2-3 xls xl Grid Grids Table Tables DataGrid DataGrids FarPoint, fpoint Enterprise Partner farpoint spread web forms, farpoint spread webforms, farpoint spread asp.net, farpoint spread web, spread web forms, farpoint spread, fpoint spread, farpoint, farpoint tech,