fdo#76402: Write unit test for this first.

Change-Id: Ib4fccb0e29d4a21a211de4af2cdeaf956f9b9cc6
fdo#76402: Handle range reference expansion in named ranges.

Change-Id: I8314260fc7588f0a0230ab63cc600fa887a8479d