[jira] Commented: (TIKA-148) The ExcelParsing should scan the cell comments

["Nick Burch (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TIKA-148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12798642#action_12798642 ] 

Nick Burch commented on TIKA-148:
---------------------------------

You can associate comments with cells, but it isn't all that easy. The "findCellComment" on HSSFCell shows how to do it, which is:
* For every TextObjectRecord, find the CommonObjectDataSubRecord of type OBJECT_TYPE_COMMENT that precedes it
* On that CommonObjectDataSubRecord, get the object ID
* Find a NoteRecord with a shape ID that matches the object ID just found
* The NoteRecord holds the row and column details

Normally the ordering of records in the file is CommonObjectDataSubRecord, TextObjectRecord, NoteRecord, cells, so you'd need to grab things as they went passed so they're to hand by the time you get to the cells.

> The ExcelParsing should scan the cell comments
> ----------------------------------------------
>
>                 Key: TIKA-148
>                 URL: https://issues.apache.org/jira/browse/TIKA-148
>             Project: Tika
>          Issue Type: Improvement
>          Components: metadata, parser
>         Environment: All
>            Reporter: Karl Heinz Marbaise
>            Priority: Minor
>         Attachments: comment.patch
>
>
> During the scanning of Excel documents it might be helpful to scan or analyze the cell comments of an excel worksheet as well.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.