Spreadsheets 뉴스

피벗 테이블로 대규모 데이터 세트를 더 빠르게 분석하세요

3월 17, 2026
Jspreadsheet Pro는 유연한 그룹화, 필터링, 정렬, 접이식 뷰를 통해 스프레드시트 데이터를 요약하는 강력한 피벗 테이블이 추가되었습니다.

Jspreadsheet Pro is a flexible JavaScript-based spreadsheet solution that enables developers to create customizable, feature-rich data grids for web applications. It offers advanced formulas, data validation, and API integrations. Ideal for tasks like financial modeling, inventory management, and project tracking, it helps businesses efficiently manage and analyze data.

Jspreadsheet Pro introduces pivot table functionality that allows developers to summarize and analyze large datasets directly within browser based spreadsheet applications. It enables users to group data across multiple rows and columns, apply aggregation methods such as sum or average, and refine results through filtering and sorting. With built in spreadsheet formulas and cross worksheet references, developers can provide interactive data analysis capabilities without requiring external tools or additional backend processing.

Jspreadsheet Pro is licensed as an Annual or a Perpetual License with support and maintenance. We can supply any Jspreadsheet Pro license including new licenses, maintenance renewals, and upgrade licenses. See our Jspreadsheet Pro for full details.

For more information, visit our Jspreadsheet Pro product page.

일관된 스프레드시트 디자인을 위해 테마를 적용하세요

3월 16, 2026
사용자 정의 테마로 스프레드시트 디자인을 개선하세요. 맞춤형 테마를 적용하면 일관된 색상과 글꼴이 즉시 반영되어 데이터를 더 명확하게 표현할 수 있습니다.

Spreadsheet themes provide a consistent visual style by applying coordinated colors, fonts, and formatting across an entire workbook. Instead of manually styling individual elements, users can quickly apply a theme to ensure tables, charts, and data ranges follow the same design. This improves readability, enhances data presentation, and helps maintain a professional and cohesive look across reports. Themes are particularly useful when creating business dashboards, financial reports, or shared team documents, where consistent formatting and clear visual hierarchy make data easier to interpret and align with company branding.

Several JavaScript spreadsheet controls offer support for applying themes including:

  • Kendo UI jQuery Spreadsheet (part of Kendo UI) by Telerik lets you apply consistent styling with customizable themes that unify fonts, colors, and formatting.
  • SpreadJS by MESCIUS allows you to implement reusable spreadsheet themes that standardize visual styles across worksheets, improving clarity and branding consistency.
  • Infragistics Ultimate UI for jQuery Spreadsheet (part of Infragistics Professional) facilitates spreadsheet styling with theme based formatting that aligns colors, fonts, and layouts.
  • Jspreadsheet Pro enables developers to style spreadsheets with configurable themes that create consistent visual structure and enhance readability across web based tables.

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

Compare JavaScript Spreadsheet Controls

워크시트 간 스프레드시트 계산 활성화

3월 13, 2026
다른 시트의 셀을 참조하여 관련 데이터를 체계적으로 관리하고 동적으로 연결된 계산을 구현하세요.

Cross-worksheet calculations allow spreadsheet components to reference and compute values across multiple sheets within the same workbook. This capability enables developers to build more advanced data models, where formulas can pull information from different worksheets to support summaries, aggregations, and linked analysis. By allowing data to be organized across separate sheets while remaining connected through formulas, applications can present complex datasets in a structured and scalable way without sacrificing calculation accuracy or performance.

Several Angular spreadsheet controls offer support for cross-worksheet calculations including:

  • SpreadJS by MESCIUS enables formulas to reference cells and ranges across worksheets, allowing developers to create linked calculations across multiple sheets.
  • Infragistics Ignite UI for Angular Spreadsheet supports cross-sheet formulas that allow values from different worksheets to be combined in calculations.
  • Syncfusion Angular Spreadsheet includes built-in formula support that references cells in other worksheets, making it possible to perform calculations across different tabs.
  • Jspreadsheet Pro provides cross-sheet references within formulas, enabling calculations that draw values from other worksheets to support multi-sheet data organization.

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

Compare Angular Spreadsheet Controls

더 깔끔한 Excel 워터폴 차트를 생성하세요

3월 5, 2026
Pine BI Excel Add-in v2.1은 워터폴(waterfall) 수식이 개선되어 더 깔끔한 데이터 세트와 투명한 계산 과정을 제공하며, 합계 항목을 더욱 정밀하게 관리할 수 있습니다.

The Pine BI Excel Add-In facilitates the rapid generation of sophisticated and interactive Excel charts, enabling the transformation of standard workbooks into engaging dashboards that improve data visualization. These easily shareable visuals can also be integrated into Microsoft Word and PowerPoint, improving the creation of impactful reports and presentations across various business applications.

The Pine BI Excel Add-In v2.1 update improves waterfall chart functionality by introducing rebuilt formulas that support a cleaner and more consistent data structure. Instead of relying on automatically calculated totals that required blank fields, developers can now explicitly define which values act as totals within the dataset. This approach simplifies data preparation, removes the need for automatic final totals, and makes chart calculations more transparent and predictable. As a result, developers can create and maintain waterfall visualizations more efficiently, particularly when working with complex financial or analytical models.

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

Pine BI Excel Add-In is licensed annually on a subscription basis with 1, 5, and 10 seat options, requiring renewal for continued use and covering each concurrent computer, with the ability to transfer individual seat activation's as needed. See our Pine BI Excel Add-In licensing page for full details.

For more information, explore the Pine BI Excel Add-In product range.

스프레드시트 정렬 기능으로 대규모 데이터 세트를 단순화하세요

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:

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

Compare .NET WinForms Spreadsheet Controls