Excel-style functions like ROW(), COLUMN(), INDIRECT() always return #N/A

[gautamsarawagi]

Describe the bug

I’m using @fortune-sheet/react to render spreadsheets and noticed that many Excel-compatible functions return #N/A, even though the formulas should be valid in a spreadsheet context.

• =ROW() -> #N/A
• =COLUMN() -> #N/A
• =INDIRECT("A"&ROW()) -> #NAME?
• =OFFSET(A1,1,0) -> #NAME?

To Reproduce

Type Row() in any cell in the sheet: https://ruilisi.github.io/fortune-sheet-demo/?path=/story/features--formula

Question

• Do we need to configure this in our code somehow?
• Or it doesn't support dynamic formulas.

[bgareth]

Related to this issue, ISBLANK() always returns FALSE.