Free Support Forum -

Rows grouping damages comments

Hi, Laurence!
When I group some rows and hide 'em, cell comments change their height. Some comments collapse to zero-height. Code sample to reproduce:

// create comment
int commentIndex = excel.Worksheets[0].Comments.Add(11, 0);
Comment comment = excel.Worksheets[0].Comments[commentIndex];
comment.Note = "Hello!";

// group some rows
excel.Worksheets[0].Outline.SummaryRowBelow = true;
excel.Worksheets[0].Cells.GroupRows(11, 12, true);
excel.Worksheets[0].Cells.GroupRows(14, 17, true);
excel.Worksheets[0].Cells.GroupRows(10, 18, true);

Is there any workaround? Or maybe this bug is easy to fix?

I have another piece of code where comments change their positions moving very far from the cell they are used to annotate. That sample is more complex to reproduce (6 grouping levels), and it's fully dynamic, so I can't send the code sample.

Changing comment.Height property don't fix the problem with the height. Comment position cannot be changed directly as Comment don't contain properties like Top and Left.

I found this problem and will fix it ASAP.

Ok, thank you!