GNOME Bugzilla – Bug 317427
xml parse problem "Sheet!$A:$A"
Last modified: 2005-09-30 09:50:40 UTC
insert a name such as my_column with Sheet1!$A:$A as value =sum(my_column) gives the correct result. Save the file, close and reopen. The name has disappeared. The file contains : <gnm:Names> <gnm:Name> <gnm:name>my_column</gnm:name> <gnm:value>Sheet1!$A:$A</gnm:value> <gnm:position>C7</gnm:position> </gnm:Name> </gnm:Names>
I can replicate this. Note that the problems happens when the file is opened and seems to be restricted to full columns.
losing data is a blocker. I'll have a look on the flight back.
Several problems: 1. "exp" (the function pointer) is not null. Fixed. 2. io context needed to be set before names were read. Fixed. 3. Discrepancy between xml expression conventions and gui ditto. [Worked around] ---> downgrading. We use gnm_1_0_rangeref_parse in xml_io_conventions. gnm_expr_conventions_default (as used inside cell_set_text and now xml_read_names) uses rangeref_parse. I really don't know why we use gnm_1_0_rangeref_parse, but it does not understand Sheet!$A:$A. Inside regular expression we survive this since we fall back to using cell_set_text.
To elaborate: either we really need to fix gnm_1_0_rangeref_parse to handle this kind of reference, or else we need to switch to using rangeref_parse.
The current arrangement seems backwards. We should export 1.0 and import anything. I'll do it on the flight back