Free Support Forum -

Insert Range is causing file corruption to the workbook which has custom formatting/Styles applied for target worksheet

We have noted the request and will share the DLL with you soon.

Now file is not corrupted …but when i copy data to inserted Range.few cell data is missing.Which is working earlier version

Could you please provide more details about this issue along with the environment details in which this issue is tested? Are you using the same template file and if different, please share the new template file as well.

I tried using framework 4.0 dll in .netstandard project may creating some issue…i will try with .netstandard 2.0 dll…when i can get .netstandard2.0 dll??
Please mention dependent libraries needed for this dll

Yes, its better that you test the issue with the .NETStandard 2.0 version when available. We will notify you here once it is ready to share. Following are the dependencies for .NET Standard 2.0 as mentioned here:


Please try our latest version/fix (.NET and Java): Aspose.Cells v19.9.3 (attached)
(Please choose/download the appropriate fix for your underlying platform/language)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells19.9.3 For .Net2_AuthenticodeSigned.Zip (4.9 MB)
Aspose.Cells19.9.3 For .Net4.0.Zip (4.9 MB)
Aspose.Cells19.9.3 For .NetStandard20.Zip (4.1 MB)

[Java] (6.6 MB)

Fix is part of 19.10.0??


Yes, your understanding is correct.

When we are testing with these changes,after populating data into inserted ranges …we are facing exception when we calculate formula for whole workbook which was working with earlier releases
Exception: Aspose.Cells: NullReferenceException: Object reference not set to an instance of an object.(Based on cell OrgEngine!AR11).

The issues you have found earlier (filed as CELLSNET-46916) have been fixed in Aspose.Cells for .NET v19.10. This message was posted using Bugs notification tool by Amjad_Sahi

Please provide us sample console demo application (you may zip the project prior attaching) to reproduce the issue, we will check it soon. Also provide your template files (input file (if any) and output file(s)). We will check it soon.

Is it possible to find issue by seeing exception and comparing changes done in this release??? .We need to create same scenario in Sample code with similar data and not easy for us .

in which scenario this exception can occur??


I am afraid, “NullReferenceException… Object reference not set to an instance of an object” has many scenarios so we cannot evaluate the issue based on the exception message or error trace. Please take your time to create the sample application to demonstrate the issue. (242.3 KB)
Please find the sample code where we are getting #Value error after calculateformula which was working before this fix .

After inserting the ranges if we copy any formula, we are getting #value errors.
After Executing the code with input excel, check S9 and S2 cells in output excel

Please analyze this issue asap. We took some time to create this sample.There is some issue with insert range and assigning the formula within range and also we are getting some issue with circular reference when we calculate formula.

We have observed the issue but need to know which version was working fine which you have mentioned here, as we want to test the scenario using that version as well.

Working Version:
Issue Observed Version:

I can not reproduce this issue with Aspose.Cells for .NET 19.10.4 version. S2 cell displays the value as 1234 and S9 displays 0.00% as in screenshot.ok.JPG (10.4 KB)

Please try it with Aspose.Cells for .NET 19.10.4 version.

Aspose.Cells19.10.4 For .Net2_AuthenticodeSigned.Zip (5.0 MB)
Aspose.Cells19.10.4 For .Net4.0.Zip (5.0 MB)

.Net 19.10.0 …it is happening .i think 19.10.4 is not released

We are able to reproduce with 19.10.4 .
Attached Screen shot
image.png (136.9 KB)
Office: Microsoft office 365
attached Both input/output Sample file and code to reproduce.
Please (78.3 KB)