Product

4D View Pro : sheet management

Automatically translated from English

Sometimes, you need to display different tables of information in one document. For better visibility, it’s often necessary to display them in different sheets. In this case, you need to create, rename, hide or remove a sheet, or simply know which sheet the user is currently on.

With 4D v19 R2, you can manage the sheets in your 4D View Pro documents by programming.

Product

4D View Pro .CSV: New import/export format

Automatically translated from English

Delimited files such as “.csv” or “.txt” are commonly used formats for importing or exporting data. Because delimited files can be generated and manipulated easily, more and more data published on the Web is tabular data, usually published as comma-separated values.

A good way to format this data and show it to your customers is to use 4D View Pro.

In 4D v19 R2, using the VP Import document and VP Export document commands that support delimited text file formats such as CSV, you can easily display that data for your clients.

Tips

4D View Pro: End of document loading

Automatically translated from English

When you use 4D View Pro (especially in offscreen mode) with complex documents, calculating all formulas could take a while and it can be difficult to know when it’s finally finished (and it’s important to wait before you call commands such as export or print).

As a solution, we’ve introduced two new events. One of which is called for every single calculation/formula, which could be used to trigger a timer. If the time expires without another formula being finished, we can assume that the whole document is finished.

Product

4D View Pro: Find and replace with code

Automatically translated from English

Sometimes when you initialize a 4D View Pro document, you need to find some values or tags in it and replace them with data issued from 4D. Now it’s a breeze with the VP Find command. Thanks to this command, you can find data, a formula, or a tag and replace it in the entire sheet or only a specific part of it!

Let’s find out how.

Product

4D View Pro now in 6 languages!

Automatically translated from English

We know how important it is for both you and your customers to have 4D View Pro spreadsheets in your native language. That’s why 4D v18 R5 now provides a set of five supported languages! In addition to English, we’ve added support for French, German, Spanish, Japanese, and Portuguese!

Product

4D View Pro: Use 4D formulas in your spreadsheet

Automatically translated from English

4D v18 R5 introduces a new command that simplifies writing your code: VP SET CUSTOM FUNCTIONS. It creates custom functions in 4D View Pro which execute 4D formulas.

Thanks to this command you can now allow 4D commands, fields, variables, methods, or any arbitrary expression to be used in your cell formulas. For example, there’s no need to create a method to use a simple variable in 4D View Pro, just pass it as a parameter to your Formula.

Product

4D View Pro: Enable, Disable, or Force calculations

Automatically translated from English

4D View Pro automatically recalculates the formulas in your worksheet when you change data they depend on (e.g., entries, formulas, names, etc.).

But what if you want to make your UI more interactive and trigger the calculation of formulas whenever you want? 4D v18 R4 makes it possible thanks to three new commands: VP SUSPEND COMPUTING, VP RESUME COMPUTING, and VP RECOMPUTE FORMULAS. These commands let you suspend and resume the calculation of all formulas in your document, or force their recalculation.