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 701604 - Failure to export URLs to xls
Failure to export URLs to xls
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
git master
Other Linux
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2013-06-04 17:40 UTC by Andreas J. Guelzow
Modified: 2013-06-05 19:38 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
Sample Excel generated file with url (22.00 KB, application/vnd.ms-excel)
2013-06-04 18:58 UTC, Morten Welinder
Details
sample gnumeric file (1.75 KB, application/x-gnumeric)
2013-06-04 19:34 UTC, Andreas J. Guelzow
Details
Converted file (5.00 KB, application/vnd.ms-excel)
2013-06-05 00:54 UTC, Morten Welinder
Details
xls file saved from within gnumeric (7.50 KB, application/msexcel)
2013-06-05 02:09 UTC, Andreas J. Guelzow
Details

Description Andreas J. Guelzow 2013-06-04 17:40:45 UTC
Debian bug #226984:

--------------------------------------------------------
Package: gnumeric
Version: 1.2.4-1
Severity: important

URLs in table cells are exported in url style (underlined
and in blue color) but have no associated url.

Importing excel files with URLs works correctly.
--------------------------------------------------------

THis is still the case in current git.
Comment 1 Morten Welinder 2013-06-04 18:58:59 UTC
Created attachment 246025 [details]
Sample Excel generated file with url
Comment 2 Morten Welinder 2013-06-04 18:59:44 UTC
If I send this through Gnumeric:

    ./ssconvert ../samples/url.xls /tmp/sss.xls

I get a file that _does_ have url properties.

I.e., I cannot confirm.
Comment 3 Andreas J. Guelzow 2013-06-04 19:34:51 UTC
Created attachment 246028 [details]
sample gnumeric file

The attached gnumeric file has a link (attached to the only cell with content). If I run 
./ssconvert ../samples/url.gnumeric /tmp/sss.xls
and open sss.xls in Gnumeric, then I do not have a link left.

Note for your xls file if I run
 ./ssconvert ../samples/url.xls /tmp/sss.xls
I do get a link in sss.xls. So clearly we are exporting some links, bt not all????
Comment 4 Morten Welinder 2013-06-05 00:53:52 UTC
I get a link with your file too.

Please attach the converted xls file so I can see where we differ.
Comment 5 Morten Welinder 2013-06-05 00:54:48 UTC
Created attachment 246035 [details]
Converted file

File from converting attachment 246028 [details] to xls.
Comment 6 Andreas J. Guelzow 2013-06-05 02:09:42 UTC
Created attachment 246039 [details]
xls file saved from within gnumeric

I may have made some mistake with the  ./ssconvert ../samples/url.gnumeric /tmp/sss.xls. SInce I can't replicate the problem that way.

But if I save from within Gnumeric I am still getting the described problem. I am attaching the xls file created.
Comment 7 Morten Welinder 2013-06-05 03:24:50 UTC
Spooky.

It seems to depend on what type of xls I save as.

As 97/2000/XP it ok.
As 97/2000/XP + 95 it is not ok.
Comment 8 Morten Welinder 2013-06-05 19:38:01 UTC
This problem has been fixed in our software repository. The fix will go into the next software release. Thank you for your bug report.