Bug 45623 - Need the 'stripFields' flag for header/footer extraction similar to WordExtractor and HeaderStories
Summary: Need the 'stripFields' flag for header/footer extraction similar to WordExtra...
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: All All
: P1 critical (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-08-12 13:27 UTC by Dmitry Goldenberg
Modified: 2008-08-14 14:41 UTC (History)
0 users


Attachments
Sample Excel doc with header with macros. (19.50 KB, application/vnd.ms-excel)
2008-08-12 13:27 UTC, Dmitry Goldenberg 		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 Dmitry Goldenberg 2008-08-12 13:27:23 UTC 
Created attachment 22439 [details]
Sample Excel doc with header with macros.

A flag was just added to WordExtractor and HeaderStories which allows you to strip off any macros from headers and footers when extracting them.

It would be great to make the same flag available in HSSF.

I'm attaching an Excel file where a header is defined with a bunch of macros. When I run the code below, I get:

>>>> CH: HEADER TEXT &P&N&D&T&Z&F&F&A&G

With the stripFields flag ON we would simply get "HEADER TEXT"
Comment 1 Nick Burch 2008-08-14 14:41:34 UTC 
A similar feature for hssf has now been added to svn