Spread for ASP.NET - Summary

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

Summary

Spread for ASP.NET by GrapeCity

URLs: farpoint-spread-asp-net, farpoint spread asp net, farpointspreadaspnet, grapecity

Easily present, edit, and update your ASP.NET data. Spread for ASP.NET (previously known as 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 (OOXML and 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) and Firefox.

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 Spread for ASP.NET V5 Build 05.00.3520?

Formatting for certain cells is now handled correctly

Column headers are now correctly exported to an Excel-formatted file

The SavePdfToResponse method now works correctly

Borders are now correctly exported to a PDF file

Certain Excel-formatted files now load correctly

The SetValue method now works correctly

What’s new in Spread for ASP.NET V5?

Visualize your spreadsheet data using charts inside of Spread. Spread for ASP.NET now includes fully integrated charting support with many different chart types and a built-in user interface for creating and customizing charts. You can present your data in Charts that are integrated in Spread and present your data in Charts using the FpChart stand-alone Control (outside of Spread).

Column Charts - The Column type has the following types of views - Clustered Column, Stacked Column, 100% Stacked Column, High Low Column, 3D Clustered Column, 3D Stacked Column, 100% 3D Stacked Column, 3D Column, 3D High Low Column, Clustered Cylinder, Stacked Cylinder, 100% Stacked Cylinder, 3D Cylinder, High Low Column Cylinder, Clustered Full Cone, Stacked Full Cone, 100% Stacked Full Cone, 3D Full Cone, High Low Column Full Cone, Clustered Full Pyramid, Stacked Full Pyramid, 100% Stacked Full Pyramid, 3D Pyramid, and High Low Column Pyramid.

Line Charts - The Line type has the following types of views - Line, Stacked Line, 100% Stacked Line, Line with Markers, Stacked Line with Markers, 100% Stacked Line with Markers, and 3D Line.

Pie Charts - The Pie type has the following types of views - 2D Pie, 3D Pie, 2D Exploded Pie, and 3D Exploded Pie.

Bar Charts - The Bar type has the following types of views - Clustered Bar, Stacked Bar, 100% Stacked Bar, High Low Bar, 3D Clustered Bar , 3D Stacked Bar, 100% 3D Stacked Bar, 3D High Low Bar, Clustered Horizontal Cylinder, Stacked Horizontal Cylinder, 100% Stacked Horizontal Cylinder, High Low Bar Cylinder, Clustered Horizontal Full Cone, Stacked Horizontal Full Cone, 100% Stacked Horizontal, High Low Bar Full Cone, Clustered Horizontal Full Pyramid, Stacked Horizontal Full Pyramid, 100% Stacked Horizontal, and High Low Bar Pyramid.

Area Charts - The Area type has the following types of views - Area, Stacked Area, 100% Stacked Area, High Low Area, 3D Area, 3D Stacked Area, 100% 3D Stacked Area, and 3D High Low Area.

XY Charts - The XY type has the following types of views - XY Point, XY Line, and XY Line with Marker.

Bubble Charts - The Bubble type has the following types of views - 2D Bubble and 3D Bubble.

Stock Charts - The Stock type has the following types of views - High Low Close, Open High Low Close, and Candle Stick.

XYZ Charts - The XYZ type has the following types of views - XYZ Line, XYZ Line with Marker, XYZ Point, and Surface.

Doughnut Charts - The Doughnut type has the following types of views - Doughnut and Exploded Doughnut.

Radar Charts - The Radar type has the following types of views - Radar Line, Radar Line with Marker, Radar Point, and Radar Area.

Polar Charts - The Polar type has the following types of views - Polar Line, Polar Line with Marker, Polar Point, and Polar Area.

You can use the Chart Designer and integrated menus and dialogs to create and manipulate charts in your Spread dashboards without writing code. You can also use the Change Chart Type and Select Data dialogs to create and modify your charts at design time.

Enhanced Microsoft Excel compatible spreadsheet features

Document Caching provides lossless editing of Microsoft Excel files containing macros, script code, and other previously unsupported content.

New support for Microsoft Excel import and export of charts.

New support for importing and exporting Excel 2007 workbooks using ISO-OOXML compliant passwords (new in Excel 2007 SP2).

Get a fast start with the new Quick Start Wizard and begin designing user interfaces today

Data bindings.

Rows and Columns.

And many more attributes.

Additional enhancements for these existing features

UI Virtualization, providing major performance enhancements for large spreadsheets in IE8

Support for Azure Development Fabric

Support for new 3.5 and 4.0 version of AjaxControlToolkit, including the AJAXControlToolkit editable combobox control

Intellisense support for client side scripting files of Spread for use in Visual Studio IDE

Ability to move and/or copy SheetViews while in the Spread Designer

Support for Visual Studio 2010

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 is now available as part of Spread.NET.

If you require more information please visit the pages above or Contact Us for pricing and availability.

Easily present, edit, and update your ASP.NET data.

Evals & Downloads: Read the Spread.NET End User License Agreement

Operating System for Deployment: Windows Azure, Windows 7, Windows Server 2008, 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 2010, Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Basic 2010, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual C++ 2010, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C# 2010, Microsoft Visual C# 2008, Microsoft Visual C# 2005, Microsoft Internet Explorer 9.0, Microsoft Internet Explorer 8.0, Microsoft Internet Explorer 7.0, Mozilla Firefox 3.6, .NET Framework 4.0, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0

Product Class: User Interface Components

Keywords: spread for asp.net 5 software, spread for asp.net 4, spread for asp.net 4 includes 1-year maintenance, spread for asp.net, farpoint spread web forms, farpoint spread for asp.net, spread for asp.net, farpoint spread asp.net, farpoint spread web, spread web forms, farpoint sprea

GrapeCity, Grape City, Powertools, Power Tools, Japanese power-tools, 動力工具 Grape City, ＧｒａｐｅＣｉｔｙ Ｇｒａｐｅ Ｃｉｔｙ グレープシティ グレプシティ

datagrid controls, datatable controls, datagrid components, datatable components, datagrid, data grid, data table, net gridview, net datagrid, data grid, grid control, net datatable, c# gridview, c# datagrid, asp.net datagrid, grid asp, vb.net datagrid

Spreadsheet spread sheet worksheet workbook excel lotus 123 1-2-3 xls xl