https://bugs.documentfoundation.org/show_bug.cgi?id=105961
Bug ID: 105961
Summary: TABLE/GUI: Numeric and Decimal doesn't allow input of
more than 17 digits
Product: LibreOffice
Version: 5.2.5.1 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 131142
--> https://bugs.documentfoundation.org/attachment.cgi?id=131142&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
