A Complete VB.NET Spreadsheet With Over 450 Excel Functions

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.

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.

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 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.

Allow your users to search for text in cells using the built-in Basic Search and Advanced Search dialogs.

Add a status bar and customize it to show function calculations on the selection and worksheet zoom controls.

Customize the appearance of the workbook and worksheet using built-in skins, or create a custom skin using the Skins Editor.

Use touch gestures including tap, press and hold, slide, swipe, pinch, rotate, and stretch, and customize the popup touch menu with custom commands.

Add new Freeform: Shape and Freeform: Scribble shapes in your workbooks using the new Enhanced Shape Engine.

The new Enhanced Camera Shape enables dynamic updates to the cell range displayed using a simple formula. Easily create rich and dynamic dashboards that update based on user selections.

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.

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.

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.

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.

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.

Import and Export XLSX containing rich text including colors, fonts, superscript and subscript using the new Features.RichText property to enable this feature.

Make your formulas easier to read and improve calculation performance using the new LET function to define local names for intermediate calculation steps.

Built-in support for the Show Formulas command allows the user to toggle showing formulas in cells using Ctrl+` just as in Excel.

This high-speed, optimized engine adds computing power to even the most complex formulas without dragging down your apps.

More functions than in any available VB.NET spreadsheet, and full customization for your formulas—you’ll take your complex spreadsheets to the next level.

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.

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.

Optimize your formulas and eliminate the use of the old HLOOKUP, VLOOKUP, and MATCH functions using the new XLOOKUP and XMATCH functions.

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 new custom functions using the new LAMBDA Function and formula syntax by defining a custom name, then used in other cells like built-in functions.

Use the new LAMBDA helper functions MAP, REDUCE, SCAN, MAKEARRAY, BYCOL, BYROW, and ISOMITTED to create advanced LAMBDA functions with Spread.NET 15!