Layout is not proper in excel and csv format

[2001 JI Open Discussion]

By: Raj - rajpalan

Layout is not proper in excel and csv format

2004-08-31 22:18

Hi,

 

When we create report with html and PDF the layout is coming well,but for excel and csv the layout is not coming proper,In excel the table column and row is not coming proper and in csv the no if camas are more than the fields.Anybody come across this problem,please let me know.

 

Thanks in Advance,

B.Rajesh

[ktlam1955]

I'm not sure if this problem is similar but I'm trying to find out how to change the default delimiters that iReport outputs in a CSV file from commas to semicolons.  I'm am unable to find out how to do this.  Would you know?  Thanks.

 

ktlam...

[makweatan]

I am having a problem on excel sheet too....I thought everything was ok when designing in the iReport..but, many columnHeader and a few data are missing/not shown in the table in Excel format. Anybody know how to settle it? I've tried so many times to modify the cell but it did not work.

[phantastes]

Have you made sure that all fields are lined up? Both vertically and horizontally. Some times this will take a bit of tweaking.

[madhukiran]

Even im facing a problem.. even after my fields being lined up vertically and horizontally. When i give a data value , it wraps the cell so that the data in the cell is printed in two rows.. whereas the pdf format prints the same dat ain a single row.. need help on this