https://bugs.documentfoundation.org/show_bug.cgi?id=93724
Bug ID: 93724
Summary: BASE: Insert Row in Filtered Form with Date/Time
Fields results in Phantom zero date displayed instead
of null, not saved
Product: LibreOffice
Version: 4.4.0.1 rc
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: dougt901-2...@yahoo.com
Created attachment 118240
--> https://bugs.documentfoundation.org/attachment.cgi?id=118240&action=edit
demonstration database: See Form1 and Macro
1 .In Base, you have a form, we'll call Form1. See demo attachment for
reproducing.
2. There are two defining characteristics of Form1: a.) it has an entry in
the Filter property for MainForm and b.) it has a date/time field.
3. Open Form1
4. Navigate beyond the last row of data in Form1 to the Insert Row.
5. Type Something in the bottom-most field (a text field)
6. Press the save record button or navigate back to the first row
UNEXPECTED RESULT: the date field at the top has gone from the desired
NULL/EMPTY input to a zero date which in this case is 1/1/1800.
Alternately, you can reproduce using the macro saved in the database which does
the same thing, basically. The 0-date 1/1/1800 is persistent in the Form1
recordset until it is closed (no matter if you navigate to other records) but
it is not saved to the table.
The workaround is to delete the filter on the form. However, that is a
non-obvious workaround because why would there be a connection between the way
the date is displayed and the existence of a filter on another field....
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
