Nouvelles Spreadsheets

Ajoutez une assistance IA dédiée aux formules dans les applications JavaScript

Juillet 23, 2026
Configurez l’assistant IA SpreadJS avec un modèle Ollama personnalisé afin qu’il puisse générer et expliquer les formules des feuilles de calcul spécifiques à l’application.

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.

Développez la prise en charge des formules de feuille de calcul

Juillet 17, 2026
DevExpress WinForms 26.1 ajoute la prise en charge de six nouvelles fonctions Excel de tableaux dynamiques, facilitant l’analyse complexe des données.

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:

Calculez sur plusieurs feuilles de calcul

Juillet 16, 2026
Permettez aux utilisateurs d’effectuer des calculs croisés en référence aux données d’une autre feuille lors de l’utilisation de formules dans les applications Vue.js.

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

Partagez les données des feuilles de calcul avec l’impression professionnelle

Juillet 16, 2026
Imprimez des feuilles de calcul avec un formatage précis, des mises en page optimisées et une sortie flexible pour des rapports professionnels, de la documentation et une revue hors ligne.

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

Améliorer l’analyse des données dans les feuilles de calcul

Juillet 14, 2026
Les widgets de feuille de calcul .NET intègrent des fonctions de filtrage et de regroupement des données qui permettent aux développeurs d'analyser de grands volumes de données et d'en faciliter la navigation.

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