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!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

1
Vote

Bug Details : 

While hiding the rows in the worksheet, the position of the shapes doesn't change. 

The shape’s position is update using UpdateAnchorPoints() method and it is not working proper 
which cause the issue. 


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();