FarPoint Spread for ASP.NET - .NET Component - V4.0 - Resumen

Descripción | Precio y licencia | Evaluaciones y descargas | Compatibilidad | Datos del autor | Opiniones | Foro | Resumen

Resumen

FarPoint Spread for ASP.NET by FarPoint Technologies

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.

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.

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.

PartNumbers: PC-513244-163744 513244-163744 PC-513244-163764 513244-163764 PC-513244-163768 513244-163768 PC-513244-163825 513244-163825 PC-513244-163748 513244-163748 PC-513244-163784 513244-163784 PC-513244-163756 513244-163756 PC-513244-163795 513244-163795 PC-513244-163797 513244-163797 PC-513244-163826 513244-163826 PC-513244-163792 513244-163792 PC-513244-163803 513244-163803 PC-513244-163856 513244-163856

Publisher PartNumbers: SSW01 SWB01 SWB06

PurchaseOptions: Spread for ASP.NET V4.0 1 Developer License , Spread for ASP.NET V4.0 4 Developer Team License , Spread for ASP.NET V4.0 6 Developer Team License , Spread for ASP.NET V4.0 1 Developer Upgrade License from Spread for Web Forms V3 , Spread for ASP.NET V4.0 1 Developer Upgrade License from Spread for Web Forms V2.5 , Spread for ASP.NET V4.0 1 Developer Upgrade License from any FarPoint product , 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 1 Developer License with Maintenance , 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 4 Developer Team License with Maintenance , 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 6 Developer Team License with Maintenance , 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 1 Developer License with Maintenance Upgrade from Spread for Web Forms V3.0 with Maintenance , 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 1 Developer License with Maintenance Upgrade from Spread for Web Forms V2.5 with Maintenance , 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 1 Developer License with Maintenance Upgrade from any FarPoint product , Spread for ASP.NET - Maintenance Renewal 1 Maintenance Renewal License (One Maintenance Required per Developer)

Resources: Read the Spread for ASP.NET help file, Spread for ASP.NET Formula Reference, Spread for ASP.NET Documentation, 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, Spread for ASP.NET Import and Export Reference, Spread for ASP.NET Developer's Guide, Download the FarPoint Spread for ASP.NET V4.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 2008, Microsoft Visual Studio 2005, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C# 2008, Microsoft Visual C# 2005, Microsoft Internet Explorer 7.0, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.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