AutoFitRows overload

[Jamadan]

Hi,

I’m currently playing around with the AutoFitRows function.

I have two overloads that are relevant:

worksheet.AutoFitRows(AutoFitterOptions options)

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.

Cheers

[Amjad_Sahi]

Hi,

Well, you may try to use the overloaded method:

Worksheet.AutoFitRow(Int32, Int32, Int32, AutoFitterOptions) to auto-fit your selective rows individually with AutoFitterOptions set, you may loop through your desired set of rows for your needs.

Thank you.

[Jamadan]

Yeah I have managed to get it working using your suggested work around.

Thanks

[Amjad_Sahi]

Hi,

Good to know that it works for your needs. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.

[Amjad_Sahi]

Hi,

Please try our latest version/fix: Aspose.Cells for .NET v8.1.2.4

We have included AutoFitRows(int startRow, int endRow, AutoFitterOptions options) overload to the list now.

Let us know your feedback.

Thank you.

[aspose.notifier]

The issues you have found earlier (filed as CELLSNET-42892) have been fixed in this update.

---

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.