Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

How to set the properties for export to excel

edited February 2016 in End User
Hello,


When I export to excel I want to have each label on each cell in the Excell
file.
Sometimes I get the value on two Cells.
How must I set the properties right?

When I have on the report page:

label1 label2 label3


I want this in excel like

Cell: A B C
label1 label2 label3


Now I get

Cell: A B C D E
label1 label2 label3

Comments

  • edited February 2016
    Hi Christophe,

    Please provide environment details, Windows version, Delphi version,
    ReportBuidler version and edition (check the Designer Help | About),
    database engine, printer etc.




    Best regards,

    -
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited February 2016
    Window7 professional 64bit, Delphi seattle 10, Report builder 17.01 build 65
    , Excel 2013


  • edited February 2016
    Hi Christophe,

    You can set Label AutoSize to False and then specify the width of each label
    to be the same, then each label will require the same width for the Excel
    export.

    However, the Excel device uses a constant column width and then merges cells
    when the width of an element requires it.

    For future reference, please post questions about export devices to the
    Devices newsgroup. This is the end-user group - focused on building
    end-user reporting solutions.



    Best regards,

    -
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.