I am still testing the release you sent me in post https://forum.aspose.com/t/106755
Now, I have other issues. Let's look at the following example. I am simulating a N/A in cell A1 (with a failing lookup), then I want to sum A1:A3 (in B3). In Excel, the result of this sum is N/A, but in Aspose, it is 5 (i.e. as if A1 equals 0).
Workbook wb = new Workbook();
Cell a1 =sheet.getCell("A1");
Cell a2 =sheet.getCell("A2");
Cell a3 =sheet.getCell("A3");
Cell b1 =sheet.getCell("B1");
Cell b2 =sheet.getCell("B2");
Cell b3 =sheet.getCell("B3");
Will provide the following output:
What's your opinion on this matter ?
Thanks in advance,