I need to process xls files ( HSSF ) only.
I don't know how, but I think only the superscript is coming inside
FormattedRun condition because when I tried the following code :
HSSFCellStyle style = cell.getCellStyle();
HSSFFont cellFont = workbook.getFontAt(style.getFontIndex());
HSSFFont myfont = workbook.getFontAt(rts.getFontOfFormattingRun(0));
And when I tried printing the values of cellFont and myFont, this is what I
got :
cellFont === org.apache.poi.hssf.usermodel.HSSFFont{[FONT]
.fontheight = 0x00DC
.attributes = 0x0001
.italic = false
.strikout = false
.macoutlined= false
.macshadowed= false
.supersubscript= 0x0000
.fontname = Calibri
[/FONT]
myFont === org.apache.poi.hssf.usermodel.HSSFFont{[FONT]
.fontheight = 0x00DC
.attributes = 0x0001
.italic = false
.strikout = false
.macoutlined= false
.macshadowed= false
.supersubscript=0x0001
.fontname = Calibri
[/FONT]
So I guess cellFont is getting the content ABC and myFont is getting the
superscript text?
But I'm still not able to obtain the superscript text separately.
Thanks
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Reading-superscript-from-data-cell-tp3414964p3424752.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
