Bug 150571 - Dates changed on a form without warning the user (date max).
Summary: Dates changed on a form without warning the user (date max).
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: UI (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Fields
  Show dependency treegraph
 
Reported: 2022-08-23 21:35 UTC by jcsanz
Modified: 2022-08-31 10:17 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Test database (11.85 KB, application/vnd.sun.xml.base)
2022-08-23 21:43 UTC, jcsanz
Details

Note You need to log in before you can comment on or make changes to this bug.
Description jcsanz 2022-08-23 21:35:19 UTC
Description:
Dates that are entered in a form, in a "date field" control with a "date max" property assigned, if they are greater than that date, they are modified without warning the user.

Steps to Reproduce:
1. Create a table with at least one DATE field
2. Create a form to edit such table, with a "Date field" control to modify the DATE field.
3. Modify the date field control to assign a "Date max" property (or leave the default 31/12/22000)
4. Save the form
5. Open the form to fill data
6. Introduce in the date control a date grater than "Date max" assigned in step 3
7. With the cursor in the date field, click on "Save record" button on the Form navigation tool bar
8. Close the form and test data in the table

Actual Results:
On step 7, if you have an autovalue field, it is assigned a new value to it, making it appear that the record has been saved correctly.
The date introduced seems as it has been saved (without any modification).
The real date saved in the table is the "Date max" date

Expected Results:
On step 7, a warning message about the invalid date.
No data saved until date is in range.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.4.0.3 (x64) / LibreOffice Community
Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL
Comment 1 jcsanz 2022-08-23 21:43:21 UTC
Created attachment 181990 [details]
Test database

Database with a table and a form to test.
Record with id,s 8 and 9 has been obtained introducing the "8/8/8888" date
Comment 2 jcsanz 2022-08-24 20:34:12 UTC
Component changed to UI because it seems a control problem, not a Base problem
Comment 3 gmolleda 2022-08-26 17:51:47 UTC
Same behaviour in LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4

In step 3 the "Date max" is 31/12/2200 and not 31/12/22000.

Esperanto estas la plibona universala lingvo, la angla diskriminacias.

Sama konduto en LibreOffice 3.3.0
OOO330m19 (Konstruo:6)
etikedo libreoffice-3.3.0.4

En la paŝo 3 la "Dato max" devas esti 31/12/2200 kaj ne 31/12/22000.
Comment 4 Stéphane Guillou (stragu) 2022-08-31 10:17:41 UTC
Confirmed with:

Version: 7.4.0.3 / LibreOffice Community
Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded