FarPoint Spread Features

• Multiple sheets
• Cross-sheet formula Referencing
• Unicode support
• Moving rows or columns allowed, with visual indication
• New scientific notation cell type and number formatting
• Faster, improved sorting
• Enhanced Spread Designer
• Customize the colors, widths, and heights of the scroll bars
• Double-click the header to automatically resize the column to the widest text
• Scalable (percentage) printing
• Fit-to-page printing
• 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
Back to Top

• 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

Cell Formatting
Back to Top

• Display up to 32K of data in each cell
• Customize your interface by changing the font and background and foreground colors of any cell
• Set more than one border color and style for the same cell
• Customize the background and text color for selected cells
• Cells in the Spread control can have notes associated with them
• Cells can display ellipsis points when left-aligned text is too long to fit in the cell
• Automatically display negative numbers as red in currency, number, and percent cells
• Display a spin button in a currency, date, number, percent, or time cell

• Provide the most popular data and database formats using 14 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
• Currency
  • Display or allow editing of a currency value 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
• Formatted PIC
  • Display or allow editing of a formatted PIC (mask) in a cell
• Number
  • Display or allow editing of a numeric value in a cell
• Owner Drawn
  • Display a user-defined picture using Window's APIs
• Percent
  • Creates a percentage cell
• Picture
  • Display a picture in a cell
  • Choose between .bmp or .ico file formats
• Scientific Notation
  • Supports the display and entry of Scientific Notation
• Static Text
  • Display noneditable, nonscrolling text in a cell
• Time
  • Display or allow editing of a formatted time value in a cell

Printing
Back to Top

• 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 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)
• Users can print a spreadsheet to an owner-defined area of the page, allowing you to print multiple items on a single page.

Sorting and Calculations
Back to Top

• Use up to 256 keys to sort data by column or row, in ascending or descending order
• Users can sort by clicking column headers using built-in sort
• 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 106 functions in your formulas
• 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
• Query the list of, retrieve information about, or remove custom functions

Data Binding
Back to Top

• Bind the spreadsheet to ActiveX Data Objects (ADO) 2.0 using OLE DB technology
• 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

Spread Designer
Back to Top

• 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