[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.