I’m currently playing around with the AutoFitRows function.
I have two overloads that are relevant:
worksheet.AutoFitRows(int startRow, int endRow)
The problem that has arisen is that if I want to apply AutoFitterOptions (in particular we are addressing merged cells), I must apply the auto fit to the whole worksheet.
What I require is an overload as such:
worksheet.AutoFitRows(int startRow, int endRow, AutoFitterOptions options)
so that the Options are applied to only a select set of rows instead of the whole worksheet.