Bug 105961 - TABLE/GUI: Numeric and Decimal doesn't allow input of more than 17 digits
Summary: TABLE/GUI: Numeric and Decimal doesn't allow input of more than 17 digits
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
3.6.7.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-02-12 16:29 UTC by Robert Großkopf
Modified: 2023-02-15 07:57 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Open the database, input 123456789123456789 as value for "Num" or "Dec" (3.74 KB, application/vnd.oasis.opendocument.database)
2017-02-12 16:29 UTC, Robert Großkopf
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2017-02-12 16:29:23 UTC
Created attachment 131142 [details]
Open the database, input 123456789123456789 as value for "Num" or "Dec"

Open the attached database. There is a table with Fields for NUMERIC and DECIMAL values. "Num" and "Dec" were set to 25 digits.

Last value of the last row shows '1'.
Type there 123456789123456789 and see: It will be changed to '1' when saving the database.

Open Tools > SQL.
Execute 
SELECT * FROM "Table";
and let you show the output.
Shows the last input is really 1.

Now Execute
UPDATE "Table" SET "Dec" = 123456789123456789 WHERE "ID" = 5;
You could execute the same query as first and see the right value.

GUI will show this value also, but Input of such a value with more than 17 digits is impossible in a new row.
Comment 1 Robert Großkopf 2017-02-12 16:35:22 UTC
Could be this bug has been inherited by OOo. I have tested with
Version 3.6.7.2 (Build ID: e183d5b)
and the bug is the same as with LO 5.2.5.1 on 
OpenSUSE 42.1 64bit rpm Linux.
Comment 2 Buovjaga 2017-02-12 18:10:46 UTC
Confirmed.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.4.0.0.alpha0+
Build ID: ac8197327d3ef4f3c94fb0746393863404df086b
CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on February 11th 2016
Comment 3 QA Administrators 2018-02-13 03:33:47 UTC Comment hidden (obsolete)
Comment 4 Robert Großkopf 2018-02-13 07:53:34 UTC
Nothing changed in
Version: 6.0.1.1
Build ID: 60bfb1526849283ce2491346ed2aa51c465abfe6
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: kde4; 
Locale: de-DE (de_DE.UTF-8); Calc: group

Input of more than 17 digits isn't saved through GUI in Decimal and Numeric fields.
Comment 5 QA Administrators 2019-02-14 03:49:22 UTC Comment hidden (obsolete)
Comment 6 Robert Großkopf 2019-02-14 07:09:17 UTC
Bug still exists in LO 6.1.5.2 on OpenSUSE 15, 64bit rpm Linux.
Comment 7 QA Administrators 2021-02-14 04:04:01 UTC Comment hidden (obsolete)
Comment 8 Robert Großkopf 2021-02-14 07:09:12 UTC
Nothing changed. Bug is almost there on LO 7.1.0.3, OpenSUSE 15.2 64bit rpm Linux.
Comment 9 QA Administrators 2023-02-15 03:20:53 UTC Comment hidden (obsolete)
Comment 10 Robert Großkopf 2023-02-15 07:57:44 UTC
Bug still exists in LO 7.5.0.3 on OpenSUSE 15.3 64bit rpm Linux.

Note: GUI won't show the right value if number has 16 digits or more. It will show the first 15 digits and all other as '0' if you input such a value through direct SQL.