Android Question Excel Hyperlink

[marcick]

Hi guys,
anybody knows how can I add a HyperLink when writing to a cell with Excel library ?

 

[emexes]

I'm guessing N/D means either "not defined" or "no data", so I'm wondering if any of the quotation marks got lost in the process. What happens if you add a formula like:

cell.InitializeFormula(6, 1, "=2+3")

(perhaps try without the "=" also ?)

edit: my thinking is that if we can get basic formula working ok, then we can graduate to functions and quoted strings

 

[emexes]

DO NOT USE GOOGLE TRANSLATE TO TRANSLATE CODE

Well spotted - if true, this would return some sanity to the situation

 

[marcick]

my thinking is that if we can get basic formula working ok, then we can graduate to functions and quoted strings

Agree. I'll be back soon, thanks.

 

[marcick]

Add the correct formula!!! DO NOT USE GOOGLE TRANSLATE TO TRANSLATE CODE

In my italian localization of the last Excel 365 version, the english notation of the formulas does not work. I'm not using google translate ! I just found that to use "HYPERLINK" I need to pickup "COLLEG.IPERTESTUALE" from the formula list.

 

[emexes]

I just found that to use "HYPERLINK" I need to pickup "COLLEG.IPERTESTUALE" from the formula list.

Does that mean you used:

cell.InitializeFormula(6, 1, "=COLLEG.IPERTESTUALE(""http://www.google.it"",""Google"")")

 

[DonManfred]

Well spotted - if true, this would return some sanity to the situation

i just used google translate to translate COLLEG.IPERTESTUALE for me: Google answered with

 

[emexes]

If means yes than I'd fall back to trying the =2+3 formula, see if it works without quotation marks and brackets

 

[marcick]

If means yes than I'd fall back to trying the =2+3 formula, see how we fare without quotation marks and brackets

Yes, you gave me a lot of indications to investigate. I'll do experiments in the afternoon and be back. Thanks.

 

[marcick]

Here I'm.

So, the correct sintax is

cell.InitializeFormula(1,1,"HYPERLINK(""http://www.google.it"",""Google"")")

No "=" prefix.
Complete url with "http//"
No formulas in italian language ....

I think you told me before, I dont' know where I was losting doing test but the "2+3" was the right starting point

Then in Excel the link works fine and the cell content become

="http://www.google.it" COLLEG.IPERTESTUALE("Google")

Thank you very much for your support.