Spread for Windows Forms [4.x Upgrade from Spread Win 2.5 with 1 YR Maintenance (Electronic)]

General Features

PDF Export

• You can print a sheet to a Portable Document Format (PDF) file using the PrintToPdf method in the PrintInfo class. Use the PdfFileName property to specify the file name and location to which to save the file.

Floating Formula Bar and Range Selection for Formula

• You can set up a floating formula bar that end users can use to add formulas. The formula bar is similar to the formula editor available to the developer and has the appearance of a text box. The formula bar provides a list of calculation functions. It also provides a visual method of selecting cell ranges for the formula.

Fractions (in Number Cell Type)

• The number cell can now display values in a fraction format such as 1/100. Set the FractionMode property of the number cell to display values in the fraction format. You can type values such as .01 (which will then display as 1/100) or you can type 1/100 in the cell.

Barcode Cell Type

• You can display a barcode graphic in a cell with the barcode cell. Various barcode types are available such as barcodes that are used in retail, the post office, etc. You can set various height and width properties for the barcode display.

Range of Cells as a Data Source and Bind Data Source to Range

Add Row (as in DataGrid)

Automatic Completion (type ahead) for Cell in Column and Selects

• You can set provide automatic completion (type ahead) from user input to a cell. You would use the IAutoCompleteSupport interface and its properties to provide the automatic completion feature.

Increased Performance

Spread Designer Updates

Color Picker Cell Type

• You can allow your end user to select a color from a color picker using the color picker cell. A color picker cell displays a dialog for selecting a color. When a color picker cell is selected it displays a single color, which can appear either in a box or filling the entire area of the cell. Optionally text can be displayed.

Appearance Features

Outline Grouping

• You can set the display of the spreadsheet component to allow rows or columns to be grouped as an outline according to the headers. This behavior of the outline grouping is similar (but with subtle differences) from Excel and OpenOffice. This feature is also called range grouping since it operates on a range of rows or columns.

Cell Note Indicator Customisation

Sheet Corner Customisation

Edit Control Style Customisation (MS Excel-like focus indicator)

Text Rendering

New Default Header Renderers (and ability to highlight selected headers)

Export-to-Excel Features

• Excel 2007 XML Support (XLSX)

• Import/Export Images to Excel (XLS only)

• Import/Export Validation List to Excel (ComboBoxCellType to Excel)

• Export View-Driven Version of Data to Excel with ExcelSaveFlag

• Export Alternating Rows Settings (AlternatingRow properties) to Excel

Other Additions

• Add DataColumnName etc. to GetPreferredColumnWidth

• Hybrid Data Model Option - by sheet of whether to use hybrid data model - sparse matrix/linear optimization for small sizes, etc.

• Events for During Resize - Add events that fire as the user is resizing columns or rows, not when finished

• Event for printing header/footer to custom header/footer per page and other enhanced printing options. (HeaderHeight and FooterHeight properties to PrintInfo as well as PrintHeaderFooterArea event for customisable header and footer printing. Event contains the page number being printed.)

• Allow user to double-click row header to auto resize the row height (as done for double-clicking column header to resize the column width).

• TickLength for Slider - so easier to see ticks and when new TickColor is changed easier to distinguish

• Enumeration to have no sorting on the filter item list

• Frozen Rows and Columns in Child View (leading only, not trailing)

• IReuseEditorControl - interface for cell types to reuse editor control instead of creating and disposing it every time

• Grouping enhancements - Ability to change text in group bar area. Group info area background event text

• New skins and themes

Cell Property Features

• Button Cell Format - Ability to display buttons in a cell
• Check Box Cell Format - Ability to display check boxes in a cell
• Currency Cell Format - Cells that display and validate currency values
• Date Cell Format - Cells that display and validate date values
• Drop-Down Lists - Ability to have a drop-down list in a cell
• General Cell Format - Cells that automatically format values depending on data, similar to Excel
• Hyperlink Cell Format - Cells that display hyperlinks
• Number Cell Format - Cells that display and validate numeric values
• Time Cell Format - Cells that display and validate time values
• Multiple Option Cell Format - Cells that display multiple options (radio buttons)
• Percent Cell Format - Cells that display and validate percentages
• Progress Bar Cell Format - Cells that display progress indicator bars
• Slider Bar Cell Format - Cells that display slider bars
• Drop-Down Calendar - Ability to have a drop-down calendar in a cell
• Custom Drawing - Ability to custom draw cells, known as Owner Draw
• Read-Only Cells - Ability to make cells read-only or locked
• Edit - Ability to edit data in a cell
• Cell Alignment - Ability to control horizontal and vertical alignment at column and/or cell level
• Cell Merge - Ability to automatically merge cells with identical content into a single cell
• Spin Edit - Ability to increment or decrement data in a cell via an up-down control
• Cell Spans - Ability to join cells to span across multiple rows or columns
• Cell Type Extensibility - Ability to create and use your own custom cell type in a cell
• Cell Notes - Ability to include notes in any cell, similar to Excel
• Styles (font, size, etc.) - Ability to control the format of the text in a cell
• Background Color - Ability to choose a background color for cells
• Cell Tips and Scroll Tips - Ability to add ToolTips to cells and scroll bars
• Customise Borders - Ability to change the appearance of grid borders
• Word-Wrap - Ability to wrap text in a cell
• 3-D Effects - Ability to add 3-D effects to cells
• Conditional Formatting - Ability to format cells based on specified condition
• Image Cell Format - Cells that display specified images
• Rich Text Cell Format - Cells that display and handle Rich Text Format (RTF) content
• List Box Cell Format - Ability to have a list display in a cell
• Regular Expression Cell Format - Cells that display and validate regular expressions
• Selection Method - Ability to determine how items can be selected by the user

