reduce the importing time by not evaluating a formula of a named range

XMLWordPrintable

    • Type: New Feature
    • Resolution: Unresolved
    • Priority: Normal
    • 5.4.0FL
    • Affects Version/s: None
    • Component/s: None
    • None
    • None

      User Story


      As app dev, I want to reduce the long importing time when there are many name ranges or name ranges' formulas refer to large ranges

      Acceptance Criteria

      • ensure that if it's required to evaluate a named range's formula during importing

      Details

      
          private void evalPtgs(FormulaEngine fe, Ref ref) {
      		if(!_refersToExprFormula.hasError() && _refersToExprFormula.isAreaRefs()){
      			//ZSS-655, should eval each name to force it be notified in dependency (for evaluated dependent)
      			//it looks like keikai doesn't need evaluated result
      			fe.evaluateOnly(_refersToExprFormula,new FormulaEvaluationContext(_book.getSheet(0), ref));
            ...
          }
      

            Assignee:
            Unassigned
            Reporter:
            hawk
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: