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

ASSUREZVOTREPRET · June 21, 2006, 2:17am

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 ?

henry · June 21, 2006, 2:29am

Call WebWorksheets.RunAllFormulas()

ASSUREZVOTREPRET · June 21, 2006, 2:33am

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

henry · June 21, 2006, 6:48pm

Hi,

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.