You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2023/02/02 10:47:10 UTC
[Bug 66462] New: Read author of threaded comments
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: dev@poi.apache.org
Reporter: pvladislavs@gmail.com
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 66462] Read author of threaded comments
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=66462
Larry Martin <ps...@hldrive.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Alias| |Larry
--- Comment #3 from Larry Martin <ps...@hldrive.com> ---
Explore the Comments API in Microsoft Excel as it allows for a more direct and
precise extraction of author information. By leveraging this approach you can
avoid the current issue with the ID representation and obtain the accurate
author name.
Visit
https://procommercialcleaningusa.com/dsc/commercial-standard-cleaning-cypress/
Commercial Standard Cleaning Services in Cypress
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 66462] Read author of threaded comments
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=66462
Mark Thomas <ma...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Alias|Henry, Larry |
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 66462] Read author of threaded comments
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=66462
--- Comment #2 from Elias Levine <je...@gmail.com> ---
Really, to be able to understand how to use this excel, you need to learn and
practice. I have referenced this document https://geometrydashlite.co it's easy
to understand.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 66462] Read author of threaded comments
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=66462
PJ Fanning <fa...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |DUPLICATE
--- Comment #1 from PJ Fanning <fa...@yahoo.com> ---
POI does not support threaded comments - they only arrived in Excel in recent
years and noone has worked on them.
*** This bug has been marked as a duplicate of bug 65462 ***
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 66462] Read author of threaded comments
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=66462
Henry Liam <he...@tmpeml.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Alias| |Henry
--- Comment #4 from Henry Liam <he...@tmpeml.com> ---
Is this <a href="https://abdc.axd">information</a> useful?
Is this information useful?
Is this [url=https://abdc.axd]information[/url] useful?
Is this [information](https://abdc.axd) useful?
Is this [https://abdc.axd information] useful?
Is this [link=https://abdc.axd]information[/link] useful?
[information][1]
[1]:https://abdc.axd
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org