Import ODB table into spreadsheet, Data Range Refresh

[jankom]

For background see these, previously SOLVED / “answered” topics.

Macro to import base table into spreadsheet

OK, I changed the name by removing “cj”, and it still connects with my other ODB files. However, your PowerFilter.odb would not connect. In fact, if I open that file Edit / Database … has only the third selection available (Advanced settings), the other two are grayed out. I edited the driver class name with another odb file but I still cannot show tables in your odb file: [Screenshot at 2024-01-12 05-02-10.png] jankom

Cannot connect to mysql

Unfortunately nothing worked. tables include Views but I cannot connect to MySQL. The Views only show up in the tables section of the odb file, they are not in the MySQL database. cannot copy queries because it wants to connect to MySQL. Yes, I could copy Forms. As far as duplicating connection setting is not working either. Background: the old odb and the underlying MySQL database was created long time ago in Ubuntu LibreOffice. Laptops expired (hardware failures), now I use an HP laptop wit…

This is a two part question:

1. If I select a table in ODB, Edit / Copy and then select a cell in ODS and do Edit / Paste the table is properly inserted into my spreadsheet, the selected cell will be the top leftmost corner of the inserted table. Good. But when I click on that cell Data / refresh Range is grayed out.
2. If I do Data / Define or Select Range there is nothing there. If I try to define the range of the just inserted table in point 1) above then I run into a naming error:
   
   OK, with trial and error I can give it a name acceptable by LibreOffice, but why could not we show some info on what is the proper syntax? The Help button on the bottom left corner of this window does not give any guidance of what names can we give:
   
   
   
   Even if I give the range an acceptable name the Data Refresh Range is still grayed out when I click on the top leftmost or on any cell within the defined range.

What is the proper way to do this operation?
jankom

[Villeroy]

[Tutorial] Using registered datasources in Calc

[jankom]

Yes, and my apologies. I totally forgot about the f4-drag method. My mind was totally absorbed with database connections and Open/Libre Office intricacies, trying to make my ODB-ODS system work again after some spreadsheet consolidation and improvements.

Thank you for the tutorial section, well written!

Just a wish list to developers:

• make the copy-paste method work the same way as the f4-drag, i.e. make the Refresh Range available even after copy-paste.
• more importantly, tell the user why a defined range name is invalid, or better yet, be more tolerant with names.

jankom