BoldSignEasily embed eSignatures in your .NET applications. Free sandbox with native SDK available.
IRange pasteRangeFrom = tempWorkSheet.Range[1, 1, tempWorkSheet.UsedRange.LastRow, tempWorkSheet.UsedRange.LastColumn];
IRange pasteRangeTo = reportWorkSheet.Range[reportWorkSheet.UsedRange.LastRow + 1, 1];
//pasteRangeFrom.EntireRow.CopyTo(pasteRangeTo, ExcelCopyRangeOptions.None);
//pasteRangeFrom.EntireColumn.CopyTo(pasteRangeTo, ExcelCopyRangeOptions.None);
reportWorkSheet.StandardHeight = tempWorkSheet.StandardHeight;
int startCol = pasteRangeTo.Column;
for (int col = startCol; col <= reportWorkSheet.Workbook.MaxColumnCount; col++)
{
reportWorkSheet.SetColumnWidth(startCol, tempWorkSheet.GetColumnWidth(col));
startCol++;
}
pasteRangeFrom.CopyTo(pasteRangeTo, ExcelCopyRangeOptions.All); |
Issue |
Details |
At this time I'm using Syncfusion version is 16.4450.0.54.
The InertRow function cannot insert many rows. After 21st row it raised the following Error:
System.ArgumentOutOfRangeException: The specified argument is not in the range of valid values.
I tried to update the latest version and at The latest version, the InsertRow function works normally
|
We are able to reproduce the issue while inserting more than 19 rows at index 21. This issue is reproduced in v16.4 as well as in our latest version 17.1. We will validate and update further details by 31st May 2019. |
But the image in the xls file couldn't copy into new Paste Range.
Could you please explain why InsertRow did not work at 16.4450.0.54 version
and How to copy image when you copy and paste to new Paste Range.
|
We are able to reproduce the issue and validating it currently. We will update further details by 31st May 2019. |
System.ArgumentOutOfRangeException: The specified argument is not in the range of valid values.
I tried to update the latest version and at The latest version, the InsertRow function works normally
|
We have validated the issue. The issue is reproduced while inserting with conditional formatting. We have logged an issue report for “Exception throws while inserting Rows with conditional formatting” and the patch for the fix will be available on June 14, 2019. |
But the image in the xls file couldn't copy into new Paste Range.
Could you please explain why InsertRow did not work at 16.4450.0.54 version
and How to copy image when you copy and paste to new Paste Range.
|
The reported image is not as picture. It’s as group shape. We don’t have a group shape support for binary format(xls file). |