Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Links in MSO 2003 Excel files randomly doesn't show in Calc 3.0.0|
|Component:||formatting||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P4||CC:||elish, issues, quan.nguyenduc, raal|
|Issue Type:||DEFECT||Latest Confirmation in:||4.0.0|
Description vuhung16plus 2008-11-06 01:50:36 UTC
How to reproduce: 1. Open this file with MSO 2003 Excel: All links are clickable. http://aoclife.ddo.jp/~vuhung/foss/ooo/patches/xls_link_bug2.xls 2. Open this file with OOo 3.0.0 Calc: *SOME* links are not clickable while the texts are blue. See the screenshot below http://farm4.static.flickr.com/3016/3006204033_b09e8bb6c1_o.jpg Expected result: All links are treated the same and clickable. Related bug: calc does not update "Sum" at status bar after deletion: http://qa.openoffice.org/issues/show_bug.cgi?id=95833
Comment 1 raal 2009-10-08 07:57:42 UTC
vuhung, cannot download test file (http://aoclife.ddo.jp/~vuhung/foss/ooo/patches/xls_link_bug2.xls). 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 http://www.webfilehost.com/?mode=viewupload&id=4950309 (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) https://mega.co.nz/#!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