Farpoint Spread for .NET Bundle - Summary

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

Summary

Farpoint Spread for .NET Bundle by FarPoint Technologies

Easily present, edit and update tabular data in Windows Forms and ASP.NET applications. Spread for .NET Bundle includes Spread for Windows Forms and Spread for Web Forms. Spread for Windows Forms includes the Spread Designer to allow developers and/or designers to quickly and easily design the look of the component at design time with no coding required. Spread for Windows Forms supports Microsoft Excel import/export as well as in-cell editing and validation. With Spread for Web Forms you have the ability to make multiple edits on multiple rows without round trips to the server. Exceptional client-side validation to alert your user of invalid data immediately and easy client-side keyboard navigation.

Spread for Web Forms offers excellent design time support for rapid development using our 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.

Main Spread for Web Forms Features include:

Hierarchy

Display data in a hierarchical format by binding Spread to a dataset with relationships

More than 200 Built-in Functions

Use the Calc Engine to add calculations to your web applications. Take advantage of over 200 included math functions or add your own custom functions

Inserting and Editing - Allow or disable the inserting and editing of data

Error Messages - Display custom error messages when invalid data has been entered (for example, entering text into a Date cell)

Command Bar - The CommandBar provides an easy and intuitive way for your users to edit, delete, and insert data, control sheet navigation, and control paging

Pager - Use the Pager to customize the navigation of multiple pages of data by displaying page numbers, next and previous arrows, or both. The pager can be positioned on the top and/or bottom 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 Spread cells, rows or columns using your own data and custom formatting

Text Tips - Display custom text tips over any row, column or cell to display additional help information for 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

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 what 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

Cross Browser Compatibility

Cell Types - Use any of 14 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

DateTime

Double

General

Hyperlink

Image

Integer

Label

List Box

Radio Button

Regular Expression

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

What's New in FarPoint Spread for Windows Forms 4.0?

PDF Export: You can print a sheet to a Portable Document Format (PDF) file using the PrintToPdf method in the PrintInfo class. Use the PdfFileName property to specify the file name and location to which to save the file.

Floating Formula Bar and Range Selection for Formula: You can set up a floating formula bar that end users can use to add formulas. The formula bar is similar to the formula editor available to the developer and has the appearance of a text box. The formula bar provides a list of calculation functions. It also provides a visual method of selecting cell ranges for the formula.

Fractions (in Number Cell Type): The number cell can now display values in a fraction format such as 1/100. Set the FractionMode property of the number cell to display values in the fraction format. You can type values such as .01 (which will then display as 1/100) or you can type 1/100 in the cell.

Barcode Cell Type: You can display a barcode graphic in a cell with the barcode cell. Various barcode types are available such as barcodes that are used in retail, the post office, etc. You can set various height and width properties for the barcode display.

Range of Cells as a Data Source and Bind Data Source to Range

Add Row (as in DataGrid)

Automatic Completion (type ahead) for Cell in Column and Selects: You can provide automatic completion (type ahead) from user input to a cell. You would use the IAutoCompleteSupport interface and its properties to provide the automatic completion feature.

Increased Performance

Spread Designer Updates

Color Picker Cell Type: You can allow your end user to select a color from a color picker using the color picker cell. A color picker cell displays a dialog for selecting a color. When a color picker cell is selected it displays a single color, which can appear either in a box or filling the entire area of the cell. Optionally text can be displayed.

What's New in FarPoint Spread for Web Forms V3.0?

Support for Outlook-style grouping (any number of levels)

Microsoft ASP.NET AJAX tested and continued 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

What’s New in Spread for Windows Forms V3?

More Display and Interaction Options

Outlook-style 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. To select a column by which to group and display that data, either double-click on the header of that column or click and drag that column into the grouping bar at the top of the page. You can provide grouping to allow users to sort the data with multiple levels of groups by dragging additional column headers into the grouping area. You can set up the display so that the items are shown initially all expanded or all collapsed when grouping is performed. You can set the colors and other formatting of both the hierarchy names and the data in the rows when grouping is performed.

Performance improvements: when saving or loading files, working with import and export, and when working with large spreadsheets, etc.

New layer that allows controls to be hosted on the sheets: You can place controls on a sheet (not just on the FpSpread component but on a specific sheet) to provide more interaction with the user. Anything that can be derived from the Control class in the .NET framework can be hosted on a sheet in FarPoint Spread. The child control is placed on a separate layer, the controls layer. This is separate from the cells of the data area of the sheet and is separate from the shapes and other graphical elements on the drawing layer

Right-to-Left ( RTL ) support for viewports, columns, rows, the tabstrip, and many other areas: You can handle support for right-to-left layouts in the FarPoint Spread component to support applications where the language is written from right to left, such as Hebrew, Arabic, or Farsi, so the user interface would be displayed naturally with right-to-left orientation. Currently these aspects of the layout are changed with the right-to-left support: column resizing on right instead of left, direction attribute in HTML export, filter and sort indicators, order of columns, popup and sticky notes and cell note indicators, scroll bars, shapes, sheet name tabs, and viewport columns

