Spreadsheets 新闻

用电子表格排序简化大型数据集

2月 19, 2026

通过提供精确、多层次控制的高性能电子表格排序实现高效的数据组织和分析。

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:

DevExpress WinForms Spreadsheet (part of DevExpress WinForms) lets you implement advanced data sorting with multi column control while preserving row relationships.
Telerik UI for WinForms Spreadsheet (part of Telerik UI for WinForms) allows you to sort spreadsheet data dynamically, enabling structured views and responsive organization.
MindFusion.Spreadsheet for WinForms facilitates customizable data sorting within spreadsheets, helping developers arrange content logically.
Syncfusion WinForms Spreadsheet (part of Syncfusion Essential Studio Enterprise) performs efficient data sorting across large datasets, ensuring accuracy and flexibility.

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

Compare .NET WinForms Spreadsheet Controls

在 JavaScript 应用中构建协作电子表格

2月 16, 2026

参加 MESCIUS CodeClinic网络研讨会直播，探索 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.

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.

插入列而无需破坏公式

2月 12, 2026

在自动更新单元格引用并保留现有计算的同时，在工作表任意处轻松添加新列。

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

用公式驱动逻辑解锁强大的分析能力

1月 30, 2026

结合计算引擎、跨表格引用和迷你图，将电子表格转变为可靠的数据分析和报表工具。

Formulas, calculations, and logic features form the analytical core of spreadsheet components, enabling data to be transformed into meaningful insights. These capabilities allow spreadsheets to move beyond static data entry by supporting dynamic calculations, rule-based behavior, and real-time feedback as data changes. A robust implementation ensures accuracy, consistency, and performance, making spreadsheets suitable for everything from simple models to complex, enterprise-grade analytical scenarios.

Common features include:

Formula / function support provides a comprehensive library of built-in functions and calculation operators to perform mathematical, statistical, logical, and financial operations.
Cross-worksheet calculations enable formulas to reference data across multiple sheets, supporting complex models and consolidated reporting.
Conditional formatting applies visual rules to cells based on their values or formula results, helping users quickly identify trends, exceptions, or thresholds.
Sparklines offer compact, in-cell visualizations that display data patterns and changes at a glance without requiring full charts.
Data validation enforces rules on data entry, such as value ranges or list constraints, to help maintain data integrity and reduce errors.

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

Explore React Spreadsheet Features

用上下文电子表格评论添加清晰度

1月 30, 2026

通过跨团队和共享电子表格澄清数据和减少误解的单元评论和工具提示加强协作。

Cell comments and tooltips in spreadsheets allow users to attach contextual information to individual cells, displayed on hover or focus without altering the sheet’s layout. They help clarify data, explain formulas and assumptions, and provide guidance for correct data entry, reducing errors and misinterpretation. By keeping explanations close to the data, comments and tooltips improve collaboration, preserve knowledge, and make complex spreadsheets easier to understand and maintain. Common use cases include documenting calculation logic, adding validation instructions, leaving reviewer feedback, explaining exceptions in reports, and supporting onboarding for new users working with shared spreadsheets.

Several .NET Spreadsheet controls offer cell comments/tooltips including:

Aspose.Cells for .NET allows you to programmatically create, read, and manage cell comments and tooltips for automated spreadsheet generation.
Telerik UI for ASP.NET AJAX Spreadsheet (part of Telerik UI for ASP.NET AJAX) allows adding cell comments and tooltips to clarify data and guide users.
EPPlus by EPPlus Software lets you embed and customize cell comments and tooltips to annotate data within Excel-compatible spreadsheets programmatically.
Syncfusion ASP.NET Core Spreadsheet (part of Syncfusion Essential Studio Enterprise) allows you to add cell comments and tooltips that clarify data.

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

Compare .NET Spreadsheet Controls