Spread COM

Add advanced spreadsheet functionality to your applications.

Published by MESCIUS (formerly GrapeCity)
Distributed by ComponentSource since 1996

Prices from: $ 1,476.52 Version: 8.0.29 Updated: Oct 13, 2020 5.00 Star Average Review5.00 Star Average Review5.00 Star Average Review5.00 Star Average Review5.00 Star Average Review (9)

i

Please Note: As a result of prevailing industry trends, recent updates affecting Windows compatibility with ActiveX controls, and the discontinuation of support by Microsoft for legacy COM and ActiveX technologies, MESCIUS will discontinue technical support for Spread COM.

Technical support for Spread COM will end on 3/31/2024. After that date, only licensing support will be provided. The MESCIUS...

Show more

Please Note: As a result of prevailing industry trends, recent updates affecting Windows compatibility with ActiveX controls, and the discontinuation of support by Microsoft for legacy COM and ActiveX technologies, MESCIUS will discontinue technical support for Spread COM.

Technical support for Spread COM will end on 3/31/2024. After that date, only licensing support will be provided. The MESCIUS Spread COM forums will remain open indefinitely.

About Spread COM

Add advanced spreadsheet functionality to your applications.

Spread COM helps you easily incorporate advanced grid and high-level spreadsheet features into your applications. It offers flexibility at the cell level for maximum control over the display and entry of the data, plenty of events to respond to user changes and an impressive feature list for everything in between; including import/export capabilities, including the ability to import and export Excel 97, 2000 and Excel 2007 files (requires the .NET Framework). It also offers enhanced printing, many cell types, formulas, a 64bit DLL and many more features. Spread COM will allow you create a spreadsheet with up to 2 billion rows by 2 billion columns.

Spread COM Features

  • Calculation Engine - 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.
  • Print Support - 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 the 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.
  • Data Binding - 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.
  • Unbound Mode - 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.
  • File Import/Export - 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.
  • Data Validation - 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.
  • Cell Borders - 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.
  • Text Tips - 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.