XOR function is not supported?

Aspose.Cells Product Family
1

I was very surprised that one of our excel files failed to work in Aspose.Cells for Java (2019.1).
I narrowed it down to a formula that contains the XOR function.
Is XOR function really not supported?

2

@sfriedrich,

Thanks for your query.

I tested in a simple scenario where I loaded a template file (containing a cell having XOR formula/function) and calculated the formula via Aspose.Cells APIs, it does not work well against the “XOR” formula. Could you provide us your template file (containing your mentioned formula) and paste your sample code (runnable) to show the issue, we will check and log a ticket for it, so it could be fixed precisely.

3

Unfortunately I cannot send the original file (because it contains a lot of confidential data from one of our clients).
I could create a simple example file plus code, if that helps.

4

@sfriedrich,

Kindly provide the example file and sample code, we will check it soon.