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

Export To Excel - Colspacing & alignment

edited October 2006 in Devices
Waler Previous post >> To make the data match the header just make sure that
the header and data
items are left aligned. Then when the device calculates the column to place
the data in,
they will both be the same. <<


I see from the previous post that the way to make the columns line up
correctly in an Excel Export (Waler 3.00 RB 10.03 server) is to make all
column headers and data LEFT justified. This works fine for text oriented
output but what about numbers?

It's not possible to print a report with a number column left justified and
have it look OK. There must be another way to get the "same" output no
matter if it's printed, PDF or exported to Excel?

If everything must be left justified why wouldn't the plug-in make the
change & calculation when placing the columns? Then re-format the cells
correctly in the spreadsheet?

Comments

  • edited October 2006

    For future reference, if you have an issue with Waler's TExtraDevices, I
    recommend that you specify that in the subject so that it is clear to all
    relevant parties.

    This issue is isolated to TExtraDevices, it is not due to RB. (The RB Device
    descendant classes process the Page.DrawCommands[], where each DrawCommand
    has properties that describe the location, text, font, alignment, etc.

    If Waler does not respond here, then try contacting support@waler.com.


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

    Best regards,

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