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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
