https://bugs.documentfoundation.org/show_bug.cgi?id=139842
Bug ID: 139842
Summary: Calc give me Err:522 results in cells but Function
Wizard give me the correst results
Product: LibreOffice
Version: 7.0.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I'm using the following formula
"=IF(O($O16="";$P16="";$Q16="";$R16="";$S16="";$U16="");"";MAX($A$4:A15)+1)".
Even if I don't change the values in the cells O16,P16,Q16,R16,S16 and U16
sometimes I see the correct value, other times I see the message "Err:522".
It's completly random.
Steps to Reproduce:
1.=IF(O($O16="";$P16="";$Q16="";$R16="";$S16="";$U16="");"";MAX($A$4:A15)+1)
2.
3.
Actual Results:
Err:522
Expected Results:
a number
Reproducible: Sometimes
User Profile Reset: Yes
Additional Info:
I can give you a copy of my file ed the position where there is the formula
--
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
