Reading font fromat from cell

[D Minor9th <dm...@gmail.com>]

I'm trying to determine if the content of a cell has been struck through.

There does not seem to be a getFont() method in HSSFCell, which would
appear to provide what I need, since HSSFFont provides a
getStrikeout() method.

I tried using HSSFCell.getCellStyle().getFontIndex() but the resulting
fontindex appears not to be consistent between excel files for a given
font format.

The fontindex I get in one file for strikeout appears to be 12 for
Arial Font, Regular Font style, Size 10, Colour Automatic, Underline
None. However the fontindex I get for the same font format in another
file is 8 !

Is the getFontIndex() the correct API to use to determine this
strikethrough information, and if so does anyone know why I'm getting
these inconsistent results ?

Even better, do any of the POI developers know when/if a
HSSFCell.getFont() method will be implemented ?

thanks,

Deepak

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/