Currently, I must manually do so, for each:
My Environment
Version: 25.8.4.2 (X86_64) Build ID: 580(Build:2) CPU threads: 12; OS: Linux 6.18; UI render: default; VCL: kf6 (cairo+wayland) Locale: en-GB (en_GB.UTF-8); UI: en-US Calc: threaded
Forms and reports constitute the user interface of your application, where dimensions are fixed. Forms and reports are made of tables and queries where formatting, column width and layout does not matter. Tables and queries show raw data without formatting.
@Villeroy, they evidently matter to me, because I’ve no desire for static, arbitrary widths, when those widths don’t encompass the names of the fields, and/or their data. I don’t see why automatic width isn’t the default.
So display them in Forms or Reports.
I don’t know of any DB where SELECTs are intended for displaying purposes to end users 
Sure: it could be. But not a necessary GUI’s feature.
@RokeJulianLockhart : Don’t know which version of LibreOffice you use, but here the automatic width is set by default. Note: Automatic width will only be the automatic width for the column header, not for the content. It will look like this:
Version: 26.2.0.1 (X86_64)
Build ID: 334ecff79a5ea28464a392deab1041cf2e705201
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded
@CRDF, I don’t see how debating what constitutes “a necessary GUI feature” is assistive.
@RobertG, you appear to be referring to libreoffice-calc-25.8.4.2-2.fc43 (although I’m unfamiliar with that modal), whereas I’m referring to libreoffice-25.8.4.2-2, and solely its Table Designer:
Name : libreoffice-base Epoch : 1 Version : 25.8.4.2 Release : 2.fc43 Architecture : x86_64 Download size : 2.3 MiB Installed size : 5.3 MiB Source : libreoffice-25.8.4.2-2.fc43.src.rpm Repository : updates Vendor : Fedora Project
@RokeJulianLockhart : Version I have tested with was LO-Version directly from LibreOffice, not from the packages of the Linux distribution I have installed. Go to Help → About to get the information on your installation. Seems to be Fedora, not original from LibreOffice. Base installed from original packages had set automatic column width - but it isn’t the same as you expect from Calc.
In Calc “automatic” will switch to the maximum width, which is needed.
In Base “automatic” will switch to the maximum, which is needed for the column header.
@RobertG, the official binaries aren’t much of an improvement for me:
RokeJulianLockhart@Beedell:~$ distrobox create
Image registry.fedoraproject.org/fedora-toolbox:latest not found.
Do you want to pull the image now? [Y/n]: y
Trying to pull registry.fedoraproject.org/fedora-toolbox:latest...
Getting image source signatures
Copying blob 51d8899a9510 done |
Copying config 89f6250290 done |
Writing manifest to image destination
89f6250290cf5c89fb97fbb75843c8c900b1e04e90f38d02453bb2759d3f6325
Creating 'my-distrobox' using image registry.fedoraproject.org/fedora-toolbox:latest [ OK ]
Distrobox 'my-distrobox' successfully created.
To enter, run:
distrobox enter my-distrobox
RokeJulianLockhart@Beedell:~$ distrobox enter my-distrobox
Starting container... [ OK ]
Installing basic packages... [ OK ]
Setting up devpts mounts... [ OK ]
Setting up read-only mounts... [ OK ]
Setting up read-write mounts... [ OK ]
Setting up host's sockets integration... [ OK ]
Integrating host's themes, icons, fonts... [ OK ]
Setting up distrobox profile... [ OK ]
Setting up sudo... [ OK ]
Setting up kerberos integration... [ OK ]
Setting up user's group list... [ OK ]
Setting up existing user... [ OK ]
Ensuring user's access... [ OK ]
RokeJulianLockhart@Beedell:~$ wget https://www.libreoffice.org/donate/dl/rpm-x86_64/25.8.4/en-US/LibreOffice_25.8.4_Linux_x86-64_rpm.tar.gz
Saving 'LibreOffice_25.8.4_Linux_x86-64_rpm.tar.gz'
HTTP response 200 [https://www.libreoffice.org/donate/dl/rpm-x86_64/25.8.4/en-US/LibreOffice_25.8.4_Linux_x86-64_rpm.tar.gz]
LibreOffice_25.8.4_L 100% [=========================================================================================================================================================================================================================================================================>] 11.58K --.-KB/s
[Files: 1 Bytes: 11.58K [36.07KB/s] Redirects: 0 Todo: 0 Errors: 0
RokeJulianLockhart@Beedell:~$ cd "$HOME/"
RokeJulianLockhart@Beedell:~$ mkdir ./LibreOffice_25.8.4_Linux_x86-64_rpm
RokeJulianLockhart@Beedell:~$ tar xf ./LibreOffice_25.8.4_Linux_x86-64_rpm.tar.gz --directory='./LibreOffice_25.8.4_Linux_x86-64_rpm'
RokeJulianLockhart@Beedell:~$ cd ./LibreOffice_25.8.4_Linux_x86-64_rpm
RokeJulianLockhart@Beedell:~$ sudo dnf5 install -y *.rpm
Updating and loading repositories:
Repositories loaded.
Package Arch Version Repository Size
Installing:
libobasis25.8-base x86_64 25.8.4.2-2 @commandline 4.4 MiB
libobasis25.8-calc x86_64 25.8.4.2-2 @commandline 26.3 MiB
libobasis25.8-core x86_64 25.8.4.2-2 @commandline 293.1 MiB
libobasis25.8-draw x86_64 25.8.4.2-2 @commandline 48.8 KiB
libobasis25.8-en-US x86_64 25.8.4.2-2 @commandline 148.6 KiB
libobasis25.8-extension-beanshell-script-provider x86_64 25.8.4.2-2 @commandline 453.3 KiB
libobasis25.8-extension-javascript-script-provider x86_64 25.8.4.2-2 @commandline 1.4 MiB
libobasis25.8-extension-mediawiki-publisher x86_64 25.8.4.2-2 @commandline 4.5 MiB
libobasis25.8-extension-nlpsolver x86_64 25.8.4.2-2 @commandline 2.3 MiB
libobasis25.8-extension-pdf-import x86_64 25.8.4.2-2 @commandline 15.6 MiB
libobasis25.8-extension-report-builder x86_64 25.8.4.2-2 @commandline 5.5 MiB
libobasis25.8-firebird x86_64 25.8.4.2-2 @commandline 11.2 MiB
libobasis25.8-gnome-integration x86_64 25.8.4.2-2 @commandline 2.9 MiB
libobasis25.8-graphicfilter x86_64 25.8.4.2-2 @commandline 3.8 MiB
libobasis25.8-images x86_64 25.8.4.2-2 @commandline 71.4 MiB
libobasis25.8-impress x86_64 25.8.4.2-2 @commandline 1.0 MiB
libobasis25.8-kde-integration x86_64 25.8.4.2-2 @commandline 9.2 MiB
libobasis25.8-librelogo x86_64 25.8.4.2-2 @commandline 849.1 KiB
libobasis25.8-libreofficekit-data x86_64 25.8.4.2-2 @commandline 1.4 KiB
libobasis25.8-math x86_64 25.8.4.2-2 @commandline 1.8 MiB
libobasis25.8-ogltrans x86_64 25.8.4.2-2 @commandline 361.9 KiB
libobasis25.8-onlineupdate x86_64 25.8.4.2-2 @commandline 435.0 KiB
libobasis25.8-ooofonts x86_64 25.8.4.2-2 @commandline 53.0 MiB
libobasis25.8-ooolinguistic x86_64 25.8.4.2-2 @commandline 2.1 KiB
libobasis25.8-postgresql-sdbc x86_64 25.8.4.2-2 @commandline 5.6 MiB
libobasis25.8-python-script-provider x86_64 25.8.4.2-2 @commandline 42.3 KiB
libobasis25.8-pyuno x86_64 25.8.4.2-2 @commandline 43.6 MiB
libobasis25.8-writer x86_64 25.8.4.2-2 @commandline 13.4 MiB
libobasis25.8-xsltfilter x86_64 25.8.4.2-2 @commandline 4.3 MiB
libreoffice25.8 x86_64 25.8.4.2-2 @commandline 3.6 MiB
libreoffice25.8-base x86_64 25.8.4.2-2 @commandline 63.0 B
libreoffice25.8-calc x86_64 25.8.4.2-2 @commandline 63.0 B
libreoffice25.8-dict-en x86_64 25.8.4.2-2 @commandline 25.2 MiB
libreoffice25.8-dict-es x86_64 25.8.4.2-2 @commandline 22.5 MiB
libreoffice25.8-dict-fr x86_64 25.8.4.2-2 @commandline 6.5 MiB
libreoffice25.8-draw x86_64 25.8.4.2-2 @commandline 63.0 B
libreoffice25.8-en-US x86_64 25.8.4.2-2 @commandline 16.0 KiB
libreoffice25.8-freedesktop-menus noarch 25.8.4-2 @commandline 1.4 MiB
libreoffice25.8-impress x86_64 25.8.4.2-2 @commandline 66.0 B
libreoffice25.8-math x86_64 25.8.4.2-2 @commandline 63.0 B
libreoffice25.8-ure x86_64 25.8.4.2-2 @commandline 44.5 MiB
libreoffice25.8-writer x86_64 25.8.4.2-2 @commandline 65.0 B
Transaction Summary:
Installing: 42 packages
Total size of inbound packages is 235 MiB. Need to download 0 B.
After this operation, 680 MiB extra will be used (install 680 MiB, remove 0 B).
Running transaction
[ 1/44] Verify package files 100% | 104.0 B/s | 42.0 B | 00m00s
[ 2/44] Prepare transaction 100% | 518.0 B/s | 42.0 B | 00m00s
[ 3/44] Installing libreoffice25.8-ure-0:25.8.4.2-2.x86_64 100% | 95.9 MiB/s | 44.5 MiB | 00m00s
[ 4/44] Installing libobasis25.8-ooofonts-0:25.8.4.2-2.x86_64 100% | 103.7 MiB/s | 53.0 MiB | 00m01s
[ 5/44] Installing libobasis25.8-core-0:25.8.4.2-2.x86_64 100% | 88.0 MiB/s | 294.7 MiB | 00m03s
[ 6/44] Installing libobasis25.8-base-0:25.8.4.2-2.x86_64 100% | 99.3 MiB/s | 4.4 MiB | 00m00s
[ 7/44] Installing libobasis25.8-impress-0:25.8.4.2-2.x86_64 100% | 95.1 MiB/s | 1.0 MiB | 00m00s
[ 8/44] Installing libobasis25.8-writer-0:25.8.4.2-2.x86_64 100% | 94.9 MiB/s | 13.4 MiB | 00m00s
[ 9/44] Installing libobasis25.8-calc-0:25.8.4.2-2.x86_64 100% | 98.8 MiB/s | 26.3 MiB | 00m00s
[10/44] Installing libobasis25.8-draw-0:25.8.4.2-2.x86_64 100% | 24.2 MiB/s | 49.5 KiB | 00m00s
[11/44] Installing libobasis25.8-en-US-0:25.8.4.2-2.x86_64 100% | 36.7 MiB/s | 150.4 KiB | 00m00s
[12/44] Installing libobasis25.8-images-0:25.8.4.2-2.x86_64 100% | 70.1 MiB/s | 71.4 MiB | 00m01s
[13/44] Installing libreoffice25.8-0:25.8.4.2-2.x86_64 100% | 137.7 MiB/s | 3.6 MiB | 00m00s
[14/44] Installing libobasis25.8-math-0:25.8.4.2-2.x86_64 100% | 91.8 MiB/s | 1.8 MiB | 00m00s
[15/44] Installing libobasis25.8-pyuno-0:25.8.4.2-2.x86_64 100% | 85.6 MiB/s | 43.9 MiB | 00m01s
[16/44] Installing libobasis25.8-librelogo-0:25.8.4.2-2.x86_64 100% | 44.9 MiB/s | 873.2 KiB | 00m00s
[17/44] Installing libreoffice25.8-math-0:25.8.4.2-2.x86_64 100% | 197.9 KiB/s | 608.0 B | 00m00s
[18/44] Installing libreoffice25.8-base-0:25.8.4.2-2.x86_64 100% | 148.4 KiB/s | 608.0 B | 00m00s
[19/44] Installing libreoffice25.8-calc-0:25.8.4.2-2.x86_64 100% | 197.9 KiB/s | 608.0 B | 00m00s
[20/44] Installing libreoffice25.8-dict-en-0:25.8.4.2-2.x86_64 100% | 118.5 MiB/s | 25.2 MiB | 00m00s
[21/44] Installing libreoffice25.8-dict-es-0:25.8.4.2-2.x86_64 100% | 152.1 MiB/s | 22.5 MiB | 00m00s
[22/44] Installing libreoffice25.8-dict-fr-0:25.8.4.2-2.x86_64 100% | 108.5 MiB/s | 6.5 MiB | 00m00s
[23/44] Installing libreoffice25.8-draw-0:25.8.4.2-2.x86_64 100% | 296.9 KiB/s | 608.0 B | 00m00s
[24/44] Installing libreoffice25.8-en-US-0:25.8.4.2-2.x86_64 100% | 8.1 MiB/s | 16.6 KiB | 00m00s
[25/44] Installing libreoffice25.8-impress-0:25.8.4.2-2.x86_64 100% | 601.6 KiB/s | 616.0 B | 00m00s
[26/44] Installing libreoffice25.8-writer-0:25.8.4.2-2.x86_64 100% | 597.7 KiB/s | 612.0 B | 00m00s
[27/44] Installing libobasis25.8-ogltrans-0:25.8.4.2-2.x86_64 100% | 51.1 MiB/s | 366.6 KiB | 00m00s
[28/44] Installing libobasis25.8-postgresql-sdbc-0:25.8.4.2-2.x86_64 100% | 94.9 MiB/s | 5.6 MiB | 00m00s
[29/44] Installing libobasis25.8-extension-beanshell-script-provider-0:25.8.4.2-2.x86_64 100% | 49.3 MiB/s | 454.5 KiB | 00m00s
[30/44] Installing libobasis25.8-extension-javascript-script-provider-0:25.8.4.2-2.x86_64 100% | 53.0 MiB/s | 1.4 MiB | 00m00s
[31/44] Installing libobasis25.8-extension-mediawiki-publisher-0:25.8.4.2-2.x86_64 100% | 23.9 MiB/s | 4.8 MiB | 00m00s
[32/44] Installing libobasis25.8-extension-nlpsolver-0:25.8.4.2-2.x86_64 100% | 14.2 MiB/s | 2.7 MiB | 00m00s
[33/44] Installing libobasis25.8-extension-pdf-import-0:25.8.4.2-2.x86_64 100% | 96.0 MiB/s | 15.7 MiB | 00m00s
[34/44] Installing libobasis25.8-extension-report-builder-0:25.8.4.2-2.x86_64 100% | 76.2 MiB/s | 5.5 MiB | 00m00s
[35/44] Installing libobasis25.8-firebird-0:25.8.4.2-2.x86_64 100% | 96.9 MiB/s | 11.2 MiB | 00m00s
[36/44] Installing libobasis25.8-gnome-integration-0:25.8.4.2-2.x86_64 100% | 101.3 MiB/s | 2.9 MiB | 00m00s
[37/44] Installing libobasis25.8-graphicfilter-0:25.8.4.2-2.x86_64 100% | 89.0 MiB/s | 3.8 MiB | 00m00s
[38/44] Installing libobasis25.8-kde-integration-0:25.8.4.2-2.x86_64 100% | 100.8 MiB/s | 9.2 MiB | 00m00s
[39/44] Installing libobasis25.8-libreofficekit-data-0:25.8.4.2-2.x86_64 100% | 1.2 MiB/s | 2.5 KiB | 00m00s
[40/44] Installing libobasis25.8-onlineupdate-0:25.8.4.2-2.x86_64 100% | 71.0 MiB/s | 436.3 KiB | 00m00s
[41/44] Installing libobasis25.8-ooolinguistic-0:25.8.4.2-2.x86_64 100% | 2.7 MiB/s | 2.8 KiB | 00m00s
[42/44] Installing libobasis25.8-python-script-provider-0:25.8.4.2-2.x86_64 100% | 21.1 MiB/s | 43.2 KiB | 00m00s
[43/44] Installing libobasis25.8-xsltfilter-0:25.8.4.2-2.x86_64 100% | 139.7 MiB/s | 4.3 MiB | 00m00s
[44/44] Installing libreoffice25.8-freedesktop-menus-0:25.8.4-2.noarch 100% | 1.2 MiB/s | 1.5 MiB | 00m01s
Warning: skipped OpenPGP checks for 42 packages from repository: @commandline
Complete!
📦[RokeJulianLockhart@my-distrobox ~]$ libreoffice --base
bash: libreoffice: command not found
📦[RokeJulianLockhart@my-distrobox ~]$ ls /usr/bin | grep libreoffice
libreoffice25.8
📦[RokeJulianLockhart@my-distrobox ~]$ libreoffice25.8 --base
/opt/libreoffice25.8/program/oosplash: error while loading shared libraries: libXinerama.so.1: cannot open shared object file: No such file or directory
…and I’ve not the bandwidth to reinstall libreoffice, nor download an ISO for virt-manager, so I’ll believe you. In that case, I presume that this is a bug, unless you’re using a newer version (or an older one, if mine has regressed).