Apache OpenOffice (AOO) Bugzilla – Issue 105030
Empty tables and Empty alert box under certain conditions
Last modified: 2013-01-29 21:47:38 UTC
When working with a Base document connected to a spreadsheet and a related Writer document pulling data from that data source, I got a blank warning dialog and a blank table when trying to access the tables. To reproduce: -download attached MiddleEarth.ods file -In OpenOffice.org, go to the New menu and choose Database -In the dialog that appears, select "connect to an existing database" and set the source type to "Spreadsheet." -Click "Next" -"Click Browse", navigate to the Middle Earth.ods file, click "Open" -Click "Next" -Make sure that "Yes, register the database for me" is checked -Click Finish -Give new database file a name and save -New Base document will open -click on "tables" then double click on "GoodGuys" to see contents of table -Close the database file -Create a new Writer document -Click on the Data Sources icon on the toolbar -In the Data Sources Viewer, navigate to the MiddleEarth database, and choose the GoodGuys Table (you may need to click on disclosure triangles to drill down to it) -Drag the fields to the Writer document -Select one or more rolse of data in the Data Source Viewer and click on the Data to Fields button -Save document -Open MiddleEarth.ods file (the spreadsheet) It will open as read only -Close MiddleEarth.ods -Open the odb (Base) File -Click on Tables, then double click on "BadGuys" The blank warning will appear -BadGuys table will open, but will be empty Only if you quit and restart OpenOffice.org will things reset and the tables be available correctly. This only happens when a Writer document which uses the odb files as a datasource if part of the mix.
Created attachment 64730 [details] test spreadsheet to use as datasource