Using Spread you can quickly create powerful database front-ends, easily manage the display and entry of up to two billion items, print flexible reports, perform complex calculations, read and write files, sort data, or simply take advantage of its unsurpassed cell-level formatting.
Features
GeneralCreate 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 i>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
- 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
/ul> - Checkbox
- Display a check box, text, and/or picture in a cell
- Allow true, false, or grayed states
- 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 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 - 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 - 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
li>Retrieve and set data in float r 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 - 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
li>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 - 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