Can we validate a single formula?

Aspose.Cells Product Family
1

Hi
We have a need to calculate a single formula using the api, I found this

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

2

@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");