Bug 141581 - cannot change the date format even though i made it as MM/DD/YY but it always shows as MM-DD-YY
Summary: cannot change the date format even though i made it as MM/DD/YY but it always...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.1.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Form-Controls
  Show dependency treegraph
 
Reported: 2021-04-09 08:01 UTC by delosreyesm195
Modified: 2024-12-24 05:48 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
the output and the control properties is in the picture (20.81 KB, image/png)
2021-04-09 08:01 UTC, delosreyesm195
Details
Date Field, Date format doesn't save (41.74 KB, image/png)
2024-10-08 17:50 UTC, Redje
Details

Note You need to log in before you can comment on or make changes to this bug.
Description delosreyesm195 2021-04-09 08:01:01 UTC
Created attachment 171053 [details]
the output and the control properties is in the picture
Comment 1 Robert Großkopf 2021-04-24 18:53:13 UTC
I could confirm the buggy behavior. The properties of the control will show the right format but the control will show the separator of the language, which is set at

Options → Language Settings → Languages → Formats → Local Setting

For German the sparator will be a '.', in the screenshot it is a '-'

If I change to a formatted field it will show the right format while editing the form and switch to test the input. But the format won't be saved in the form so the language settings of this field are ignored also.
Comment 2 Rob Ward 2022-05-05 23:55:30 UTC
I have a column with date entries. It has a date format:

20-02-2022

I select the column and click "Date" to ensure date field for all cells.

I click the popout to select the date format:

dd/mm/yyyy

Most of the dates change (rows 1-177) to the new format, but others (below row 177) will not change to the new format.

I clear the formatting for those cells. No change.
Comment 3 QA Administrators 2024-05-05 03:16:49 UTC Comment hidden (obsolete)
Comment 4 Redje 2024-10-08 17:48:53 UTC
Looks like this problem still exists in 24.8.2.1. Whenever I change the Date format of a Date Field, after saving and closing and then reopening the form, the Date format field always reverts back to the item from the Date format dropdown. Also see attachment.


Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
Comment 5 Redje 2024-10-08 17:50:59 UTC
Created attachment 196967 [details]
Date Field, Date format doesn't save

Date format always reverts back to the first item from dropdown, after saving, closing and reopening the form.