4D View Pro: What’s new in SpreadJS v14.1?

4D v19 R2 comes with a new version of SpreadJS and a Ribbon update that is compatible with it. Let’s discover the new features offered by this new version.

SpreadJS v14.1 comes with many new features:

• Pivot Tables
• Camera Shape
• Chart Enhancements
• Calculation Enhancements
• Shape Enhancements
• Workbook Enhancements
• Introducing the new TableSheet BETA

Pivot Tables

Pivot tables are among the most useful Excel features–allowing users to swiftly summarize and analyze large quantities of data with a simple and intuitive UI. The SpreadJS v14.1 release includes this feature, PivotPanel UI, and Excel import/export capabilities.

Camera Shape

Camera shape is a new feature that lets you create a dynamic snapshot of a specified range of cells–making it ideal for creating stunning dashboards. This shape will reflect all of the live changes made in the actual cell range.

Chart Enhancements

SpreadJS v14.1 includes new chart enhancements and a new chart type:

• Word-Wrap for Bar Y-axis Values
• IMAGE Sparkline
• Axis Reverse Values
• Histogram Sparkline
• Gauge KPI Sparkline

Sheet Tab Position

This new feature allows developers to choose where tabs in the workbook are displayed.

For more information, take a look at What’s New in SpreadJS v14.1.