FarPoint Spread 8 COM General Features:

• Create a spreadsheet with up to 2 billion rows by 2 billion columns
• Drag and drop data anywhere in the spreadsheet control
• Use the clipboard copy/cut/paste shortcut keys
• Prevent editing of data by locking any cell data
• Create headers by allowing cell data to overflow into adjacent cells
• Freeze the top-most rows or the left-most columns from scrolling to allow certain data to be viewed at all times
• Import and export spreadsheet files in Microsoft Excel BIFF8 format
• Use the Operation modes to set Spread to read-only or let it act as a single or multi-selection listbox
• Use the 33 Action properties to perform tasks, including saving and printing the spreadsheet
• Cell Formatting
• Display up to 32K of data in each cell
• Customize your interface by changing the font and background and foreground colors of any cell
• Highlight any cell or block of cells using six border styles
• Provide the most popular data and database formats using 12 cell types
• Button: Display a push button in a cell, Include text, graphics, or both
• Checkbox: Display a check box, text, and/or picture in a cell, Allow true, false, or grayed states
• Combobox: Display a drop-down list in a cell
• Date: Display or allow editing of formatted dates in a cell
• Support Year 2000 seamlessly
• Edit: Display or allow editing of text in a cell
• Float: Display or allow editing of a formatted floating-point (currency) value in a cell
• Formatted PIC: Display or allow editing of a formatted PIC (mask) in a cell
• Integer: Display or allow editing of an integer value in a cell
• Owner Drawn: Display a user-defined picture using Windows APIs
• Picture: Display a picture in a cell, Choose between .bmp or .ico file formats
• Static Text: Display noneditable, nonscrolling text in a cell
• Time: Display or allow editing of a formatted time value in a cell

FarPoint Spread 8 COM Printing

• Create custom print configurations by specifying margins, page orientation, borders, headers, gridlines, colors, and shadow effects
• Print a block of cells, a range of pages, or only the columns and rows that contain data
• Use the new Print Preview control to see how your printed spreadsheet will look
• Calculate the number of pages to print based on the current print settings
• Query the next page break either by row or column
• Define the starting page number to print in the header of the first page
• Specify the order in which pages are printed (down then across or across then down)

FarPoint Spread 8 COM Sorting and Calculations

• Use up to three keys to sort data by column or row, in ascending or descending order
• Use the Calc Engine to perform complex mathematical functions with named expressions and relative cell addressing
• Add user-defined custom functions for greater flexibility
• Use one of 74 functions (includes 61 new ones) in your formulas
• Sort with up to 256 sort keys
• Recalculate the value of an individual cell
• Retrieve and set data in float or integer cells as numeric values
• Query the list of, retrieve information about, or remove custom functions

FarPoint Spread 8 COM Data Binding

• Automatically save any user-entry changes back to the database
• Increase control by validating when and what data gets written to the database
• Insert unbound columns or load specified fields into a bound spreadsheet
• Increase data access speed by using the Virtual Data Manager to control how many records are read and displayed at a time
• Bind the spreadsheet to ActiveX Data Objects (ADO) 2.0 using OLE DB technology [still supports data binding to Data Access Objects (DAO) and Remote Data Objects (RDO)]

FarPoint Spread's Spread Designer

• Increase productivity and decrease your learning curve by using its unique WYSIWYG interface
• Open and design multiple spreadsheets
• Apply any view from Spread Designer back to the original control
• Use the user-friendly design-time interface that includes dockable toolbars and help balloons

The Excel 2007 methods require the Microsoft .NET 2.0 Framework, must be registered with regasm.exe using the /codebase option, and must ensure that the Spread 8 module is in the same folder as the corresponding Excel2007 dll or can be found in the system path.