I see that by using CellName, I can assign and retrieve named ranges. They can also be used in formulae.
Two things:
1. If I then save this to JSON, the names disappear - so if the names are used in formulae, the formulae no longer work. Can they be saved and read back?
2. I don't seem to be be able to read named ranges from an XLS file that's read in (LoadFromXLS). Is there a way to do this?
stephen