Advanced Excel-Like Functionality With Winforms Spreadsheet Components

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:

• CSV, Text I/E
• Excel I/O
• HTML
• Open Password-Protected File
• PDF Export

This high-speed, optimized engine adds computing power to even the most complex formulas and includes support for:

• External Variables Integrate the Calculation Engine
• Language Packages for Calculations
• Data Visualization Functions (VisualFunction)
• Auto-Formatting Formula Values

More than 450 functions in categories including Date and Time, Engineering, Financial, Information, Logical, Lookup and Reference, Math and Trig, Statistical, Text, and Web:

• 450+ Functions
• External Cross-Workbook references
• Insert Structured Table References in Formulas
• Custom Formula Calculation Functions

Dynamic Arrays are a powerful new calculation feature which enables a single formula to return results that spill to adjacent cells and optimize calculations:

• Dynamic Arrays and Spilled Range Operator
• FILTER, RANDARRAY, SEQUENCE, SINGLE, SORT, SORTBY, UNIQUE Functions

Complete table support including context menus, table insert row and column, table formulas with structured references:

• Adding a Table
• Resizing a Table
• Sorting a Table
• Table Styles
• Table Formula

Create filters in tables, sheets, or a cell range using AutoFilter then filter and sort and by Value, Fill, or Icon:

• Advanced Filter and Sort on Cell Range
• Filter Bar Controls
• Allow the User to Filter Rows
• Enhanced Row Filtering
• Cell Range AutoFilter
• Advanced Search Dialog

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:

• Connecting Shapes
• Grouping Shapes
• Shape Themes and Styles
• Shape Action

All the built-in user interface elements you expect in a spreadsheet, formula UI tools, range drag-fill and drag-drop, undo-redo, common spreadsheet keyboard shortcuts and more:

• Formula Textbox
• Data Validation
• Range Drag-Fill and Range Drag-Drop
• Globalization and IME
• UI Undo/Redo
• Key Mapping

Fully customize the cell format and style with the new IStyle interface and flat-style model to create cell styles using built-in styles like Accent1 or Currency, merge styles to create custom styles, and easily apply Office themes to change your fonts, color scheme, or effects:

• Gradient and Pattern fill
• Lock Cells
• Merge Cells
• Number Formatting
• Office Themes