Spread for .NET Bundle (Spread Suite for .NET)

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 Windows Forms 5?

Visualize your spreadsheet data using charts inside of Spread with FarPoint Chart for .NET

• Fully integrated charting support with over 85 different chart types and built-in user interface for creating and customizing charts .
• Present your data in Charts that are integrated in Spread
• Present your data in Charts using the FpChart stand-alone Control(outside of Spread).

Use Chart Designer and integrated menus and dialogs to create and manipulate charts in your Spread dashboards without writing code

• Use the Change Chart Type and Select Data dialogs to create your charts at design time, or allow your end-users to modify their charts at run time
• Use the Chart Designer at design time or run time to modify the formatting of your charts.

Leverage the enhanced Microsoft Excel-compatible spreadsheet features

• Lossless editing of Microsoft Excel files containing macros, script code, and other previously unsupported content .
• New support for Microsoft Excel import and export of shapes and charts.
• New support for importing and exporting Excel 2007 workbooks using ISO-OOXML compliant passwords (new in Excel 2007 SP2).

Simplify your development using new Spread Designer capabilities to design powerful user interfaces

• New ribbon bar interface similar to Microsoft Excel 2007.
• Set multiline text in the header cells.
• Set Microsoft Outlook®-style grouping in design time.
• Set conditional formats.
• Clipboard support for entire sheets.

Get a fast start with the new Quick Start Wizard

• Data bindings.
• Rows and columns.
• And many more attributes

Perform advanced Calculations using these new functions

• AverageIf
• AverageIfs
• CountIfs
• IfError
• Match
• Search
• SumIfs
• Text

Enhance your user experience with these new and improved usability features

• Sort numeric column filter lists.
• Display a current row indicator.
• Move multiple columns or rows.
• Provide enhanced mouse interaction with buttons in cells.
• Customize scrolling increments.
• Use new display options for sheet titles, subtitles, row preview, and scrolling.
• Provide new clipboard enhancements.
• Select, move, and size shapes and charts while the sheet is zoomed.
• Provide multiple links and string trimming in hyperlink cells.
• Set a custom cursor for the gray area in a sheet (beyond the last row and column).
• New column and group footers with calculated and formatted values.

Additional enhancements for these existing features

• More control over edit mode.
• Improved export of text from a sheet.
• Enhance date and time data entry.
• Select multiple list items in list box cells.
• Customize display of text in cells and notes.
• Display buttons in cells.
• Display tool tips over buttons in cells.
• Improved display empty values.
• Display cell note indicators in any corner of the cell.
• Display column sort and filter indicators for each column in any header row.
• Customize images displayed for row expand/collapse, row selector, column filter, column sort, and new sheet tab indicators.
• Enhanced Outlook-style grouping of data.

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

Spread for .NET Bundle includes Spread for Windows Forms and Spread for ASP.NET

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.

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.

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.

Spread for Windows Forms is a comprehensive spreadsheet component for Windows Forms applications that combines grid capabilities, spreadsheet functionality, and includes the ability to bind to data sources. This control may be dropped on a Windows Form and customized for a range of applications. You can control the appearance and control the user interaction in a variety of ways. With a built-in Designer, you can quickly create a prototype or customize your finished design. With most of the Spreads appearance and functionality based on underlying models, the advanced developer has complete control over the component. Import and export capabilities provide another source of flexibility when developing and exchanging designs.

For more information please refer to the help file in the Evals & Demos section.

Spread for Windows Forms introduces some powerful features.

• Multiple Sheets - You can use multiple sheets in the spreadsheet. Use multiple sheets to categorize your information, similar to worksheets in Microsoft Excel
• Customized Appearance (Skins) - Easily and quickly configure the appearance of Spread using predefined skins or create and save your own custom skins. Custom skins can be shared with everyone in your development team, allowing a consistent look of the control across applications
• Spannable Cells - You can span cells. Create cell spans to join cells together, allowing one cell to span across multiple cells to include, for example, your company logo. You can span data cells or headers. You can also have Spread automatically merge cells that are the same value
• Headers with Multiple Columns and Rows - You can have multiple column headers and row headers. You can also span header cells. Use headers with multiple columns or rows to organize your column and row information
• Sorting Capabilities - You can sort rows or columns or a range of cells. Programmatically sort data by rows or columns. Or allow your users to sort rows automatically simply by clicking on the column header. The methods at the sheet level allow these kinds of sorting: Sorting Automatically by Column, Sorting Columns or Rows Manually, Sorting Data in a Range
• Multiple Cell Types - You can define a feature-rich set of cell types. Use Spread's cell types or create your own to determine what kind of data can be entered into a cell, avoiding unnecessary checks and validations by the developer and providing a natural way for your user to enter data
• Hierarchical Display - You can create a sheet within a row to display relational data hierarchically, with parent rows and child views of related data
• Data Binding - You can bind the spreadsheet to a data set to display and allow your users to edit information. Spread can automatically update the data set with the changes
• Built-In Functions - You can use built-in functions and operators to develop formulas and perform calculations. Add calculations quickly to your applications by using any of over 200 pre-defined algorithms or add your own custom functions
• Navigation - Spread provides multiple ways to control navigation within the spreadsheet. Keyboard Navigation and Action Keys - You can control Spread control actions when the user presses keys. A default set of keys and related actions is provided; however, you can customize these input maps, mapping keys to actions. For example, you can map the Enter key to move the focus to the cell below the current cell. Multiple Viewports - You can allow more than one pane or viewport in the spreadsheet to allow you to view data from different parts of the spreadsheet in one display. Display data in multiple viewports and allow your user to customize their own viewport view
• Spread Designer - You can use the Spread Designer to design your control and to create a prototype quickly. UseSpread Designer to reduce development time by allowing you to customize the look and feel of the control at design time using an intuitive, easy-to-use interface
• Import and Export Capabilities - You can import data from and export data and formatting to Microsoft Excel, both individual spreadsheets and entire workbooks. You can import and export entire spreadsheet(s) with data and formatting to and from XML

Spread Maintenance Package includes all updates, major upgrades, email and forum support, and unlimited support calls for one year.