[Prefill from Spreadsheet]
Changes the report options to match the current layout of the spreadsheet. This is an easy way to get a printout that looks the same as the spreadsheet on the screen. If you prefer a different layout for the report, you can change the settings before printing. Sage Estimating (SQL) applies the following layout settings to the report:
- Gridlines
- Column properties
- Summary level, if the spreadsheet is fully summarized or fully expanded
- Sort levels
Tips:
- Click [Save Layout] to save your changes as the default for this report.
- If you use this option, Sage Estimating (SQL) automatically selects the Use summary levels from spreadsheet option on the Range tab.