Hello together
When I want to access a cell in my excel sheet with the following formula
=OFFSET(INDIRECT(CONCATENATE(“S_AV_TRK_NACHWEIS.L90N”,$C10)),0,$B$4+1)
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.
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.
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)
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.