Notes in Excel2007
Posted: Tue Apr 16, 2013 10:36 am
Hello
Please provide an example to add note to a cell. For Excel97, the following code works:
BIFFDrawing is nil for Excel2007 mode, so I can't use it. Samples directory has an example called "Comment" that works for Excel2007:
but when I change version to Excel97, there are no commented cells in output file at all.
What is the correct way? Is there a proper code for both writing modes?
Tested on version 5.10.16.
Please provide an example to add note to a cell. For Excel97, the following code works:
Code: Select all
Result := xlsRW[0].Drawing.BIFFDrawing.Notes.Add;
Result.Text := text;
Code: Select all
XLS[0].Comments.Add(1,4,'Hello,world')What is the correct way? Is there a proper code for both writing modes?
Tested on version 5.10.16.