Excel Export: Extra wide column to fit gap to page border

Posted by: dillen-dd on 4 August 2017, 2:52 pm EST

  • Posted 4 August 2017, 2:52 pm EST

    We encountered the following problem when exporting to Excel.

    The fields covering approx 60% of a landscape page.
    In the xls file we see a empty column after the leftmost data column and the width is equal to the space between the field and the page width.
    So if I change the  page layout to portrait, this column gets much samller
    .

    Is there any option to avoid this wide column?

    Thanks Christof.
  • Replied 4 August 2017, 2:52 pm EST

    Christof,


    First, which build of Active Reports are you running. If you are not already, make sure that you verify that the issue still occurs against the latest build (1283). You can download it here: http://www.datadynamics.com/forums/37/ShowForum.aspx. If this does not resolve the issue, can you save your report output to the RDF format so that I can take a look at it? You can save the report to RDF by calling the .Pages.Save method off of the report object after it has been run.


    Example,


    rpt.Pages.Save("C:\Output.RDF")


    Thanks,

  • Replied 4 August 2017, 2:52 pm EST

    Hi Peter,
    we are using build 1230, but problem is reporducable with build 1283 as well.

    Attached you will find the .xls and .rdf files.
    Column K is the column of concern.

    Thanks for your support.
    Christof.



    2006/04/Export.zip
  • Replied 4 August 2017, 2:52 pm EST

    Christof,


    I tried several different property combinations of the Excel export and could not get the output behavior that you are looking for. One of the causes may be that you are exporting a report to Excel which contains the line control. The line control is not supported in our Excel export. Here is a list of the export's limitations: http://www.datadynamics.com/forums/1349/ShowPost.aspx. We cannot guarantee the format of the ouput to excel when the line control is used. There is a spreadbuilder api that is included with the product which gives you more control over the generated excel document. There is an example of using this api here: http://www.datadynamics.com/forums/377/ShowPost.aspx

  • Replied 4 August 2017, 2:52 pm EST

    Peter,

    thanks - but we are not using any line control, we are only using fields.

    Christof.
  • Replied 4 August 2017, 2:52 pm EST

    Christof,


    My fault, are you using control borders to generate the lines? What happens if you open the RDF file using the RDF Viewer sample that is distributed with the product and export the RDF files to Excel without changing any of the property settings of this sample. You may also want to experiment with this sample regarding selecting various property combinations for the Excel export. Something must be different regarding your machine versus mine, which may be affecting the behavior. Which version of Excel are you using? What happens if you remove the contrl borders from the report?


    Thanks,

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels