https://bugs.documentfoundation.org/show_bug.cgi?id=104903
Bug ID: 104903
Summary: Firebird: Function ROUND gives wrong values
Product: LibreOffice
Version: 5.4.0.0.alpha0+ Master
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 129915
--> https://bugs.documentfoundation.org/attachment.cgi?id=129915&action=edit
Open the query round - seems the decimal places were lost.
Open the attached Firebird 3.0 database.
Open the query Round.
Gives wrong values here, ignores the decimalpoint.
Query
SELECT "ID", 7.314 "7.314", ROUND( 7.324, 2 ) "ROUND(7.324, 2)" FROM "Table1"
Shows
1 | 7314 | 7320
ROUND works right with decimal and numeric fields, but doesn't work right with
direct input. Seems to be something wrong with writing decimal places here at
all, see '7314' instead of '7.314'. The value has been rounded right, but it is
displayed wrong.
Version: 5.4.0.0.alpha0+
Build ID: 2a4cd80abcf9e515d1ce3b3a944b573bdc42bff2
CPU Threads: 4; OS Version: Linux 4.1; UI Render: default; VCL: kde4;
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
2016-12-22_00:18:04
Locale: de-DE (de_DE.UTF-8); Calc: group
--
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
