I have a rather complex excel sheet where if i go to out_softvalidationresult Cell H3 excel displays the value false, but reading with aspose code reads the value true.
The error occurs on sheet Claimengine Cell DO 112 where excel displays a false and aspose reads a true.
Can you help me identify why aspose is reading true there (perhaps because of a wrong formula some where but i don’t see the error).
@info.verne.nu,
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-47029 – Incorrect value 'TRUE' retrieved from Cell instead of value 'FALSE'
I reproduced this issue in a different sheet. Where we have two cells with a similar formula however one cell reads no value (and return the number 0) and the other cell read the expected result (71).
When opening the sheet in excel both cells show the value 71.
We evaluated your issue further.
The issue was caused by incorrect formula data for some cells in the template file. If the template file was created by Aspose.Cells, we are afraid you should re-generate the file with our new fix (attached). If it is impossible for you to re-generate the file in the original way, you may try:
e.g Sample code:
Workbook wb = new Workbook(filename);
wb.Save("tmp.xlsx");
wb = new Workbook("tmp.xlsx");
wb.Save("newdoc.xlsb");
the newdoc.xlsb should be able to work for your case.
For your new issue/case, we will test it soon. At the same time, please try our latest fix/version Aspose.Cells for .NET 19.11.7, maybe the issue of the new case has already been fixed by it too.
I updated the code with some additional lines like your sample.
Workbook wb = new Workbook(filename);
wb.Save("tmp.xlsx");
wb = new Workbook("tmp.xlsx");
wb.Save("newdoc.xlsb");
However saving the excel sheet first to xls and then to xlsb does not solve the problem.
I also upgrade the cells dll toversion 19.11.7 (see bin folder).
Hope you can take another look.
This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-47029”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.
@info.verne.nu,
The regular release will be done at the end of third week of December. However we are discussing the possibility to provide a hot fix and will share our feedback soon.
@info.verne.nu,
We have observed the issue and logged this information in our database for our reference. We will write back here as soon as some feedback is ready to share.
We do not find any code of calculating formulas in your code segment. If you do not calculate the workbook, all cell values are those original values read from template file. For your template files and those specified cells, the original values saved in them are just those incorrect ones. The proper sequence should be:
filename = Path.Combine(basefilename, "tmp.xlsx");
document.Save(filename);
document = new Workbook(filename);
filename = Path.Combine(basefilename, "tmp.xlsb");
document.Save(filename);
document = new Workbook(filename);
document.CalculateFormula(true);
The issues you have found earlier (filed as CELLSNET-47029) have been fixed in Aspose.Cells for .NET v19.12. This message was posted using Bugs notification tool by Amjad_Sahi
We found another issue that is related to this one.
I updated my sample code the previous errors are fixed, but on the same sheet we now have cell EH3 which in excel displays false, but when reading in aspose is reading true. Can you take a quick look what is happening, and why this is now failing?
Thanks for the sample project with template file(s).
I tested your scenario/ case using your both your sample code with template file and MS Excel (manually). I am afraid for your mentioned issue (“cell EH3 which in excel displays false, but when reading in Aspose is reading true”), when I opened the file into MS Excel or even re-calculate formula manually (by double clicking in the cell and press enter), it still shows “True”, so this seems to me an expected return value, see the screenshot (attached) for your reference. sc_shot1.png (104.3 KB)
I see you screenshot but if i open ExcelSaveSample3.xlsb directly from the zip. I see False.
But i also see that in your screenshot fields EH13 have value and they should be empty. Can you please do a recheck or a screen sharing session with me?