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 616378 - Support external references in xls import
Support external references in xls import
Status: RESOLVED OBSOLETE
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
git master
Other Linux
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
: 64931 568929 577786 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2010-04-21 09:00 UTC by Konstantin Tokarev
Modified: 2018-05-22 13:37 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
xls file with external links (81.50 KB, application/octet-stream)
2010-04-21 09:03 UTC, Konstantin Tokarev 		Details

Description Konstantin Tokarev 2010-04-21 09:00:38 UTC 
Attached xls contains links to cells from another file, and Gnumeric displays them as links
to the same file, which is misleading.
Comment 1 Konstantin Tokarev 2010-04-21 09:03:25 UTC 
Created attachment 159238 [details]
xls file with external links

It is properly opened by OpenOffice.org
Comment 2 Andreas J. Guelzow 2010-04-22 00:01:39 UTC 
I really don't know anything about the excel importer but we appear to read the formulas/references in question in ms-formula-read.c in the case  FORMULA_PTG_REF_3D on line 1622.

From there via excel_formula_parses_ref_sheets we are going into excel_externsheet_v8 in ms-excel-read.c which appears to deal with sheet names only (and returns no sheetname for this formula/reference).
Comment 3 Konstantin Tokarev 2010-04-22 08:42:52 UTC 
If you fix it, please, add a possibility to save file with conversion of external links to numbers (or simply without update of them)
Comment 4 Morten Welinder 2010-04-23 02:47:44 UTC 
excel_read_SUPBOOK is incomplete.
Comment 5 Morten Welinder 2010-04-23 15:32:20 UTC 
The situation is slightly improved now:

1. A warning is issued.  (Two actually with this sample.)
2. The references import as #REF!
Comment 6 Konstantin Tokarev 2010-04-23 15:38:16 UTC 
1. Does it continue to display numbers?
2. What will be with numbers after Save As to another files?
Comment 7 Morten Welinder 2010-04-23 15:50:39 UTC 
1. Yes, but only until recalculation is triggered.  Then you get #REF!
2. As displayed, i.e., it depends on whether you recalculate first.

(Recalculation is triggered when you press F9.)

Note: I didn't close this bug report.  I am leaving it open so we can
produce a proper fix.
Comment 8 Andreas J. Guelzow 2010-05-05 08:17:53 UTC 
*** Bug 64931 has been marked as a duplicate of this bug. ***
Comment 9 Andreas J. Guelzow 2010-07-29 00:37:04 UTC 
*** Bug 568929 has been marked as a duplicate of this bug. ***
Comment 10 Morten Welinder 2014-02-28 00:31:28 UTC 
*** Bug 577786 has been marked as a duplicate of this bug. ***
Comment 11 GNOME Infrastructure Team 2018-05-22 13:37:17 UTC 
-- GitLab Migration Automatic Message --

This bug has been migrated to GNOME's GitLab instance and has been closed from further activity.

You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/gnumeric/issues/136.