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: [email protected]
Reporter: [email protected]
CC: [email protected]
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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
