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