Column attributes should be saved with query.
1. Open Media_without_Macros.odb from https://wiki.documentfoundation.org/images/5/52/Sample-databases.zip
2. Query, Select Current_Date, Edit, Run,
2a. Right-Click a Column Header, Column Format, Format Category Date 31 Dec 1999 OK
2b. Right-Click a Column Header, Column Width, Width 5cm OK
3 File, Save, Close
4. Query, Select Current_Date, Right-Click, Open
5. Format attributes not retained
Version: 220.127.116.11 (x64) / LibreOffice Community
Build ID: 2a7ea282da28d665a7dc086360567b4aea27bf08
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-AU (en_AU); UI: en-GB
Thought that this had already been reported ages ago, but a quick trawl of bugzilla didn't bring it up.
Version: 18.104.22.168 / LibreOffice Community
Build ID: 0e133318fcee89abacd6a7d077e292f1145735c3
CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
against a mysql database containing a query that by default displays the date as DD/MM/YY.
Try to format the date column in the query grid to DD/MM/YYYY, validate the format dialog, and the date is displayed as desired.
Now close the query grid view. The user isn't asked whether they want to save the formatting change, nor does any indication in the main DB window show that a change has occurred.
Now re-execute the query, the default date display is back again.
Pretty certain that this has always been like this since OOo3.0.
This probably has something to do with the XML attributes that should be saved to the ODB file.
Perhaps these attributes don't even exist (I haven't checked), and therefore it is more the case of a missing implementation.
See also bug 60539.
Note: Query will be preformatted by the formatting of the table. but this would never work with the special query of this report, which doesn't show any field of a table.
Seems to be a duplicate of bug 86315. I will set this one to DUPLICATE. Feel free to reopen if you see differences there.
*** This bug has been marked as a duplicate of bug 86315 ***
Knew I'd seen it before, thanks Robert.