https://bz.apache.org/bugzilla/show_bug.cgi?id=58883
--- Comment #3 from [email protected] --- What i'm doing is reading the cells and writing them to a csv file: try(Reader reader = new InputStreamReader(sheetInputStream,"UTF-8")){ InputSource sheetSource = new InputSource(reader); sheetSource.setEncoding("UTF-8"); SAXParserFactory saxFactory = SAXParserFactory.newInstance(); SAXParser saxParser = saxFactory.newSAXParser(); XMLReader sheetParser = saxParser.getXMLReader(); // ContentHandler handler = new MyXSSFSheetHandler(styles, strings, // this.minColumns, this.output); DataFormatter format = new MyDataFormatter(); SheetContentsHandler blof = new MySheetContentsHandler(this.printStream, rowsLimit); ContentHandler handler = new XSSFSheetXMLHandler(styles, strings, blof, format, false); sheetParser.setContentHandler(handler); sheetParser.parse(sheetSource); } And MySheetContentsHandler basically doing: @Override public void cell(String cellReference, String formattedValue) { // Add data this.printStream.print(formattedValue); } Where the 'printStream' is a writer to new CSV file. I opened the xlsx file as a zip file and observed this cell value and it was 620.91666666666663 so that what i'm expecting to be read in the 'formattedValue'. Moreover, this same behavior in version 3.10.1 did read the value as is in the inner xml file -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
