merging cells and comments

[Guest]

Two questions according merging 2 cells together; 1 with contents and
comments, 1 empty cell.
When I merge 2 cells (vertically) together of witch the bottom cell contains
the data and comments, why does the comments disappear and the content stays?
I want to keep them both.
And secondly, when I unmerge the same two cells (with comments and
contents), why does the top cell contains always these data after unmerging,
and not the bottom cell?
How do I solve these problems?

thanks,
roland, belgium

 

[Peter T]

Hi Roland,

Only the top left cell of a Merged area can contain data or comments. When
you merge you will lose everything in the other cells. There's no way round
this, other than to check manually or programatically what you might want to
keep in the "other" cells, and if necessary move elsewhere before merging.

Regards,
Peter T