| Summary: | EDITING Relation designer refuse to add a table | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | patrick.gelin |
| Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | LibreOffice, robert, serval2412 |
| Priority: | medium | ||
| Version: | 3.6.3.2 release | ||
| Hardware: | Other | ||
| OS: | Linux (All) | ||
| See Also: | https://bugs.freedesktop.org/show_bug.cgi?id=57624 | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
Libreoffice database for the bug
fixed file |
||
The table "LesLocalisations" is already inside the relation designer. When I choose in the relation designer "New Relation" I can choose this table. Because I didn't know, where it is, I tried to connect a field to another table. The GUI shows, that the table is positioned outside the relation designer window on the left side of the relation design. You could see the connection, but couldn't see the table. I don't know, how it could be positioned outside. When I try to put a table on the left outside the window of the relation design, it didn't work. The table is positioned back to the left border. Comment on attachment 70686 [details]
Libreoffice database for the bug
Fix mimetype
Created attachment 71984 [details]
fixed file
On pc Debian x86-64 with master sources updated today, I reproduced the problem.
After having unzipped the odb file and some research, I found that the file had a problem in settings.xml
I runned this command found on the net to format the xml:
cat settings.xml | tidy -utf8 -xml -w 255 -i -c -q -asxml > settings_new.xml
and noticed this:
<config:config-item-set config:name="Table9">
<config:config-item config:name="WindowHeight" config:type="int">120</config:config-item>
<config:config-item config:name="ShowAll" config:type="boolean">false</config:config-item>
<config:config-item config:name="WindowLeft" config:type="int">-334</config:config-item>
<config:config-item config:name="WindowName" config:type="string">LesLocalisations</config:config-item>
There's a negative value here.
So, here what I did:
- removed the "-" from settings.xml
- zip all the directories and files in a new zip
- rename zip in odb
- opened the file
- opened relationships window and put LesLocalisations at right so you can see more easily.
Rainer/Robert: should we investigate about the negative value or should we consider it as an old bug? I have tried to confirm this behavior with a database with much tables. Loaded all tables in the relation-designer. All tables appear there, no table is outside of the window at the left side. I have tested with LO 3.3.4 and LO 3.6.4.3 on Linux 23bit rpm. I don't know how the table could get a negative value "WindowLeft". We should investigate more in such a bug, when there is any person, who could confirm this behavior with another database. I set this bug to "Resolved" and "Worksforme". If this bug could be reproduced with another bug, we should reopen this bug. |
Created attachment 70686 [details] Libreoffice database for the bug I can't to add table "localisation" using relation designer into database file join to this bug.