General ⇒ How to pass extra navigation directives to a \href Link

[GroovieMan]

Dear friends,
i am trying to transfer a reporting document (taken from word) to latex.
Finally i want to give pdf-document to an office, that offers links to
documents, that are described in my latex report.
Finally i want to ship a usb-stick or a cd-rom with my repor an a couple of
referred pdf and xls/ods documents.

So for the first href seems to be a perfect solution for this, tried:

Code: Select all

\href{run:/doc/payments/payment.pdf}{Electrician's invoice 123}

This works very well with PDF and other OS know documents.

Next, i was trying refer to a cell in a spreadsheet. In the original document i used a
URL with a path into the spreadsheet, pointing to a cell. Each time i was pointing to the
generated pdf report a speadsheet popped up the the cursor went to the cell. The pdf
showed the following link

Code: Select all

file:///doc/payment/calculation//calc.ods#nkcalc!C5

where
- calc.ods is an libreoffice-sheet,
- nkcalc the tab
- C and 5 the column and row.

How can i implement this in latex?
I think i have to use \href in order to set my own label "Electrician's invoice 123"-

Code: Select all

\href{run:doc/payment/calculation//calc.ods#nkcalc!C5}{see here }

Sad to say, that this does not work.

[GroovieMan]

Dear friends,

in the meantime i found the solution:
\href{file:///doc/payment/calculation//calc.ods\#nkcalc!C5}{400,00 €, payment}

I have overseeen the escape symbol in front of the #

[Stefan Kottwitz]

Welcome to the forum!

And thanks for letting us know the solution you found.

Stefan

[GroovieMan]

Yough, if I tend to ask stupid questions in forums like this with the expectation of getting them answered, i should be ready to leave a note here in case of a found solution.

Stefan, thanks for your work!
​