[Libreoffice-bugs] [Bug 116607] New: EDITING & FORMATTING: Percentage formatted cell cannot be use for addition

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 116607
           Summary: EDITING & FORMATTING: Percentage formatted cell cannot
                    be use for addition
           Product: LibreOffice
           Version: 6.0.2.1 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: eobet at eobet.com

Description:
1. Enter a number in a cell.
2. Click the % button in the tool bar.
3. Enter a number in a new cell.
4. In a third cell, press = and then click on the second cell, press + and
click on the first cell.

The cell will now reads "#VÄRDE!" when it really should read a decimal value.

Steps to Reproduce:
1. Enter a number in a cell.
2. Click the % button in the tool bar.
3. Enter a number in a new cell.
4. In a third cell, press = and then click on the second cell, press + and
click on the first cell.

Actual Results:  
#VÄRDE!

Expected Results:
A decimal value containing the added percentage.


Reproducible: Always


User Profile Reset: No



Additional Info:
This feels like Excel 101 and you're up to version 6 without this working?


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101
Firefox/58.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/20180324/c7d4aa8e/attachment.html>