I would like to get some help regarding threaded comments in Excel. I also attached a sample project with example output files (in Excel and xml output folders) to demonstrate my issue. Here are some further details:
- OS: Ubuntu 20.04, Windows Server 2019
- Aspose Cells version: 21.8.0
- Editor for Excel files: Microsoft Office 365 Online (both for editing and opening files)
Regarding the issue, I have an Excel file (test.xlsx) that contains threaded comments. I would like to process the comments in the file, both simple comments (equivalent to notes) and threaded comments because I experienced that threaded comments are also processed as notes, independently from the threaded comment itself.
However, in case I modify any of the note’s properties (e.g: Author or Note), it leads to a broken threaded comment structure: threaded comments are converted to simple notes when opening the output in Excel 365 online which means that only the note modifications will appear, threaded comment contents disappear. In contrast, when the note’s properties remain untouched, the threaded structure is correct too. What can be the cause of this problem? (Note: updating both the note’s and threaded comment’s properties was successful.)
I also checked the threaded comment xml files after unzipping the output Excel files in these 2 cases, but there was no difference.
Furthermore, I would like to ask a question too. I realized based on the info written to the console, that modifying a property of a threaded comment author will apply to every other instance of that same author. In other words, if I want to modify the name of an author, I do not need to loop through every comment and set its author’s name, but it is enough to do that once. Does this happen based on the author’s UserId field or what is the mechanism behind this?
Thank you for your help in advance!
ThreadedComments.zip (29.5 KB)