Axolot Data

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

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.

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).