Free Support Forum - aspose.com

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

@taruney,
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: 19.8.0.0
Issue Observed Version: 19.10.0.0

@taruney,
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 checkValueError1.zip (78.3 KB)

@taruney,
We were able to observe the issue but we need to look into it more. 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-46994 – #Value! in the output Excel file (Opened in Excel 365) after calling the Calculate Formula

Even we observed for few sheets we are getting null exception when we calculate formula for workbook.
(NullReferenceException: Object reference not set to an instance of an object.(Based on cell OrgEngine!AR11) for one of the cell OrgEngine!AR11…Earlier it was working

@taruney,
Could you please share template file which produces the exception. We will reproduce the problem and provide our feedback after analysis.

Please find the sample file where we are getting object null exception …Same code. Sample_Cp75.zip (56.8 KB)

Please provide fix asap…We are waiting for fix from long time.

@taruney,
We were able to observe the issue where exception is raised but we need to look into it more. 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-47001 – CalculateFormula() causes NullReferenceException

@taruney,
This is to inform you that we have fixed your issues (logged earlier as “ CELLSNET-47001” and “CELLSNET-46994”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

Thank you…Please provide fix as soon as possible.

@taruney,

You should be getting the fix/version in 1-2 days.

Keep in touch.

@taruney,
Please try our latest version/fix: Aspose.Cells for .NET 19.10.6 (attached).

Your issues (logged earlier as “ CELLSNET-47001” and “CELLSNET-46994”) should be fixed in it.

Let us know your feedback.
Aspose.Cells19.10.6 For .Net2_AuthenticodeSigned.Zip (5.0 MB)
Aspose.Cells19.10.6 For .Net4.0.Zip (5.0 MB)

We are seeing similar issue in other sheets and circular references are not getting resolved.We will update once we complete our testing…

@taruney,

Please take your time to evaluate the new fix/version. If you find any issue, kindly provide us your sample code (runnable) or preferably a 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) and some screenshots to highlight the issue. This will help us really to evaluate your issue precisely to consequently figure it out soon.

A post was split to a new topic: Value error while evaluating the formula

@taruney,
As this issue is different than the title of this post, so I have split it to a new post. Please follow it there as this thread is getting too long to maintain.

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