Spreadsheetsのニュース

ダブルクリック連続入力で数式を簡単に拡張

4月 26, 2024
Spread.NET v17.1では、セルの塗りつぶしハンドルをダブルクリックすることで、数式を範囲にすばやく適用できるため、数式の効率が向上

英語で読み続ける:

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