https://bz.apache.org/bugzilla/show_bug.cgi?id=66462
Bug ID: 66462
Summary: Read author of threaded comments
Product: POI
Version: 5.2.2-FINAL
Hardware: PC
OS: Mac OS X 10.1
Status: NEW
Severity: major
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Hi,
MS Excel 365 allows adding threaded comments.
But if read such comment via POI API like:
> try (Workbook workbook = WorkbookFactory.create(new File("Threaded
> Comment.xlsx"))) {
> var sheet1 = workbook.getSheet("Sheet1");
> var comment = sheet1.getCellComment(new CellAddress("B6"));
> System.out.println(comment.getAuthor());
> }
API returns author name like: tc={F049E3E4-F46C-4142-BC23-765F15BF2866}
That is not correct, because it's an ID to the person from
/xl/persons/person.xml file with the following content:
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <personList
> xmlns="http://schemas.microsoft.com/office/spreadsheetml/2018/threadedcomments";
> xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main";>
> <person displayName="John Smith"
> id="{0308133B-9C44-2641-B9DF-A3A2B2FF3930}" userId="9ea07f6ebf54614f"
> providerId="Windows Live"/>
> </personList>
Is there any API to read a correct author name for such comments? If no, could
you please fix this issue and provide an API for it?
--
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]
