Good day
When I hide rows with:
Aspose.Cells.Worksheet ws = wb.Worksheets[0];
ws.Cells.HideRow(iC);
and export via:
Aspose.Cells.Rendering.ImageOrPrintOptions iopo = new Aspose.Cells.Rendering.ImageOrPrintOptions();
Aspose.Cells.Rendering.SheetRender sr = new Aspose.Cells.Rendering.SheetRender(ws, iopo);
the export is fine, with the hidden row not shown.
But if I autofit the rows with:
Aspose.Cells.AutoFitterOptions autofit = new Aspose.Cells.AutoFitterOptions(); autofit.AutoFitMergedCells = true; ws.AutoFitRows(autofit);
before the export, the hidden rows are shown again.
The AutoFit resets the visible setting on the rows.