.NET Spreadsheet Top Features
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.
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.
Make your formulas easier to read and improve calculation performance using the new LET function to define local names for intermediate calculation steps.
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.
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.
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.
Use Ctrl+Click to select multiple worksheet tabs for Copy, Cut, Delete, or Hide. Implement custom actions to process multiple selected worksheets.
More functions than in any available .NET spreadsheet, and full customization for your formulas—you’ll take your complex spreadsheets to the next level
With the powerful Spread Desktop Designer App, you’ll get code-free .NET spreadsheet apps in no time.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 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.
Visualize your data in a more compact way with sparkline charts that draw directly inside the cell.
Add a status bar and customize it to show function calculations on the selection and worksheet zoom controls.
Bind the worksheet to any .NET data source including DataSet, DataView, DataTable, or a custom collection of objects, and show hierarchical views with expandable rows and child worksheets.
Create row and column range groups that can expand and collapse rows or columns to create vertical and horizontal outlines.
Create Outlook-style groupings of rows using the built-in group bar and customize group footers with aggregation functions in the footer cells.