4D View Pro: Use 4D formulas in your spreadsheet
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.
4D View Pro: Enable, Disable, or Force calculations
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.
4D View Pro: Merge and unmerge cells
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.
4D View Pro: Offscreen Areas
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.
4D View Pro: More options to customize your worksheets
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.
4D View Pro: Freeze panes to lock rows or columns
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.
4D View Pro: Manage Rows and Columns
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!
New 4D View Pro form events
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”.
4D View Pro: SVG conversion
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.
4D View Pro: Manage Printing and PDF export
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!
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