https://bugs.documentfoundation.org/show_bug.cgi?id=97123
Bug ID: 97123 Summary: data range created by drag'n drop from base window loses database name on save Product: LibreOffice Version: 5.0.3.2 release Hardware: All OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: pa...@gestman.lu CC: lio...@mamane.lu 1) Open an ODB file 2) Open an ODS file, go to an empty sheet 3) drag'n drop a table from the base window to the Calc sheet This creates a data range which is linked to the database table. In calc, menu Data / Define Range / Options. Note that the "Source" looks like: file:///c:/path/to/foo.odb/tablename In calc, menu Data / Refresh range. Works. 4) Save ODS file. 5) Close ODS file. 6) Reopen ODS file. 7) menu Data / Refresh range Expected result: works Actual result: Unable to establsh connection Note: menu Data / Define Range / Options the "Source" now looks like: /tablename that is, it has lost the path to the odb file. This is confirmed in the actual XML, where content.xml contains something like: <table:database-ranges> <table:database-range table:name="Import1" table:target-range-address="Sheet3.A1:Sheet3.H1319"> <table:database-source-table table:database-table-name="tablename"> </table:database-source-table> </table:database-range> </table:database-ranges> Note the missing "table:database-name" attribute. By contrast, if one drag'n drops from the "Data Sources" calc window (which displays *registered* databases), then it works correctly and the content.xml contains something like: <table:database-ranges> <table:database-range table:name="Import1" table:target-range-address="Sheet3.A1:Sheet3.H1319"> <table:database-source-table table:database-name="foo" table:database-table-name="tablename"> </table:database-source-table> </table:database-range> </table:database-ranges> -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs