Difference between "merged" and "covered" cells

[Holger Persch]

Hi,

Could some please explain the detailed difference between "merged" and "covered" cells and give an example when to use the one or the other.

Thanks in advance,
Holger Persch

[Holger Persch]

PS: It would also be usefully to know if there is a difference referable to the performance (speed) of the grid.

[Administrator]

They are really two different things.

Covered cells are when you want several cells in a rectangle to behave and look like a single large cell. This large cell has its properties set by the top left small cell. You provide a specific reactangular range to cells that you want to cover.

Merge cells occur when consecutive cells (either horizontally or vertically, but not both) have the same value. Setting merge cells will take these consecutive cells with the same value (or same style depending upon settings), and display it as a single large cell. So, you really do not specify a range per se. Instead the range is determined by the like values in the cell.