When using the Cells.InsertCutCells()
to cut a row/column with a cell formula to other non-cut cells, the cut cell formulas don’t stay referenced to those non-cut cells. However the non-cut cells still reference the proper cells.
E.g. if you run the follow code through the attached workbook on the “Input” worksheet, you’ll receive the “Output” worksheet result instead of the “Expected Output” which is what you receive if you follow the same logic with Interop.
Workbook wb = new Workbook(“test failing vForum”);
Worksheet ws = wb.Worksheets[“Input”];
Range cut = ws.Cells.CreateRange(“9:9”);
ws.Cells.InsertCutCells(cut, 4, 0, ShiftType.Down);
test failing vForum.zip (10.2 KB)
Blockquote