When I want to access a cell in my excel sheet with the following formula
I get the error message:
“Input string was not in a correct format.” and in the debugger I see #VALUE!
I tried this with EPPlus and there I can read the value.
Can it be that Aspose.Cells can not handle such Excel formulas.
Thanks for your support
Could you please zip your template Excel file and paste your sample code to reproduce the issue, we will check it soon.
AV_ASPOSE_TEST_WinFormsApp1.zip (5.4 MB)
AV_ASPOSE_TEST.zip (91.5 KB)
Here is the XLS and the application.
It seems to be the “workbook.CalculateFormula()” ?!
Thanks for the support
Thanks for the template file.
Please try our latest version/fix: Aspose.Cells for .NET v22.8 (Download | NuGet). I have tested using your sample code segment and template file and it works fine, I do not get any exception or error.
Let us know if you still find any issue or error with latest version/fix.
Unfortunately, it still does not work for me
Can it be that it does not work with Excel in German?
image.png (49.3 KB)
I do not think the issue is due to Excel in German. Anyways, we will look into it further.
I evaluated your issue further.
I did open your template file “AV_ASPOSE_TEST.XLSM” into MS Excel 2016 manually and found the cells in those columns (e.g., Y column in “07” sheet) are calculated as “#VALUE!”. See the screenshot attached. Aspose.Cells will also calculate as “#VALUE!” when using Workbook.CalculateFormula() method.
sc_shot1.png (92.5 KB)
Unfortunately I can’t open the png file. I have changed my account. Probably that is the reason.
In that case it seems to be an Excel problem. I will analyze the excel file.
Thank you very much for the support.
Greetings from Switzerland