Bug 116567 - VIEWING: After apply of some needed formatting on a calculated field in a query it get lost after closing the query
Summary: VIEWING: After apply of some needed formatting on a calculated field in a que...
Status: RESOLVED DUPLICATE of bug 86315
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.4.6.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-03-22 16:46 UTC by kivi
Modified: 2018-03-23 10:12 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
small sample database (125.82 KB, application/zip)
2018-03-22 16:48 UTC, kivi
Details

Note You need to log in before you can comment on or make changes to this bug.
Description kivi 2018-03-22 16:46:31 UTC
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
Comment 1 kivi 2018-03-22 16:48:10 UTC
Created attachment 140813 [details]
small sample database
Comment 2 Alex Thurgood 2018-03-23 10:12:59 UTC

*** This bug has been marked as a duplicate of bug 86315 ***