https://bugs.documentfoundation.org/show_bug.cgi?id=144422
Bug ID: 144422 Summary: Sheet, "Link To External Data", directly import csv FILEOPEN, FILEIMPORT Product: LibreOffice Version: 6.0.7.3 release Hardware: All OS: All Status: UNCONFIRMED Severity: enhancement Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: mcl1...@yahoo.com.au Description: URL of external data source. Enter the URL or the file name that contains the data that you want to insert, and then press Enter. Alternatively, click Browse button to select the file name from a file dialog that opens. Only then will the URL be requested from the network or file system. Note Icon A dialog for CSV data import appears when linking to external CSV file. Available tables/ranges Select the table or the data range that you want to insert. "If the selected Calc or Excel document contains no named range, spreadsheet data cannot be inserted and OK button will remain inactive" I am referring to the last part of the description above in quotes"" I have a HTML link to a downloadable .csv file. This dialogue works up to and including defining special column data as one would on opening the file directly from my local disc. The system process underlying the part quoted should be changed to permit an assumption that the whole document is to be loaded as per the settings in the csv column definition dialogue and the OK button activated so the process can proceed. Sample public link https://data.nsw.gov.au/data/dataset/aefcde60-3b0c-4bc0-9af1-6fe652944ec2/resource/21304414-1ff1-4243-a5d2-f52778048b29/download/covid-19-cases-by-notification-date-and-postcode-local-health-district-and-local-government-area.csv Steps to Reproduce: 1. Menu 2. Sheet 3. Link to external data 4. insert URL press enter 5. Text import dialogue pops up 6. Select Comma, Format quoted field as text, Fields Column type YMD on first column. 7. click OK 8. Available Tables/Ranges is blank but it could say "Entire file" 9. select Update every 84600 seconds for a daily update 10 OK button is inactive but it could be active. Actual Results: got nowhere Expected Results: should have created permalink to the file Reproducible: Always User Profile Reset: No Additional Info: Version: 6.0.7.3 Build ID: 1:6.0.7-0ubuntu0.18.04.10 CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3; Locale: en-AU (en_AU.UTF-8); Calc: group -- You are receiving this mail because: You are the assignee for the bug.