Bug 45544 - poi-3.5-beta1-20080718.jar - content from the comments of a 2007 xlsx document is not extracted.
Summary: poi-3.5-beta1-20080718.jar - content from the comments of a 2007 xlsx documen...
Status: RESOLVED WORKSFORME
Alias: None
Product: POI
Classification: Unclassified
Component: POI Overall (show other bugs)
Version: unspecified
Hardware: PC Windows Server 2003
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-08-04 09:12 UTC by xtrim
Modified: 2008-08-07 03:14 UTC (History)
0 users



Attachments
Contains JUnit test class and documents used for testing. (69.61 KB, application/x-zip-compressed)
2008-08-04 09:12 UTC, xtrim
Details

Note You need to log in before you can comment on or make changes to this bug.
Description xtrim 2008-08-04 09:12:30 UTC
Created attachment 22368 [details]
Contains JUnit test class and documents used for testing.

The text contained in the comments of an excel 2007 document is not extracted.
Find in attachments the JUnit test class and the documents used for testing.
We expected to extract the words "testdoc" and "test phrase".

Notes on the attached documents:

- the documents "classic_TextInComment.xlsx" and "form_TextInComment.xlsx" contain the words "testdoc" and "test phrase" as comments.


"TestUnitPoi35Filter.java" is the JUnit class.
Comment 1 Nick Burch 2008-08-05 09:02:03 UTC
As with hssf, you need to call
   setIncludeCellComments(true)
to request that comments are included in the extraction (by default they're not)
Comment 2 Yury Batrakov 2008-08-07 02:31:29 UTC
Is there any chance that these issues aren't generated by robots and comments are ever being read? :)
Comment 3 Nick Burch 2008-08-07 03:14:02 UTC
No idea on the robot/person thing, but bugzilla entries do tend to come up high in google, so hopefully someone else will benefit from the report answer no matter what!