datasetsXLSX: Hyperlinks on Index Page seem to be broken

[ruizcrp]

Hi, when using the datasetsXLSX function, the hyperlinks on the index page seem to be broken. They look like this:

=HYPERLINK("#'Alle Angebote'!A1", "Kostenübersicht aller Angebotsnutzungen für Gemeinde Dielsdorf")

[ruizcrp]

[ruizcrp]

When looking at wb-object

[ruizcrp]

I Think there are two issues. 1) The function openxlsx::makeHyperlinkString generates a HYPERLINK with a comma (as in ENglish Excel) as opposed to semicolon (as in German Excel) for the separation wthin a formula. 2) However, the main issue seems to be the conversion of the string. It happens within openxlsx::writeFormula. I also tried to replace openxlsx::makeHyperlinkString with a manual string, but the encoding was the same.

[ThomasKnecht]

How should the string for the hyperlink look like in the end?

[ruizcrp]

I think the following is the closes to what we need: =HYPERLINK("#'Alle Angebote'!A1", "Kostenübersicht aller Angebotsnutzungen für Gemeinde Dielsdorf")

However, not sure about the comma, as in the German Excel this would be a semicolon (however, maybe it is saved with a comma)

[ThomasKnecht]

the example seems to work

do you have a reprex where it does not work?

[Thomas-Caspar-Fischer]

Closing, as hyperlinks are currently working (based on makeHyperlinkString and writeFormula from the openxlsx package).