如何在opeoffice的calc中開啟本地端檔案

在[excel]中用HYPERLINK可開啟本地端硬碟的檔案，例如『=HYPERLINK(C2&".pdf",C2)』。

但在[calc]則無法開啟

尋找過程
第一步
第二步：在此找hyperlink
Create a named reference for ease of use:
Insert>Names>Define...(Ctrl+F3)
Name: Path
Refers To:=MID(CELL("filename");2;SEARCH("/[^/]+'#";CELL("filename"))-1)
[Add], [OK]
Let column A be a list of file names "xxx.pdf" and column B a list of optional descriptions.
Create a hyperlink from this document's path and the file name in A1. Use the label given in B1 or A1 if no label in B1:
=HYPERLINK(Path&A1;IF(B1<>"";B1;A1))
來源：Linking from a sheet to a scanned image?
還要記得開啟enable regular expressions in formulas在Tools - Options - OpenOffice.org Calc - Calculate.
ps：我灌的是英文版2.4
2009-12-05
用openoffice將xls另存成ods會無法使用此法
需將xls的資料複製到ods裡才可以