Re Excel / Calc
I tried to migrate from Excel to Calc but
Libre does not yet support named ranges and
Therefore LIbre also can’t create or import named ranges
For example
nameSTART=workSheet!$G$205
nameEND=workSheet!$G$3012
name=workSheet!nameSTART:nameEND
At the moment, Calc only support direct ranges not referenced ranges
ie name=workSheet!$D$205:$G$3012 is supported