Apache OpenOffice (AOO) Bugzilla – Issue 95893
Links in MSO 2003 Excel files randomly doesn't show in Calc 3.0.0
Last modified: 2013-04-26 06:32:25 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
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.
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.
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.
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.
Please close issue. Thank you.
Please re-upload file. Links in description and comment 2 are not working.
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 :)
Links are not clickable. Rev. 1467605 Win7