https://issues.apache.org/ooo/show_bug.cgi?id=122987
Bug ID: 122987
Issue Type: DEFECT
Summary: Insert new sheet from .csv file located on remote
server does not work when authentication data is
passed in URL
Product: Calc
Version: 3.4.1
Hardware: PC
OS: Windows Vista
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: open-import
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
>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:[email protected]/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 ?
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
