FarPoint Spread for Windows Forms 4 

On the surface, many grids or spreadsheets may look the same. However, like most things, it's the attention to details that separate the average from the best.

With the ability to import and export native Microsoft Excel .xls workbooks, multiple sheets and cross-sheet formula referencing, hierarchical display, grouping and the new outline grouping like Excel, conditional formatting, sorting, row filtering, searching, zooming, undo/redo, data binding or unbound modes, pdf export, and splitter bars, you can create a solution for any application. And that's just the tip of the iceberg. Complete customization at the cell level is possible with the 18 cell types (including the ability to create your own custom cell types), cell spans, multiple headers, shapes, 320 built-in calculation functions, cell tips and notes, and much more.

What does this mean to you?

·         Reduced development time and costs - features you would have to spend hours coding in other grids are only a property setting or line of code away

·         Complete confidence knowing Spread will perform as expected

·         Satisfied customers by making it easy and intuitive for your users to view and update their data

·         Improved developer productivity by using Spread's extensive feature set to program against

·         Guaranteed professional support

·         Timely updates and new versions

·         Knowing you are backed by the industry leader in spreadsheet technology

FarPoint Spread for Windows Forms Feature

·         Multiple Sheets: Use Multiple Sheets to categorize your information, similar to Microsoft Excel.

·         Bound Mode: Use in Bound mode to connect to your favorite data source to display and edit information.

·         Hierarchical view: Display your data in Hierarchical view or Flat view.

·         Multiple Panes: Display data in multiple panes and allow your user to customize their own pane view.

·         Grouping: Allow Outlook-style grouping with any number of levels

·         Undo/Redo: The undo/redo feature allows you to add capability to your application to undo various actions in the spreadsheet performed by your end user

·         Control Layer: You can place any control, including other 3rd party controls, on a sheet that resides on a separate control layer to provide more interaction with the user. This is in addition to the data area where cells are and drawing layer where shapes and other graphical elements are located.

·         Annotation mode: You can add free-hand drawing to the drawing layer of the sheet using annotation mode. Annotation mode allows the user to draw in free-hand mode on the shapes layer and to save the annotation on the sheet as a shape.

·         Sort: Programmatically sort data by rows, columns, a range of rows, a range of columns or a range of cells. Or, allow your users to easily auto sort columns simply by clicking on the column header.

·         320 Built-in Functions: Use the 320 built-in functions or create your own custom functions for Spread's advanced Calc Engine to evaluate, including cross-sheet formula referencing.

·         Drawing shapes: You can use shapes to make draw attention to parts of your spreadsheet or emphasize some information or process involving the use of the spreadsheet. There are several built-in shapes for you to use or you can create your own shape. Each shape can be rotated and resized, and their ability to be rotated and resized by the end user can be constrained.

·         Row filtering: Programmatically sort data by rows, columns, a range of rows, a range of columns or a range of cells. Or, allow your users to easily auto sort columns simply by clicking on the column header.

·         Printing: Specify print ranges and print your spreadsheet data using the optional print preview.

·         Unbound Mode: Use unbound to display and edit any data - no datasource needed.

·         Cell Spans: Create cell spans to join cells together, allowing one cell to span across multiple cells to include, for example, your company logo.

·         Operation Modes: Use the Operation modes to determine how your user can interact with Spread:
Normal, ReadOnly, RowMode, SingleSelect, MultiSelect, ExtendedSelect.

·         Named 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 your coding time and allows you to easily modify the master style so that it will update all related styles accordingly.

·         Intuitive Spread Designer: Use the Spread Designer to save valuable development time by quickly adding data and easily designing the look of the Spread component with no coding required.

·         Zoom: Zoom in and out of the spreadsheet data.

·         Enhanced Scrolling: Use the scrollbar tracking feature to quickly see what row you are on while scrolling through Spread's data.

·         Skins: Use any of the built-in skins to apply a consistent look across controls or quickly create and use your own custom skin. Your custom skin can be shared with your fellow developers to use across the company.

·         Selections: Allow or prevent your user from selecting rows, columns, blocks of cells, or multiple blocks of cells.

·         Objects: Use the Column, Row and Cell objects to quickly take advantage of Spread's extensive feature set.

·         Multiple Line Headers: Use multiple line headers to better organize your column and row information

·         Open: Open Microsoft Excel files, Spread 6/7 files, Spread XML files, and Text delimited files.

·         Save: Save to Microsoft Excel, Spread XML, HTML, XML and Text delimited files.

·         Cell Extensibility: In addition to our included cell types, you can create and use your own custom cell type. For example, you could display another Spread inside a cell, use another control or create your own custom control to display and use.

·         Gradients, Background Images and Alpha Blending: Spread supports background images, alpha blending, and transparent background colors. This allows you to place background pictures in cells, on Spread so all cells bleed through the image, or even place an image on the form and have the image show through Spread

·         Enhanced Keyboard Mapping: You have complete control over how your spreadsheet will react when the user presses any key, including function keys. For example, your could move the focus to the next cell below when the Enter key is pressed or bring up your own custom editor or a calendar when the user presses the F4 key when in a datetime cell.

·         Merge Cells: Automatically merge cells that contain identical information for easier viewing of your data.

·         Cell Overflow: Allow cell contents to overflow to adjacent cells if the data is too long to be displayed in the cell.

