How to set the properties for export to excel

rbuser

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

nardmoseley

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

rbuser

Window7 professional 64bit, Delphi seattle 10, Report builder 17.01 build 65
, Excel 2013

nardmoseley

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