Setting Range.RowHeight has no effect


#1

When I tried to set the row height by forming a range encompassing the row, it had no effect. Setting the ColumnWidth property through the range object worked fine.

// Works
excel.Worksheets[0].Cells.CreateRange(1,1,true).ColumnWidth=0.5;

// Doesn’t work
excel.Worksheets[0].Cells.CreateRange(1,1,false).RowHeight=0.5;

// Works
excel.Worksheets[0].Cells.SetRowHeight(0,3.75);


I’ll use the Cells.SetRowHeight method instead, as this works okay. Any thoughts on why Range.RowHeight has no effect?

Regards,

Josh


#2

Dear Josh,

Please download fix 1.8.5 and have a try.