In answer to my own question, I found that I should be using: "Sheet -> Named Ranges and Expressions -> Define" instead to name a cell or cells.

I'm left puzzled, then, why there are two methods in Calc to name a cell or range, but only one exports correctly.