Issue 31050 - Hyperlinks applied to Number cell contents in .xls lost after import
Summary: Hyperlinks applied to Number cell contents in .xls lost after import
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1
Hardware: All All
: P3 Trivial with 14 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: ms_interoperability, oooqa
: 69192 89432 96923 102367 (view as issue list)
Depends on: 91351
  Show dependency tree
Reported: 2004-07-02 20:08 UTC by koyaanisqatsi
Modified: 2013-08-07 15:13 UTC (History)
8 users (show)

See Also:
Latest Confirmation in: 4.0.0
Developer Difficulty: ---

5 numeric hyperlinks, only one works in OOo 2.0 (14.00 KB, application/
2005-10-25 21:09 UTC, grambo
no flags Details
XLS test document (13.50 KB, application/
2008-07-03 14:01 UTC, daniel.rentz
no flags Details
XLSB test document (7.87 KB, application/
2008-07-03 14:02 UTC, daniel.rentz
no flags Details
XLSX test document (8.58 KB, application/
2008-07-03 14:03 UTC, daniel.rentz
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description koyaanisqatsi 2004-07-02 20:08:23 UTC
In MS Excel you can type something into a cell, then click on that cell, hit
CTRL+K, paste a URL, and hit enter to keep working.  (In OpenOffice, you must
select the text before pasting a hyperlink; else nothing will be linked).

Making your links in Excel as described above causes numerical links to fail in
OpenOffice (though they will all work in Excel, and alpha links made that way in
Excel will work in both programs).

After some trial and error, I've found that you can get those numerical links to
work by doing the following: open the sheet in Excel, go to the first
non-hyperlinked entry and retype the entry in the location bar at the top, then
hit enter and save the file.  That link will now work in OpenOffice.  To get the
rest of the numerical links to work, you must simply click in the location bar
and hit enter--with or without changing anything--then save the file in Exel and
reopen it in OpenOffice.

I wonder if OpenOffice might arrange a way to read links written this way in
Excel.  I expect it's sloppy coding on Microsoft's part, but it would be nice to
accomodate them as they have most of the market share.

Best wishes,
Comment 1 lc3 2004-07-07 18:53:05 UTC
Reproduced on Win XP Pro 2002 SP1, OOo 1.1.2
Reproduced on Win XP Pro 2002 SP1, OOo 2.0_680m45

Comment 2 frank 2004-07-08 10:34:34 UTC
Hi Daniel,

type 123 into a cell in Excel. Press CTRL+K and type an URL into the dialog.
Save the documnet and open it in OOo
The former link is not imported. If you do it with abc, it works.

Comment 3 grambo 2005-10-25 21:07:36 UTC
intermitantly confirmed on OOo 2.0, i386 Win2k SP4 platform:

(uploading test3.xls) Spreadsheet shows 5 cells with hyperlinks in Excel
(Microsoft Excel 2000 (9.0.2720)), and only the first one shows up in OOo 2.0.
Hope this helps,
Comment 4 grambo 2005-10-25 21:09:39 UTC
Created attachment 30834 [details]
5 numeric hyperlinks, only one works in OOo 2.0
Comment 5 frank 2006-09-07 14:07:27 UTC
*** Issue 69192 has been marked as a duplicate of this issue. ***
Comment 6 daniel.rentz 2006-11-21 10:42:28 UTC
Calc only supports hyperlinks in text cells. That is because it inserts a hyperlink 
textfield into the cell, while Excel stores the hyperlink as cell property. In the 
attached file, the first cell contains text that looks like a number, the other cells 
are numbers.
Comment 7 dalo 2007-04-04 20:53:17 UTC
Additionally confirmed this issue in OOo 2.2 on Win XP.
Numerical hyperlinks are converted as cells with a simple number only in
hyperlink format (only blue text colouring and underlined)
Comment 8 daniel.rentz 2008-05-26 09:09:31 UTC
*** Issue 89432 has been marked as a duplicate of this issue. ***
Comment 9 daniel.rentz 2008-05-26 10:10:57 UTC
A possible workaround for the import filter is to replace numeric cells with
formula cells using the HYPERLINK function
Comment 10 daniel.rentz 2008-07-03 14:01:44 UTC
Created attachment 54918 [details]
XLS test document
Comment 11 daniel.rentz 2008-07-03 14:02:57 UTC
Created attachment 54919 [details]
XLSB test document
Comment 12 daniel.rentz 2008-07-03 14:03:52 UTC
Created attachment 54920 [details]
XLSX test document
Comment 13 daniel.rentz 2008-07-10 12:48:49 UTC
depending on OOo 3.x issue 91351, setting target
Comment 14 sdjengineering 2008-10-23 11:38:58 UTC
I do believe that I'm having the same trouble.

In MS Excel a cell with an equation =Sheet1!B10 and a hyperlink to cell 
When I import it into Calc the equation is fine but lose the hyperlink

This is the only bug I'm not liking, but when it gets fixed YeeHa!!
Comment 15 Rainer Bielefeld 2008-12-05 10:18:01 UTC
*** Issue 96923 has been marked as a duplicate of this issue. ***
Comment 16 kpalagin 2009-03-31 11:11:54 UTC
any chance of targeting this issue for 3.2?
Thanks a lot.
Comment 17 daniel.rentz 2009-03-31 11:55:50 UTC
don't think so because of the dependency to issue 91351
Comment 18 kpalagin 2009-03-31 12:26:55 UTC
Do you have some estimate for 91351?
Comment 19 daniel.rentz 2009-03-31 12:49:25 UTC
not my issue, please ask there. But ODF TC is involved, therefore probably some
more time will be needed.
Comment 20 quannd 2009-10-11 10:12:40 UTC
*** Issue 95893[] has been
marked as a duplicate of this issue. ***
Comment 21 dj_baldey 2010-11-05 07:32:15 UTC
This problem is a determinative for the small enterprises receiving a price
sheets from the partners in a format *.xls
Comment 22 Rainer Bielefeld 2013-06-08 07:30:16 UTC
*** Issue 102367 has been marked as a duplicate of this issue. ***