Product
Fabrice Mainguené

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.

Read more

Product
Fabrice Mainguené
blank

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.

Read more

Product
Fabrice Mainguené
blank

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.

Read more

Tips
Fabrice Mainguené
blank

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.

Read more

Product
Fabrice Mainguené
blank

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.

Read more

Product
Fabrice Mainguené
blank

4D View Pro: Customize the Style of your Tables

Tables are an integral part of 4D View Pro documents, so we have provided many table-related features over the releases of 4D. 4D v19 R8 adds a new one related to styles so that the table fits perfectly with the rest of your document.

From now on, the VP Set table theme provides a way to apply by programming one of the predefined table styles. If none of these styles meet your need, you can define your own theme and apply it to your table.

Read more

Product
Fabrice Mainguené
blank

4D View Pro: New Commands to Manage Rows & columns

Spreadsheets are great versatile tools. From dashboards to input/output UI, spreadsheets provided by 4D View Pro can quickly solve a lot of situations encountered by your end-users.

We previously explained using the 4D View Pro table feature to display and modify data collections. Using 4D View Pro tables, you may need to add or remove columns later on, depending on end-users needs. To do so, from 4D v19 R7, 4D View Pro has several new commands to manage your table columns and rows. Let’s see how it works.

Read more

Product
Fabrice Mainguené
blank

4D View Pro: New in 4D v19 R7

With every release, the 4D View Pro features list is growing. And this feature release is no exception:4D v19 R7 comes with a new version of SpreadJS, the v15.2, and a Ribbon update that is compatible with it.

Let’s discover the new features offered by this new version.

Read more

Product
Fabrice Mainguené
blank

4D View Pro: Display your Collections as Tables

You know it already; 4D View Pro allows you to easily load and display data in spreadsheets.
4D v19 R6 brings exciting news. This blog post will show you the new table feature that enables you to do much more and benefit from additional properties like headers, table resize, summary row, column sorting, filters, and more. You’ll also discover how to quickly load data from data classes and collections. And don’t miss out on the demo, which provides a complete example and some visual charts as a bonus.

Read more