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

Automatically translated from English

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

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.

Fabrice Mainguené

• Product Owner •

Fabrice Mainguené joined 4D Program team in November, 2016. As a Product Owner, he is in charge of writing the user stories then translating it to functional specifications. His role is also to make sure that the feature implementation delivered is meeting the customer need.

After obtaining a Bachelor degree in Computer Science at CNAM, Fabrice joined a small software publishing company as a Windev developer. Then he worked for different companies in industry and trade areas as a Windev and web developer as well as technical advisor on new features.