Spreadsheets 뉴스

선택한 셀에 LAMBDA 함수를 직접 적용하세요

8월 15, 2025
SpreadJS 18.2는 선택한 셀에 LAMBDA 수식을 적용해 결과 값으로 한 번에 바꿀 수 있는 새로운 Transform 명령이 추가되었습니다.

SpreadJS is a high-performance JavaScript spreadsheet and data presentation component designed for enterprise web applications. It enables developers to deliver Excel-like functionality directly within their web solutions, providing advanced features such as data binding, complex calculations, pivot tables, charts, and extensive formatting options. Fully compatible with modern JavaScript frameworks like React, Angular, and Vue, SpreadJS allows seamless integration and customization, empowering development teams to create interactive, data-driven user experiences without relying on external spreadsheet applications.

The SpreadJS 18.2 adds a new Transform command which enables you to apply LAMBDA functions directly to a selected range of cells and replace the original content with calculated results. This simplifies data transformations - whether mapping, filtering, or reshaping - into a clean, single-step process. With this feature, you can select any range and apply a custom LAMBDA formula - for example, converting units, adjusting values, or formatting entries - and have SpreadJS overwrite the selection with the computed results immediately. This removes manual steps like inserting formulas in separate cells, copying values, or pasting back as values. This feature integrates with SpreadJS’s existing LAMBDA capabilities to offer more interactive and efficient spreadsheet manipulation.

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

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.

스프레드시트 데이터를 정밀하게 편집하고 다듬으세요

8월 12, 2025
고급 셀 수준 도구를 사용하면 정확성과 직관적인 상호 작용을 결합하여 스프레드시트 콘텐츠를 쉽게 입력, 서식 지정, 조정할 수 있습니다.

Cell-level editing and interaction features are essential components of any modern spreadsheet application, as they directly influence how users enter, modify, and manage data at the most granular level. These capabilities go beyond basic typing to provide enhanced flexibility, control, and context, enabling users to maintain accuracy while streamlining workflows. A well-designed set of cell-level tools supports both data integrity and user productivity, ensuring that spreadsheets can handle everything from quick updates to complex, structured datasets with efficiency and precision.

Common features include:

  • Cell Comments/Tooltips enable contextual notes or guidance to be attached to specific cells, aiding collaboration and documentation.
  • Cell Formatting provides options for adjusting fonts, colors, borders, and number formats, improving both readability and visual appeal.
  • Clipboard Operations such as cut, copy, and paste simplify moving or duplicating content while preserving formatting and formulas.
  • Find / Replace simplifies locating and updating values across large datasets.
  • In-cell Data Editing allows users to enter or update values directly within a cell for faster, more intuitive workflows.
  • Inserting Columns enables users to add new vertical sections to the spreadsheet, creating space for additional data fields or reorganizing existing content without overwriting adjacent information.
  • Inserting Images enables embedding of visual elements directly into the spreadsheet for richer presentations.
  • Inserting Rows allows the addition of new horizontal entries, supporting expansion of datasets, schedules, or tables while maintaining the integrity of surrounding data.
  • Merging Cells lets users combine multiple cells into one for clear headings or layout adjustments.

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

Explore Angular Spreadsheet Features

더 스마트한 RibbonBar 도구로 UI 디자인을 개선하세요

8월 1, 2025
Spread.NET 18.2에서는 RibbonBar 레이아웃과 아이콘이 더욱 명확하게 향상되어, WinForms 애플리케이션의 디자인 정밀도와 적응력이 개선되었습니다.

Spread.NET by MESCIUS is a powerful tool for building Excel-like applications in your .NET projects. It lets you create interactive spreadsheets, grids, dashboards, and even forms within WinForms, ASP.NET, and WPF applications. With its rich feature set, including a robust calculation engine, formula support, and Excel compatibility, Spread.NET empowers developers to build data analysis tools, budgeting apps, scientific dashboards, and more, all within the familiar .NET environment.

The Spread.NET 18.2 update refines the RibbonBar in WinForms to improve the efficiency and clarity of UI design during development. With expanded icon visibility, developers can more easily access and identify commands, reducing visual ambiguity and speeding up layout tasks. The addition of new layout options for the collapsed state offers greater control over how the RibbonBar adapts to different form sizes, enabling more responsive and space-efficient interface designs. These improvements help streamline the design-time experience, allowing developers to build cleaner, more functional applications with less manual configuration.

To see a full list of what's new in v18.2, 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.

XML을 사용하여 스프레드시트 데이터를 변환하세요

7월 29, 2025
.NET WinForms 스프레드시트 컨트롤은 데이터를 XML로 내보낼 수 있으므로 안정적인 데이터 교환을 위한 일관되고 이식 가능한 형식을 보장합니다.

Export to XML in a .NET WinForms Spreadsheet control allows developers to convert and save spreadsheet data into an XML (Extensible Markup Language) format, preserving the structure, content, and metadata of the spreadsheet in a standardized and portable form. This capability is particularly useful for integrating spreadsheet data with other systems, enabling data exchange, storage, or transformation. By using XML, the exported data can be consumed by a wide range of applications and platforms, making it easier to support interoperability and maintain consistency across different environments.

Several .NET 9 WinForms Spreadsheet controls offer Export to XML including:

  • Spread.NET WinForms by MESCIUS facilitates XML export of worksheet data, enabling integration with XML-based systems and workflows in a structured format.
  • DevExpress WinForms Spreadsheet (part of DevExpress WinForms) allows you to export spreadsheet content to XML, preserving data structure, formatting, and cell-level metadata for reuse.
  • Aspose.Cells for .NET lets you save spreadsheets as XML with full fidelity, supporting formulas, styles, and complex layout configurations.

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

Compare .NET 9 WinForms Spreadsheet Controls

Excel 페이지 전반에서 시각적 개체를 일관되게 유지하세요

7월 22, 2025
Document Solutions for Excel, .NET Edition은 이미지와 도형의 페이지 매김을 지원하며, 시각적 개체를 셀에 고정하여 가독성을 높입니다.

Document Solutions for Excel, .NET Edition by MESCIUS is designed to enable developers to create and manipulate Microsoft Excel documents programmatically within .NET applications. It provides a robust API for interacting with Excel spreadsheets, allowing developers to automate tasks such as data extraction, formatting, and generation of reports. The framework offers comprehensive support for various Excel features, including formulas, charts, conditional formatting, and data validation. It also provides tools for handling large datasets and optimizing performance, making it suitable for both small-scale and enterprise-level applications.

Document Solutions for Excel, .NET Edition improves pagination by enabling images and shapes to stay anchored to their top-left cell, maintaining consistent positioning as content flows across pages. This enhancement ensures that visual elements such as charts, icons, and shapes are treated as part of the cell's content, allowing them to paginate along with the data they relate to. As a result, developers can generate dynamic, multi-page Excel documents with accurate and predictable layouts, without having to manually reposition or reformat visuals. This not only saves time during document generation but also improves the overall quality and reliability of exported reports, forms, and other structured content.

Document Solutions for Excel 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.

Document Solutions for Excel, .NET Edition is available to buy in the following products: