Autoresizing problem in excel format

[balak]

Hi  all,

I am facing this problem :

when i export my report in excel format, If the data for textfield is long like for eg:

data of 4 lines.I am able to see only some lines out of 4.All the 4 lines not shown.To see all the lines i need to double click on the cell.I think the textfiled doesn not get expanded enough to occupy the data.

I have set following  properties to textfiled:

isStretchWithOverflow =true.

stretchType=relattiveToTallestObject.

I have also checked with the property print.keep.full.text=true.

but still i am facing the same problem.

I am using the font as : Arial  and font size=10.

 

Please help to solve this issue.

 

Thanks in advance.

 

[giobby]

hi try with this istruction:

JRExporter exporter = new JRXlsExporter();
    //  exporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, new Boolean(true));
    // exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, new Boolean(true));
      exporter.setParameter(JRXlsExporterParameter.IS_FONT_SIZE_FIX_ENABLED, new Boolean(true));
 

I hope this help you

Giovanni

...La puissance est rien sans controle...

 

[balak]

hi ,

your instructions helps to solve my problem,but it decreased the font size by 1 pixels,but anyways it solves visibility problem.

Thanks a lot.