I am very pleased to see that gnumeric has named cell references now -
very handy, and lets it load some fancy sheets from elsewhere it could
not handle last time I looked.
However there seems to be a problem saving and reloading such references in ODF:
If I have a function which refers to two named cells (housedepth and housewidth) like this:
=housedepth*housewidth
everything is good.
But if I save as .ods and reload the sheet all the cells with such
references in say '#NAME'. And the functions now look like:
=[]housedepth*[]housewidth
(when they were entered as =housedepth*housewidth )
Removing the square brackets makes everything work again, but clearly
there is some kind of problem with these being reformatted on
save/reload, and apparently an empty name not working as 'this sheet'.
I tested these formats:
ODF 1.2 extended conformance
ODF 1.2 strict conformance
ISO/IEC 29500
Gnumeric
The last two will correctly save and reload named cells
The first two will add '[]' to all name references, and then complain on reload that
'name does not exist in workbook':
e.g. Unable to parse '[]floorarea*2.25' ('Name 'floorarea' does not exist in workbook')
Now floorarea does exist in workbook 'Calcs' (sheet3), but not in sheet <empty string>.
I'm not sure if this is a save or reload problem.
Is there something I can do to fix this behaviour or do I just need to
avoid using ODF with named references?