Neuigkeiten zu Spreadsheets

KI-Formelhilfe zu JavaScript-Anwendungen hinzufügen

Juli 23, 2026
Konfigurieren Sie SpreadJS AI Assistant mit einem benutzerdefinierten Ollama-Modell, damit er anwendungsspezifische Tabellenkalkulationsformeln generieren und erklären kann.

SpreadJS is a complete enterprise JavaScript spreadsheet solution used to create financial reports and dashboards, budgeting and forecasting models, scientific, engineering, healthcare, education, science lab notebooks, and other similar JavaScript business applications. It delivers true Excel-like spreadsheet experiences with zero dependencies on Excel, with full support for React, Vue, Angular, and TypeScript.

In this blog post, MESCIUS Product Manager Chris Bannon shows you how to connect the SpreadJS AI Assistance add-on to a custom-trained Ollama model so it can generate and explain application-specific spreadsheet formulas without requiring you to manually unpack every function, reference, and operator. Steps include:

  • Create the Custom Spreadsheet Function
  • Put the Function in a Real Workbook Context
  • Add the Formula Editor Panel and AI Assistant Add-on
  • Connect SpreadJS AI to Your Own Endpoint
  • Teach the Model About the Custom Formula
  • Create the Local Ollama Model

Detailed code is included to help you along the way.

Read the complete blog and get started unlocking the power of the SpreadJS AI Assistant.

SpreadJS is licensed per developer and includes 1 Year Maintenance (major and minor version releases and unlimited support phone calls). SpreadJS requires an Annual or Perpetual Deployment License. The optional Add-ons are available at an additional cost, and require a SpreadJS license. See our SpreadJS licensing page for full details.

For more information, visit our SpreadJS product page.

Erweitern der Unterstützung für Tabellenkalkulationsformeln

Juli 17, 2026
DevExpress WinForms 26.1 integriert die Unterstützung für sechs neue dynamische Array-Excel-Funktionen und erleichtert so die Analyse komplexer Daten.

DevExpress WinForms is a comprehensive suite of 190+ UI controls and development tools designed for building high-performance desktop applications. It offers a broad array of customizable controls, from data grids and ribbon interfaces to advanced charts, maps, and diagramming components. This empowers developers to rapidly create functionally rich applications, while adhering to accessibility guidelines and touch-enabled technology for modern Windows environments.

The WinForms Spreadsheet Control in version 26.1 adds support for six new dynamic array-based Microsoft Excel functions: XLOOKUP, XMATCH, SORT, SORTBY, FILTER, and UNIQUE. These additions make it easier to search, sort, filter, and organise spreadsheet data while reducing the need for complex formulas. By matching Microsoft Excel calculation behaviour more closely, the control also helps improve compatibility with existing workbooks and delivers a more familiar experience for users.

To see a full list of what's new in version 26.1, see our release notes.

DevExpress WinForms is licensed per developer and is available as a Perpetual License with a 12 month support and maintenance subscription. See our DevExpress WinForms licensing page for full details.

DevExpress WinForms is available individually or in the following products:

Durchführen arbeitsblattübergreifender Berechnungen

Juli 16, 2026
Erlauben Sie Benutzern, arbeitsblattübergreifende Berechnungen durchzuführen, indem Sie bei der Verwendung von Formeln in Vue.js-Anwendungen Daten aus einem anderen Blättern hinzuziehen.

Cross-worksheet calculations allow formulas in one worksheet to reference cells, ranges, or named ranges located in another worksheet within the same spreadsheet. This capability enables related data to be organized across multiple worksheets while preserving links between them, reducing duplicated information, improving consistency, and making complex spreadsheet models easier to manage and maintain.

Several Vue.js spreadsheet components allow you to perform cross-worksheet calculations, including:

  • SpreadJS by MESCIUS supports cross-worksheet calculations through formulas that reference cells and ranges on other worksheets, with automatic recalculation.
  • Jspreadsheet Pro provides cross-worksheet formula references, allowing calculations to combine data from different worksheets within the same workbook.
  • Syncfusion Vue Spreadsheet (part of Syncfusion Essential Studio Enterprise) includes cross-sheet formulas, allowing references and calculations across multiple worksheets.

For an in-depth analysis of features and price, visit our comparison of Vue.js spreadsheet components.

Compare Vue.js Spreadsheet Components

Teilen von Tabellenkalkulationsdaten mit Professional Printing

Juli 16, 2026
Drucken Sie Tabellenkalkulationen mit genauer Formatierung, optimierten Layouts und flexiblen Ausgaben für professionelle Berichte, Dokumentation und Offline-Prüfungen.

Printing spreadsheets enables users to produce high quality hard copies of worksheets while preserving formatting, tables, charts, images, and page layouts. Features such as print preview, page scaling, margins, and page break controls help ensure content fits correctly on the page, reducing the need for manual adjustments and improving readability. This makes spreadsheet printing valuable for business reports, financial statements, invoices, schedules, inventory lists, project plans, and other documents that need to be shared in meetings, distributed to stakeholders, archived for compliance, or reviewed offline.

Several .NET WinForms spreadsheet components enable printing, including:

  • DevExpress WinForms Spreadsheet (part of DevExpress WinForms) lets you print spreadsheets with accurate layouts and preserved formatting.
  • Telerik UI for WinForms Spreadsheet (part of Telerik UI for WinForms) allows you to generate printed worksheets with customizable page settings and consistent presentation.
  • Aspose.Cells for .NET facilitates spreadsheet printing with advanced print options preserving charts, tables, formatting across multiple pages consistently for reporting.
  • MindFusion.Spreadsheet for WinForms lets you create print ready spreadsheets with flexible layouts for invoices, schedules, reports, and documentation needs efficiently.

For an in-depth analysis of features and price, visit our comparison of .NET WinForms spreadsheet components.

Compare .NET WinForms Spreadsheet Components

Verbessern der Datenanalyse von Tabellenkalkulationen

Juli 14, 2026
.NET-Tabellenkalkulationskontrollen bieten Funktionen zur Datenfilterung und -gruppierung, die Entwicklern helfen, große Datensätze zu analysieren und die Navigation zu verbessern.

Data Filtering and Grouping in a .NET spreadsheet control enables developers to organize and display worksheet data more effectively by allowing users to filter rows based on specific criteria and group related rows or columns into expandable sections. These capabilities make it easier to work with large datasets, focus on relevant information, improve worksheet navigation, and present data in a more structured way without modifying the underlying content. By supporting familiar Excel-style functionality, data filtering and grouping also help create more intuitive business applications while maintaining compatibility with spreadsheet workflows.

Several .NET Spreadsheet controls offer data filtering and grouping including:

  • DevExpress WinForms Spreadsheet (part of DevExpress WinForms) lets you filter data dynamically and group worksheet content for clearer analysis and navigation.
  • Spread.NET by MESCIUS, allows you to apply flexible filters and create collapsible groups across worksheets for enhanced data exploration.
  • EPPlus lets you implement filtering and grouping features programmatically while preserving structured spreadsheet views and user productivity.
  • IronXL for .NET by Iron Software lets you apply data filtering and grouping features programmatically while maintaining Excel-compatible worksheet organization.

For an in-depth analysis of features and price, visit our comparison of .NET Spreadsheet controls.

Compare .NET Spreadsheet Controls