Column Width Based on Objects in Area-Use this combo box to specify the criteria that you want ClearSCADA to use for assigning the column widths in the Excel version of a report.Use the remaining fields in the Column Widths section of the tab to specify that width. Use the Points field to specify the width for each column.Ĭlear the check box if the column widths are to assume a particular width, based on a particular column-type. Constant Column Width-Select this check box if you want to specify a particular width, in points, for each column in a report, for when that report is exported to Excel.Use the fields within the Column Widths section of the tab to specify: 2007-2010 (Data only)-Select this option to export purely the report data, excluding any layout or format settings, into a default Excel 2007-2010 work sheet.97-2003 (Data only)-Exports purely the report data, excluding any layout or format settings, into a default Excel 97-2003 work sheet.97-2003-Exports the report data and any supported formatting into an Excel 97-2003 work sheet.
Version-Use to specify to which version of Excel a report is to be exported.When the Format is set to Microsoft Excel, the tab displays these fields: If ClearSCADA is to export a report in Microsoft Excel format, use the Format field on the Export Format tab to specify the Microsoft Excel format. Ideally, use the Snap to Grid feature on the Options window to help position objects accurately. Any objects that are not aligned on such a report may cause the exported version of the report to include blank or mis-aligned rows and/or columns.
It is imperative that formatting of reports that are to be exported to Microsoft Excel is precise.
0 kommentar(er)
