search

JanKallman / EPPlus

Create advanced Excel spreadsheets using .NET
3.76k stars 1.18k forks source link

ExcelWorksheet.DefaultRowHeight does nothing #241

Open avianrand opened 6 years ago

avianrand commented 6 years ago

I've tried several variations on this and posted questions about it in other places. It seems to have no effect. Is this a bug?

Dim ep As ExcelPackage = New ExcelPackage Dim wks As ExcelWorksheet wks = ep.Workbook.Worksheets.Add("test") wks.DefaultRowHeight = 15

I have a ton more code that follows that creates a several dozen sheet workbook with datavalidation, merged cells, formatting, formulas, etc. It all works great. I just discovered this tool a few nights ago. It's great. But DefaultRowHeight does nothing no matter what I set it to.

xKushGene commented 6 years ago

I guess all Height are broke. because this also doesn't work: ws.Row(10).Height = 12.75;