Value of the formula cell is not computed when batching setCellContents

[BrianHung]

Description

It seems that replacing cell contents that contain a formula at the same address in the same batch results in a Value of the formula cell is not computed error, since the vertex is created but the value is not yet cached in FormulaCellVertex yet since evaluation is suspended.

hyperformula/src/DependencyGraph/AddressMapping/AddressMapping.ts

Lines 70 to 80 in 9f7b2db

	public getCellValue(address: SimpleCellAddress): InterpreterValue {
	const vertex = this.getCell(address)
	if (vertex === undefined) {
	return EmptyValue
	} else if (vertex instanceof ArrayVertex) {
	return vertex.getArrayCellValue(address)
	} else {
	return vertex.getCellValue()
	}
	}

A potential fix may be to check and return the EmptyValue singleton.

  public getCellValue(address: SimpleCellAddress): InterpreterValue {
    const vertex = this.getCell(address)

    if (vertex === undefined) {
      return EmptyValue
    } else if (vertex instanceof ArrayVertex) {
      return vertex.getArrayCellValue(address)
+  } else if (vertex instanceof FormulaCellVertex) {
+     return vertex.isComputed() ? vertex.getCellValue() : EmptyValue;
    } else {
      return vertex.getCellValue()
    }
  }

import HyperFormula from "hyperformula";

const hf = HyperFormula.buildFromArray([[1, 2, "=A1+B1"]], {
  licenseKey: "gpl-v3"
});

const sheetName = "Sheet1";
const sheetId = hf.getSheetId(sheetName);

hf.suspendEvaluation();
hf.setCellContents({ sheet: sheetId, row: 0, col: 2 }, "=A1/B2");
hf.setCellContents({ sheet: sheetId, row: 0, col: 2 }, "10");
hf.resumeEvaluation();

Demo

https://codesandbox.io/s/young-butterfly-zdxrvc?file=/src/hyperformulaConfig.js

[AMBudnik]

Thank you for sharing the issue report @BrianHung

We confirmed the issue and will update you as soon as it gets fixed.