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
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 m
with ss1 and ss2 I get 0 with NO
decimal digits.
When I import query1 in localc and do the sum and squaring and
further computation there I can get the precision I need.
Thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
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