How to Manage the Workbook 'List of Articles' |
  
|
How to Manage the Workbook 'List of Articles' |
|
Tool: Set database editor, Home>Edit
By default, two tabs are defined and visible in Edit mode:
▪Articles, much like the Minutes table
▪Data, a list of parameters that describe the conditions required to import the set to the Minutes, and of options Y/N, that define the behavior and the visibility of the Articles sheet.
To add a sheet as data source or target, click Insert>Insert Sheet (alternative: right-click anywhere in the list of articles and select Insert Sheet); this opens a new tab Sheetn featuring an empty frame.
It is visible in Connected mode as soon as the visible area is defined; refer to How to Create Input Fields.
To show a sheet only in Edit mode, enter {HIDESHEET} in the cell A1. Refer to How to Hide/Unhide a Sheet.
To change the tab's name, select Format>Organize Sheets>Rename Sheet (alternative: right-click in the sheet).
The order of the extra sheets can be modified (context menu: Move Sheet).
To work in ExcelTM instead, select a set and click the Excel icon in the toolbar; the whole workbook is exported with the name XLTempArt. The QDV7 names are visible. The list in Data>Column's name is lost.