https://bugs.documentfoundation.org/show_bug.cgi?id=97123
Michael Peter <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|WORKSFORME |--- Status|RESOLVED |REOPENED OS|Windows (All) |Linux (All) --- Comment #11 from Michael Peter <[email protected]> --- still an issue with drag n drop a query in Base to Calc with mariadb database. In this case the path to the database is lost when the Calc file is closed and reopened. Calc still doesn't save the path to the database at closing as already mentioned by Paulo Martins in 2016. When reopening the calc file after saving and trying to refresh range, the following message appears: "XQueriesSupplier interface not available. at /home/buildslave/source/libo-core/dbaccess/source/core/api/RowSet.cxx:2348" the source file only indicate the query: i.e /query1 without full path to database as indicated before saving file on Calc. Only solution found so far is to reopen Base database en redrag n drop the Query. With copy n paste method there is no link at all with the database anymore Works fine with pivot table but less comfortable to work with data in Calc Same issue dragging and dropping a table. Tested with same result on: Linux mint 21.3, LO 24.2.7.2 and LO 24.8.3 Windows Server 2019 Standard 10.0.17763 Build 17763, LO 24.2.7.2 Let me know if anyone has a solution or if more details are needed, best regards and thanks to all Libreoffice developers -- You are receiving this mail because: You are the assignee for the bug.
