Home General

Alignment when exporting to excel

edited July 2011 in General
I have some questions on how to export a report to excel. The report has a
mixed heading of horizontal and vertical labels (Angle = 90 degrees), and
beneeth the heading I display a vertical line. And for the data I use the

The difficulties with the heading is that on exporting to Excel, I haven't
been able to get the labels on the same row. Also the length of the
underlying line is too short no matter what I try. Further, the vertical
alignment of the labels differ (Excel aligns the rotated text at the top)

The problem with the data is that using the "BlankWhenZero", the position of
last column isn't correct. (It gets positioned one to the left) Which is
strange, since the group below that displays the sum of the data gets
positioned just right. (Try to move the DBText-controls several pixels, but
that doens't mak a difference for the Excel-export, but does have an
undesired effect on the normal print)

Could you give me some advise on this please...


  • edited July 2011
    Please create a simple example that we can build and run here. Use standard
    Delphi components and RB. Use the DBDemos data or dump some data to
    TClientDataSet(s). Send in zip format to support@ and we can check it out

    Nard Moseley
    Digital Metaphors

    Best regards,

    Nard Moseley
    Digital Metaphors
This discussion has been closed.