After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 650125 - Import of names from ODF
Import of names from ODF
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export OOo / OASIS
git master
Other Linux
: Normal normal
: ---
Assigned To: Andreas J. Guelzow
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2011-05-13 16:12 UTC by Andreas J. Guelzow
Modified: 2011-05-19 18:47 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
sample file (116.14 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-05-13 16:13 UTC, Andreas J. Guelzow 		Details

Description Andreas J. Guelzow 2011-05-13 16:12:52 UTC 
ODF has much less restrictions on the makeup of defined names. For example in the attached file we have:

<table:named-range table:name="sheet1.newstcode" table:base-cell-address="$GENERAL.$A$1" table:cell-range-address="$GENERAL.$BH$1:.$BH$36"/>

So when open the file we get for General!U18 the error:

Unable to parse 'sheet1.newstcode' (''sheet1.newstcode' cannot be used as a name')

We will need to handle these names somehow. I would guess by replacing the period with a different character.
Comment 1 Andreas J. Guelzow 2011-05-13 16:13:20 UTC 
Created attachment 187778 [details]
sample file
Comment 2 Andreas J. Guelzow 2011-05-18 00:14:28 UTC 
We are now accepting those names. So we do not see those errors anymore.

We still have to fix the names after import since we can't parse the names of these named expressions. As a consequence, if users try to edit the cells with formulas that contain these names they fail. Nor can they rename those names or change te corresponding expressions.
Comment 3 Andreas J. Guelzow 2011-05-19 18:47:59 UTC 
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.