Welcome to the WinForms feedback portal. We’re happy you’re here! If you have feedback on how to improve the WinForms, we’d love to hear it!>
Thanks for joining our community and helping improve Syncfusion products!
Bug Details :
While hiding the rows in the worksheet, the position of the shapes doesn't change.
Code Snippet :
ExcelEngine excelEngine = new ExcelEngine();
excelEngine.Excel.DefaultVersion = ExcelVersion.Excel2016;
IWorkbook workbook = excelEngine.Excel.Workbooks.Open("Input.xlsm");
IWorksheet worksheet = workbook.Worksheets[0];
Int32 row = 11;
row++;
int i = (row + (1 + 1));
// additional blank line per request
while ((i <= 23))
{
worksheet.ShowRow(i, false);
i++;
}
workbook.SaveAs("Output.xlsm");
System.Diagnostics.Process.Start("Output.xlsm");
workbook.Close();