Summary

The SpreadSheet tab page allows you to control how spreadsheets are displayed in Daily View.

Fields

SpreadSheet:

Select an appropriate spreadsheet from the pick list .

Show captions:

Yes/No field that determines whether worksheet tabs are displayed.

Show grid:

Yes/No field that determines whether grid lines are displayed in the spreadsheet.

Show headers:

Yes/No field that determines whether row and column headers are displayed in the spreadsheet.

R1C1 reference style:

• No - Spreadsheet column headers are letters (A,B,C...)
• Yes - Spreadsheet column headers are numbers (1,2,3...).

Calculation:

Select 'Automatic', 'Manual' or 'Background' to determine how spreadsheet values are calculated.

Refresh data:

Select 'Automatic', 'Manual' or 'Background' to determine how the spreadsheet is refreshed.

Save your layout

When you finish customising your layout, you must use File | Save Layout As to save your settings. Your most recently saved layout becomes the default layout, and you will see it whenever you access this window. If you do not Save Layout As, then your changes will be lost when you exit or apply another layout.