piXLSColumnWidth - cDRReport ¶

Type¶

Default¶

20

Arguments¶

None

Description¶

When the export to XLS the width of a column determines how many cells need to be merged to hold the content. The smaller the value is the more precise the output will be but it also means the number of columns in the spreadsheet increases a lot.

Can be retrieved or set after the OCX is initialized.

DataFlex Framework Usage¶

Web
Windows
FlexTron

Sample¶

Object oReport is a cDRReport
    Set psReportName to 'MyReport.dr'
End_Object

Object oExportToXLSReportButton is a Button
    Set Label to 'Export Report to XLS'

    Procedure OnClick
        String sReportId

        Get OpenReport of oReport to sReportId
        If (sReportId <> '') Begin
            Set piXLSColumnWidth of oReport to 10
            Send ExportReport of oReport C_drXLS 'c:\tmp\report.xls'
        End
    End_Procedure
End_Object

piXLSColumnWidth - cDRReport¶