Grapecity Spread.NET v14.45.20201
Grapecity Spread.NET v14.45.20201
Explore the possibilities of your .NET enterprise apps with these dependency-free .NET spreadsheet components.
Deliver Excel-like spreadsheet experiences, fast, with desktop designer apps
Create enterprise spreadsheets, grids, dashboards, and forms with the comprehensive API
Powerful calculation engine includes 450+ functions
Import and export Excel spreadsheets
Develop in Visual Studio using VB or C# for WinForms, ASP.NET, and WPF
NEW: v14 NuGet package now supports .NET 5.0, .NET Core 3.1, and .NET 4.52+
A Complete High-Performance .NET App Toolbox in One Spreadsheet Control
Leverage the extensive .NET spreadsheet API and powerful calculation engine to create analysis, budgeting, dashboard, data collection and management, scientific, and financial applications.
High-speed Performance and Optimized App Size
Every platform of Spread.NET ensures maximum performance and speed for your enterprise apps, and its modular structure means you only need to add what you use to your .NET spreadsheet apps.
Code-free Extensibility and Customization with Spread Designers
Instantly design a powerful Excel-like .NET spreadsheet app with our desktop designer apps—no learning curve required. Designers are available for WinForms, WPF, and ASP.NET.
Powerful Calculation Engine includes 450+ Functions
With more built-in functions than other .NET spreadsheets, custom functions, and the formula text box, your computing power is optimized for big data, complex calculations, and advanced Excel models.
Seamless Visual Studio Integration
Build .NET spreadsheet apps in Visual Studio, including VS19, and deploy to Windows 10 with no compatibility issues—and include Excel 2016 themes.
Advanced Data Visualization
Use the many chart types, sparklines, custom data visualization functions and more to enable your users to create the most advanced data visualizations.
Grid-Based Input Forms
Create complex input forms in the free-form grid layout.
Code-free designers for Excel-like design
Excel-like copy and paste
Smart data validation
Checkbox & ComboBox
NEW: NuGet Package for .NET 5, .NET Core 3.1, and .NET 4.52+
Add Spread to your project quickly and easily using NuGet Package Manager, and create new applications for .NET Core 3.1 and .NET 5 Windows targets.
NEW: Cell Data Types for custom .NET objects
Create custom data types and set objects in cells, then use formulas to reference the object's properties in calculations. Use built-in UI or code to insert formulas in adjacent cells and table columns.
NEW: LET Function optimizes formula calculations
Make your formulas easier to read and improve calculation performance using the new LET function to define local names for intermediate calculation steps.
NEW: Edit Points in Enhanced Shapes
Easily create custom shapes using the new Edit Points feature, or create custom shapes in code using the new API to specify the shape points and segments.
NEW: Enhanced Hyperlink Support
Add hyperlinks in cells by simply typing in the link using AutoCreateHyperlink, or use the Edit Hyperlink dialog. Hyperlinks can be applied to shapes or cells, and import/export in XLSX.
NEW: Show Formulas Command
Built-in support for the Show Formulas command allows the user to toggle showing formulas in cells using Ctrl+` just as in Excel.
Enhanced Excel-Compatible Keyboard Shortcuts
Easily enable common Excel keyboard shortcuts in your applications for users. The API allow full customization of the Input and Action Maps to suit your needs.
ultiple Worksheet Select
Use Ctrl+Click to select multiple worksheet tabs for Copy, Cut, Delete, or Hide. Implement custom actions to process multiple selected worksheets.
Powerful, Fast, Optimized Calculation Engine
This high-speed, optimized engine adds computing power to even the most complex formulas without dragging down your apps.
450+ Functions in Customizable Library
More functions than in any available .NET spreadsheet, and full customization for your formulas—you’ll take your complex spreadsheets to the next level
No-Code Design with Spread Designers
With the powerful Spread Desktop Designer App, you’ll get code-free .NET spreadsheet apps in no time.
Import/Export Excel Files into a .NET Spreadsheet
No spreadsheet is complete without full Excel import/export support! Import your most advanced Excel spreadsheets and then export your Spread.NET spreadsheet to XLSX or other file formats... all with zero dependencies on Excel.
Enhanced Shape Engine with Group Shape
Create flowcharts, process diagrams, cell callouts, and more with over 150 shapes, lines, and arrows. Connect and combine into Group Shapes to design logos or custom dashboard controls that can be scripted to perform user actions.
Slicers for Easy Table Filtering Selection
Create Slicers to display table column values for filtering, apply themes, and styles to customize. Cut and paste the Slicer to another sheet to operate as a dashboard control.
Dynamic Array Formulas and Functions to Optimize Your Calculations
Use dynamic array formulas to optimize your calculations by calculating a range of results in one formula with the new functions including FILTER, RANDARRAY, SEQUENCE, SINGLE, SORT, SORTBY, and UNIQUE.
Language Packages for Formulas and Enhance Localization for Users
Localize your cell formulas with 18 new Language Packages to parse and format the formulas using structured references like Excel, or create a new custom Language Package.
Show Precedent and Dependent Cells with Formula Tracing and Auditing
Easily trace your formula's reference chains using built-in formula tracing methods to show arrows from the cell to all dependent or precedent cells, and audit formulas using Dependents, DirectDependents, DirectPrecedents, and Precedents.
XLOOKUP and XMATCH Functions
Optimize your formulas and eliminate the use of the old HLOOKUP, VLOOKUP, and MATCH functions using the new XLOOKUP and XMATCH functions.
Custom Calculation Functions to Extend the Calculation Engine
Create custom calculation functions that implement custom code to perform your calculation and return the result value or dynamic array that can spill to adjacent cells, and optionally allow the end-user to enter formulas using these functions.
Custom Data Visualization using Visual Functions
Create custom data visualization functions that extend the Custom Function feature with new interfaces for applying styling or drawing custom content directly in the cell to create new reusable data visualizations that can be used directly in cell formulas.
Sorting and Filtering
Add filtering and sorting drop-down in a table or range and enable your users to apply filters on colors, text, dates, and numbers.
Apply built-in cell styles using Theme colors, and create new custom cell styles with Number, Alignment, Font, Border, Fill, and/or Protection settings including Pattern and Gradient Fills in the Cell Format.
Conditional Format Rules
Apply Conditional Format Rules in cells and ranges to apply styles based on the cell content or a custom formula, and display icons, data bars, color scales in the cells to quickly visualize values.
Tables and Table Styles
Create tables using built-in table styles or create custom table styles to apply banded columns or rows and custom formatting.
Cell Types, Data Validation
Apply Cell Types, Cell Validators, or IValidation for data validation in cells such as whole number, list, date, time, and custom with input message and error alert.
Cell Comments and Sticky Notes
Add pop-up cell comments that show when the user hovers over the cell note indicator, or apply sticky notes for the cell that remain visible in the sheet with a line indicating the cell.
Apply cell borders with various styles and colors including diagonal line borders, bevel borders, double-line borders and more.
Merged Cells and Cell Spans
Apply row or column merge to automatically merge cells with like data, or apply span cells to data area or header cells to explicitly merge specific cells.
Allow your users to search for text in cells using the built-in Basic Search and Advanced Search dialogs.
Visualize your data with advanced chart types such as Waterfall, Pareto, Funnel, TreeMap, and more.