Focal Point
[SOLVED] Excel Report Alignment Issues

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/572107222

August 28, 2009, 01:45 AM
VadivelNagaraj
[SOLVED] Excel Report Alignment Issues
Hi,

I have developed a summary report to display the data in Excel format. The report has only HEADING, SUBHEAD and SUBFOOT(no detail records). Each of Heading, SUBHEAD & SUBFOOT has 4-5 lines printing the text with ST. values, Since the lines lenght/width is not same in all of this sections, The data in excel doesn't look aligned. Please share your ideas to set the first column width of the excel to look even.

Thanks

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.1.4
Windows
Both Excel & HTML
August 28, 2009, 05:21 AM
SureshKumar
Try using COLSPAN for Heading and Footing to set up column width.


Webfocus 8002M, 8009
OS: Windows7
August 28, 2009, 10:46 AM
VadivelNagaraj
Thanks Suresh, It worked.


WebFOCUS 7.1.4
Windows
Both Excel & HTML