improve the performance when editing a cell

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 5.11.0
    • Affects Version/s: 5.8.1
    • Component/s: None
    • Security Level: Jimmy
    • None

      Steps to Reproduce

      1. import the file https://docs.google.com/spreadsheets/d/1y4FjyDn4hs4us4uB9sBMif97audpjNtm/edit?usp=sharing&ouid=114351817352708928223&rtpof=true&sd=true
      2. enter a number at EK49
      3. check the time in developer tool > network tab

      Current Result

      take almost 1.6 ~ 2s to get the respond

      Expected Result

      less time than the current time

      Debug Information

      • try the workaround below but doesn't improve
        CellImpl.java
        	public CellType getFormulaResultType() {
        		checkType(CellType.FORMULA);
        		if (_formulaResultValue == null) {
        			evalFormula();
        		}
        		return _formulaResultValue.getCellType();
        	}
        

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

              Created:
              Updated:
              Resolved: