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.