Farpoint Spread for .NET Bundle

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

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.

Our regular prices are shown below. Please logon to see your discounted prices.

Spread for .NET Bundle (Includes Spread for Web Forms V3 and Spread for Windows Forms V4)

Spread for .NET Bundle with Maintenance (Includes Spread for Web Forms V3 and Spread for Windows Forms V4)

Spread for .NET Bundle - Maintenance Renewal

Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase.  All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed above including volume licensing and previous versions.

Our regular prices are shown above. Please logon to see your discounted prices.

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

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