The easy-to-use, intuitive Spread Designers make creating detailed spreadsheets, input forms, or datagrid screens quick and painless. Design new forms or edit existingsheets using the Excel-like, visual, drag-and-drop UI—all without writing code. You can even import an Excel file to start.
Spread includes a powerful calculation engine that allows you to quickly add formulas to your applications by using any of the 300+ pre-defined functions. Spread also supports custom functions and cross-sheet formula referencing.
All the Editable and Graphical Cell Types You Will Ever Need
Just like Excel, you are not limited to having the same celltype for columns only. Cell types can be set for individual cells, a range of cells, columns, rows, or an entire sheet.
Data Visualization Controls
Give your data a voice with the data visualization functionality provided in Spread. Recognize trends, isolate out-of-range values, and gain a clear understanding of your data.
Every Popular Chart Type
Create impressive 2D & 3D charts at design time using the Spread Designer and Chart Designer, or through code using the comprehensive Chart object model. Charts can be bound to external data sources, and you can allow end-users to make changes to the chart formatting at run time.
Sparklines are tiny charts drawn directly inside cells to provide a visual representation of your data, right next to the data itself. Spread supports multiple sparklines, plus the ability to import/export sparklines to Excel.
Change the appearance of a cell range based on conditions. Use visualizations such as data bars, color scales, and icon sets to help you visually answer specific questions about your data, highlight interesting cells or ranges of cells, and emphasize unusual values.
MultiRow works when typical a grid view just won't do. It displays single data rows in a multi-line template you design with a Visual Studio-integrated drag-and-drop designer. This is more than a simple row template that you see in most grids. You can assign cell types to individual fields and place them anywhere you like. This makes creating complex displays and input forms easy. A common example is a Bill of Materials or invoice that may have a name and address in a header and multiple line items below. MultiRow combines the best of spreadsheets and grids by giving you control over layout, individual cell types, calculations, bound and unbound modes, data valiadation, and tabular display in a very easy to use package.