I have an excel spreadsheet that is using some simple formulas to lookup and calculatetotals. These work correctly within excel and when this spreadsheet is loaded within the Spreadsheet control but as soon as an edit is made which would effect the reclaculation they result in an "Improper Formula" message in the cells.
Some example of the formula is
=IFERROR(IF(ISNUMBER(SEARCH("Video",$D8)), IF($C8="","",IF(VLOOKUP($E8,$B$40:$B$52,1,FALSE),1,0)),""),"")
=IFERROR(IF($C8="","",IF(VLOOKUP($E8,$B$40:$B$52,1,FALSE),1,0)),"")
In the attached spreadsheet go to the 9am tab and change the name from spotty to something else - the sum columns for this line should show 1,"",1 in the respective columns.
Now load the worksheet into a spreadsheet control and do the same action. results in 0,Improper Formula, Improper Formula.
EXPECTED RESULT
Same calculations as excel spreadsheet generates in Excel
ACTUAL RESULT
Invalid calculation and Error