use suspendCalcService and resumeCalcService method when adding
multiple formulas
Import Flags CalcOnDemand
incrementalLoading
iterativeCalculation
Named Style
static formulas vs static values
Static formulas are the ones which does not change its result in In
those cases we should convert that formulas in to static values
Conditional formatting
Conditional formatting is a very powerful tool but we need to be
careful while using it. following is the demonstration where you
could observe the loading time difference. the first file contains
conditional formatting for 1200 cell and second is the converted
version of the first but this does not contain volatile formulas
both give the same result but you will also observe loading and
scroll on the first file is slow.