Icon

Description

Open report in Spreadsheet Editor.  This is similar to the Report Template Editor, except that it doesn't have report template functions (Report Template Explorer, Entity Properties Explorer, Global Boundary Generator) and more than one workbook file can be opened. The Spreadsheet Editor can open/save files in XLS, XLSX, XLSM, XLT, TXT and CSV format.

Open report in Excel. If you don't have any version of Excel^© 93/2010 installed in your computer, you can open the report in the Spreadsheet Editor provided.

Export report. You can export to Microsoft Excel^© Workbook 2007/2010 (*.xlsx), Microsoft Excel^© 97/2003 (*.xls), Unicode text (*.txt) or comma delimited files (*.csv).

Update cell values from linked CAD entities. Selecting this option, cell values will be updated if the property of the linked entity is modified.

Update CAD entities from linked cell values. Entity properties will be updated if the corresponding linked cell values change. Properties must not be read-only.

Auto update cell values from linked CAD entities. Cell values will be automatically updated if linked entity properties change if this option is checked.

Auto update CAD entities from linked cell values. If this option is checked, entity properties will automatically change if linked cell values change. Properties must not be read-only.

Show linked entity. The corresponding linked entity to the current selected cell will be highlighted and shown on screen, with options to zoom in/out and reset the view.

Auto show linked entity. If this option is checked and a linked cell is selected, the corresponding linked entity will be automatically highlighted and shown on screen.

Show linked cells. Cells that are linked to entities will be filled with a solid yellow color to identify them.

Send selected table range to AutoCAD. The AutoCAD Table Exporter will be shown. Selected cells will be sent to AutoCAD as multiple text for content, line or polyline entities for borders and solid hatch for cell fill colors, with options to define corresponding colors and linetypes.

Take report screenshot. A preview thumbnail image of the report will be taken and shown when a report file is selected to be opened in the 'Open report file' dialog box from the Report Template Editor.

Zoom percentage. A numeric value from 25 to 400% can be specified to enlarge or reduce the report view extents.

Show grid lines. If this option is checked  grid lines will be shown for reference. If this option is unchecked grid lines will be hidden.

Show headings. Row and column headings will be shown if this option is checked. If this option is unchecked row and column heading will be hidden.

Print report. Options to print the current worksheet, workbook or cell selection will be shown. A standard printer dialog box will be shown afterwards to configure printer settings.

Print preview. Options to preview the current worksheet, workbook or cell selection will be shown. A standard printer preview dialog box will be shown afterwards, with the options print the report using the current printer settings, zoom to enlarge/reduce the current view and group the report preview in one, two, three, four or six pages.

Help. This help topic will be shown.