4D View Pro: Workbook options
When you create a document with 4D View Pro, you often need to fine-tune your user experience by hiding the sheet tabs and the scrollbars, or by deactivating the context menu or the drag and drop option… All these features and more are now possible thanks to the VP SET WORKBOOK OPTIONS command from the v19 R4.
4D View Pro: What’s new in 4D v19 R4?
4D v19 R4 comes with a new version of SpreadJS, the v14.2, and a Ribbon update that is compatible with it. Let’s discover the new features offered by this new version.
4D View Pro: Speed up your development process with templates
Creating reports or spreadsheets from existing templates speeds up development. Starting with 4D v19 R4, copy and paste actions can now be performed using code that copies a range of cells from another location (including other areas).
4D View Pro: What’s new in SpreadJS v14.1?
4D v19 R2 comes with a new version of SpreadJS and a Ribbon update that is compatible with it. Let’s discover the new features offered by this new version.
4D View Pro: Manually Adjust the Print Area Using Page Breaks
When printing, page break location is set by default, but you can adjust the print area by defining your own page breaks.
Starting with 4D v19 R2, to help your customers choose where they want to place their page breaks, 4D View Pro lets you add and remove page breaks manually, and also display the print preview lines.
4D View Pro : sheet management
Sometimes, you need to display different tables of information in one document. For better visibility, it’s often necessary to display them in different sheets. In this case, you need to create, rename, hide or remove a sheet, or simply know which sheet the user is currently on.
With 4D v19 R2, you can manage the sheets in your 4D View Pro documents by programming.
4D View Pro .CSV: New import/export format
Delimited files such as “.csv” or “.txt” are commonly used formats for importing or exporting data. Because delimited files can be generated and manipulated easily, more and more data published on the Web is tabular data, usually published as comma-separated values.
A good way to format this data and show it to your customers is to use 4D View Pro.
In 4D v19 R2, using the VP Import document and VP Export document commands that support delimited text file formats such as CSV, you can easily display that data for your clients.
4D View Pro: Update of SpreadJS version
4D v19 comes with a new a new version of SpreadJS and a new version of the ribbon. Besides the fresh look, we have added new features to support the new functionalities of SpreadJS v14.
This blog post walks you through these changes.
4D View Pro: End of document loading
When you use 4D View Pro (especially in offscreen mode) with complex documents, calculating all formulas could take a while and it can be difficult to know when it’s finally finished (and it’s important to wait before you call commands such as export or print).
As a solution, we’ve introduced two new events. One of which is called for every single calculation/formula, which could be used to trigger a timer. If the time expires without another formula being finished, we can assume that the whole document is finished.
4D View Pro: Find and replace with code
Sometimes when you initialize a 4D View Pro document, you need to find some values or tags in it and replace them with data issued from 4D. Now it’s a breeze with the VP Find command. Thanks to this command, you can find data, a formula, or a tag and replace it in the entire sheet or only a specific part of it!
Let’s find out how.
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