AutoFitRow(int) doeant unhide a hidden row

Aspose.Cells Product Family
1

Hi,


Running “ActiveSheet.Cells.Rows(n).AutoFit” on a sheet where the “nth” row is hidden, unhides it. Whereas , running “w1.Worksheets[0].AutoFitRow(n);” doesn’t.

Please look into this

Thanks


2

Hi,

Thanks for your posting and using Aspose.Cells.

AutoFitRow(s) does not unhide the hidden row and it is correct behavior.

If you think otherwise, then please provide us your sample code and sample file to look into this issue. We will investigate it and help you asap.

3

Hi,


If you run:


Sub Macro()

ActiveSheet.Cells.Rows(2).AutoFit

End Sub

…on test1.xlsx, the 2nd hidden row is unhidden

Thanks
4

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue. Autofit Macro code unhides the hidden row.

As a workaround, could you please use the following code to unhide the hidden row.

C#
worksheet.Cells.UnhideRow(3, 25);