[Libreoffice-bugs] [Bug 138404] New: LO base: problems on defining "0" (zero) and "NULL" as "default" values in control fields

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138404

            Bug ID: 138404
           Summary: LO base: problems on defining  "0" (zero) and "NULL"
                    as "default" values in control fields
           Product: LibreOffice
           Version: 7.1.0.0.alpha1+
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: rich.libre at demattio.co.at

Description:
>Spinoff from ticket bug_138387

definition of "default" value in controlfields:
a.) if you would like to have "0" (zero) as default value,
      you first have to define for example "1" and then change to zero.
      If you try to enter "0" directly, it is interpreted as "empty" (NULL?)
b.) the other way round is also a problem:
      it is not possible to change the default value to empty/NULL.
      You have to delete the control and add it from scratch

Steps to Reproduce:
1. self explaining
2.
3.

Actual Results:
in numeric control fields you can not define "0" (zero) directly.
You have to define i.e. "1" first and can define "0" then.

Once you have defined a "non NULL" default value, it is not possible to set the
default to "NULL" again. Can be necessary, if the table behind itself has rules
for defaults.
Actually this is only possible by deleting the control field and recreate it.

Expected Results:
Mainly resetting to NULL should be possible


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 7.1.0.0.alpha1+
Build ID: 312a33b7636334f6ce3b6d1702bc5d3e45215601
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: de-AT (en_US.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64 at 86-TDF, Branch:master, Time:
2020-11-17_01:31:31
Calc: threaded

Graphics:  Device-1: 
           VMware SVGA II Adapter driver: vmwgfx v: 2.18.0.0 bus ID: 00:02.0 
           chip ID: 15ad:0405 
           Display: x11 server: X.Org 1.20.8 driver: 
                    vmware unloaded: fbdev,modesetting,vesa 
           resolution: 1920x1014~60Hz 
           OpenGL: renderer: SVGA3D; build v: 2.1 Mesa 20.0.8 direct render:
Yes

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201122/0c7534a1/attachment.htm>