GNOME Bugzilla – Bug 578557
Combo and Listboxes plus summary not retaining data
Last modified: 2009-04-14 03:32:58 UTC
If you create a listbox or combobox enter a cell for the link and a data range for the content fields click ok, click out of edit mode, click the combo to get the dropdown or look in the listbox there is nothing there, right click again select properties to confirm, there is really nothing there, If you had create these Elements in OpenOffice.org Or Microsoft Excel documents and import those with Gnumeric these elements work. Another problem When you enter title and author information using file > properties > description tab and then save and close the document, when you open the document again this information is not there. What am I overlooking this time around? I do not know much about the Gnumeric xml file format but even if you edit the xml directly and insert the summary section as shown below, it is ignored by Gnumeric.when the file is opened. <gmr:Summary> <gmr:Item> <gmr:name>application</gmr:name> <gmr:val-string>gnumeric</gmr:val-string> </gmr:Item> <gmr:Item> <gmr:name>author</gmr:name> <gmr:val-string>Author Name</gmr:val-string> </gmr:Item> </gmr:Summary>
The configuration dialog for listboxes and comboboxes isn't really implemented. I can replicate the problem with the title and author info. PS: in future please file separate bugs for separate issues.
The properties dialog is now correctly storing the information and is even using the undo/redo interface to do that. As a side-effect libgoffice is in fact writing the information into the gnumeric file. Unfortunately it uses the opendocument format to do so: <office:document-meta xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:ooo="http://openoffice.org/2004/office" office:version="1.0"> <office:meta> <meta:user-defined meta:name="gsf:category" meta:type="string">thiscategory</meta:user-defined> <meta:initial-creator>thisauthor</meta:initial-creator> <dc:subject>thissubject</dc:subject> <meta:user-defined meta:name="dc:publisher" meta:type="string">thiscompany</meta:user-defined> <meta:user-defined meta:name="gsf:manager" meta:type="string">thismanager</meta:user-defined> <dc:title>thistitle</dc:title> <dc:description>thiscomment has 3 lines</dc:description> <meta:keyword>thiskeyword</meta:keyword> </office:meta> </office:document-meta>
By the way the <gmr:Summary> stuff is apparently gone: /* The old 'SummaryItem' Metadata. Removed in 1.7.x */ I am not sure what is supposed to replace it!
I have split off the metadata issue into Bug 578607.
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report. Th metadata issue separated into Bug 578607 is still outstanding.