Bug 150572 - Dates changed on a form without warning the user (date min)
Summary: Dates changed on a form without warning the user (date min)
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:52 UTC by jcsanz
Modified: 2022-08-31 10:19 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Test database (11.90 KB, application/vnd.sun.xml.base)
2022-08-23 21:54 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:52:11 UTC
Description:
Dates that are entered in a form, in a "date field" control with a "date min" property assigned, if they are lower 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 min" property (or leave the default 1/1/1800)
4. Save the form
5. Open the form to fill data
6. Introduce in the date control a date lower than "Date min" 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 min" 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:54:54 UTC
Created attachment 181991 [details]
Test database

Database with a table and a form to test.
Record with id = 10 has been obtained introducing the date 21/1/1770
Comment 2 jcsanz 2022-08-24 20:34:49 UTC
Component changed to UI because it seems a control problem, not a Base problem
Comment 3 gmolleda 2022-08-26 17:20:22 UTC
Same behaviour in version 3.3:
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 4 Stéphane Guillou (stragu) 2022-08-31 10:19:07 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