I am using poi 3.8 & jre 1.6
attached my file.
code:
File fis = new File(filePathName);
OPCPackage opcPackage = OPCPackage.open(fis.getAbsolutePath());
XSSFWorkbook wb = new XSSFWorkbook(opcPackage);
XSSFSheet sheet = wb.getSheetAt(0);
CellReference cellReference = new CellReference(cellName);
XSSFRow row = sheet.getRow(cellReference.getRow());
XSSFCell cell = row.getCell(cellReference.getCol());
XSSFRichTextString cellText1 = new XSSFRichTextString();
cellText1 = cell.getRichStringCellValue();
System.out.println(cellText1.numFormattingRuns()); // returns 0
System.out.println(cell.getRichStringCellValue().numFormattingRuns()); //
returns 0 Test3.xlsx
<http://apache-poi.1045710.n5.nabble.com/file/n5714652/Test3.xlsx>
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Unable-to-read-the-fully-formatted-text-from-XSSF-tp5714625p5714652.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]
