https://bugs.documentfoundation.org/show_bug.cgi?id=104890
--- Comment #2 from [email protected] ---
Have tested this again:
SELECT ABS(-23.45) FROM "Table"
gives 2345
SELECT ABS(CAST(-23.45 AS NUMERIC(10,2))) FROM "Table"
gives 23.45
You have to change the fieldtype and switch the length to min. 10 and the
function will give the right value.
Tested with
Version: 5.4.0.0.alpha0+
Build ID: d9cfbabc7fe13752daf02e2a8cfa38c72a30fb29
CPU Threads: 4; OS Version: Linux 4.1; UI Render: default; VCL: kde4;
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
2017-01-22_23:06:33
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
