Finding inconsistency in excel output for the same input using Aspose Cells java

Aspose.Cells Product Family
,
21

@amjad.sahi
I will check the Paid support link given by you. I wanted to know by any chance can you provide us with ETA for the existing issue id (“CELLSJAVA-45725”) as our team is waiting for the resolution.

22

@gkamdar,

We are evaluating/analyzing your issue. Hopefully, we will get back to you soon with the latest updates/ETA on your issue. Once we have an update on it, we will let you know here.

23

@gkamdar
The issue was caused by circular references when refreshing dynamic formulas and calculating formulas. We are working on it and try to solve it in this week. In fact it is a bit complicated and maybe we need more time. We will let you know here when we get any progress.

24

@johnson.shi: thanks for the update

25

@gkamdar

You are welcome and thank you for your patience.

26

@gkamdar,

This is to inform you that your issue has been resolved. The fix will be included in the upcoming release (Aspose.Cells v23.12) that we plan to release in the next week. You will be notified when the next version is published.

27

thank you for the update

28

@gkamdar,

You are welcome.

29

@amjad.sahi:- One question the fix that you found worked for both the examples that I posted on the forum?

30

@gkamdar,

Yes, it will work for both your example (Excel) files.

31

@amjad.sahi thank you

32

The issues you have found earlier (filed as CELLSJAVA-45725) have been fixed in Aspose.Cells for Java 23.12.

33

@amjad.sahi : I am trying to download the repository from maven and I get the below error

Failure to transfer com.aspose:aspose-cells:pom:23.12 from Aspose Repository Browser /java/repo/ was cached in the local repository, resolution will not be reattempted until the update interval of AsposeJavaAPI has elapsed or updates are forced. Original error: Could not transfer artifact com.aspose:aspose-cells:pom:23.12 from/to AsposeJavaAPI (Aspose Repository Browser /java/repo/): sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

pom.xml

            <repository>
		<id>AsposeJavaAPI</id>
		<name>Aspose Java API</name>
		<url>https://releases.aspose.com/java/repo/</url>
	</repository>

           <dependency>
		<groupId>com.aspose</groupId>
		<artifactId>aspose-cells</artifactId>
		<version>23.12</version>
	</dependency>
	<dependency>
                   <groupId>com.aspose</groupId>
                   <artifactId>aspose-cells</artifactId>
                   <version>23.12</version>
                   <classifier>javadoc</classifier>
            </dependency>

Can you pls help here.

34

@gkamdar ,

It works OK on our side.
Is your network behind some proxy?
If possible, please try it on the other end/environment.

35

@peyton.xu : I tried with other environment and I still see the same error.
is there some problem with the repo

    <repository>
	<id>AsposeJavaAPI</id>
	<name>Aspose Java API</name>
	<url>https://releases.aspose.com/java/repo/</url>
</repository>

Please revert on this as we are getting delayed to implement our fix.

Thanks,
Priyanka

36

@gkamdar,

Could you please provide your complete environment details? Are you using some dedicated Azure VM or something else? If true, then we have to verify your IP address, so you will require to kindly share the IP address for verifications.

37

@amjad.sahi : I got the above issue sorted. But I still find the mismatches. will attach the files in sometime. Is there any additional code that I need to add to make this work?

38

@gkamdar,

Good to know that your issue regarding maven repository downloads is sorted out now.

You meant there are still some differences in formula calculations by Aspose.Cells for Java? Please provide more details, sample Excel file(s), and sample code that you are working with. We will check your issue soon.

39

@gkamdar

There may be some dynamic array formulas which need to be refreshed when data they depend on changed. So, please call refreshDynamicArrayFormulas(boolean calculate, CalculationOptions copts) before calculating formulas. Code sample:

Workbook wb = ...
...
wb.refreshDynamicArrayFormulas(true, new CalculationOptions());
wb.calculateFormula();
...

If you still find some formulas have not been calculated with expected results, please send us your template file and code to reproduce the issue. If you are using the file you have attached in this post, please point out the cells which have not been calculated correctly. With those resources we will look into the issue for you soon.

40

@johnson.shi : Here is the attached files along with code. I can see mismatches for a lot of columns in output sheet (E167, F167, G167 , D57:D70, E57:E70,F57:F70)
I have colored the mismatch columns in red in both the excels.

I am using the <aspose-cells.version>23.12</aspose-cells.version>

Code snippet:

workbook.refreshDynamicArrayFormulas(true, new CalculationOptions());
workbook.calculateFormula();

Please let me know if you need any more details from my end.
excel-mismatch-example2.zip (3.0 MB)

Thanks,
Priyanka