[Libreoffice-bugs] [Bug 133485] New: A CALC cell formated as "percent" (-12.95%) returns wrong number.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 133485
           Summary: A CALC cell formated as "percent" (-12.95%) returns
                    wrong number.
           Product: LibreOffice
           Version: 6.4.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dheif at compuserve.com

Description:
using LibreOffice Version: 6.4.4.2 (x64) Build ID:
3d775be2011f3886db32dfd395a6a6d1ca2630ff 
in which a cell formated as "percent" (-12.95%) returns wrong number. 
Entering a '2' results in showing 2%. 
Entering a '.2' results in showing 20% instead of 0.20% as expected.
If I enter '.002' the result shows 0.20% which appears to be the correct number
used in calculating the math.


Steps to Reproduce:
1. format cell "percent" (-12.95%)
2. enter '2' in this cell
3. view = 2%
4. enter '.2' in this cell
5. view = 20%
6. enter .002 in this cell
7. view = 0.20%

Actual Results:
explained above

Expected Results:
I would expect that entering '.2' would result in a view which would indicate
two-tenths of a percent, not twenty percent. This has been true for quite some
time and I have simply adjusted by entering the raw number indicating the
actual mathmatical number I need. Evidently whole numbers are all that are
calculated so '.2' would indeed be calculated as 20% even though it was meant
to be used as 2/10%.


Reproducible: Always


User Profile Reset: No



Additional Info:
If I enter '=.2/100' in the percent formatted cell I do get the proper view of
0.20%. Live and learn!

-- 
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/20200528/765e2748/attachment.htm>