Hi Greg,
I tested with the attached file but was able to successfully read the comment in cell A1. Please try running this sample
F18371ReadComments_8637.zip
and let me know if you see the problem in this sample also. I am using version 2.1.0.9.
Also, the other issues[Bool, error support] that you had reported in this thread have been fixed internally. Thank you for your co-operation.
Best regards,
Stephen.
>Stephen,
>
>3) I presumed that was the syntax. Unfortunately it doesn''t work. irange.Comment fails.
>
>5) Yes, that actually works. My bug appears to be with .Net''s string.Trim() function (not researched further). I''ve changed it to .Replace() and all is good.
>
>Please actually try reading a comment from an xls file that you open. ... OK, I''ll send you one. I get error: ''ecell.Comment.Text'' does not exist (and yes, the ecell is the correct irange, verified by checking ecell.Text)
>
>Thanks,
>Greg
>
>
>>Hi Greg,
>>
>>1) The bug with ExcelRW not reading Bool entries, error entries will be fixed soon.
>>
>>2) The bug with HasFormula and FormulaHidden returning objects will also be fixed.
>>
>>3)You can read the comments in a cell using
>>
>>IWorksheet.Range["A2"].Comment.Text
>>
>>4) Comments height issue will also be fixed.
>>
>>5) Use for new lines in comments
>>
>>mySheet.Range["B4"].AddComment().Text = "HelloWorldThisisatest";
>>
>>We really appreciate your suggestions and feedback.
>>
>>Best regards,
>>
>>Stephen.
>>
>>>Good Day,
>>>
>>>I am able to open and read many more files, thanks. A problem I encountered today is not being able to read boolean entries, directly edited error entries, and comments. I suspect that I simply don''t know how to go about reading comments, although I did successfully write comments (wish the comment box size was auto-created - I had to give it a height to be practical)
>>>
>>>In Excel, enter
>>>True
>>>into a cell, and
>>>False
>>>into another cell, and
>>>#Value!
>>>into another cell. All without quotes. The first two create Boolean cell types, while the third creates an Error cell type (as seen in XML Spreadsheet export). When I read this xls file, I get cell.IsBlank is true on all three of these. I want to be able to read and write these value types, but it seems you are only currently supporting Formulas, Text, and Numbers.
>>>
>>>Also note that the HasFormula returns a System.Object instead of a bool. There is another, I think FormulaHidden that also is typed as object when it should be bool.
>>>
>>>As for the comment, entering one in Excel, I can discover no method to retrieve it during ExcelRW reading. I was able to create one with AddComment, but had to strip out my \r and characters as Excel displayed unknown graphics for those. Not sure what I need to use for newlines in comments yet.
>>>
>>>Please let me know how to do all of the above.
>>>
>>>Thanks,
>>>Greg
>>>
>
>
comment1_2732.zip
>
>