[Bug]: Named Expressions don't update when adding rows

[grahamorrell]

Description

When adding rows using hf.AddRows( ) any formulae that are affected are automatically updated, matching the behaviour of Excel.

However any named expressions are not updated, meaning the ranges they point to are now incorrect.

Full reproduction in stackblitz link below

Video or screenshots

Demo

https://stackblitz.com/edit/node-sfv4nvjp?file=index.ts

HyperFormula version

3.0.0

Your framework

Node

Your environment

N/A

[sequba]

Hi @grahamorrell, thanks for reaching out.

I verified that Microsoft Excel updates the named expression when a row is added in the middle of the referenced range. In that case, it must be considered a HyperFormula bug. I'm adding it to our backlog.