Exporting to Excel reduces font size

[mwarner_2]

Has anyone else noticed this?  If so, how have you gotten around this bug?

For all my reports, I use a style sheet with defined styles.  All fonts I use are Tahoma.  Some are size 8 (row data), 10 (column headers), 14 (report titles).  You get the idea.

But when I publish any report to JS Server, and run the report and export the report to Excel, all the fonts are one size smaller than what I defined them as.

For instance, my row data in Excel is now Tahoma 7, my column headers Tahoma 9, and my report titles are Tahoma 13.

I did some experimenting, and if in Studio when I overwrote the row data style and defined the field as Tahoma 9, then when I run and export the report, that data field is displayed as Tahoma 8. 

I did further experimenting and didn't use a style sheet, and just created some text fields of size Tahoma 8, Tahoma 10, Tahoma 14, and Arial 14, SansSerif 10, and Calibri 8  When I ran and exported the report, they all were in Excel with one size smaller.  So it is not a style sheet issue nor a font issue.  The fonts are properly sized in Studio, Preview.

Why in JS Server would exporting to Excel reduce the font size by 1?  And more importantly, how can I fix this?

[hozawa]

It's probably because the following property is not set.

net.sf.jasperreports.export.xls.font.size.fix.enabled

[mwarner_2]

Thank you.  Adding the following keeps the font size from getting reduced.  Who would have known?

<property name="net.sf.jasperreports.export.xls.font.size.fix.enabled" value="false"/>

[christoph.hoeller]

So you gotta *disable* the font size fix in order for font sizes to be fixed... This is just great.

[vinothm2k]

this solution is not working in  Jasper Report 7.1.0 version