GrapeCity Spread is a component suite that helps .NET and javascript programmers produce technology, performance monitors, accounting, risk evaluation, scientific, fiscal, and other enterprise programs. Spread's search engine comprises over 300 works, supports custom purposes, also includes a formulation text box. Produce a numerical version of any kind or permit users to execute their very own ad-hoc calculations.
Spread COM helps you easily incorporate advanced grid and high-tech features into your software. It gives 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; such as import/export capacities, including the capability to export and import Excel 97, 2000 and Excel 2007 documents (requires the .NET Framework). Additionally, it offers improved printing, many cell types, formulas, a 64bit DLL, and many more attributes. Spread COM will permit you to create a spreadsheet with up to 2 billion rows by 2 billion columns.
Spread is intended to link to all significant information resources. Concentrate on designing your program rather than binding info. Distribute exports and imports Excel documents with attributes fully intact. Frequent situations are saving info in Excel to databases, making ad-hoc what-if investigation on jump data, and using Excel to design templates. Spread follows dictionary workflow and interactions fundamentals. Therefore it isn't hard to create dashboards, data views, and enter forms of any sort. Spread provides flexible design and permits you to combine bound and unbound modes, perform calculations, and employ conditional formatting, add graphs, and format tables.
Customize Spread to act precisely how you want using the extensive API. Spread comprises template designer software that looks and acts similar to Excel. They're also able to import Excel documents, which means it is possible, to begin with, templates that you presently have or let non-technical subject matter specialists help you layout forms and views.
Spread comprises a complete calculation engine with over 100 built-in capabilities to give formulation support. Easily add your own custom functions to Spread. You could also use called sayings or relative cell addressing to mention the formulas.
Spread lets you control over-printing options like page ranges, data ranges, headers and footers, margins, orientation, grid lines, and colors. Spread also supports advanced scaling options to match the page's content and APIs for customized printing demands.
The added print preview management makes it effortless to preview the menu that is printed. There are lots of possibilities for controlling your client will preview the information; for example, the number of pages previewed on display and zooming options.
Design Documents with our run-time layout instrument. It enables you to set formatting, properties, data sources, calculations, and much more without writing code. The Learn Mode program records your activities and creates VB code that will help you learn how to use the API and accelerate your development of code for event handlers.
Spread can automatically retrieve and display data from ActiveX objects (ADO), Data Access Objects (DBO), and Remote Data Objects (RDO). Spread will produce the right columns, configure headers, make suitable cell types, and permit the user to upgrade the database.
Spread's bound manner is strong, Spread is equally powerful when loading information from several different sources like Microsoft Excel, CSV, tab-delimited documents, and custom-delimited documents. Virtual Mode events supply the API for loading rows and buffering the rows in a digital page.
Spread will export and import your information to numerous file formats such as Excel .xls and .xlsx, XML, HTML, .SS* (Spread proprietary structure ), tab-delimited, and comma-delimited. Excel files may be exported without formulas.
Among the most effective characteristics of Spread is your capability to validate information automatically. Spread offers two built-in cell types configured to accept only a specific kind of information input, and a custom made cell type that could use any controller for editing from the cell.
Operation modes control the way your clients can interact with Spread. By way of instance, you may make Spread read-only or have it behave as a listing box. Row Mode is created for data binding usage instances that edit a row and then flame the LeaveRow occasion.
All border layout attributes such as depth, color, and design are all encouraged. Create abundant reports with thick and thin lines, dotted lines, outlines, touch lines and much more, quickly and easily with the Spread Designer instrument or API.
Insert cell text and notes suggestions to provide users extra info. Cellular Notes are indicated by a red dot at the corner of the cell and if clicked, data seems. Text suggestions are similar except that they look on hover.
Lock certain cells entire sheets out of editing. Shield worksheets with or without a password, and also limit user actions such as column and row insertion, deletion, resizing, and much more. Safe your formulas and stop others from viewing your proprietary information.