4D View Pro: What’s New in 4D v20 R4

With every release, the list of features in 4D View Pro continues to expand. And this feature release is no exception: 4D v20.2 and 4D v20 R4 come with a new version of SpreadJS, the v16.2, and a Ribbon update that is compatible with it.

Let’s explore the enhanced features introduced in this latest version.

Formula Editor Panel

Viewing, editing, and debugging long and complex formulas is now even easier with the Formula Editor Panel.

This new component provides the following functionalities:

  • Formulas that are long and complex can be formatted into separate lines with the appropriate indentation and nesting,
  • Formula outlines can be collapsed and expanded,
  • Formulas can be entered quickly and correctly with suggested functions, custom names, and enumerated parameters,
  • Tooltips with information about a function will show when a user hovers over a function name or types a function,
  • Formula errors such as incorrect parameters and unmatched brackets will be flagged.

PivotTable Enhancements

SubTotal Option for Single Fields

We have enhanced PivotTable support by adding a subtotal option for individual fields. Previously, you would change the subtotal position to the bottom of each field. Now, you can change the position for respective fields.

Calculation Enhancements

Excel Manual Calculation Options

4D View Pro now supports manual calculation. When set, formulas will not automatically calculate; instead, formulas will only calculate when edited or when a new formula is entered.


All dirty cells will be calculated automatically if relevant cells have been changed. With manual calculation, only cells that have been directly changed are calculated; cells that reference a changed cell will not be calculated.

Cross-Sheet Reference Support when Entering Formulas

We have added the ability to click on a different sheet tab while editing a cell formula to reference cells in other worksheets.

Workbook Enhancements

Display Zero

Sometimes, a worksheet may have formulas that result in 0 in a cell, and a user might not want those cells to show any value. To support this, we have added the showZeros option, which can be enabled to show 0 values in cells and disabled to show the cell value as blank.

Password-protected Worksheets

Worksheets can now be password-protected. You can set a password for specific sheets or the entire workbook, matching Excel’s functionality.

Cell defaultValue Property

We have added a property allowing you to set a cell’s default value. You can set any value or formula as the default value of a cell.


Insert Cut Cells for Tables

Inserting copied or cut cells outside of a table range is already supported, and this release allows copied and cut cells to be inserted into a Table.

Designer Enhancements

Excel Themes, Colors, and Fonts

We have added Themes, Colors, and Fonts buttons to the Designer, which lets users switch themes or color sets to affect all shapes, charts, and built-in cell styles that reference those theme colors.

Set Excel like themes, colors, and fonts with the new buttons in the JS Designer Component

Need more information? Take a detailed look at these SpreadJS v16.1 and SpreadJS v16.2 advances, and share your experience on the 4D forum.

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.