When you need high-performance, fully-customisable spreadsheet/grid components, join professional developers around the world who consistently turn to FarPoint Spread for powerful, extendable spreadsheet solutions. With FarPoint Spread, you get unmatched flexibility at the cell level for maximum control over the display and entry of the data, plenty of events to respond to user changes, and an extensive list of built-in calculation functions. And you`re guaranteed a quick learning curve using the Spread Designer, a design-time tool with a point-and-click interface. The different versions of FarPoint Spread are:
Spread ActiveX/COM - Spread 8 COM is a high-performance, fully-customisable Spreadsheet for your VB6 applications Spread ASP.NET - Provides powerful spreadsheet capabilities and advanced grid functionality to your ASP.NET web applications Spread BizTalk - Provides a complete solution for integrating Microsoft Excel documents seamlessly into your BizTalk applications. Spread Windows Forms - Powerful, feature-packed spreadsheet component for Windows Forms applications built on the .NET framework Spread Suite for .NET - Combines Spread for Windows Forms and Spread for ASP.NET into one great package
Key Features 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.
SkinsUse 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.
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