Export To Excel - Colspacing & alignment

rbuser

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?

nardmoseley

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