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

但在[calc]則無法開啟

請教大家在[calc]中要如何作才能開啟本地端硬碟的檔案？

尋找過程 [url=http://www.google.com/search?q=openoffice+forum&hl=zh-TW]第一步[/url] 第二步：在[url=http://www.oooforum.org/forum/search.phtml]此[/url]找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)) 來源：[url=http://www.oooforum.org/forum/viewtopic.phtml?p=275675#275675]Linking from a sheet to a scanned image?[/url] 還要記得開啟enable regular expressions in formulas在Tools - Options - OpenOffice.org Calc - Calculate.