Hello,
I have an issue when I merge 2 worskheets in 1.
The merge works fine, but when I right-click on a row, it’s impossible to Insert or delete a row, could you please advice?
Thanks
Regards
Below is my code:
Workbook destWorkbook = new Workbook();
Worksheet destSheet = destWorkbook.Worksheets[0];
using (MemoryStream m1 = new MemoryStream(templateFile))
{
Workbook workBook = new Workbook(m1, new LoadOptions(LoadFormat.Xlsx));
Worksheet claimsFiledWorksheet;
claimsFiledWorksheet = workBook.Worksheets[0];
FillClaimsFiledSheet(claimsFiledWorksheet, claimsFileds, reportFilter, dashboard.CompanyId);
PasteOptions options = new PasteOptions
{
PasteType = PasteType.All
};
Range sourceRange = sourceSheet.Cells.MaxDisplayRange;
Range destRange = destSheet.Cells.CreateRange(sourceRange.FirstRow, sourceRange.FirstColumn, sourceRange.RowCount, sourceRange.ColumnCount);
destRange.Copy(sourceRange, options);
var totalColumnCount = sourceSheet.Cells.MaxDataColumn;
sourceRange = claimsFiledWorksheet.Cells.MaxDisplayRange;
destRange = destSheet.Cells.CreateRange(sourceRange.FirstRow, sourceRange.FirstColumn + totalColumnCount + 1, sourceRange.RowCount, sourceRange.ColumnCount);
destRange.Copy(sourceRange, options);
destSheet.AutoFitColumns();
destSheet.AutoFitRows();
destSheet.ActiveCell = "A1";
destSheet.Name = sourceSheet.Name;
destSheet.Protection.AllowEditingContent = true;
destSheet.Protection.AllowEditingObject = true;
destSheet.Protection.AllowEditingScenario = true;
destSheet.Protection.AllowDeletingRow = true;
destSheet.Protection.AllowDeletingColumn = true;
destSheet.Protection.AllowInsertingColumn = true;
destSheet.Protection.AllowInsertingRow = true;
WorkbookUtil.CopyStyleFirstRow(destSheet, firstDataRow, destSheet.Cells.MaxDataColumn);
using (MemoryStream m2 = new MemoryStream())
{
destWorkbook.Save(m2, SaveFormat.Xlsx);
}