GrapeCity Spread Studio

Enterprise .NET Spreadsheet Components

Develop in .NET, ASP.NET, WPF, and WinRT

Use as a spreadsheet, grid, input form, or dashboard

Read/write native Microsoft Excel™ files

Spread Studio is a multi-functional spreadsheet that professional Visual Studio developers use to create analysis, dashboard, data collection and management, scientific, and financial applications for Windows and web. The Spread Studio package includes .NET spreadsheet components, template designers, charting components, calculation engine, API, and much more.

Familiar Spreadsheet UI

Workbook Support

Present data in a grid, a single spreadsheet, or in a multiple sheet workbook. However you choose to display data, you get features such as a function library, grouping, sorting, filtering, and conditional formatting.

Spreadsheet Authoring

Whether you are working in bound or unbound mode, users will enjoy an easy click-to-edit spreadsheet authoring workflow.

Style and Formatting

Format cells exactly the way you wish with features such as fonts, alignment, merging, borders, and shading. Apply data type formatting, such as currency, to cells.

Spreadsheet Features and Excel Compatibility

Excel-like Data Display

Sort, filter, group, and outline flat and hierarchical data to get the view you need. Table formatting and conditional formatting are also supported.

Excel Features

Give your users the spreadsheet features they expect such as drag-fill, drag move, hidden columns, hidden rows, shapes, cell protection, and frozen panes.

Excel Import/Export Support

Spread imports Excel files with features, formatting, and security rules intact. If the Excel file has a feature unsupported in Spread, it will still be preserved upon Excel export.

 

Print and Print Preview

Full Set of Print Options

Spread fully supports printing and includes a print settings and preview window you can display in your applications.

Print API

Customize Print behavior to your specifications by coding against the print API.

PDF Export

Export and share your spreadsheet views to platform independent PDF files.

Modern Technology

Works with Microsoft’s Latest Releases

Spread Studio is fully tested in Visual Studio 2015 and Windows 10. It can also import/export Excel 2016 files and includes Excel 2016 themes.

The Latest Versions of All Modern Browsers

ASP.NET applications created with Spread Studio will run in the latest releases of Google Chrome, Microsoft Internet Explorer, Microsoft Edge, Mozilla Firefox, and Safari. Touch interactions are also supported.

All .NET Development Platforms

Spread Studio includes components for Windows Forms, WPF, ASP.NET, and WinRT.

 

Visual Designers for Creating Spreadsheets, Data Views, Dashboards, and Input Forms

Spreadsheet Designer Application

Included application helps you lay out data views and forms in a familiar Excel-like interface. Use it to create new forms or import Excel files.

Spreadsheet Designer Component

Embed the spreadsheet designer component in your applications to give your end-users ad-hoc data view design features.

Powerful Calculation Engine

Built-in Function Library

Choose from over 300 functions and apply them to individual cells, rows/columns, or entire sheets.

Advanced Function Support

Take advantage of cross-sheet referencing, structured formulas, and array formulas. You can also create your own custom functions.

Formula Text Box Control

Add an Excel-like formula text box to your applications.

Cell Types for Data Input, Validation, and Display

Editable Cell Types

Choose from a library of cell types, such as date or number, that automatically add input controls and enforce data validation rules.

Graphical Cell Types

Cell types, such as barcode, button, and image are included to display data in a specific format.

Custom Cell Types

Spread is fully extensible, so you can create your own cell types tailored to your needs.

 

Powerful Charting Features

Complete Chart Collection

Visualize data with over 80 chart types such as line, column, financial, polar, and radar. Multiple axes and 3D charts are also supported.

Chart Component

Spread adds a separate chart component to your toolbox so you can use the chart anywhere in your application.

Chart Designer

Use the point-and-click designer to select a chart type, select data, format axes, design series, and more.

More Features

 

 

Dashboards

Use Spread to create complete dashboards, giving your decision makers a snapshot of the current trends or KPIs to make informed decisions.

 

Sparklines

Show data trends with column, line, and win-loss Sparklines.

 

Conditional Formatting

Add conditional elements such as performance indicators, icon sets, data bars, and color scales.

 

Tables

Format data sets with features such as pre-defined table styles, automatic filtering, sorting, structured references, and named items.

Cell Formatting

Full styling options for text, alignment, borders, and colors.

Format data for numbers, currency, dates, images, links, buttons, and more.

 

Cell Borders

All border design properties including diagonal borders, thickness, color, and style are supported.

 

Flexible Data Binding

Bind individual cells, ranges, tables, or entire sheets to any data source. Mix bound and unbound modes on the same sheet.

 

Groups, Outlines, and Subtotals

Organize and summarize your data with Excel-like automatic and manual groups, outlines, and subtotals.

 

Clipboard Support

Spread fully supports clipboard operations including those specific to spreadsheets such as paste all cell info or only data, formatting, or formulas.

 

Sorting and Filtering

Give your users Excel-like sorting and filtering features including Outlook-style drag and drop functionality.

Sorting and Filtering

Themes

Spread includes themes from Office 2003 through 2016 and other professionally designed skins. A skin editor is also included so you can create your own.

Fully Documented API

Customize your Windows Forms, ASP.NET, WPF, and WinRT applications to fit your needs with Spread’s comprehensive API.

 

Scroll Tips

Show a tooltip containing a content preview on the scroll bar as a user scrolls.

 

Localization Support

Spread controls honor culture settings for symbols such as currency, will render any character set, and you can localize interface strings. Double-byte characters and right-to-left layout are also supported.

 

Camera Shapes

Camera shapes allow you to embed a live view of a range and place it anywhere else in the workbook. This gives you a way to embed a portion of one sheet on another in a floating object.

Multiple Headers

Cell Merging

Named Items

Search

 

Shapes

Comments

Zoom

Sheet and Cell Protection