[Libreoffice-bugs] [Bug 134398] [LibreOfficeCalc] Wrong Result when you try to add a %

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #1 from Mike Kaganski <mikekaganski at hotmail.com> ---
This is not a bug.

A value that is written like "10%" is just another way of writing "0.1". It's
because "ten percent" is another way of writing "ten hundredths". Thus, when
you write

> = C2 + 10%

you effectively write

> = C2 + 0.1

and that rightfully gives (for 1.81 in C2) 1.91.

If you need 10% *of C2* then you must write that explicitly:

> = C2 + C2*10%

or

> = C2 * 110%

-- 
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/20200629/efe6f9cf/attachment.htm>