Spreadsheets 新闻

Easily Extend Formulas with Double-Click Fill Down

4月 26, 2024
Spread.NET v17.1 enhances formula efficiency with the ability to quickly apply formulas to a range by double-clicking a cell's fill handle.

Spread.NET by MESCIUS helps you create spreadsheets, grids, dashboards, and forms. It includes a powerful calculation engine with 450+ functions and the ability to import and export Microsoft Excel spreadsheets. Developers can leverage the extensive .NET spreadsheet API and powerful calculation engine to create analysis, budgeting, dashboard, data collection and management, scientific, and financial applications.

The Spread.NET v17.1 update introduces a streamlined method for extending formulas across datasets by allowing users to double-click the fill handle located at the bottom right corner of a selected cell. This action automatically replicates the formula down to the end of the data range, aligning it with the rows in adjacent columns. By simplifying the process of copying formulas, this feature enhances both efficiency and accuracy in data management tasks. It eliminates the need for manual drag-and-fill operations, reducing the time spent on repetitive tasks and minimizing the risk of inconsistencies in data entry. This improvement is particularly advantageous for users working with extensive datasets, facilitating quicker data processing and a more user-friendly experience in spreadsheet management.

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

Spread.NET is licensed per developer and is available as a Perpetual License with a 12 month support and maintenance subscription. We can supply any Spread.NET license including new licenses, maintenance renewals, and upgrade licenses. See our Spread.NET licensing page for full details.

For more information, visit our Spread.NET product page.

用模板快速创建 Excel 电子表格

4月 19, 2024
Document Solutions for Excel v7.1 具有重构的 DsExcel 模板，可提高性能、稳定性并处理更广泛的用户需求。

继续用英语阅读:

Document Solutions for Excel, .NET Edition (DsExcel) is a high-performance spreadsheet API library that enables .NET developers to create, manipulate, and generate Excel documents within their applications entirely independent of Microsoft Excel. DsExcel boasts a fast and lightweight design and features cross-platform and cross-framework compatibility. It includes a powerful calculation engine that handles over 450 Excel functions and allows for the creation of custom functions for complex calculations.

The Document Solutions for Excel v7.1 update includes enhancements to DsExcel templates which prioritize performance and stability to cater to a broader range of use cases. This includes improved handling of missing data sources, new OverwriteFillFormat functionality to operate in both Pagination and non-Pagination modes, expanded support for image and shape elements, optimized processing for merged cells, and backwards compatibility with older templates to ensure a smooth transition for existing users.

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

Document Solutions for Excel, .NET Edition is licensed per developer and is available in several license options for differing distribution needs. Team licenses are also available for multiple developers within the same organization. See our Document Solutions for Excel, .NET Edition licensing page for full details.

Learn more on our Document Solutions for Excel, .NET Edition product page.

直接在单元格中编辑 WPF 电子表格数据

4月 16, 2024
单元格内编辑无需单独的数据输入字段，使数据输入和修改更快、更直观。

继续用英语阅读:

In-cell data editing refers to the functionality within spreadsheet software that allows users to directly click on and modify the contents of a cell without the need for separate data entry forms or pop-up dialogs. This feature allows for quicker and more direct changes to the data displayed on the screen, enhancing productivity by reducing the steps required for data manipulation.

Several .NET 8 WPF spreadsheet controls support in-cell data editing including:

  • DevExpress WPF Spreadsheet (part of DevExpress WPF), lets you directly edit cell data with robust validation and conditional formatting options in the WPF environment.
  • Spread WPF (part of Spread.NET by MESCIUS) facilitates seamless in-cell data manipulation and real-time calculation updates, enhancing productivity for WPF applications.
  • Telerik WPF Spreadsheet (part of Telerik UI for WPF), enables efficient data entry and editing within cells, complete with support for formulas and data formats in WPF.
  • MindFusion.Spreadsheet for WPF allows users to easily modify and manage cell content interactively, supporting complex data types and customization in WPF.

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

Compare .NET 8 WPF Spreadsheet Controls

用附加组件提升您的 JavaScript 电子表格

4月 9, 2024
MESCIUS 提供的 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. Leverage the 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. Fully customize your application’s needs with SpreadJS’s optional deployment add-on components for Pivot Tables UI, and an Excel-like Designer ribbon, allowing your users to perform complex interactive analysis and data visualization.

MESCIUS has created a brief but informative video blog that highlights the functionality of these powerful add-ons:

  • Designer Ribbon - for seamless toolbar integration
  • PivotTable - for robust data analysis
  • GanttSheet - for project management
  • ReportSheet - for easy report design

View the Video Blog and learn how to effortlessly upgrade your JavaScript spreadsheets.

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.

动态汇总大型数据集

4月 4, 2024
利用 .NET 电子表格控件中的数据透视表功能来简化您应用程序中的数据浏览和分析。

继续用英语阅读:

.NET spreadsheet controls with built-in pivot table functionality empower developers to seamlessly integrate robust data analysis into their applications. This feature allows users to effortlessly rearrange and aggregate large datasets, gaining insights through customizable views without modifying the original data. Pivot tables streamline decision-making by simplifying complex tasks like sorting, filtering, and visualizing information, ultimately enhancing the usability and effectiveness of these spreadsheet applications.

Several .NET Spreadsheet controls support pivot tables including:

  • DevExpress WPF Spreadsheet (part of DevExpress WPF) offers advanced pivot table functionality for dynamic data analysis, enhancing usability and decision-making.
  • Document Solutions for Excel, .NET Edition by MESCIUS enables seamless integration of pivot tables into .NET applications for efficient data summarization and analysis tasks.
  • Aspose.Cells for .NET provides robust pivot table functionality, allowing developers to efficiently summarize and analyze large datasets within their .NET applications.
  • EPPlus empowers developers with pivot table capabilities in Excel files, facilitating dynamic data analysis within .NET applications effortlessly.

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

Compare .NET Spreadsheet Controls