Features

Spread for Web Forms offers excellent design time support for rapid development using the innovative Spread Designer and supports in-cell editing and validation. You have complete customization at the cell level, not only with rows and columns, and you can edit multiple rows without requiring a postback. You can apply styles at the table, row, column and cell level and offer customized views. Spread supports paging, cells spanning, multiple line headers, sorting, a rich set of cell types and many other features. View some of these features below.

• Hierarchy
  Display multiple levels of data because datasets are getting deeper.
• More Than 200 Built-in Functions
  Add calcuations quickly to your web applications by using any of over 200 pre-defined algorithims or add your own custom functions.
• Insert and Edit
  Allow or prohibit users from inserting and editing data in columns, rows, or cells.
• Custom Messages
  Display custom error messages when invalid data has been entered (for example, entering text into a date-time cell).
• Command Bar
  A button bar provides an easy and intuitive way for your users to edit, delete, and insert data, control sheet navigation, and control paging.
• Page Navigation
  Customize the navigation of multiple pages of data by displaying page numbers, next and previous arrows, or both. It can be positioned on the top and/or bottom of Spread 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 columns, rows, and cells using your own data and custom formatting. Text Tips Display custom text tips over any column, row, or cell to display additional information to help 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. Client-Side 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 how 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.
• Multiple Browsers
  Unlike other grids, we recognize the possibility that not every one of your users will be using MS Windows Internet Explorer 6.0. We have done extensive testing with other browsers and versions and, when possible, have added support for these as well. Try that with your current grid!

Cell Types

Use any of 15 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
• Date
• Time
• Double
• General
• Hyperlink
• Image Integer
• Label
• List Box
• Radio Button
• Regular Expression
• Text