Misleading presentation of small decimal in the calculated field in Queries.
Not possible to get the needed results after apply the needed representation of number precision of the needed field, closing and opening again the same Query.
I could not find any useful information how I can achieve to get the applied numbers precision when start same query again.
So I believe this is a nasty bug as shows to users misleading numbers. They can believe the number is zero but it will be very small decimal
Steps to Reproduce:
1.Create a Query where you calculate one field and result will be a very small decimall
2.When start the qyery instead to see 0.00456879 only 0.1 or 0 is visible
3.If I try to change the column formatting to show the needed precision it get shown as expected but until I close the Query.
If I start same query again it again shows the numbers as 0 or 0.1 instead of some thing like 0.0123456
After appying the needed formatting on the field I expect always if I start the same qyery to see the result with the applied format - same way as it works for fields in tables.
User Profile Reset: No
I am attaching a simple sample database
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0
Created attachment 140813 [details]
small sample database
*** This bug has been marked as a duplicate of bug 86315 ***