The ROOT segment — the whole expression, evalIndex 0. Any trailing tokens the engine couldn't
place (the unparsed tail of an in-progress formula, e.g. the + in =SUM(A1)+) are EXCLUDED:
the root eval is the valid prefix, so the broken tail isn't part of what's evaluated. null when
nothing parsed at all.
The ROOT segment — the whole expression,
evalIndex0. Any trailing tokens the engine couldn't place (theunparsedtail of an in-progress formula, e.g. the+in=SUM(A1)+) are EXCLUDED: the root eval is the valid prefix, so the broken tail isn't part of what's evaluated.nullwhen nothing parsed at all.