With 4D v17 R6, you can programmatically customize the style of your 4D View Pro documents. There’s three ways to go about it, you can: 1) use the default style commands to define the general style of a sheet, 2) use the stylesheet commands to define frequently used custom styles, and finally 3) use the cell style commands to define the style of specific cells.
If you need to read or write hundreds of different values or formulas, you can do it faster, easier, and at the same time by using collections. New commands are available for this: VP SET VALUES, VP Get values, VP SET FORMULAS, and VP Get formulas.
Typically, 4D View Pro requires that you identify the cell being worked with and where data will be entered (the active cell). You may also need to select some cells and then perform an action, such as formatting or entering values in them. 4D v17 R5 provides a new set of commands to help you manage both the active cell and cell selections.
In addition to the existing toolbar, we’re proud to announce the addition of a very powerful ribbon-style toolbar to enhance the 4D View Pro user interface. Just select an option in the Property List and you’re off and running!
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.
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