https://bugs.documentfoundation.org/show_bug.cgi?id=171354
Bug ID: 171354
Summary: the numeral result of a =se(ou function can't be used
as an input to a =média function
Product: LibreOffice
Version: 25.8.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
i will be using portuguese related terms since i dont use libreoffice in
english.
if a cell using a =SE(OU function generates a number, this number cannot be
used as an input to a =MÉDIA function, it simply can't pull the value.
basically if i write a =se(ou function that returns 70, then reference the cell
in any shape of form as an input to a =MÉDIA function, it will return 0 or
whatever is the other number cosigning the formula
Steps to Reproduce:
1.=SE(OU function that returns 70
2.function =MÉDIA(64;cell that has =se(ou)
3.
Actual Results:
it will return 64, effectively repeating the number instead of 67, the actual
middle ground of those 2
Expected Results:
67 (i swear i'm serious about this)
Reproducible: Always
User Profile Reset: Yes
Additional Info:
it's clear enough
--
You are receiving this mail because:
You are the assignee for the bug.
