Bug 157923 - Negative Default Value for Integer field in Base Database doesn't work
Summary: Negative Default Value for Integer field in Base Database doesn't work
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.3.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-10-25 17:34 UTC by Jurassic Pork
Modified: 2023-10-25 21:52 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
LibreOffice Base file to test the bug (12.04 KB, application/vnd.sun.xml.base)
2023-10-25 17:35 UTC, Jurassic Pork
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jurassic Pork 2023-10-25 17:34:06 UTC
Description:
In LibreOffice Base, in a table for an Integer type field when you set a negative value by default, when entering a recording (with entry in Table or in a Form) this value appears in the field concerned but when we save this entry, we end up with a value of 0. If we type the negative number in the field during entry, this one is well recorded.

Actual Results:
0 in the recorded Integer field

Expected Results:
negative default value  in the recorded Integer Field


Reproducible: Always


User Profile Reset: No

Additional Info:
Comment 1 Jurassic Pork 2023-10-25 17:35:39 UTC
Created attachment 190421 [details]
LibreOffice Base file to test the bug
Comment 2 jcsanz 2023-10-25 21:51:40 UTC
I can confirm the bug. 

I've also tested with a Firebird database and the behavior is the same, so I think is not a problem of the database used but a problem of the interface

Tested with
----------------
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: es-ES
Calc: CL threaded
----------------
Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 2; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb)
Locale: es-ES (es_ES.UTF-8); UI: es-ES
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.3
Calc: threaded