4D v19 R4 comes with a new version of SpreadJS, the v14.2, and a Ribbon update that is compatible with it. Let’s discover the new features offered by this new version.
Ribbon enhancements
Single Toolbar mode
The ribbon display has been enhanced with a single toolbar mode:
You can activate it with this code:
$js:="designer.setConfig(GC.Spread.Sheets.Designer.ToolBarModeConfig);"
WA Evaluate JavaScript(*; "ViewProArea"; $js)and deactivate it with:
$js:="designer.setConfig(GC.Spread.Sheets.Designer.DefaultConfig);"
WA Evaluate JavaScript(*; "ViewProArea"; $js)Ribbon collapse
4D View Pro provides an easy way to collapse / uncollapse the ribbon:
$js:="designer.setData('isRibbonCollapse',!(Boolean(designer.getData('isRibbonCollapse'))));"
WA Evaluate JavaScript(*; "ViewProArea"; $js)Go To
With the Go To feature, users can navigate to the Home tab under Editing → Find → Go To… to open the Go To dialog – providing various options for sheet navigation.
Find and replace
Prior to this release, we supported the “Find” functionality. Now with this release we have included support for Replace and Replace All.
Format Painter
4D View Pro add a format painter icon to enable users to copy and paste formatting with a simple click of a button.
Context Menu Sheet Copy/Move
4D View Pro has added the Sheet Copy/Move function to the context menu when a user right-clicks on a sheet tab in the Designer:
Unhide Multiple Sheets
With this release, users can now unhide multiple hidden sheets with a new menu.