[Libreoffice-bugs] [Bug 122301] New: Function error in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: yuuboku3 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181224/2861f3aa/attachment-0001.html>