https://bugs.documentfoundation.org/show_bug.cgi?id=104116
Bug ID: 104116
Summary: Writer - forms: Can't use relative URLs for data
source
Product: LibreOffice
Version: 5.2.3.2 rc
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
Description:
I have created a directory that contains:
1. An .odb (LibreOffice Base) file, "Production.odb" containing tables and
queries.
2. A subdirectory at the same directory, named "forms", that contains all the
forms that I need. All the forms have the "Production.odb" file as "Data
source" in form properties
("file:///home/kostas/path-to-directory/Production.odb").
The problem is that, dispite the checked box "Save URLs relative to file
system" at Options => Load/Save => General, the URLs are not treated as
relative ones. That is, when I move the whole directory or rename a part of the
path to it, the form is loosing the connection to the .odb file.
This bug prevent me from creating a database UI (a set of forms) that avoid
using macros for opening forms using buttons. When I move the directory to my
users' PCs I have to adjust the path to the Data Source in every form.
The workaround for this is to register the database to LibreOffice and then use
the registered name for Data Source. But this requires a setup in user's
machine, not just a file copying.
Steps to Reproduce:
1. Create an .odb file, create some tables/queries in it.
2. Create a form inside the .odb (in Base) that display some data.
3. Save the form as .odt file inside "forms" subdirectory.
4. Open it with Writer. Go to View => Toolbars => Form Design and check it. In
the toolbar that appears, press the 2nd button ("Edit") and then the 5th button
("Form Navigator"). In Form Navigator, right click your form and go to
Properties => Data => Data Source and select your .odb file. Save the .odt file
and close both .odt and .odb files.
5. Reopen the form (.odt) just to see that the database data is listed
normally. Then close it.
6. Move the whole directory that the database and forms reside, or rename a
directory in its path.
7. Open the form (.odt) again.
Actual Results:
The database data is not appearing. If you try to edit the form, a warning
appears that says "The connection to the data source could not be established".
Expected Results:
The database data is appearing normally.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:49.0) Gecko/20100101
Firefox/49.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
