[Libreoffice-bugs] [Bug 116567] New: VIEWING: After apply of some needed formatting on a calculated field in a query it get lost after closing the query

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116567

            Bug ID: 116567
           Summary: VIEWING: After apply of some needed formatting on a
                    calculated field in a query it get lost after closing
                    the query
           Product: LibreOffice
           Version: 5.4.6.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kiv at mail.orbitel.bg

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180322/ae954024/attachment.html>