4D View Pro: What’s new in 4D 21 R2
4D 21 R2 introduces an updated version of 4D View Pro based on SpreadJS v18.2, along with a Ribbon fully compatible with this release. Since 4D View Pro is built on top of SpreadJS, upgrading the underlying engine immediately brings performance improvements and new capabilities. Some of these enhancements are directly available in 4D, others can be accessed through the View Pro designer, and a few require custom JavaScript code. In this article, we highlight the most important changes introduced by SpreadJS v18.2, including features that are not yet directly exposed as 4D functions.
4D View Pro: Import callback ensures custom functions are fully resolved
Importing documents is a common task when working with 4D View Pro. However, when these documents contain custom functions, it can be challenging to determine when all calculations are completed before performing actions like printing or saving. To solve this, 4D 20 R9 makes sure that the callback formula of import commands is done only after all custom functions have been fully dealt with. This improvement gives more control and reliability when working with imported 4D View Pro documents.
4D View Pro: Excel import/export update
As part of 4D View Pro‘s continuous development, we’ve expanded the Excel import and export functionalities in 4D 20 R8. In this update, new language options have been added to align with the interface capabilities and give you more control over the exported workbook.
4D View Pro: What’s new in 4D 20 R7
4D 20 R7 comes with a new version of SpreadJS, v17.1, and a Ribbon update that is compatible with it. Let’s discover the new features this new version offers to help accelerate your 4D View Pro development.
4D View Pro: Enhancement of Custom Functions
Sometimes, you may require specialized calculations on the contents of a column or row without knowing how many cells will be affected.
With 4D 20 R5, you can now pass multiple cells ranges to a custom formula within your spreadsheet formula, such as “A1:C10”, or an object such as “OBJECT(“Firstname”,B2,”Lastname”,C2)”,and retrieve a collection or an object containing all cell content in your 4D method.
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.
4D View Pro: Import/ Export Documents in Blob Format
For those of you working with larger and more complex 4D View Pro documents, we understand the performance concerns that arise. Starting from the 4D v20 R3, we offer a new blob format that enables you to store compressed documents in your database with the same performance as the .sjs format.
New 4D View Pro Format File: sjs
For those of you working with larger and more complex 4D View Pro files, we understand the performance concerns that arise. To tackle this, we have introduced a new file format called .sjs. The .sjs format is a compressed file with multiple smaller JSON files, following a structure similar to Excel XML. This new format aims to enhance performance and optimize the handling of these files.
4D View Pro: Create a Pivot Table from a data table
Pivot tables are among the most valuable features that allow users to swiftly summarize and analyze large quantities of data to see comparisons, patterns, and trends in their data. From the 4D v19, pivot tables are included in 4D View Pro. This blog post reviews how to use a pivot table through the ribbon interface.
4D View Pro: What’s New in 4D v20
With every release, the 4D View Pro features list is growing. And this feature release is no exception: 4D v20 comes with a new version of SpreadJS, the v16, and a Ribbon update that is compatible with it.
Let’s discover the new features offered by this new version.
Contact us
Got a question, suggestion or just want to get in touch with the 4D bloggers? Drop us a line!
* Your privacy is very important to us. Please click here to view our Policy