finderiworknumberspathurl
How do I add a hyperlink to a local file?
I know how to add a hyperlink to a website, so I tried something like file:///Users/MyUser/Documents/Invoices/Some%20Stuff.pdf
However, adding this path to the hyperlink won't make Numbers open the file.
Any ideas?
There isn't much to troubleshoot with iCloud syncing and the iOS version of Numbers. (In the sense that even using Xcode to look at the console logs on the device, the error messages are thin to nonexistent.)
When you enable iCloud on one device it should push all the local documents to iCloud so you don't have to connect to iTunes and manage the files manually.
There are three avenues to make the best progress to resolving this issue:
If a field in a CSV file begins with an apostrophe ('), both Excel and Numbers will treat the field as text, and not render it with any numerical formatting.
Your CSV files appear to try to force text rendering through enclosing number fields in double quotes, but Numbers and Excel don't seem to take the hint that double quote numbers should be treated as strings. The trick seems to be to modify the CSV files so they use the "starts with a single apostrophe" trick rather than the "contained in double quotes" trick for numeric fields, but keep the double quotes for text fields involving punctuation (including commas, quotation marks, line breaks, etc).
To process your CSV files so they do this, you can create an Automator application.
In Automator, create a new Application.
It will have a single action: Run Shell Script (passing input as arguments). Here is the script:
for f in "$@"
do
perl -pi -e "s/\"\"([0-9A-Za-z: \.\-+]+)\"/'\1/g" "$f"
done
Save the resulting application on your Desktop. Drop any CSV files you want to use in Numbers on the application icon, and they will be converted so Numbers should keep the numbers in the fields as literal numbers, and not format them or throw away information.
Back up your data before trying this; it is possible that a particularly oddly constructed string in a record field could throw off the results here.
Best Answer
Out of the box, Numbers cannot link to a non-Numbers local document other than an email.
Numbers can create a link to a webpage, or to a sheet (in Numbers, a "sheet" is a tab within a single spreadsheet), or to a specific email. Numbers cannot, however, create a link to other types of files. This Apple Numbers page contains this text:
The same text (and same limitation as to linked filed types) appears in Numbers on-line help, and in the Menu Bar at Numbers > Format > Add Link.