Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

Create hyperlinks to local files in Numbers Apps
One drawback preventing me from switching over completely to Numbers from Excel is its inability to create hyperlinks to local files. I work around this by serving the files on my local machine using Mac OS X's built-in Apache Web server.

First, turn on System Preferences » Sharing » Web Sharing. Test that the server is working by typing 'localhost' into the URL box of a web browser. An Apache message should appear confirming your Websever is functioning. Then add files to /Library/WebServer/Documents folder. Link this file to an entry in Numbers by highlighting the entry in the cell, then create a hyperlink in Numbers' Inspector by checking the 'Enable Hyperlink' box and in the 'Link to:' box type 'http://localhost/filename.' That's it.

To keep documents organized in their proper places, create aliases to the files in the WebServer Directory and place them where one would normally keep the file. For example, create file folder aliases for folders containing pdf copies of bills or receipts, for examples, and place them in your Documents folder for easy access to add/delete/modify those files within one's normal organization or workflow. Files will automatically update in their real location within the WebServer directory.

[crarko adds: I tested this, and it works as described. It's odd that Numbers doesn't support the file:// convention in a URL, but I tried it and it didn't work.]
    •    
  • Currently 5.00 / 5
  You rated: 5 / 5 (2 votes cast)
 
[11,749 views]  

Create hyperlinks to local files in Numbers | 4 comments | Create New Account
Click here to return to the 'Create hyperlinks to local files in Numbers' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Create hyperlinks to local files in Numbers
Authored by: afingal on Dec 06, '10 12:45:11PM

If you're going to enable Apache for purposes like this, make sure that you enable the firewall in the Security preference pane and remove access to Apache. Otherwise, you are opening an avenue for attack. This bad if you're not going to monitor Apache logs and keep on top of security as a web master would.



[ Reply to This | # ]
Create hyperlinks to local files in Numbers
Authored by: leamanc on Dec 06, '10 06:13:53PM

Agreed 100%. While this solution would seem to be designed for personal use (you can't send these Numbers workbooks to someone else and have them use the links, without sending them the files and having them set up Apache also), it's entirely possible one would do this on a corporate LAN. And if you've got a script kiddie in your company checking for open ports on the network, this would be a pretty easy way to hack into your Mac.



[ Reply to This | # ]
Create hyperlinks to local files in Numbers
Authored by: arcticmac on Dec 07, '10 03:50:04PM

Just for the record, it appears, from running Numbers in gdb a little bit that it recognizes, and will at least try to open the following URL schemes (though I couldn't figure out how to construct rdar or pages URLs that were valid enough to get it to actually open them):
http, https, itms, rdar, mailto, pages

it recognizes these URL schemes internally, but for whatever reason (maybe it's a bug?) decides not to pass the user along to them:
file, keynote

any other URL scheme will cause the link to be ignored, similar to the previous two.



[ Reply to This | # ]
Create hyperlinks to local files in Numbers
Authored by: bowlingb on Feb 08, '11 09:47:16AM
Here are a couple of items that came to mind when I read this hint. First, once you enable web sharing in the system preferences, there is a hyperlink right there to open up your browser of choice automatically. No need to manually launch your browser and type a localhost url. Second, enabling web sharing also enables your Sites folder in your user account(~myusername/Sites). Files stored in /Library/... may or may not be picked up by your backup program, depending on your settings. If it is in your user directory structure it is much more likely to get backed up. Rather than http://localhost/filename, you would use http://localhost/~myusername/filename to link the file into your spreadsheet.

[ Reply to This | # ]