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

ExtraDevices - Centering problem with XLS output

edited March 2005 in Devices
Hello,

We are working with ReportBuilder 9.01 Standard, Delphi 6 Enterprise, and
TExtraDevices 2.96. Our application generates reports to PDF and XLS
formats, both using TExtraDevices instead of RB's native PDF output.

The problem:
We are printing our report in landscape layout. There is a centered header
at the top of the first page. Our header consists of two lines, one above
the other, of static text. When we print our report using PDFFile as the
device type, it prints correctly. However, when we select ExcelFile as the
device type, the header is no longer centered in the report.
Actually, for all of our tests, the header is always generated centered on
column D in Excel (tested using Excel 2000).

Any ideas how we can get our report to print correctly?

Thanks.

Rich Ackerson

Comments

  • edited March 2005
    Excel spacing is limited to columns. Two lines of text will not be perfectly centered relative
    to each other due to the fixed column size. There is no adjustment beyond the column placement.

    James Waler
    Waler Ltd
    http://www.waler.com
  • edited March 2005
    Thanks for the reply. Unfortunately, I think I may have misled you in my
    initial post.

    The problem is not that the two lines of header text are not centered with
    each other. Our problem is that the header (neither line) is even close to
    being centered in comparison with the body of our report. Our report spans
    columns A through P. Our header outputs on column D. All columns are the
    same size so I would assume if column placement was the only consideration,
    the header should have appeared somewhere around columns H or I.

    Rich

  • edited March 2005
    How is the title defined? Static size? You can send a "print to archive" file to me for testing.

    James Waler
    Waler Ltd
    http://www.waler.com
This discussion has been closed.