Hello, i get an NPE writing a null value String value = null; Workbook workbook = new SXSSFWorkbook(); Sheet sheet = workbook.createSheet(); Row row = sheet.createRow( currentRowNr); Cell cell = currentRow.createCell( currentCellNr); cell.setCellValue( new XSSFRichTextString( value)); Error: java.lang.NullPointerException at org.apache.poi.xssf.streaming.SXSSFSheet$SheetDataWriter.outputQuotedString(SXSSFSheet.java:1384) at org.apache.poi.xssf.streaming.SXSSFSheet$SheetDataWriter.writeCell(SXSSFSheet.java:1349) at org.apache.poi.xssf.streaming.SXSSFSheet$SheetDataWriter.writeRow(SXSSFSheet.java:1289) at org.apache.poi.xssf.streaming.SXSSFSheet.flushOneRow(SXSSFSheet.java:1209) at org.apache.poi.xssf.streaming.SXSSFSheet.flushRows(SXSSFSheet.java:1199) at org.apache.poi.xssf.streaming.SXSSFSheet.getWorksheetXMLInputStream(SXSSFSheet.java:61) at org.apache.poi.xssf.streaming.SXSSFWorkbook.injectData(SXSSFWorkbook.java:108) at org.apache.poi.xssf.streaming.SXSSFWorkbook.write(SXSSFWorkbook.java:496) Kind regards, Daniel
Not sure what we should be doing for someone giving XSSFRichTextString a null value? Any chance you could check what XSSF and HSSF make of this?
in XSSF and HSSF it's ok. I have changed implementation today cause we need large file export.
Do they just treat it as an empty string? (We'll want to replicate the same behaviour for SXSSF when fixed)
Yes. Null value should be treat as empty string. I have done a workaround in my implementation. null value -> empty string
Should be fixed in r1143059.