Apache OpenOffice (AOO) Bugzilla – Issue 122987
Insert new sheet from .csv file located on remote server does not work when authentication data is passed in URL
Last modified: 2014-01-14 13:24:58 UTC
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 ?