Apache OpenOffice (AOO) Bugzilla – Issue 124018
authentication to database while drag and drop data from calc
Last modified: 2014-01-15 09:27:35 UTC
When you have data source browser (F4) open with Calc, you can drag and drop data to database. This is great and important functionality. But if you have not authenticated to datasource before, whilst you are like dragging data to datasource's table (to create a new table), whole OOo hangs up. Situation seems pretty clear: OOo starts to request input to database authentication dialog window, but you cannot type anything, because you were in dragNdropping with mouse. I get out of this by terminating whole OOo process with remote login to host (as whole graphical environment becomes unresponsive, as you were dragNdropping and still you have activated a dialog). I have only tested this on KDE. How to replicate this: 1. Open Calc and create data to sheet 2. Create registered connection to database, which requires authentication with password 3. Open Data Source Browser with F4 (but do not open "tables" view, so you are still NOT authenticated to datasource) 4. Select data from calc sheet 5. Drag selected data from calc to datasource's "tables" (which would allow you to create a table into database) 6. Now you get authentication window, but you can't interact with it and OOo freezes your KDE environment.
How to perform step 2?
??? Easy if you use databases. You need database (mysql,postgres,etc), where to connect to. You will need jar-archives added to your OOo installation to have clients for your db. Naturally, you also need a username and password to this database. Then with OOo Base, create data source connection to it (in window that opens when you start OOo Base). When you create connection, in screen that asks for username, type your username and you NEED to check "Requires password" -box.
Thank you. I don't use databases.
If it helps anyone capable of handling this, I think this should be connected to OOo Base, instead of Calc, because Data Source Browser is mo related to Base - so changing product to Base.