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
@ianpaul,
We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.
This issue has been logged as
CELLSNET-46715 - Cells.InsertCutCells() Issue
@ianpaul,
This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-46715”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.
@ianpaul,
Please try our latest version/fix: Aspose.Cells for .NET v19.4.6 (attached)
Your issue should be fixed in it.
Let us know your feedback.
Aspose.Cells19.4.6 For .Net2_AuthenticodeSigned.Zip (4.9 MB)
Aspose.Cells19.4.6 For .Net4.0.Zip (4.9 MB)
The issues you have found earlier (filed as CELLSNET-46715) have been fixed in Aspose.Cells for .NET v19.5. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi