EPPlus
EPPlus copied to clipboard
Fix #690: Preserve column/row ranges on row/column insert
When there are defined names referencing a whole column (e.g. Sheet1!$C:$C), inserting rows fails to update the range: Sheet1!Sheet1!$C1:#REF!.
Same issue for named row ranges and inserting columns.
This fixes the issue (see https://github.com/EPPlusSoftware/EPPlus/issues/690)