Re: Format code in XSSFSheetXMLHandler.SheetContentsHandler

2018-05-07 Thread Wilson de Carvalho
Good point, Greg. Thanks. I think the best choice to handle dates, though, is to provide a CellStyle object and then use DateUtil.isADateFormat static method to check if the formatted value is in fact a date or not. It seems to work better now. Anyway, including the CellStyle in this method would

Re: Format code in XSSFSheetXMLHandler.SheetContentsHandler

2018-05-06 Thread Greg Woolsey
Don't know the history, but the value is not that straightforward. If the cell has a specifically assigned format, it is used. However, format may also be derived from conditional formatting, which may not be evaluated in that context. In fact, conditional formatting evaluation is quite a

Format code in XSSFSheetXMLHandler.SheetContentsHandler

2018-05-06 Thread Wilson de Carvalho
Hi, everyone. I've been working in a solution with an implementation of XSSFSheetXMLHandler.SheetContentsHandler interface and struggled with date-formatted cells. I wonder why the format code that is present in the style file is not provided in method public void cell(String cellReference,