Bug 139392 - Relation Design canvas should expand as we move elements beyond it
Summary: Relation Design canvas should expand as we move elements beyond it
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.0.3.1 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-01-04 02:34 UTC by Rodger
Modified: 2021-11-26 14:28 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Relation Window Error (10.86 KB, image/png)
2021-01-05 07:10 UTC, Rodger
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Rodger 2021-01-04 02:34:07 UTC
The "Relation Design" window appears to have a size limit of just under 1920x1080 no matter what screen resolution is used, or which database I use.

I have tried dragging tables to the edge, I have tried using the window resize tools, I have tried a blank database. I tried shrinking the screen resolution to see if the area shrunk too. I tried updating to the latest stable version of LibreOffice (7.0.3.1).

It doesn't seem like a bug, but maybe it is? Or I am using LibreOffice Base for a task that is too complicated for it, since I can't find this mentioned anywhere?

Is there a way that more space can be added?  My design needs much more room (at least 4x right now), admittedly because I jumped in the deep end with a complicated relational database, and need everything to visually make sense to my novice brain.
Comment 1 Robert Großkopf 2021-01-04 17:25:14 UTC
I have tested it under OpenSUSE 15.2. Created a table and put this right and down in the window. Then I moved the window on the left out of the screen. I could expand the window an the table could be move on.

The height of the screen doesn't grow more than the screen expands, 1080 px here. But the width of the screenshot from this relation design window is 4338 px and it could be expanded more than this.

Don't know if you could move the window outside on the left in Windows. Then it should work there also.
Comment 2 Rodger 2021-01-04 21:56:51 UTC
Thank you for testing this, Robert.

With the Windows version, if I try to drag a table outside any of the 4 edges, the table will snap to the edge, rather than expand the area used.
Comment 3 Robert Großkopf 2021-01-05 06:50:41 UTC
(In reply to Rodger from comment #2)
> Thank you for testing this, Robert.
> 
> With the Windows version, if I try to drag a table outside any of the 4
> edges, the table will snap to the edge, rather than expand the area used.

That is the same here. But I have taken the window for the relation design and moved it on the left out of the visible area. Seems this is saved somewhere in the window manager here. If I open https://bugs.documentfoundation.org/attachment.cgi?id=168681 it will show me a relation design window which has the same width I have "created" in this way for another database: 4338 px without any table.
Comment 4 Rodger 2021-01-05 07:10:13 UTC
Created attachment 168694 [details]
Relation Window Error

SQL Status: S1000
Error code: -40

General error: org.hsqldb.lib.FileSystemRuntimeException: java.io.IOException:
Comment 5 Rodger 2021-01-05 07:10:54 UTC
I downloaded the attached file and tried to load it, and got the error attached.

SQL Status: S1000
Error code: -40

General error: org.hsqldb.lib.FileSystemRuntimeException: java.io.IOException:
Comment 6 Rodger 2021-01-05 07:12:44 UTC
I also tried to drag the window over to the left until the window was mostly off the screen, and tried extending the window without change.  I tried closing and reoopening from the place with no change (except that the window loaded back in its normal place)
Comment 7 Robert Großkopf 2021-01-05 07:29:18 UTC
(In reply to Rodger from comment #4)
> Created attachment 168694 [details]
> Relation Window Error
> 
> SQL Status: S1000
> Error code: -40
> 
> General error: org.hsqldb.lib.FileSystemRuntimeException:
> java.io.IOException:

Seems you haven't installed all what is needed for working with Base. The window shows that it is missing the possibility to open a HSQLDB database. Have downloaded the file and tested it. It isn't defect.

But all this wouldn't solve your problem. Isn't it possible to define the width and height of a window by the window manager of Windows?
Comment 8 Buovjaga 2021-11-26 14:28:13 UTC
I tested on Windows and Linux and at least the canvas size does not get bigger, if I try to move a table element beyond it either to the right or to the bottom. So this seems to be a valid request.

Arch Linux 64-bit
Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: b18c2a0024c6d33cdf142ed2adf0d127483411e8
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 26 November 2021