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.

HDI 4DVP workbook options

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.

Fabrice Mainguené
• Product Owner •Fabrice Mainguené joined 4D Program team in November, 2016. As a Product Owner, he is in charge of writing the user stories then translating it to functional specifications. His role is also to make sure that the feature implementation delivered is meeting the customer need.After obtaining a Bachelor degree in Computer Science at CNAM, Fabrice joined a small software publishing company as a Windev developer. Then he worked for different companies in industry and trade areas as a Windev and web developer as well as technical advisor on new features.