Bug 52369

Summary: XLSX: text extraction malformed "=NOW()" and "=TODAY()" cells
Product: POI Reporter: Albert L. <albert>
Component: XSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: 3.8-dev   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: sample of file that malforms dates when calling for text extraction

Description Albert L. 2011-12-19 18:21:24 UTC 
Created attachment 28089 [details]
sample of file that malforms dates when calling for text extraction

When text extracting a XLSX file, "=NOW()" and "=TODAY()" cells are improperly formatted as floating point numbers instead of date/time cells.

Aside, works for XLS cells using HSSF.
Comment 1 Nick Burch 2011-12-20 05:54:54 UTC 
XSSFSheetXMLHandler wasn't applying formatting rules to any formula cells, so no event based XSSF code was getting them

The same applied to XSSFExcelExtractor

As of r1221108 this should be fixed