Re: [SOLVED + CAVEAT] [libreoffice-users] rounding problem with Base

2013-12-30 Thread Tom Davies
Hi :) You can make a Feature Request usignt he bug-report system https://wiki.documentfoundation.org/QA/BugReport Just hunt around the drop-downs to find the one that has Feature request at the bottom of it's list. At least i think it's at the bottom, they might have moved it up in the last

[SOLVED + CAVEAT] [libreoffice-users] rounding problem with Base

2013-12-29 Thread Ivan Sergio Borgonovo
On Fri, 27 Dec 2013 19:06:58 +0100 Ivan Sergio Borgonovo m...@webthatworks.it wrote: To make the change in format permanent you've to build a view from the query and change the format there otherwise if you change the format in the query the format is lost next time you run the query. A bit

[SOLVED] [libreoffice-users] rounding problem with Base

2013-12-27 Thread Ivan Sergio Borgonovo
On Fri, 27 Dec 2013 01:30:27 +0100 Ivan Sergio Borgonovo m...@webthatworks.it wrote: It seems I just had to adjust the format of the column of the query once the query is run. Right click on the query result column and chose format. On Thu, 26 Dec 2013 21:41:48 +0100 Ivan Sergio Borgonovo

Re: [SOLVED] [libreoffice-users] rounding problem with Base

2013-12-27 Thread Tom Davies
Hi :) Are you saying you have solved this problem yourself without help from the list or has the problem just changed a bit? Regards from Tom :) On 27 December 2013 13:02, Ivan Sergio Borgonovo m...@webthatworks.it wrote: On Fri, 27 Dec 2013 01:30:27 +0100 Ivan Sergio Borgonovo

[libreoffice-users] rounding problem with Base

2013-12-26 Thread Ivan Sergio Borgonovo
I've a rounding or maybe display format problem with base. I'm making computations with NUMERIC(30, 2) I've a query (let's name it query1) that do some computation on numeric columns something like: SELECT SUM(c1 * c2 / c3) as s1 , SUM(c4 * c5 / c6) as s2 FROM table1 GROUP BY c0;

Re: [libreoffice-users] rounding problem with Base

2013-12-26 Thread Ivan Sergio Borgonovo
On Thu, 26 Dec 2013 21:41:48 +0100 Ivan Sergio Borgonovo m...@webthatworks.it wrote: I've a rounding or maybe display format problem with base. I'm making computations with NUMERIC(30, 2) I've a query (let's name it query1) that do some computation on numeric columns something like: