|
In the workbook node is where the settings for the selected workbook and its corresponding worksheets can be defined.
.png)
1. Precision as displayed. If checked, calculations will be performed with formated cell values instead of the unformatted full precision original values.
2. Save link values. Cell references to another workbooks will be saved. The referenced workbook files don't need to be opened or be part of the workbook set if this option is checked, but they must be present in the referenced file path.
3. Sheet tabs. Shows or hides the sheet tabs at the bottom of the worksheet.
4. Horizontal scrollbar. Shows or hides the horizontal scrollbar.
5. Vertical scrollbar. Shows or hides the vertical scrollbar.
6. Protect structure. Checking the this option will disable the insert, copy, delete, rename, copy and hide worksheet commands, preserving the workbook structure. A password can be specified to unprotect the workbook structure.
7. File password. Checking this option a password to open the workbook file can be specified. When opening the workbook file the exact password must be typed, otherwise the file will not be opened. If the password is left blank the workbook file can be unprotected without typing a password.
8. Display shapes. Shows existing shapes (e.g.: lines, autoshapes) in the workbook.
9. Hide shapes. Hides existing shapes (e.g.: lines, autoshapes) in the workbook.
10. Show placeholders. Show placeholders instead of shapes.
|