Bug 168197 - LibreOffice Base Form with tablecontrol date dropdown (default 14th Feb 2019 instead of today on VCL:gtk3 only)
Summary: LibreOffice Base Form with tablecontrol date dropdown (default 14th Feb 2019 ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
25.8.0.4 release
Hardware: x86-64 (AMD64) Linux (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: GTK3
  Show dependency treegraph
 
Reported: 2025-08-30 13:52 UTC by Brian Stewart
Modified: 2025-08-31 05:55 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Very simple Sample database showing problem (11.85 KB, application/vnd.oasis.opendocument.database)
2025-08-30 13:54 UTC, Brian Stewart
Details
screenshot showing date centered on 14th Feb 2019 (20.54 KB, image/png)
2025-08-30 13:57 UTC, Brian Stewart
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Brian Stewart 2025-08-30 13:52:35 UTC
Description:
I have a database which uses a form with subform in which a date can be entered.
The form contains a date field in the main form with a dropdown. Clicking this shows a calendar centred on today’s date (fine - as it should be).

The form also contains a subform with another date field. This also has a dropdown box for it’s date (edit form, right click date field, select column from list, select dropdown yes).
In the subform the date always seems to be centred on 14th Feb 2019 rather than today’s date. This is inconvenient as I usually want to enter a date close to today’s date.
I raised a topic about this:-
https://ask.libreoffice.org/t/libreoffice-base-form-with-subform-date-dropdown-default-14th-feb-2019/125954

Applies to LibreOffice base Version: 25.8.0.4 (X86_64) and earlier versions.
applies to both HSQLDB and firebird, both embedded and external databases.
Running Ubuntu 24.04.3 LTS.
also applies to openSUSE GNOME environment (openSUSE KDE is fine).

Has been suggested that it would be a bug with LibreOffice VCL gtk3.

Steps to Reproduce:
1. Create a database with 2 tables with at least 1 date field
2. Create a form using 2nd table as subform of first table
3. Change date field of subform to "drop down"
4. When clicking the dropdown in the date field of the subform a calendar opens centred around 14th Feb 2019 rather than today's date.

Actual Results:
dropdown in subform is centred on 14th Feb 2019

Expected Results:
dropdown in subform should be centred on current date


Reproducible: Always


User Profile Reset: No

Additional Info:
see discussion on ask.libreoffice.org forum
https://ask.libreoffice.org/t/libreoffice-base-form-with-subform-date-dropdown-default-14th-feb-2019/125954

a sample database and screenshots are available there.
Comment 1 Brian Stewart 2025-08-30 13:54:26 UTC
Created attachment 202615 [details]
Very simple Sample database showing problem
Comment 2 Brian Stewart 2025-08-30 13:57:26 UTC
Created attachment 202616 [details]
screenshot showing date centered on 14th Feb 2019

Sample database and screenshot
Comment 3 Robert Großkopf 2025-08-31 05:50:39 UTC
Have tested with Linux/KDE and couldn't confirm the bug. So tested more with SAL_USE_VCLPLUGIN=gen. Also no buggy behavior.
Bug appears under Linux only with gtk3. See screenshot from another user in
https://ask.libreoffice.org/t/libreoffice-base-form-with-subform-date-dropdown-default-14th-feb-2019/125954
Take this as confirmation for the buggy behavior.