Hyperlink in Numbers.

You can do something like this:

tell front document of application "Numbers"
	tell active sheet
		tell (first table whose class of selection range is range)
			set v to value of first cell of selection range
		end tell
	end tell
end tell
do shell script "open " & quoted form of v

Where the value in the cell is something like this on my machine:

/Users/sg3/Desktop/green-right-v.png

But I find it more convenient to click a Dropbox file link.

SG

SG

After all these years do we not have a script that will take a selected cell or range of cells containing file paths and open the file(s)? I'd put one together but for the life of me I can't figure out how to open a file based on the POSIX path provided in a cell. I can open one if I put the path in quotes directly in my script but not if I get it from a cell. I was able to open a file that used colons instead of slashes in the path in the cell but that style is not normal for most people.

It would not be "click to open" but it could be set to a simple key combination

Thanks for that. I could have sworn I tried that shell script line but I must have had something different. I deleted what I was working on this morning so no way to tell what I was doing wrong.

One advantage of a script, aside from not having to upload documents to Dropbox, is you can open multiple documents at the same time. Here are two versions of what I had in mind. The first uses the Applescript path such as "Macintosh HD:Users:badunit:Desktop:grant.png" The second uses the POSIX path like your script "/Users/badunit/Desktop/grant.png". Both allow a range of cells to be selected and their files opened in one call to the script. Invalid paths are skipped. I do wonder how many it can handle before it misbehaves. I've only tried it on three at a time. A limit could be implemented if necessary.

Anyway, if a script invoked by a keyboard shortcut would be a usable solution, the OP has a few to choose from.

tell application "Numbers" to tell front document
	tell active sheet
		tell (first table whose class of selection range is range)
			if (number of cells in selection range) > 5 then display dialog "Open more than five documents?"
			
			repeat with c in (get selection range)'s cells
				set filepath to (value of c)
				try
					tell application "Finder" to open file filepath
				end try
			end repeat
		end tell
	end tell
end tell

tell application "Numbers" to tell front document
	tell active sheet
		tell (first table whose class of selection range is range)
			if (number of cells in selection range) > 5 then display dialog "Open more than five documents?"
			
			repeat with c in (get selection range)'s cells
				set filepath to (value of c)
				try
					do shell script "open " & quoted form of filepath
				end try
			end repeat
		end tell
	end tell
end tell

That's cool. Everything up until the "stop" part worked as you said but if I type localhost into Safari it continues to say "it works" and I can get to the files via Safari after "sudo apachectl stop" and even after I reboot. The links I had in Numbers won't go there, though. How do you get it back to how it was at the beginning?

EDIT: Never mind. It was just pulling up the cached files. I cleared the Safari cache for localhost and all is back as it was.

Badunit wrote:

That's cool. Everything up until the "stop" part worked as you said but if I type localhost into Safari it continues to say "it works" and I can get to the files via Safari after "sudo apachectl stop" and even after I reboot.

Well, you could try a clean install of the OS.😀.

But maybe not necessary.

I went to Safari > Preferences > Privacy > Manage Website Data... and cleared out the localhost cache.

SG

Well, you could try a clean install of the OS.😀.

That always remains an option to fix whatever oddities cannot be solved otherwise. There was a time when I would do this periodically, and reinstall all apps from scratch (along with all their updates and patches), just to clear out all the detritus, especially when I was on a PC running Windows. Now there are so many settings to redo, so many apps to reinstall, and so many saved password, shortcuts, etc. that would be lost in such an operation.

Hi Rabiul,

That is not possible.

What you can do is upload files to a website such as Dropbox and create links to those files.

Regards,

Ian.

Can others on the LAN access the same files?