4D v17 R4 is on the way with a cool new 4D View Pro feature: named ranges and formulas. If you need to use formulas with references to cell(s) or constant(s), this feature can be a great help!
With these new commands, your formulas are more readable and easily accessible with 4D View Pro’s automatic completion.
The ability to interact with a document via programming is an important part of using 4D View Pro. Now you can fill your documents by programming. You can set data as labels, database fields, or formulas in your document. Of course, if you can set, you can get too! You can also retrieve cell formulas or values entered by your users.
4D v17 R4 brings new features to 4D View Pro and one of them is the creation of ranges with code.
First, you need to define a range object to manipulate your cells by programming. You can do this in 4D View Pro with the following new commands: VP Cell, VP Cells, VP Column, VP Row, VP All and VP Combine ranges.
Do you need to open a Microsoft Excel document directly in your 4D View Pro area, or convert a 4D View Pro document to Microsoft Excel format to send it to a customer? It’s now possible! Thanks to this feature, your 4D business applications have taken a further step towards better compatibility with the MS Office environment.
With 4D v17 R2, it’s now possible to call 4D project methods and fields from within your formulas. This not only extends the possibilities of your 4D View Pro documents, but as the conversion process is continuously improved, calls to 4D methods and fields in converted 4D View documents are also preserved.
UI is all about personal preference, and 4D View Pro gives you two new options to enhance yours.
Two properties have been added to the Property List in the new Appearance section. They allow you to tailor your 4D View Pro documents with a new user interface. The first property, User Interface, allows you to switch between two different display modes: Toolbar and None. The second property, Show formula bar, is a checkbox to hide or show the formula bar.
Do you need to create a 4D View Pro document using code, without any user interface? It’s possible! Because 4D View Pro documents are objects, it’s very easy to create off-screen documents. You can create a new document in a variable of object type and manipulate it through its properties. When your document is ready, you can register it in your database, in a file, or display it directly in a 4D View Pro area.
We know how important your customer’s existing 4D View documents are, and being able to move them to 4D View Pro has been a priority for us. This is now possible with 4D v16 R6 (as a preview). Converting your 4D View documents to 4D View Pro is just a single line of code, thanks to the new command, VP Convert from 4D View.
Starting with 4D v16, you can set a different row height for each row in your list box. So with a few lines of code, you have a list box with rows that conform to the content. With this 4D v16 feature, we gave full control to the developer to precisely define the height for every single row of the list box.
With 4D v16 R5, we’ve decided to go further, and provide you with a fully automatic mode. It’s now possible to display lists in a gorgeous interface without any programming. You only need to set a few properties in the list box, and 4D does the rest for you. It’s magical, fluid, and again … not a single line of code!
After the advanced list usage completely covered with 4D v16, 4D v16 R4 reaches a major step toward with 4D View Pro by providing our customers with the first step of our 4D View Pro spreadsheet solution, provided as a preview.
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