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.
VP SET WORKBOOK OPTIONS command allows you to manage the following:
- tab strip
- scrollbars
- workbook background
- column and row resizing
- copy / paste options
- drag and drop options
- drag and fill options
For example, sometimes you may not want the scroll bars to appear on your spreadsheet, which reduces the risk of users moving around too much:
$param:=New object
$param.showHorizontalScrollbar:=False
$param.showVerticalScrollbar:=False
VP SET WORKBOOK OPTIONS("ViewProArea"; $param)The list of options is too long for this blog post, but take a look at the documentation to find the complete one, and don’t forget to try this command with the HDI above.