[Bug]: rebuildAndRecalculate() throws Error: Value of the formula cell is not computed.

[adjenks]

Description

Previously I was using the function to avoid #REF errors like so: #1116

However, now when I call rebuildAndRecalculate() I get this error:

Uncaught (in promise) Error: Value of the formula cell is not computed.
getCellValue FormulaCellVertex.mjs:189
getCellValue AddressMapping.mjs:61
getCellValue DependencyGraph.mjs:533
evaluateAstWithoutPostprocessing Interpreter.mjs:78
evaluateAst Interpreter.mjs:47
evaluateAstToCellValue Evaluator.mjs:117
recomputeFormulaVertexValue Evaluator.mjs:112
recomputeFormulas Evaluator.mjs:98
recomputeFormulas Evaluator.mjs:96
run Evaluator.mjs:32
measure Statistics.mjs:73
run Evaluator.mjs:31
buildEngine BuildEngineFactory.mjs:94
rebuildWithConfig BuildEngineFactory.mjs:46
rebuildWithConfig HyperFormula.mjs:4228
rebuildAndRecalculate HyperFormula.mjs:893
calculate WorkbookCalculator.ts:91
calc BuildingForm.tsx:62
onSubmit BuildingForm.tsx:123
React 23
index.tsx:6
FormulaCellVertex.mjs:189:12

the context around the error is this:

  /**
   * Returns cell value stored in vertex
   */
  getCellValue() {
    if (this.cachedCellValue !== undefined) {
      return this.cachedCellValue;
    } else {
      throw Error('Value of the formula cell is not computed.');
    }
  }

It seems to occur on some regular formula that was previously working fine. I'm not sure what changed and I'm having trouble creating a minimum sized example of the problem. Any idea why I'd get that?

Video or screenshots

No response

Demo

I will try to provide one soon, but it's difficult to trim down the code.

HyperFormula version

3.0.0

Your framework

react built with vite

Your environment

firefox on windows

[AMBudnik]

Hi @adjenks

Could you please create a full demo so that we can replicate the issue and debug it together?

[adjenks]

Okay so, I don't have a full demo yet, but I've found the minimal change to fix it. It was caused by referencing a formula from a named expression. the expression was something as simple as ='sheet'!$C$12. The cell it referenced was a formula with further dependencies on other sheets.
If I simply used getCellValue on C12 instead of getNamedExpression on the named expression, I no longer saw the "Value of the formula cell is not computed" error.

[adjenks]

@AMBudnik So because it was the named expressions that seemed to cause a problem, I emulated the named expressions feature by adding an extra sheet to store expressions and created a Map object to store the row number that the expressions are stored on in the sheet. I don't need the feature anymore and I therefore I don't have the bug anymore, and I don't have time to create a minimum working demo. So, just know that something about named expressions fails when they reference cells on other sheets, that then reference cells on other sheets. Good luck and thank you.

[AMBudnik]

You are right, @adjenks

Thank you for the details.

I created a demo here https://codesandbox.io/p/devbox/jolly-dawn-yrrr5m?file=%2Findex.html&workspaceId=ws_7DxkzvEdje9nzFaV6ecDpC and created two named expressions to cross-sheet them. And you are right the getNamedExpressionValue returns undefined.

Let me ask my colleague to check it out when he's back from vacation.

[AMBudnik]

Hi @adjenks

We'd like to investigate the subject. My demo was apparently a bit off from the main issue. Could you please provide a full example with steps to replicate the issue?

[adjenks]

I'll have to check out my code to the state it was in when I was using expressions and then trim things away until i get a small example. It will take some time when I have free time. I'll get back to you at a later date.