search

JanKallman / EPPlus

Create advanced Excel spreadsheets using .NET
3.76k stars 1.18k forks source link

Epplus bug image with insertrow #578

Open alejandrohorcajo opened 4 years ago

alejandrohorcajo commented 4 years ago

Hello,

I have a problem with the EPPlus library. When taking an excel with image, when adding rows above it using .InsertRow(), the image does not change row. However, if I add a row directly using Excel, yes.

Any ideas?

Code:

worksheet.InsertRow(tableRowNum, 1);

worksheet.Cells[tableRowNum + 1, 1, tableRowNum + 1, tableCell.Column].Copy(worksheet.Cells[tableRowNum, 1, tableRowNum, tableCell.Column]);

Alexander-Hauser commented 4 years ago

What value is set for the "EditAs" property in your image in EPPlus?