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

Free Support Forum - aspose.com

Can we validate a single formula?

Hi
We have a need to calculate a single formula using the api, I found this
https://docs.aspose.com/display/cellsnet/Formula+Calculation+Engine+in+Aspose.Cells

but it seems to calculate for entire workbook, we want just for one cell/specified formula

Goal is to determine if path in formula, such as
=VLOOKUP(A1, ‘https://test.sharepoint.com/Users/chris.ang/Desktop/ Excel Test/Parent/[Parent Test.xlsx]Sheet1’!$1:$1048576,2,FALSE)

has broken link and need to detect it by doing calculate to see if it fails.

Thanks
Chris

@Chrisksang,

Thanks for your query.

Worksheet.CalculateFormula() can be used to calculate a single formula. Please give a try to the following simple code and provide your feedback.

Workbook wb = new Workbook();
wb.Worksheets[0].Cells["A1"].Value = 5;
wb.Worksheets[0].Cells["A2"].Value = 10;
var result = wb.Worksheets[0].CalculateFormula("=A1+A2");