-
New Feature
-
Resolution: Unresolved
-
Normal
-
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));
...
}