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.
Often when you create a table, you might need to combine two or more cells to create a centered title on a particular section of your table. As of 4D v18 R4, a new set of commands is at your disposal to help you merge and unmerge a group of cells by programming. Let’s take a look at some examples.
In 4D v18, we introduced a new way to send emails. Then in 4D v18 R2, we added a new way to retrieve emails using POP3. Now in 4D v18 R4, we’re taking the first steps for a new way to handle the IMAP protocol. As we did for SMTP and POP3, there’s a new IMAP New transporter command to handle the IMAP protocol.
The Internet Message Access Protocol (IMAP) is an Internet standard protocol used by email clients to retrieve email messages from a mail server. This protocol makes it possible to manage multiple mailboxes, download emails, perform searches on the server, manage message state, and a lot more!
And with this first IMAP feature, you can add methods to the transporter to: have the list of the available mailboxes, select a mailbox, and receive email from the selected mailbox. Let’s see how.
Want to dynamically generate 4D View Pro documents on a server and, for example, send them by email or calculate values? 4D v18 R4 introduces a new command to manipulate 4D View Pro commands in an offscreen area: VP Run offscreen area.
To create user-friendly documents, you often need to hide a gridline or header, protect certain cells, or simply change the line color to respect the corporate identity. With 4D v18 R3, you can do all this and more with the new VP SET SHEET OPTIONS command.
If you have a large table of data, it can be useful to keep an area of a worksheet visible while you scroll to another area. That’s why 4D v18 R2 includes a new command to help you create panes. Say hello to VP SET FROZEN PANES.
More features continue to be added to 4D View Pro’s ever-growing list of capabilities and this R-release is no exception. 4D v18 R2 includes new commands allowing you to add and remove columns or rows, as well as define their size, visibility, and header labels. This blog post shows you how!
As of 4D v18, a new set of 4D View Pro form events are available. They return special information that can be accessed with the new FORM Event command, introduced in this blog post. Say hello to: “On Column Resize”, “On Row Resize”, “On Clicked”, “On Double Clicked”, “On Header Click”, “On Selection Change”, and “On After Edit”.
Do you need to print a 4D form with an embedded 4D View Pro document, or maybe displaying part of the document in a 4D View Pro document? With the VP Convert to picture command, you can create an SVG from a part of the 4D View Pro document and handle it like a picture. We’ll show how in this blog post.
With the VP PRINT and VP EXPORT DOCUMENT commands, you can now print a document or create a PDF version of it. However, in order to create an appealing document for your customer, you not only need to print a document, but also add headers, footers, define the zoom, define the paper orientation, and so on. With 4D v18, it’s all possible thanks to the VP SET PRINT INFO command that allows you to define these attributes and more in your document!
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