Bug 52369 - XLSX: text extraction malformed "=NOW()" and "=TODAY()" cells
Summary: XLSX: text extraction malformed "=NOW()" and "=TODAY()" cells
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.8-dev
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-12-19 18:21 UTC by Albert L.
Modified: 2011-12-20 05:54 UTC (History)
0 users


Attachments
sample of file that malforms dates when calling for text extraction (8.99 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2011-12-19 18:21 UTC, Albert L. 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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