About Spread.NET

A collection of spreadsheet components and designers for WinForms, ASP.NET, WPF, and WinRT.

Spread.NET helps you deliver multi-functional spreadsheets in less time with Visual Studio.Create analysis, dashboard, data collection and management, scientific, and financial applications for Windows and web. The Spread.NET 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.
    • 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.
  • 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. Also: 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 spreadsheet specifics like 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.
    • Themes - Spread includes themes from Office 2003 through 2016 and other professionally designed skins. Create your own with the skin editor.
    • 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. Embed a portion of one sheet on another in a floating object.