Issue 107281 - Time field with spinner apparently not nullable
Summary: Time field with spinner apparently not nullable
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.1.1
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2009-11-28 16:17 UTC by villeroy
Modified: 2013-01-29 22:01 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Form with various nullable controls bound to nullable fields (12.24 KB, application/vnd.sun.xml.base)
2009-11-28 16:19 UTC, villeroy
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description villeroy 2009-11-28 16:17:15 UTC
A time field bound to a nullable table field with property "Input required=No"
and a spin button refuses to stay empty when you delete its content string.
The attached database with form demonstrates the issue. Remove the contents of
the boxes that are shifted to the right side.
The time stays visible although it is removed from the table until you remove
the spinner.
The numeric fields write zero instead of Null. 
Not shure if the latter is by design. At least it is confusing.
Comment 1 villeroy 2009-11-28 16:19:20 UTC
Created attachment 66383 [details]
Form with various nullable controls bound to nullable fields
Comment 2 r4zoli 2009-11-28 21:12:18 UTC
If I go into the time control, I can remove time with backspace, without
removing spinner.
Comment 3 villeroy 2009-11-28 22:29:26 UTC
Indeed, now it works. I can't reproduce it anymore.

Oh, wait a minute!
Store a time value in the time field.
Close the form.
Reopen the form.
Remove the time value.
Comment 4 villeroy 2009-11-29 11:22:38 UTC
Another example:
Open form "qCurrentStatus" and try to remove the preset time value.
It works as designed when you clear the value from "qFilterRow2" or table "Filter".
No, this has nothing to do with the spin buttons.