Free Support Forum -

How to make the WebWorkSheet update the formula after using ImportDataView?

After filling data in webworksheet by ImportDataView, i give formula values to some cells, and i want to calculate the result when first time it displays, how to do that ?

Call WebWorksheets.RunAllFormulas()

its ok, but we can not run formula only in one WorkSheet ?


This control doesn't support running formula in one sheet. Because it support cross-sheet reference, it need to run all the formulas in all sheets to ensure getting correct result.