Issue 122987

Summary: Insert new sheet from .csv file located on remote server does not work when authentication data is passed in URL
Product: Calc Reporter: Dimitri Pochet <dimi.pochet>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: dimi.pochet, elish, issues
Version: 3.4.1Keywords: needhelp
Target Milestone: ---   
Hardware: PC   
OS: Windows Vista   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description Dimitri Pochet 2013-08-08 22:20:29 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 ?