We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Input string was not in a correct format / OFFSET / #VALUE!

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.

Thanks for your support

@clipch,

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

@clipch,

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 :frowning:

Can it be that it does not work with Excel in German?

image.png (49.3 KB)

@gigidegi,

I do not think the issue is due to Excel in German. Anyways, we will look into it further.

@gigidegi,

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

Chris

@gigidegi,

You are welcome.