If I read a cell with a formula. I get the formula, but not the actual value.
The sheet has the following.
RANDBETWEEN(250, 500)
422
All that is returned is.
{
formula: "RANDBETWEEN(250, 500)",
style: undefined,
}
No value.
The code skips the actual value.
if (fNode) {
cell.formula = fNode.text ?? "";
} else if (vNode) {
// Parse cell.value
}
If I read a cell with a formula. I get the formula, but not the actual value.
The sheet has the following.
RANDBETWEEN(250, 500) 422All that is returned is.
{
formula: "RANDBETWEEN(250, 500)",
style: undefined,
}
No value.
The code skips the actual value.
if (fNode) {
cell.formula = fNode.text ?? "";
} else if (vNode) {
// Parse cell.value
}