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

Free Support Forum - aspose.com

workbook.Open throws exception - Invalid Formula

Hi,

I'm trying to open a workbook which opens using Excel 2007 with Aspose.Cells

Workbook workbook = new Workbook();
workbook.CalcMode = CalcModeType.Manual;
workbook.ReCalcOnOpen = false;
workbook.Open(path);

and I'm gettign the exception below.

How can I prevent this exception? I do not need any calculations, just some values which are not calculated.

Thanks in advance,
Raimondo

Invalid formula:"'VGO + Freight'!$G$37".
Message Invalid formula:"'VGO + Freight'!$G$37".
StackTrace at x9d2539cac3622db3.x40937ad35b1cf5f7.x1f490eac106aee12(String x5518c79299afe5d9, Int32 xa806b754814b9ae0, Int32 xe3e287548b3d01f5, xc6fc9f03cbfcc296 xa4aa8b4150b11435, Boolean xa76cb9c5bdf91339)
at xabb58b8f2887ff8e.xb470a2a0cf1d462e.x596c9eca295be240(XmlTextReader xb9763b0038341e6c, x88920ec2ac291d92 x91e0345c20e91a3a)
at xabb58b8f2887ff8e.xb470a2a0cf1d462e.x312b6c5e4f0b92d5(XmlTextReader xb9763b0038341e6c)
at xabb58b8f2887ff8e.xb470a2a0cf1d462e.x06b0e25aa6ad68a9(XmlTextReader xb9763b0038341e6c)
at xabb58b8f2887ff8e.x9d49ab444acbddce.xaf2022b282675601()
at xabb58b8f2887ff8e.x9d49ab444acbddce.x06b0e25aa6ad68a9()
at Aspose.Cells.Workbook.Open(Stream stream, FileFormatType type)
at Aspose.Cells.Workbook.Open(String fileName)

Hi,

Please try the attached version v4.8.2.3. If you still find the issue, kindly post your template excel file here, we will check your issue soon.

Thank you.

We were able to isolate the problem (see attached xlsx).

The cell is referring to a named range which is defined as a single cell reference. This named range contains a sheet name that contains a '+' sign.

For some reason Aspose.Cells is intepreting this + as an addition.

Thanks,
Raimondo

Hi,
Please try the attached version (latest fix v5.1.1.3), i have tested with your file and it works fine with it.

Thank you.