marcick Well-Known Member Licensed User Longtime User Mar 25, 2021 #1 Hi guys, anybody knows how can I add a HyperLink when writing to a cell with Excel library ?
E emexes Expert Licensed User Longtime User Mar 26, 2021 #21 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: B4X: 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 ? Upvote 0
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: B4X: 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 ?
E emexes Expert Licensed User Longtime User Mar 26, 2021 #22 DonManfred said: DO NOT USE GOOGLE TRANSLATE TO TRANSLATE CODE Click to expand... Well spotted - if true, this would return some sanity to the situation ? Upvote 0
DonManfred said: DO NOT USE GOOGLE TRANSLATE TO TRANSLATE CODE Click to expand... Well spotted - if true, this would return some sanity to the situation ?
marcick Well-Known Member Licensed User Longtime User Mar 26, 2021 #23 emexes said: my thinking is that if we can get basic formula working ok, then we can graduate to functions and quoted strings ? Click to expand... Agree. I'll be back soon, thanks. Upvote 0
emexes said: my thinking is that if we can get basic formula working ok, then we can graduate to functions and quoted strings ? Click to expand... Agree. I'll be back soon, thanks.
marcick Well-Known Member Licensed User Longtime User Mar 26, 2021 #24 DonManfred said: Add the correct formula!!! DO NOT USE GOOGLE TRANSLATE TO TRANSLATE CODE Click to expand... 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. Upvote 0
DonManfred said: Add the correct formula!!! DO NOT USE GOOGLE TRANSLATE TO TRANSLATE CODE Click to expand... 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.
E emexes Expert Licensed User Longtime User Mar 26, 2021 #25 marcick said: I just found that to use "HYPERLINK" I need to pickup "COLLEG.IPERTESTUALE" from the formula list. Click to expand... Does that mean you used: Code: cell.InitializeFormula(6, 1, "=COLLEG.IPERTESTUALE(""http://www.google.it"",""Google"")") Upvote 0
marcick said: I just found that to use "HYPERLINK" I need to pickup "COLLEG.IPERTESTUALE" from the formula list. Click to expand... Does that mean you used: Code: cell.InitializeFormula(6, 1, "=COLLEG.IPERTESTUALE(""http://www.google.it"",""Google"")")
DonManfred Expert Licensed User Longtime User Mar 26, 2021 #26 emexes said: Well spotted - if true, this would return some sanity to the situation Click to expand... i just used google translate to translate COLLEG.IPERTESTUALE for me: Google answered with Upvote 0
emexes said: Well spotted - if true, this would return some sanity to the situation Click to expand... i just used google translate to translate COLLEG.IPERTESTUALE for me: Google answered with
E emexes Expert Licensed User Longtime User Mar 26, 2021 #27 If ? means yes than I'd fall back to trying the =2+3 formula, see if it works without quotation marks and brackets ? Upvote 0
If ? means yes than I'd fall back to trying the =2+3 formula, see if it works without quotation marks and brackets ?
marcick Well-Known Member Licensed User Longtime User Mar 26, 2021 #28 emexes said: If ? means yes than I'd fall back to trying the =2+3 formula, see how we fare without quotation marks and brackets ? Click to expand... Yes, you gave me a lot of indications to investigate. I'll do experiments in the afternoon and be back. Thanks. Upvote 0
emexes said: If ? means yes than I'd fall back to trying the =2+3 formula, see how we fare without quotation marks and brackets ? Click to expand... Yes, you gave me a lot of indications to investigate. I'll do experiments in the afternoon and be back. Thanks.
marcick Well-Known Member Licensed User Longtime User Mar 26, 2021 #29 Here I'm. So, the correct sintax is B4X: 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 B4X: ="http://www.google.it" COLLEG.IPERTESTUALE("Google") Thank you very much for your support. Upvote 0
Here I'm. So, the correct sintax is B4X: 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 B4X: ="http://www.google.it" COLLEG.IPERTESTUALE("Google") Thank you very much for your support.
