[Libreoffice-bugs] [Bug 144422] New: Sheet, "Link To External Data", directly import csv FILEOPEN, FILEIMPORT

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: mcl1552 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210910/89f338fb/attachment.htm>