[Libreoffice-bugs] [Bug 139848] New: #VALUE! thrown repeatedly with the exact same text inserted manually and via copy and paste despite it originally working with the exact same cell input originally

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139848
           Summary: #VALUE! thrown repeatedly with the exact same text
                    inserted manually and via copy and paste despite it
                    originally working with the exact same cell input
                    originally
           Product: LibreOffice
           Version: 7.0.3.1 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: faxorol116 at dashseat.com

Description:
=AVERAGE(IF(B3:B23<0,B3:B23,"")) averaging the negative % values in those
cells. It works originally. I copy and paste the exact same thing back into the
exact same cell and it shows #VALUE! It also does this if i clear the cell,
manually retype the same exact thing, and change it to C for similar data. This
also is occurring when i restart, restart the software and other tests.

Steps to Reproduce:
1.Series of decimal % values some positive and others negative in a column
2.=AVERAGE(IF(C3:C23<0,C3:C23,""))
3. #VALUE!

Actual Results:
#VALUE!

Expected Results:
Average of the negative values


Reproducible: Always


User Profile Reset: No



Additional Info:
Not sure what the problem is. It worked originally. I didnt change anything to
the code whatsoever and it breaks everything now. Possible exploit issue?

-- 
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/20210123/a06f5ac6/attachment-0001.htm>