FarPoint Spread What's New

All features listed above, plus...
Define multiple column and header rows
Merge columns or rows that contain identical data for easier viewing of the data
Create a cell span to join multiple cells
Use Spread's new Search feature to find specified text or values in a column or row
Rotate cell or header text 90 degrees, 180 degrees or 270 degrees
Identify any column by giving it a unique name (useful when moving columns)
Automatically display negative numbers as red in currency, number, and percent cells
Set user-defined tags for a specified cell, column, row, or the entire spreadsheet
Type one or more characters to automatically search for an item in the list of a combo box cell
New Percent cell type
Enhanced Currency cell type
Enhanced Number cell type
Data can overflow into adjacent empty cells while edit mode is on in a cell
Display a spin button in a currency, date, number, percent, or time cell
Copy, Move or Swap the data and formatting in a range of columns, rows, or cells in the spreadsheet.

All features listed above, plus...
Define multiple column and header rows
Merge columns or rows that contain identical data for easier viewing of the data
Create a cell span to join multiple cells
Use Spread's new Search feature to find specified text or values in a column or row
Rotate cell or header text 90 degrees, 180 degrees or 270 degrees
Identify any column by giving it a unique name (useful when moving columns)
Automatically display negative numbers as red in currency, number, and percent cells
Set user-defined tags for a specified cell, column, row, or the entire spreadsheet
Type one or more characters to automatically search for an item in the list of a combo box cell
New Percent cell type
Enhanced Currency cell type
Enhanced Number cell type
Data can overflow into adjacent empty cells while edit mode is on in a cell
Display a spin button in a currency, date, number, percent, or time cell
Copy, Move or Swap the data and formatting in a range of columns, rows, or cells in the spreadsheet.
Cells in the Spread control can have notes associated with them
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
Users can sort by clicking column headers using built-in sort
Users can print a spreadsheet to an owner-defined area of the page, allowing you to print multiple items on a single page.
Cells can display ellipsis points when left-aligned text is too long to fit in the cell
New mathematical and other functions are provided by the Calc Engine
Improved Spread Designer
You can set the pop-up calendar text for a specific Spread control
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
27 methods and 20 events have been enhanced for use in scripting environments

All features listed above, plus...
Define multiple column and header rows
Merge columns or rows that contain identical data for easier viewing of the data
Create a cell span to join multiple cells
Use Spread's new Search feature to find specified text or values in a column or row
Rotate cell or header text 90 degrees, 180 degrees or 270 degrees
Identify any column by giving it a unique name (useful when moving columns)
Automatically display negative numbers as red in currency, number, and percent cells
Set user-defined tags for a specified cell, column, row, or the entire spreadsheet
Type one or more characters to automatically search for an item in the list of a combo box cell
New Percent cell type
Enhanced Currency cell type
Enhanced Number cell type
Data can overflow into adjacent empty cells while edit mode is on in a cell
Display a spin button in a currency, date, number, percent, or time cell
Copy, Move or Swap the data and formatting in a range of columns, rows, or cells in the spreadsheet.
Cells in the Spread control can have notes associated with them
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
Users can sort by clicking column headers using built-in sort
Users can print a spreadsheet to an owner-defined area of the page, allowing you to print multiple items on a single page.
Cells can display ellipsis points when left-aligned text is too long to fit in the cell
New mathematical and other functions are provided by the Calc Engine
Improved Spread Designer
You can set the pop-up calendar text for a specific Spread control
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
27 methods and 20 events have been enhanced for use in scripting environments
Bind the spreadsheet to ActiveX Data Objects (ADO) 2.0 using OLE DB technology
Import and export spreadsheet files in Microsoft Excel 97 format (BIFF 8) -- 32-bit versions only
Export spreadsheet files as HTML (version 3.2 and greater) files -- 32-bit versions only
Use the new Print Preview control to see how your printed spreadsheet will look
Enhance a combo box cell using the FarPoint List Pro fpCombo control, available separately
Supports OLE drag and drop
Load data from or save data to an integer or float array
Provide text tips
Use one of 74 functions (includes 61 new ones) in your formulas
Sort with up to 256 sort keys
Disable or change the F2, F3, and F4 special editing keys
Set more than one border color and style for the same cell
Provide different colors for alternating rows
Define a custom mouse pointer for drag-and-drop operations
Make the scroll bar track mouse movement throughout the spreadsheet
Specify the vertical alignment of the contents in all cell types
Customize the background and text color for selected cells
Choose whether or not to include headers when copying data to the Clipboard
Create a Windows 3.1 or Windows 95 appearance for the control
Display short and long day and month names in the popup calendar
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
Allow the width of a combo box cell to change based on the width of the widest item
Specify the number of rows in the drop-down list of a combo box cell
Set the minimum and maximum date ranges (including the century)
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)
Fire events when the user changes text while in edit mode, when the list drops down in a combo box cell, when the combo box closes, and when the user selects another item or reselects the same item in a combo box cell
Support the IntelliMouse

Have a question?

RSS Subscribe

Top 10 Publisher and Top Best Seller Award

"In the first month we have estimated that we have saved over 40 man hours programming time alone having implemented Spread 6 and ListPro 3. This though is only half the story. The main benefit is that the software we have developed works well and fulfils our clients needs far better than it would have with any other products.

Congratulations on providing superlative products backed by excellent support"

Grant Spencer

"Thinking back over the 2 years that we've been using Spread, it occurs to me that we have never had a single problem with Farpoint, from the sales staff, to the support staff, to the products themselves. In my position, anything that I can mark off of my "worry list" is a valuable asset. Thanks Farpoint."

Ronnie Applewhite

"Spread made it possible to deliver an intuitive application that allows management to forecast sales trends in a fraction of the time it normally would have taken to complete. Keep up the great work!"

Larry Smith