Android Question Excel Hyperlink

[marcick]

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

 

[marcick]

This is the string I should write in the cell to obtain what I need, but writing it with Excel Library then I have the plain text as result and not the HyperLink.

=HIPERLINK("www.google,it", "Google")

 

[DonManfred]

=HIPERLINK

Are you sure it is the correct command? Shouldn´t it be HYPERLINK(url, [optional name]) ?

Away from that you should NOT use comma in a URL. Use DOT. Also you need to enter a complete http URL!

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

works.

 

[marcick]

Sorry for the mistake in the post, yes, HYPERLINK.
But in the genereted Excel I read the string as plain text. If then (in Excel) I copy that string and paste in another cell, the result is correct, eg an Hyperlink.

 

[marcick]

Away from that you should NOT use comma in a URL. Use DOT.

Sorry again, two mistake writing the post. But I confirm the behaviour

 

[DonManfred]

But I confirm the behaviour

Check post #3 again. I posted the solution

 

[marcick]

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

works.

Sorry: works where ? In Excel (of course) or writing a workbook with B4A and Excel library ?

 

[DonManfred]

In Excel

i tested in in excel

It should work with excel library too. you need to add the correct formula to the cell.

 

[marcick]

It should work with excel library too. you need to add the correct formula to the cell.

No, it doesn't .....
in the genereted Excel I read the string as plain text. If then (in Excel) I copy that string and paste in another cell, the result is correct, eg an Hyperlink.

 

[DonManfred]

Post you code

 

[marcick]

            Dim cell As WritableCell
            cell.InitializeText(6, Index,"=COLLEG.IPERTESTUALE(" & Chr(34) & "www.google.it" & Chr(34) & "," & Chr(34) & "Google" & Chr(34) & ")")
            cell.SetCellFormat(cf)
            Sheet1.AddCell(cell)

(italian version of Excel)

And this is the result. In cell H2 I have copied the contents of cell G2 and it has been translated to HyperLink

 

[angel_]

Try this:

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

 

[marcick]

 

[angel_]

View attachment 110463

What text appears in the cell?

 

[marcick]

That one: "#N/D"

 

[emexes]

That one: "#N/D"

What appears in the cell edit field when you press F2 in one of the column-G hyperlink formula cells?

 

[marcick]

Pressing F2 I see it appears "hyperlink" in the formula box

 

[emexes]

Pressing F2 I see it appears "hyperlink" in the formula box

View attachment 110464

I'm more wondering why this bit isn't the HYPERLINK formula:

edit: but I don't have Excel any more on any of my computers, so I can't try it for myself

 

[marcick]

I don't know ....

 

[DonManfred]

I don't know ....

YOU are adding this as a fomula in your Code!

 Dim cell As WritableCell
            cell.InitializeText(6, Index,"=COLLEG.IPERTESTUALE(" & Chr(34) & "www.google.it" & Chr(34) & "," & Chr(34) & "Google" & Chr(34) & ")")
            cell.SetCellFormat(cf)
            Sheet1.AddCell(cell)

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

I´m out here.