A Grid Control/Component by FarPoint Technologies, Inc.

Spread V7.0

Use FarPoint's Spread 7 to easily incorporate advanced grid and high-level spreadsheet features into your applications. 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 impressive feature list for everything in between; including import/export capabilities, enhanced printing, 14 cell types, formulas, plus many more features you'd expect from the market-leading component.

New Features for Spread 7

• Center page horizontally or vertically for printing


• Control characters (/time and /date) in the header and footer for printing


• Enhanced image type support, including .gif and .jpg


• Expanded text tips (allow >1000 characters)


• LoadTextFile allows up to 32,000 characters for each cell when loading a file


• Hide or show the focus rectangle when the cell has focus


• Automatic positioning of the cursor when going into edit mode


• Column labels convertible (letters to numbers and numbers to letters)


• Align text and images in a button cell


• Maximum column width calculations can include button cells


• Refresh the bound Spread control without affecting headers


• Check box cell has familiar Windows appearance


• Event for scroll tips


• DataLoaded event fires when all data has been loaded from the database

General Features

• Create a spreadsheet with up to 2 billion rows by 2 billion columns


• Define multiple column and header rows


• Merge columns or rows that contain identical data for easier viewing of the data


• Rotate cell or header text 90 degrees, 180 degrees or 270 degrees


• Data can overflow into adjacent empty cells while edit mode is on in a cell


• Type one or more characters to automatically search for an item in the list of a combo box cell


• Use Spread's new Search feaure to find specified text or values in a column or row


• Identify any column by giving it a unique name (useful when moving columns)


• Create a cell span to join multiple cells


• Copy, Move or Swap the data and formatting in a range of columns, rows, or cells in the spreadsheet.


• Set user-defined tags for a specified cell, column, row, or the entire spreadsheet


• 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


• Support the IntelliMouse


• Freeze the top-most rows or the left-most columns from scrolling to allow certain data to be viewed at all times


• Use the Operation modes to set Spread to read-only or let it act as a single or multi-selection listbox


• Import and export spreadsheet files in Microsoft Excel BIFF8 format


• Export spreadsheet files as HTML (version 3.2 and greater) files


• You can export a range of cells or the entire spreadsheet in ASCII text format to a file and specify the delimiters you want to use to separate your data in the file


• Supports OLE drag and drop


• Provide text tips and cell notes


• The Spread control can display scroll tips as users move the scroll box


• You can export a range of cells or the entire spreadsheet in XML format to a file or a buffer


• 27 methods and 20 events have been enhanced for use in scripting environments

Technical Information

Component Type - Contains the following types of components...

• ActiveX Custom Control (OCX)  • Dynamic\Static Link Library

For more information about this product please visit the