Event handling to allow custom painting for the sheet tab and gray area

Annotation mode for free-hand drawing

Animated (marquee) focus border: You can customize the focus indicator for the active cell by using the FocusRenderer property of the FarPoint Spread component (which uses the IFocusIndicatorRenderer interface). For animated indicators, you can use the IAnimatedFocusRenderer interface.

Renderer for gradient in header cells

HitTest information for locating cursor (for accessibility compliance): You can use the HitTest method for finding the location of the cursor (pointer) on the spreadsheet component to help with development of applications where accessibility issues are concerned. Whether you are meeting accessibility standards and displaying information for the user based on cursor location, or want to provide additional interactivity based on cursor location, you can use this capability to customize the display and user interaction. You can find whether the cursor is over a part of the header, the tab strip, or a particular viewport of the data area.

More Spread Designer GUI enhancements

Enhanced visual styles property

New default action maps (extend, move, or scroll) based on screen coordinates

More Cell Type Features

New list box cell

New multiple-column combo box cell

Automatic completion for combo box cells

Gradient mode for button cells

Gradient style for progress indicator cells

Picture style for progress indicator cells

New Undo/Redo Actions

With the undo/redo feature, you can add capability to your application to undo various actions in the spreadsheet performed by your end user. You make use of the UndoAction class and several specific classes that correspond with those various user actions. There is also a manager class that keeps track of the end user actions that can be undone and re-done.

Cell editing undo/redo

Clipboard operations undo/redo

Row or column resizing undo/redo

More File Export Options

New save sheet to HTML table: You can save an individual sheet or a range of cells in a sheet to an HTML table in a file or stream if you need to display the sheet in a Web browser. This does not save the entire spreadsheet, only an individual sheet. This saves as much of the formatting information or presentation-related settings as possible, depending on whether that information can be translated to an HTML element or attribute.

New save spreadsheet data to simple XML: You can save the data in the spreadsheet (on an individual sheet) to an XML file or stream if you need to process the data further and want the data in a structured format.

More Formula Capabilities

More formula functions bringing the total to 320 different functions

GoalSeek capability

ROW, COLUMN functions

VALUE function

PartNumbers: PC-515591-143338 515591-143338 PC-515591-143341 515591-143341 PC-515591-143344 515591-143344 PC-515591-143347 515591-143347 PC-515591-143436 515591-143436 PC-515591-143437 515591-143437 PC-515591-143353 515591-143353

Publisher PartNumbers: SBN01 SBS01

PurchaseOptions: Spread for .NET Bundle (Includes Spread for Web Forms V3 and Spread for Windows Forms V4) 1 Developer License , Spread for .NET Bundle (Includes Spread for Web Forms V3 and Spread for Windows Forms V4) 4 Developer Team License , Spread for .NET Bundle (Includes Spread for Web Forms V3 and Spread for Windows Forms V4) 6 Developer Team License , Spread for .NET Bundle with Maintenance (Includes Spread for Web Forms V3 and Spread for Windows Forms V4) 1 Developer License with Maintenance - Includes all updates, major upgrades, email and forum support, and unlimited support calls for one year , Spread for .NET Bundle with Maintenance (Includes Spread for Web Forms V3 and Spread for Windows Forms V4) 4 Developer Team License with Maintenance , Spread for .NET Bundle with Maintenance (Includes Spread for Web Forms V3 and Spread for Windows Forms V4) 6 Developer Team License with Maintenance , Spread for .NET Bundle - Maintenance Renewal 1 Maintenance Renewal License (One Maintenance Required per Developer)

Resources: Read the Spread for Web Forms help file, Farpoint Spread for Windows Forms V4 ReadMe, Read the Spread for Web Forms End User License Agreement (EULA), Read the FarPoint Spread for Windows Forms License Agreement, Download the FarPoint Spread for Web Forms V3.0 evaluation on to your computer - Expires After 30 Days, Download the Spread for Windows forms V4.0 evaluation .NET 2.0 framework build on to your computer - Expires after 30 days, Download the Spread for Windows forms V4.0 evaluation .NET 3.5 framework build on to your computer - Expires after 30 days

Operating System for Deployment: Windows Vista, Windows XP, Windows 2000, Windows NT 4.0

Architecture of Product: 32Bit

Product Type: Component

Component Type: ASP.NET WebForms, .NET WinForms, 100% Managed Code, JavaScript, AJAX

Compatible Containers: Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Studio .NET 2003, Microsoft Visual Studio .NET, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual Basic .NET 2003, Microsoft Visual Basic .NET, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C++ .NET 2003, Microsoft Visual C++ .NET, Microsoft Visual C# 2005, Microsoft Visual C# .NET 2003, Microsoft Visual C# .NET, Delphi 2006 (10.0), Delphi 2005 (9.0), Delphi 8.0, Delphi 7.0, C#Builder, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0, .NET Framework 1.1, .NET Framework 1.0

Product Class: User Interface Components

Search Items: New Product Dec 04, New Product Jan 05, New Product June 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 net bundle, farpoint spread net, farpoint spread bundle, farpoint spread, fpoint spread, farpoint, farpoint tech,