Notícias sobre Spreadsheets

Permita cálculos entre planilhas em uma pasta de trabalho

Março 13, 2026
Referencie células em outras planilhas para estabelecer cálculos conectados que mantenham os dados relacionados organizados e dinamicamente conectados.

Cross-worksheet calculations allow spreadsheet components to reference and compute values across multiple sheets within the same workbook. This capability enables developers to build more advanced data models, where formulas can pull information from different worksheets to support summaries, aggregations, and linked analysis. By allowing data to be organized across separate sheets while remaining connected through formulas, applications can present complex datasets in a structured and scalable way without sacrificing calculation accuracy or performance.

Several Angular spreadsheet controls offer support for cross-worksheet calculations including:

  • SpreadJS by MESCIUS enables formulas to reference cells and ranges across worksheets, allowing developers to create linked calculations across multiple sheets.
  • Infragistics Ignite UI for Angular Spreadsheet supports cross-sheet formulas that allow values from different worksheets to be combined in calculations.
  • Syncfusion Angular Spreadsheet includes built-in formula support that references cells in other worksheets, making it possible to perform calculations across different tabs.
  • Jspreadsheet Pro provides cross-sheet references within formulas, enabling calculations that draw values from other worksheets to support multi-sheet data organization.

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

Compare Angular Spreadsheet Controls

Produza gráficos de cascata Excel mais limpos

Março 5, 2026
O Pine BI Excel Add-In v2.1 melhora as fórmulas em cascata, permitindo conjuntos de dados mais limpos, cálculos transparentes e maior controle sobre totais.

The Pine BI Excel Add-In facilitates the rapid generation of sophisticated and interactive Excel charts, enabling the transformation of standard workbooks into engaging dashboards that improve data visualization. These easily shareable visuals can also be integrated into Microsoft Word and PowerPoint, improving the creation of impactful reports and presentations across various business applications.

The Pine BI Excel Add-In v2.1 update improves waterfall chart functionality by introducing rebuilt formulas that support a cleaner and more consistent data structure. Instead of relying on automatically calculated totals that required blank fields, developers can now explicitly define which values act as totals within the dataset. This approach simplifies data preparation, removes the need for automatic final totals, and makes chart calculations more transparent and predictable. As a result, developers can create and maintain waterfall visualizations more efficiently, particularly when working with complex financial or analytical models.

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

Pine BI Excel Add-In is licensed annually on a subscription basis with 1, 5, and 10 seat options, requiring renewal for continued use and covering each concurrent computer, with the ability to transfer individual seat activation's as needed. See our Pine BI Excel Add-In licensing page for full details.

For more information, explore the Pine BI Excel Add-In product range.

Simplifique grandes conjuntos de dados com ordenação em planilhas

Fevereiro 19, 2026
Possibilite a organização e análise eficiente dos dados com ordenação de planilhas de alto desempenho que oferece controle preciso e multinível.

Data sorting in a spreadsheet is the process of arranging data in a specific order such as alphabetically, numerically, or by date based on one or more columns. It enables users and developers to quickly organize large datasets, improve readability, and surface meaningful insights such as top performing products, recent transactions, or lowest inventory levels. By supporting multi level sorting, for example by region and then by revenue, spreadsheets maintain row integrity while delivering structured and analysis ready views of data. Common use cases include ranking sales performance, organizing customer lists, managing financial records, preparing reports, and enhancing interactive data grids within business applications.

Several .NET WinForms spreadsheet controls allow you to sort data, including:

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

Compare .NET WinForms Spreadsheet Controls

Construa planilhas colaborativas em aplicativos JavaScript

Fevereiro 16, 2026
Participe do webinar ao vivo MESCIUS CodeClinic para explorar o complemento Collaboration Server para SpreadJS.

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 leverages a high-speed calculation engine with over 500 Excel built-in functions in 19 languages to deliver true Excel-like spreadsheet experiences with zero dependencies on Excel and full support for React, Vue, Angular, and TypeScript.

On Thursday, February 26th at 11:00 AM EST, MESCIUS (formerly GrapeCity) will be presenting a CodeClinic Live Webinar highlighting the new Collaboration Server as a production-ready solution for real-time, multi-user spreadsheet editing in enterprise JavaScript applications. During this webinar, SpreadJS Product Manager Chris Bannon and Product Marketing Manager Mackenzie Albitz will take you through the following key takeaways:

  • How the SpreadJS Collaboration Framework enables low-latency, conflict-free editing in JavaScript applications.
  • The architecture behind the Sheets Collaboration Optional Add-On and how it converts workbook changes into synchronized operations.
  • How real-time presence, selections, and multi-user awareness are implemented.
  • How collaborative undo/redo works in concurrent editing scenarios.
  • Permission models for balancing collaboration with control in enterprise apps.

Register for the Live Webinar today and mark your calendar for February 26th.

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.

Insira colunas sem desestruturar as fórmulas

Fevereiro 12, 2026
Adicione novas colunas com facilidade em qualquer lugar na planilha enquanto atualiza automaticamente as referências às células e mantém os cálculos existentes.

Inserting columns in a spreadsheet allows users to expand worksheets dynamically while preserving existing data and formulas. This capability is essential for scenarios where datasets evolve over time, such as adding new fields, categories, or calculated values. A well-implemented insert columns feature ensures that cell references, formatting, and formulas adjust automatically, helping maintain data integrity and reducing the risk of errors during updates.

Several ASP.NET Core spreadsheet controls offer the ability to insert columns including:

  • DevExpress ASP.NET Core Spreadsheet (part of DevExpress ASP.NET and Blazor) enables users to insert one or multiple columns at any position in a worksheet, automatically updating formulas.
  • Telerik UI for ASP.NET Core Spreadsheet (part of Telerik UI for ASP.NET Core) allows columns to be inserted through both the user interface and APIs, ensuring that cell references are preserved.
  • Syncfusion ASP.NET Core Spreadsheet (part of Syncfusion Essential Studio Enterprise) provides options to insert columns with full support for formula recalculation.

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

Compare ASP.NET Core Spreadsheet Controls