This project has moved. For the latest updates, please go here.

Problem with height after autosize merged cells

Oct 19, 2012 at 10:45 AM
Edited Oct 19, 2012 at 10:46 AM

I have a several row with data, like example:

_____________________________

1    |   data1     |   longdata1

      |                |   longdata2

      |                |   longdata3

      |                |   longdata4

_____|_____________|___________

      |   data2     |

_____|_____________|___________

 I need to merge rows in 1-st and 3-rd columns, but after that, height of merged cells equals to height of data1 + data2, like that:

_____________________________

1    |   data1     |   longdata1

      |_____________|   longdata2

      |   data2     |   longdata3

_____|_____________|___________

 But i need height of rows equals to height of "longdata". When i trying get height of "longdata" cell before merging (ws.Row(i).Height), i always have default value 15

How i can get and set current height of row and merged cells?