https://bugs.documentfoundation.org/show_bug.cgi?id=122301
Bug ID: 122301
Summary: Function error in Calc
Product: LibreOffice
Version: 6.0.0.0.alpha0+
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: yuubo...@gmail.com
Description:
The following function becomes an error in Calc.
=MAX(FREQUENCY(ROW($L$11:$L$1000),($L$11:$L$1000>=0)*ROW($L$11:$L$1000))-1)
The error message is #VALUE !.
The file does not get an error in EXCELL.
If you read an error in Calc with EXCELL, save it, and read the file in Calc,
you will not get an error.
If you copy and paste the function on the file where no error occurs, you will
get an error again.
Actual Results:
It will happen every time
Expected Results:
I get an error
Reproducible: Always
User Profile Reset: No
Additional Info:
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs