EXCEL - row height too narrow for text

[richardc]

Hi,

 

This is a duplicate of a previous entry:

see

http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=8&id=28509#28509)

 

 

 

Basically, the rows in Excel don't stretch enough to display all of the text in cells when exporting reports to Excel. It works ok when there is no text overflow, but when there is text overflow, only a proportion of the text is visible in excel.

 

Is there a way to add Excel macro detail in a report template to get the spreadsheet to auto-fit the text?

 

Currently users need to manually auto fit text in Excel by: selecting the rows in excel and then from the menu: Format->Row->AutoFit. However, using this can cause the page height to extend beyond the printable height for the page.

 

 

Regards,

 

Richard

 

Post edited by: richardc, at: 2007/10/03 15:28

Post edited by: richardc, at: 2007/11/26 08:13

[richardc]

Hi Teodor,

 

This issue is quite important - can we raise it as a bug?

 

Another link to the same problem is:

 

http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=8&id=19559#19559

 

[richardc]

Hi Teodor,

 

This issue is quite important - can we raise it as a bug?

 

Another link to the same problem is:

 

http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=8&id=19559#19559

 

[teodord]

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

[richardc]

Hi Teodor,

 

That worked!

 

Thanks,

 

Cheers,

Richard

[imclive]

some work.. some didn't..