|
The world’s most popular ASP.NET spreadsheet component...now with Dynamic Data support!
Use our ASP.NET spreadsheet component to add full-featured spreadsheet capabilities or highly advanced grid functionality to your ASP.NET applications. Our award-winning Spread for ASP.NET frees you from spending tedious hours coding features that are missing in other grids. In Spread for ASP.NET many of those features are only a property setting or line of code away. Take the product tours, read the whitepapers, or download your evaluation today.
A Complete ASP.NET Spreadsheet
Spread for ASP.NET is a complete ASP.NET spreadsheet component that 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.
- Full Excel Compatibility
- AJAX
- Filtering
- Hierarchy
- Spread Designer
- Searching
- Load on Demand
- Conditional Formatting
- Formulas
- Grouping
- Frozen Rows/Columns
- Rich Set of Cell Types
- Operation Modes
- Cell Merging
- Column Moving
- and many other features
Written from the ground up in C#, you can be assured 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 you expect from a FarPoint Spread product.
What's new Version 4
Improvements to the Component
- AJAX Extenders
All controls in the AJAX Control Toolkit can add or attach client behaviors to a target control. The target control is exposed as the Editor property of the extender cell type in FarPoint Spread.
- Print to PDF
Use one of the SavePdf methods or the SavePdfToResponse methods. The former saves the FarPoint Spread to the specified PDF file. The latter saves the FarPoint Spread to the specified PDF response.
- New skins
- Sheet corner customization
- Add client events at design time
- Row template editor
You can allow a row edit template to be displayed so the user can edit the contents of an entire row using a specified template or form. In the example shown here, the entire row of data is presented to the user as a vertical form with an Update and Cancel button at the bottom of the form.
- New default appearance
- Title and SubTitle
- Column footers and group footers
You can show a column footer or a group footer or both for the sheet and put information in the footer such as formulas or text. The column footer is an area at the bottom of the sheet. The group footer is an extra row of footer cells at the bottom of a sheet with grouping, if you are using the grouping feature.
- Quick start wizard
- New improved Spread Designer
You can quickly customize a spreadsheet component using the Spread Designer. Whether you are prototyping a complete spreadsheet component or simply customizing some aspect of your spreadsheet component, the dedicated graphical interface offers many features to save time and effort. It also provides a way for you to add data to and set properties for the component easily, including properties that are not available at design time in Visual Studio. You can set both design-time and run-time properties. In most cases you can preview changes before applying them to the spreadsheet.
- Enhanced color support when saving to xls
- LayoutMode
For a more compressed format of displaying information, you may want to display columns with multiple lines of information. You can create row templates, also called aggregation subtotals or multiple-line columns. You can display multiple lines within a column, such as to display address information together in one column that involves multiple fields of information.
- Multi-Column combo cell
- HyperLink cell tooltips
- ForeColor for button cell
- BackColor for button and combo cells
- OnClientClick property for button cells
- OnClientChanged property for combo cells
- Tag cloud
Improvements to the User Interaction
- Texttips for scroll bars (ScrollingContentVisible)
This feature adds the ability to display scroll tips when the control is scrolled. The scrolling grid content can be displayed in a horizontal direction or vertical direction. By default, the content of the scroll tips is the contents of row header or column header but the developer can also customize this content to display other information.
- Skip cells with tab key (TabStop)
- Move multiple columns
New Events
New Methods
- Open and Save methods for sheets
- Import or Export Open XML (.xlsx) files
New Properties
- SelectionPolicy
- New CursortType enum
- SaveViewStateToSession
New Client Methods
- GetActiveChildSheetView
- HideMessage
- ShowMessage
Please contact BTSoftware for Site Licenses pricing
|
