LO Base: Wrong date while setting default value
Steps to Reproduce:
1. LO Base, create new table
2. Set Date for some field
3. Set default value = for ex, 14.03.2008, see screen-1
4. Save changes
Default date is changed. See screen-2
It is also changed if to switch between fields (date field and another one).
Date is not changed
User Profile Reset: No
Build ID: e3e15d8c625cbf56e1f03d9ebde966e78844c7a4
CPU threads: 1; OS: Linux 4.14; UI render: default; VCL: kde5;
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2018-12-13_20:10:25
Locale: ru-RU (ru_RU.UTF-8); UI-Language: en-US
Reproduced also for GTK3
Created attachment 147606 [details]
Created attachment 147607 [details]
Created attachment 147608 [details]
test file Firebird embedded, date field with default date, local en_us lang en_us
Test system Ubuntu 18.04.1 (AMD64) LO6.2Beta1 (daily build 12/15)
Test file created with english dates and the string entered in the table designer was '02/01/18' which was then changed in the example format as '02/03/01'.
I then changed the display format for the column, in the table view, to long dates and both the values added to new records and the string displayed in the table editor was again changed.
Confirming issue, default date string being misread.
1 - open attached base file
2 - open the table view for Table1
3 - enter a new record.
4 - close the table view and open the table design editor
5 - try to change the default date string
the conversion of the default date string to a date value is wrong.
It's a duplicate of 102945.
Every time you leave the field and enter it again the date will be set 2 days later. So you couldn't set a default and edit the table again without changing the default.
*** This bug has been marked as a duplicate of bug 102945 ***