·         Cell Notes: Display pop-up cell notes, which contain your own custom text, over any cell.

·         All The Things You Expect: Apply fonts, borders, and colors to an individual cell, range of cells or specified columns and rows.

·         AlternatingRows: Easily customize the display by using AlternatingRows to apply your own distinct look.

·         Full Clipboard Support: Including special paste features that you are used to in Excel.

·         Security: Add security to your data by locking cells from being edited and protecting sheets.

·         Microsoft Excel Look and Feel: If your users are familiar with Excel, they will be comfortable using Spread

·         Extensible Models: Spread's Models allow extensive customization.

·         Complete Cell Customization: Spread is "Cell-centric", meaning you have full control at the cell level in addition to rows, columns and the sheet level.

Use Spread's celltypes 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:

Button, Check box, Combo box, Multi-Column Combo box, Currency, DateTime, General Formatter, Hyperlink, Image, Listbox, Mask, MultiOption, Number, Percent, Progress, Regular Expression, Rich Text, Slider, or Text

Licensing
Licensing is one copy per developer. There are no additional run-time or royalty fees when used in accordance with the license agreement. If you have 10 developers, you will need to purchase 10 licenses and can deploy to any number of users. Please refer to the license agreement for full details.

FarPoint Spread for ASP.NET 4

ASP.NET spreadsheet component to add full-featured spreadsheet capabilities or highly advanced grid functionality to your ASP.NET applications. Our award-winning Spread for ASP.NET frees you from spending tedious hours coding features that are missing in other grids. In Spread for ASP.NET many of those features are only a property setting or line of code away. Take the product tours, read the whitepapers, or download your evaluation today.

Compiled against both the 2.0 and 3.5 Frameworks, Spread for ASP.NET is a complete ASP.NET spreadsheet component that 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.

·         AJAX Support: AJAX allows the component to refresh without refreshing the entire page. This affects several features including expanding and collapsing child sheets in a hierarchical display, column sorting, inserting rows, searching, filtering, paging, and formulas.

·         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.

·         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.

·         Conditional Formatting: You can set up conditional formats within cells that determine the formatting of the cell based on the outcome of a conditional statement. You can use a named style to specify various formatting options such as borders and colors to apply if the condition statement is valid, that is, if the operation is satisfied.

·         Hierarchy: Display multiple levels of data because datasets are getting deeper.

·         Insert and Edit: Allow or prohibit users from inserting and editing data in columns, rows, or cells.

·         Command Bar: A customizable button bar provides an easy and intuitive way for your users to edit, delete, and insert data, control sheet navigation, and control paging. This can be positioned on the top or bottom of the control.

·         Sheets: Each control can contain multiple sheets, similar to Microsoft Excel, allowing you to organize your information on one convenient screen. You can also hide sheets.

·         Unbound: Use in unbound mode to populate columns, rows, and cells using your own data and custom formatting.

·         Multiple Data Changes: Allow multiple data changes, even on multiple rows, without a having to round trip to the server to save your changes.

·         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.

·         Sort: Automatically sort any column in ascending or descending order by double clicking on the header, or programatically sort any range of cells.

·         HTML tables: Use Spread as a replacement for HTML tables, giving you full access to Spreads' advanced formatting options.

·         Operation Modes: Use the Operation Modes to control how selections can be made:
  Normal, ReadOnly, RowMode, or SingleSelect.

·         Spans: Add spans to headers, rows, columns or cells.

·         Cell Customization: Complete customization at the cell level, including setting cell types, tags, alignment, borders, colors, font and margins.

·         Import / Export Data: Import/export Microsoft Excel 97 and higher files and text files. Export to Spread XML.

·         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.

·         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.

·         Frozen Rows and Columns: Using Microsoft Internet Explorer (IE) 5.5 and higher, 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.

·         Load on Demand: You can allow the Web page to load on demand -- as the user scrolls further down the spreadsheet the FarPoint Spread 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.

·         Drag and Move Columns: Moving columns just got easier.You can 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.

·         More Than 300 Built-in Functions: Add calcuations quickly to your web applications by using any of over 300 pre-defined algorithims or add your own custom functions. Spread now supports cross-sheet formula referencing.

·         Custom Messages: Display custom error messages when invalid data has been entered (for example, entering text into a date-time cell).

·         Page Navigation: Customize the navigation of multiple pages of data by displaying page numbers, next and previous arrows, or both. It can be positioned on the top and/or bottom of Spread or on the Command Bar.

·         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. Spread can bind to any data source that supports the IList or IListSource interface.

·         Text Tips: Display custom text tips over any column, row, or cell to display additional information to help your user.

·         Client-Side 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.

·         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.

·         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.

·         Objects: You have complete control over the design of Spread by using the Sheet, Row, Column and Cell objects.

·         Multiple Headers: Add multiple rows and columns to the headers.

·         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.

·         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.

·         Multiple Browsers: Unlike other grids, we recognize the possibility that not every one of your users will be using MS Windows Internet Explorer 6.0. We have done extensive testing with other browsers and versions and, when possible, have added support for these as well. Try that with your current grid!

 
Licensing
Licensing is one copy per developer. There are no additional server deployment fees. If you have 10 developers, you will need to purchase 10 licenses and