Search via Google? (which claims to find about 1,160,000 results for "excel hyperlink format" …)
Ask in a more Excel/Microsoft oriented forum?
Well, there is libXL, a powerful library to read/write Excel files. We use it for our MBS FileMaker Plugin, so you could use the methods we have there. This includes embedding pictures in an Excel file as well as adding formulas.
Of course this is an alternative way which requires licenses.
Of course, I first looked there In Excel forums they use macros, thats no go for me.
The reason why to ask here, is that maybe somebody had the same problem and solved it.
I thought it too, but the problem is that Excel import every field either as text or number, not as Link. Maybe there is a code sequence necessary in the text field?
Of you can do it for free (discounting your own time) with ScriptMaster and several Java libraries.
Darüber bin ich auch schon gestolpert, aber irgendwie habe ich nicht gefunden was ich gesucht habe. Können Sie mir zu libXL näheres schicken? Wie hoch sind die Lizenz Kosten?
I'm already stumbled about it, but somehow I did not find what I am looking for. Can you send me further details to LibXL? How much does the license cost?
Write Excel formula in text field starts with = (as you do).
Export records as html.
Open the html with Excel.
If the text value is "=1+2", Excel shows it as 3.
If you just have the calculation ist works. The Link get as link, but when I click on it I get a error message (unexpected error).
The Link for example looks like this:
"pdf" is the folder where the pdf is.
I find an other way, I export it as "merge" and open it in Excel. Excel ask now how to import it and set the cell to standard. When I finish it, the calculation tell me the result and the link is a link, it's not blue, but it works!
You miss type parameter separator in Excel function , as ;
Excel is a german Version on Mac, maybe it's different to the english version, or other language? In the description there is no , there is ;
Hmm, sorry I forgot your language, but in the 1st post you wrote comma as separator...
It is worth to try using comma.
I tested on Windows7 that using full path, partial path, using space in path ( converted to %20 ) in link is OK.
(The URL is file: scheme, so using backslash instead of slash in path is also OK)
Something system setting
and exporting charcter set may affect.
I've never seen FORMULAS work for import into Excel this way. the "=" just becomes part of the text of the cell.
I've used XML/XSLT to create the Excel (as .xls) which can then put proper styling and formulas into the cells. It's a lot of work, but worth once you set it up and use again and again. However, no "images" are imported this way, but perhaps FM13's base64 could be used now-a-days if Excel can handle the decoding?
When I posted about the link as text, it must be a valid link and your "path" may not be valid. How does Excel know where to get the document/image? is it relative to the Excel document? is the "url" the proper one for that kind of document/image?