Spread COM Key Features
Spread includes a very comprehensive calculation engine with over 100 built-in functions to provide formula support. Easily add your own custom functions to Spread. You can also use named expressions or relative cell addressing to reference the formulas.
Spread gives you control over printing with options such as page ranges, data ranges, headers and footers, margins, orientation, grid lines, and colors. Spread also supports advanced scaling options to fit the content in the page and APIs for custom printing requirements.
Print Preview Control
The included print preview control makes it easy to preview the printed spreadsheet. There are several options for controlling how your customer will preview the data, including the number of pages that will be previewed on the screen and zooming options.
Visual Template Designer
Design spreadsheets with our run-time design tool. It lets you set properties, formatting, data sources, calculations, and more without writing code. The Learn Mode tool records your actions and generates VB code to help you learn how to use the API and speed your development of code for event handlers.
Spread can automatically retrieve and display information from ActiveX objects (ADO), Data Access Objects (DBO), and Remote Data Objects (RDO). Spread will create the appropriate columns, configure headers, and create the proper cell types, and allow the user to update the database.
While Spread's bound mode is powerful, Spread is equally effective when loading data from many other sources such as Microsoft Excel, CSV, tab-delimited files, and custom-delimited files. Virtual Mode events provide the API for loading rows dynamically and buffering the rows in a virtual page.
Spread will import and export your data to multiple file formats including Excel .xls and .xlsx, XML, HTML, .SS* (Spread proprietary format), tab-delimited, and comma-delimited. Excel files can be exported with or without formulas.
One of the most powerful features of Spread is the ability to validate data automatically. Spread provides fourteen built-in cell types that are configured to accept only a certain type of data input, and a custom cell type that can use any control for editing in the cell.
Multiple Operation Modes
Operation modes control how your customers can interact with Spread. For example, you can make Spread read-only or have it act as a list box. Row Mode is designed for data binding use cases which edit a row and fire the LeaveRow event.
All border design properties including thickness, color, and style are supported. Create rich reports with thin and thick lines, dotted lines, outlines, signature lines and more, quickly and easily using the Spread Designer tool or API.
Add cell notes and text tips to give users additional information. Cell Notes are indicated by a red dot in the corner of the cell and when clicked, information appears. Text tips are similar except they appear on hover.
Sheet and Cell Protection
Lock specific cells or entire sheets from editing. Protect worksheets with or without a password, and restrict user actions like row and column insertion, deletion, resizing, and more. Secure your formulas and prevent others from seeing your proprietary data.