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 152317 - additional quotes around series names when saving to XL format
additional quotes around series names when saving to XL format
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
1.3.x
Other Linux
: Normal minor
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2004-09-10 16:19 UTC by Frederic Parrenin
Modified: 2005-07-30 03:42 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
The .xls file showing the problem (7.00 KB, application/msexcel)
2004-09-10 16:20 UTC, Frederic Parrenin 		Details

Description Frederic Parrenin 2004-09-10 16:19:56 UTC 
steps to reproduce:
- open the .xls file in gnumeric
- save it
- open it in XL2k
=> an error message appears in XL saying: "error: data loss risk".
The file seems to be imported correctly except the legend in the graph.
Comment 1 Frederic Parrenin 2004-09-10 16:20:23 UTC 
Created attachment 31472 [details]
The .xls file showing the problem
Comment 2 Jody Goldberg 2004-09-16 04:58:26 UTC 
XL seems to have an undocumented limitation.
I can't seem to set the name of a series to be a non-trivial expression

eg "foo" is ok as a constant  =ref is ok
but I keep getting a parse error for
="foo"&"bar"

I'll try to to dumb things down on export if necessary.
Comment 3 Jon Kåre Hellan 2005-07-08 19:35:22 UTC 
No error message in Norwegian version of Excel 2000 (9.0.2812) when current HEAD
gnumeric has read and written the file.
Comment 4 Frederic Parrenin 2005-07-11 12:37:14 UTC 
Indeed, I don't see any error message when opening and saving the file with
gnumeric-1.5.2.
However, I see another error in the conversion: there are additional quotes
around series names in XL, that are not present in gnumeric.
I am changing the bug title accordingly.
Comment 5 Jon Kåre Hellan 2005-07-14 07:16:40 UTC 
Setting priorit to normal
Comment 6 Jody Goldberg 2005-07-30 03:42:53 UTC 
The extra quotes aren't too hard to fix.
We were being simplistic about exporting expressions which contained only a
string and quoting it.