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


#21

@taruney,
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:


#22

@taruney,

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.
[.NET]
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]
Aspose_Cells_Java_v19.9.3.zip (6.6 MB)


#23

Fix is part of 19.10.0??


#24

@taruney,

Yes, your understanding is correct.


#25

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).


#26

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


#27

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.


#28

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??


#29

@taruney,

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.


#30

ValueError.zip (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


#31

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.


#32

@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.


#33

Working Version: 19.8.0.0
Issue Observed Version: 19.10.0.0


#34

@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)


#35

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


#36

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)


#37

@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


#38

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


#39

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


#40

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