setHyperlink properties do not accept interpolated strings. about office-scripts-docs-reference

[umaxy]

Thanks Alex for pointing this all out.

[AlexJerabek]

Hi @umaxy,

I just tested the sample for Range. setHyperlink and it works as intended. Could you please share the Code Editor error you're getting?

[umaxy]

Your right it does work. I just noticed a back quote was used instead of a single quotation. I've read documentation on single and double quotes but is the back quote interpreted the same way?

[umaxy]

The method only works with back quotes. You cannot use the following https://learn.microsoft.com/en-us/dotnet/visual-basic/programming-guide/language-features/strings/interpolated-strings. Is there any explanation for that behavior?

[AlexJerabek]

That link is to the Visual Basic language reference. Office Scripts are written in TypeScript (which is a superset of JavaScript). The use of a backtick is for Template Literal Types. Single or double quote strings do not allow for variables and would have to be assembled through string concatenation. Functionally, the following two lines are the same:

let text = `Setting hyperlink of ${cell.getAddress()} to the ${linkedSheetName} sheet's A1 cell`;

let text = "Setting hyperlink of " + cell.getAddress() + " to the " + linkedSheetName + " sheet's A1 cell";

Personally, I find the first version more readable and less likely to miss a space or something.

[AlexJerabek]

Closing this issue, since we've confirmed the samples are fine. Happy to keep chatting about TypeScript in the comments.