how to use calc "data -> data provider" to connect on sqlite db

[Vas]

Hi.
I trying use “data → data provider” in LO calc (6.2).
I set up fields with these values:

1. Database range: import1
2. Data provider: org.libreoffice.calc.sql
3. URL: i used fs path to my sqlite base ( like /home/user/sqlite.db ) but without success
4. ID: i don’t know what is it

Please advice me how to fill all these fields in my case

PS: my sqlite base is registered by LO Base

[Ratslinger]

Hello,

You have stated you have a registered Base file connected to SQLite. With that you can access the data (tables and queries) from Data Sources. This is menu → View>Data Sources (or Shift+Ctrl+F4). This opens access to registered databases where you can select the DB then the table or query. In the right panel the actual data can then be placed in the spreadsheet.

For more on this, see the LO documentation → LibreOffice Calc Guide Chapter 10 - Linking Calc Data.

Edit 2019-10-07:

There is no information or documentation on Data->Data Provider. See tdf#120220, tdf#120911 and tdf#122046