Grid Property Features

• Grid Line Display - Ability to show horizontal and/or vertical grid lines
• Grid Line Color - Ability to customise the color of the grid lines
• Alpha-Blend - Ability to add a background image with transparency
• Automatic Column Size - Columns are automatically resized based on data length
• Reusable Grid Layouts - Ability to save and load grid layouts
• Excel-Like Splits - Ability to split rows and columns similar to Excel's Split function
• Fixed, Nonscrolling Columns - Ability to fix or freeze multiple columns
• Fixed, Nonscrolling Rows - Ability to fix or freeze multiple rows
• Hierarchical View - Ability to view data in a hierarchical way
• Worksheet Support - Ability to have multiple worksheets
• Rows or Columns Hide - Ability to hide rows or columns
• Column Styles - Ability to set styles to entire columns
• Multiline Column Header - Column header with multiple lines
• Multiline Row Header - Row header with multiple lines
• Multiple Blocks Select - Ability to select or prevent multiple blocks of cells
• Selection Modes - Ability to determine how your user to select items
• Reusable Styles - Ability to create styles that be shared with other items
• Skin Support - Ability to apply pre-defined and custom skins
• Multiple Alternating Row Styles - Ability to apply multiple alternating row styles, not limited to every other row
• Selection Styles - Ability to customise the selection colors
• Cell Overflow - Ability to allow text to overflow to adjacent cells if the data is to long to fit in the cell
• Rows or Columns Insert - Ability to insert rows and columns at run time
• Rows or Columns Delete - Ability to delete rows and columns at run time
• Rows or Columns Move - Ability to move rows and columns
• Data Clear - Ability to clear data from cells, row and columns
• IntelliPoint Mouse Support - Support for the IntelliPoint mouse scrolling and zooming
• Row Filtering - Ability to filter rows based on specified criteria
• Visual Styles - Ability to specify the visual style such as XP themes
• Custom Cell Focus Indicator - Ability to customise the focus indicator for a cell
• Multiple Sheet Support - Ability to have multiple worksheets

Grid Method Features

• User Sort - Ability to sort data displayed in the grid by clicking on a column header
• Programmatic Sort - Ability to programmatically sort data by multiple columns, rows or range of cells
• Search - Ability to find data in the grid based on a search criteria
• Print - Ability to print the grid
• Print Preview - Ability to preview the grid
• Calculations - Ability to perform complex calculations with custom and built-in functions
• Formula Cell Reference - Ability to define absolute or relative cell addressing
• User Formulas - Ability to allow or prevent the user from entering formulas
• Custom Functions - Ability to create your own custom functions
• Clipboard Support - Full clipboard support
• Zoom - Ability to zoom in or out of the data
• Rows or Columns Resize - Ability to allow or prevent the user from resizing columns and rows and run-time
• Custom Labels - Ability to customise the labels for row or column headers using custom text
• Drag and Drop Features - Ability to drag and drop cells, rows, or columns
• OLE Drag and Drop - OLE Drag and Drop
• Built-In Functions - Over 300 built-in functions for formulas

Programming Models

• Axis Model - Models for the rows and columns
• Data Model - Models for the data
• Selection Model - Models for the selection behavior and interaction
• Span Model - Models for cell spans
• Style Model - Models for cell styles
• Cell Helper Object - Helper objects for programming with the Cell object
• Cells Helper Object - Helper objects for programming with the Cells object
• Column Helper Object - Helper objects for programming with the Column object
• Column Header Helper Object - Helper objects for programming with the ColumnHeader object
• Columns Helper Object - Helper objects for programming with the Columns object
• Row Helper Object - Helper objects for programming with the Row object
• Row Header Helper Object - Helper objects for programming with the RowHeader object
• Rows Helper Object - Helper objects for programming with the Rows object
• Sheets Helper Object - Helper objects for programming with the SheetView object

Import and Export Features

• Excel Import and Export - Ability to import or export Microsoft Excel 97 and higher files
• Text Import and Export - Ability to import or export any delimited file
• Spread XML Import and Export - Ability to import or export Spread XML files

Data Connection

• Unbound Mode (Full) - Full unbound support with no need for a bound column
• ADO.NET Support - Connects to a data source via ADO.NET

Grid Navigation

• Tab Behavior - Ability to control the standard behavior in response to the user selecting the Tab key
• Full Keyboard Support - Grid provides expected behavior for standard keys
• Keyboard Mapping - Ability to customise the navigation of the control depending on the key pressed

Additional Features

• Extensible Object Interface - Extensible Object Interface
• WYSIWYG Design-Time Editor - Ability to customise the control at design-time with no coding required
• Drawing Shapes - Ability to draw shapes on a presentation layer of the spreadsheet

Licensing is one copy per developer. There are no additional run-time or royalty fees when used in accordance with the license agreement. If you have 10 developers, you will need to purchase 10 licenses and can deploy to any number of users. Please refer to the license agreement for full details.