<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - VIEWING: After apply of some needed formatting on a calculated field in a query it get lost after closing the query"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116567">116567</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>VIEWING: After apply of some needed formatting on a calculated field in a query it get lost after closing the query
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>kiv@mail.orbitel.bg
</td>
</tr></table>
<p>
<div>
<pre>Description:
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.
Actual Results:
If I start same query again it again shows the numbers as 0 or 0.1 instead of
some thing like 0.0123456
Expected Results:
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.
Reproducible: Always
User Profile Reset: No
Additional Info:
I am attaching a simple sample database
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
Firefox/52.0</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>