Providing the Best User Experience in the Industry
Search Site
High-performance, fully-customizable Spreadsheet for your Microsoft Visual Studio 6 applications

FarPoint Spread Features

New Features | General Features | Cell Formatting | Printing | Sorting and Calculations | Data Binding | Spread Designer
New Features for Spread 7
Back to Top
  • 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