How to set font in decimal number using HSSFFont

apache-poi, java

Solution

Promoting comments to an answer - the POI HSSF Font class has two font size settings methods:

- setFontHeight(short) - Set the font height in unit's of 1/20th of a point

- setFontHeightInPoints(short) - Set the font height in point

Using setFontHeightInPoints is the easier one for most cases, and is recommended in the Javadocs. However, it'll only cope with whole-number font heights. That's most font sizes, but not all

To set a font height of 7.5, you'd need to change your code instead to be:

xtFont.setFontHeight((short)(7.5*20));

That uses the alternate one that takes `1/20` point sizes, so copes with non-integer values.

Problem

I want to set text font to 7.5 to a particular text in excel sheet. I am using below code to prepare the Font. ``` HSSFCellStyle txtStyle = (HSSFCellStyle)workbook.createCellStyle(); HSSFFont txtFont = (HSSFFont)workbook.createFont(); txtFont.setFontName("Arial"); txtFont.setFontHeightInPoints((short)7.5); txtStyle.setFont(txtFont); ``` But it always takes font as 7 because of short type casting and hence targeted text in excel sheet is taking font 7 and not 7.5. I also tried method 'setFontHeight' but that also takes short as parameter. So is there any way by which I could set text font to decimal number?

Original source