Issue 95893

Summary: Links in MSO 2003 Excel files randomly doesn't show in Calc 3.0.0
Product: Calc Reporter: vuhung16plus
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: elish, issues, quan.nguyenduc, raal
Version: OOo 3.0Keywords: needmoreinfo
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: 4.0.0
Developer Difficulty: ---

Description vuhung16plus 2008-11-06 01:50:36 UTC
How to reproduce: 

1. Open this file with MSO 2003 Excel: All links are clickable.

2. Open this file with OOo 3.0.0 Calc: *SOME* links are not clickable
   while the texts are blue. See the screenshot below

Expected result: All links are treated the same and clickable.

Related bug: 
calc does not update "Sum" at status bar after deletion:
Comment 1 raal 2009-10-08 07:57:42 UTC
cannot download test file
Please attach xls_link_bug2.xls to issue.
Comment 2 quannd 2009-10-10 06:09:12 UTC
You can download this file at this URL
(Please wait about 30s before you can download)
Thanks much.
Comment 3 raal 2009-10-10 10:24:36 UTC
I can confirm within version DEV320m1.
Probably duplicate of issue 31050.
See comment:
------- Additional comments from dr Tue Nov 21 10:42:28 +0000 2006 ------- 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.

In your spreadsheet is cell formated as date. 
Comment 4 quannd 2009-10-11 10:09:37 UTC
Thank you,
Finally, this error is the difference of format in MS Excel & CALC.
So I hope this maybe fix with additional tools such as extension.
Comment 5 raal 2009-10-11 13:45:45 UTC
Please close issue.
Thank you.
Comment 6 Edwin Sharp 2013-04-19 11:43:51 UTC
Please re-upload file. Links in description and comment 2 are not working.
Comment 7 quannd 2013-04-26 03:25:42 UTC
I reupload new file in test with mso 2003 & oOo 3.3:
link_in_calc_ bug.xls (22 KB)!k113jADD!aDDE-Bgy9sIwluW5KapdRQs_v4AtkW1ecjaMYkWOawE
You can download here!
Thanks :)
Comment 8 Edwin Sharp 2013-04-26 06:32:25 UTC
Links are not clickable.
Rev. 1467605 Win7