A distinction between comments and notes?
I am trying to delete all the comments in a file, but leave the notes. I just asked this question on SO.
And then a bit later, came across this issue, where someone refers to the "shitty little VML file" that handles the comments. This inspired me to rip open the file and have a look. There's now a threadedComments
folder too. So this leads me to my requests:
- Is there a way to put a property on comments that distinguished between new comments (threaded style) and old ones (note style)? I'm guessing that either looking at the string contents, or if the comment is in both shitty little VML files, then it must be threaded?
- Either way, is there a way to go to the comments on the doc, I guess via the file, rather than having to iterate over the work book sheet by sheet and column by column?
p.s. this library is great