Issue 122987

From a Calc document, inserting a new sheet (with "link" checkbox checked) from a remote .csv file stored on a WEB server, does not work when authentication data gets passed in URL (in the form http://user:pwd@domain/path/file.csv).

I tried it with test WS at http://user1:user1@test.webdav.org/auth-basic/ and checked network traffic using Wireshark -> OO Calc does not even issue a TCP request towards the remote server.

Same attempt from Basic Macros :
 dim document as object
 dim feuille_donnees as object
 dim filtre as string
 dim details_filtre as string
 dim Url as string
 dim mode as integer
 document=ThisComponent
 feuille_donnees = document.Sheets.getByName("Données")
 Url = "http://samplecsvs.s3.amazonaws.com/Sacramentorealestatetransactions.csv"
 filtre = "Text - txt - csv (StarCalc)"
 details_filtre = "44,34,ANSI,1," ' comma (chr(44)) delimiter, double quote  (chr(34)) text delimiter, ANSI coding
 mode = com.sun.star.sheet.SheetLinkMode.NORMAL
 feuille_donnees.link(Url, "", filtre, details_filtre, mode) 
..and same no-effect.

I thought OO was compliant with RFC1738 §3.1 ?