Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Dragging query from Base to a Calc sheet causes an error in Ooo 4.01|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||UNCONFIRMED ---||QA Contact:|
|OS:||Windows 8, 8.1|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description edknight 2014-03-24 23:38:27 UTC
This bug report is similar to the one posted here, https://issues.apache.org/ooo/show_bug.cgi?id=119147 , except that report was for OOo 3.4. While 3.4 may have been fixed, OOo 4.01 still has a similar issue. I'm not an IT tech guy, but here's my report. I've recently had to reformat my C:\ Drive, reinstall win 8 (x64). In the process, I switched from OOo 3.4.1 to OOo 4.0.1. Java is 7.0.510.13 My OOo DB is a split using server mode using Mydb.exe. Data mods using forms works OK after pointing OOo and the server.start.bat files to new locations for Java.exe and hsqldb.jar. My problem happens when I try to export a query by dragging to an OOo Calc sheet. I get the error below. "The interface XQueriesSupplier is not available" My Base connection checks...The following are listed under my OOo's Registered Databases: biblio.odb; mydb.file.odb; EKP_Inventory.file.odb (This is the name of my DB). Under Edit/Database/Database Properties DB Type is "JDBC". Under Connection settings, both Test Class and Test Connection buttons showed "successful". Results of my tests of dragging a query to a Calc sheet. OOo 3/Mydb Win 8 (x64) OOo 3.4.1 - Dragging Successful Win XP SP3 (x32) OOo 3.3.0 - Dragging Successful OOo 4.01/Mydb Win 8 (x64) - Dragging caused Error above Win XP SP3 (x32) - Dragging caused Error above Thus, it appears the problem is with OOo 4/Mydb. My guess is that it is a bug as a copy/paste of the query works, while dragging throws an error.