1
Vote

Column AutoFit doesn't take AutoFilter size into consideration.

description

Just a small visual thing that I noticed (thank you OCD), if I am using AutoFilter, and then apply a column AutoFit, it doesn't take the size of the AutoFilter into consideration when applying the AutoFit size.

So in some columns the text will be covered by the AutoFilter, although re-applying an AutoFit once inside Excel will remedy the situation.

For example:
//Turn on the AutoFilter
workSheet.Cells[2, 1, 2, LastCell].AutoFilter = true;

for (var col = 1; col <= totalCols; col++)
{
workSheet.Column(col).AutoFit();
}

Thanks,
Ian

BTW, I love this tool, my reports even look nicer than the ones people can generate using SAP Business Objects!

file attachments

comments