DefaultRowHeight doesn't appear to work in XLSReadWriteII v4

[BlueKnight]

Hi,

I use XLSReadWriteII v4 to create a workbook, then I create a spreadsheet and I set the DefaultRowHeight for the sheet to 15. However, when I open the workbook in Excel, the default row height is 12.75. I have tried different values for DefaultRowHeight, as well as verifying the value before the file is written, but it always appears as 12.75 in Excel.

Any ideas?

Regards,

Bevan

[larsa]

Hello

DefaultRowHeight will not work if the row height is set explicit in the rows as this overrides the default setting.
Anyway, 15 is not a good value for row height as the height is a 1/20 of a point. 300 is a better value.

[BlueKnight]

Just to clarify, when I refer to the values 12.75 and 15, those are the row heights as shown in Excel - in my code I set the DefaultRowHeight to 300 (ie. 15*20), but Excel still shows the height as 12.75 for the rows which I don't specifically set the height for.

I just tried again now with a value of 2000 for the default row height, and Excel is still showing all rows as 12.75 (ie. 255).