AutoFitRows expands hidden grouping

Aspose.Cells Product Family
1

Hi ...this also applies for AutoFitRow method.

regards

Rale

Workbook wb = new Workbook();

wb.Worksheets.Clear();

Worksheet ws = wb.Worksheets.Add("New");

ws.Cells[5, 5].PutValue(34);

ws.Cells[5, 5].Style.Font.Size = 23;

ws.Cells.GroupRows(3, 9, true);

ws.AutoFitRows();

wb.Save(@"Result.xlsx", FileFormatType.Excel2007Xlsx);

2

Hi,
Thank you for considering Aspose.
Well, it is the behavior of MS Excel. If you group the rows first and then AutoFit them, rows will get expended. You may try to auto-fit the rows first and then group them.

Workbook wb = new Workbook();
wb.Worksheets.Clear();
Worksheet ws = wb.Worksheets.Add("New");
ws.Cells[5, 5].PutValue(34);
ws.Cells[5, 5].Style.Font.Size = 23;
ws.AutoFitRows();
ws.Cells.GroupRows(3, 9, true);
wb.Save(@"Result.xlsx", FileFormatType.Excel2007Xlsx);

Thank You & Best Regards,