Cell allignment in excel reports

[sudha_ramaiah]

Can we achieve the autoadjust of cell height in excel based on the content?

 

I have set the stretchifoverflow for all the fields in the report.I have also set the excel parameters,IS_AUTO_DETECT_CELL_TYPE and IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS to true.But the content does not appear properly.I tried with stretch with tallest object property also for all the fields in the report as i do not know which field will be longer in a particular row though i know the max width field in the report.For some,unneccassary rows are created in the excel and for some the cell height is not enough to fit the content.The rows have to manually extended to see the contents properly.Please help.

 

Thanks.

[sumankumar_alla]

hi

 

i also faced the problem before.

we have to be take care while giving x,y,height and width for the elements.

 

go through the below link.

i hope it will be helpful.

 

http://jasperforge.org/sf/wiki/do/viewPage/projects.jasperreports/wiki/FAQ

 

all the best

[sudha_ramaiah]

Thank You.I have set the proper x and y for all the elements in the report.There is no problem with the grids but the problem happens only when there is a text with larger content which cannot fit the cell height.

[sudha_ramaiah]

Teodar,

Can you please help me in this?

Thanks

[Teodor Danciu]

Hi,

 

Have you tried the IS_FONT_SIZE_FIX_ENABLED exporter parameter?

This makes the font size slightly smaller so that text fits better in the cells.

 

I hope this helps.

Teodor