Spread.NET makes it possible to produce spreadsheets, grids, dashboards, and types. It features a strong search engine using 450+ works and the capability to export and import Excel spreadsheets. Leverage the extensive .NET spreadsheet API and powerful calculation engine to evaluate, budget, dash, data collection and management, scientific, and financial programs. You can create in Visual Studio using VB or even C# for WinForms, ASP.NET, and WPF. Each stage of Spread.NET ensures optimum speed and performance for your business programs, and its modular structure means you have to add exactly what you use to your .NET recorder programs.
Insert Spread to your job quickly and easily using NuGet Package Manager, and make new programs for .NET Core 3.1 along with .NET 5 Windows targets.
Create customized data types and place items in cells, and then use formulas to mention the item's properties in calculations. Use built-in UI or code to add formulas in adjoining cells and table columns.
Make your formulas easier to read and enhance calculation performance by utilizing the newest LET function to specify domains for intermediate calculation steps.
Easily create custom shapes using the newest Edit Points attribute, or produce customized contours in code with the new API to define the contour points and sections.
Add links in cells by just typing in connection with AutoCreateHyperlink, or use the Edit Hyperlink dialog. Hyperlinks may be applied to cells or shapes and import/export in XLSX.
Built-in support for your Display Formulas command permits the user to toggle displaying formulas in cells with Ctrl+' as in Excel.
Easily enable-shared Excel keyboard shortcuts on your software for users. The API enables complete customization of the Input and Action Maps to fit your requirements.
Use Ctrl+Click to select multiple worksheet tabs for Copy, Cut, Delete, or Hide. Implement customized activities to process numerous selected worksheets.
This high-speed, optimized search engine provides computing power to the most complicated formulas without dragging your programs.
More acts than in virtually any accessible. NET spreadsheet, and complete customization to your formulas--you will take your complicated spreadsheets to another level
Together with the strong Spread Desktop Designer Program, you are going to acquire code-free. NET recorder programs very quickly.
No spreadsheet is complete with no complete Excel import/export support! Publish your advanced Excel spreadsheets, then export your Spread.NET recorder to XLSX or alternative document formats... all without dependencies on Excel.
Create flowcharts, process diagrams, mobile callouts, and much more with over 150 contours, lines, and arrows. Connect and combine to Group Shapes to design logos or custom dash controls scripted to do consumer activities.
Produce Slicers to exhibit table column values such as filtering, use themes, and designs to personalize. Cut and glue the Slicer to a different sheet to function as a dashboard controller.
Use lively array formulas to maximize your calculations by simply calculating various results in 1 formula using all the newest functions such as FILTER, RANDARRAY, SEQUENCE, SINGLE, SORT, SORT BY, and UNIQUE.
Localize your mobile formulas with 18 fresh Language Packages to parse and format the formulas utilizing structured references such as Excel, or create a new custom made Language Package.
Easily follow your formulation's reference chains employing built-in formulation tracing approaches to display arrows in the mobile to all determined or precedent cells, and audit formulas utilizing Dependents, DirectDependents, DirectPrecedents, and Precedents.
Boost your formulas and remove these older HLOOKUP, VLOOKUP, and MATCH functions utilizing the newest XLOOKUP and XMATCH functions.
Produce custom calculation capabilities that apply custom code to do your calculation and return the result value or lively selection that may spill to adjoining cells, and optionally enable the end-user to input formulas utilizing these functions.
Create customized data visualization capabilities that expand the Custom Function attribute with new ports for implementing drawing or styling custom material directly in the mobile to make brand new reusable data visualizations, which may be utilized directly in cell formulas.
Add sorting and filtering drop-down at a desk or variety and empower your customers to use filters on colors, dates, text, and figures.
Employ built-in mobile styles using Theme colors, and make new custom made mobile styles with Number, Alignment, Font, Border, Fill, or Protection settings such as Pattern and Gradient Fills from the Cellular Format.
Apply Conditional Format Rules in cells and ranges to employ styles dependent on mobile content or a customized formulation, exhibit icons, information bars, and color scales from the cells to visualize values rapidly.
Create tables with built-in table designs or make custom table designs to employ banded rows or columns and custom formatting.
Employ Cell Types, Cellular Validators, or validation for information validation in cells like whole amount, record date, time, and habit with input and error awake.
Insert pop-up mobile comments that reveal when the user hangs on the mobile note index, or employ sticky notes to the mobile that stay visible in the sheet using a line indicating the mobile.
Apply cell borders with assorted styles and colors such as diagonal line boundaries, bevel boundaries, double-line boundaries, and much more.
Employ column or row merge to combine cells with similar information or use span cells into information place or header cells to either combine certain cells.
Enable your customers to search for text in cells employing the built-in Basic Search and Advanced Search dialogs.
Visualize your data with advanced chart kinds like Waterfall, Pareto, Funnel, TreeMap, and much more.
Visualize your data in a more streamlined manner with sparkline graphs that draw directly within the cell.
Add a status bar and personalize it to demonstrate purpose calculations on the choice and worksheet zoom controllers.
Bind the worksheet into any. NET data sources such as DataSet, DataView, DataTable, or a custom made a set of items reveal hierarchical viewpoints with expandable rows and kid worksheets.
Produce column and row range groups that may expand and collapse columns or rows to make horizontal and vertical outlines.
Produce Outlook-style groupings of rows with the built-in group pub and customize set footers with aggregation works in the footer cells.
Publish your worksheets with innovative options such as borders, header, footer, best match column or row, and publish scaling.
Customize the look of this workbook and worksheet using built-in skins or custom-made skin working with the Skins Editor.
Utilize touch gestures such as tap, press and hold, slip, swipe, pinch, rotate, extend, and customize the popup signature menu with custom controls.
