I am unable to access the font properties of a cell comment that has been added manually within Excel itself. To reproduce my scenario:
- Within Excel, add a comment to cell A1.
- Clear the default comment text (author) and add new text eg. 'Hello'
- Set the font size of the entire comment text to 8 points, the colour to red and non-bold.
Open that workbook in Aspose.Cells and instantiate the comment eg (in VB):
Nowhere in the properties of oComment can I find IsBold=False and the correct font size, colour etc. I'm sure it's there somewhere but I can't find it!
The problem is not encountered when the comment is created by Aspose.Cells like this:
ws.Comments(1, 0).Note = "Hello"
ws.Comments(1, 0).Font.IsBold = False
ws.Comments(1, 0).Font.Color = Color.Fuchsia
Unfortunately my application needs to manipulate comments in a workbook that were created manually within Excel. I hope you can enlighten me!