https://issues.apache.org/bugzilla/show_bug.cgi?id=49185
Summary: Implementation of HSSFName#getComment - descriptive
text or comment record
Product: POI
Version: 3.7-dev
Platform: PC
OS/Version: Linux
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=25352)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=25352)
a spreadsheet with a single named range with a comment
I am trying to read a spreadsheet created in excel 2007 and saved as an "Excel
97-2003 Workbook". Using the new UI for the name manager, I create a Name whose
name is "foobarName" and whose comment is "This is a comment". POI claims that
the comment for the name is blank. It should be noted that reading the xlsx
file, POI correctly returns the comment.
I have looked at the xls file produced by excel (attached) and noticed an
unknown record (0x894). This seems to be the record intended to store the
comment for names.
The current implementation of HSSFName#getComment uses the "Description text"
field of the NAME record. Unfortunately I have no idea what "Description text"
is supposed to contain and so I'm loathed to suggest simply ignoring this field
in favour of the NAMECMT record.
I am currently working on a patch for support of NAMECMT records but would like
to know what the correct behaviour should be.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
