[Libreoffice-bugs] [Bug 119137] New: MAXIFS: error in parameters list (Err:504) for 1-cell range

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119137

            Bug ID: 119137
           Summary: MAXIFS: error in parameters list (Err:504) for 1-cell
                    range
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com

1. Create a new spreadsheet.
2. In A1, enter a number (e.g., 3)
3. In B1, enter formula `=MAXIFS(ROW($A$1:$A1);$A$1:$A1;3)`

Expected: B1 should give `3`.
Actual: it returns `Err:504` ("Error in parameters list").

Note that function wizard for B2 shows that first two parameters to MAXIFS
return arrays ({3}), not scalars.

When B1 is drag-copied downwards, i.e., the formula starts referencing more
than a single row, it starts working correctly.

Tested with Version: 6.1.0.3 (x64)
Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1
CPU threads: 12; OS: Windows 10.0; UI render: GL; 
Locale: ru-RU (ru_RU); Calc: CL

-- 
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/20180807/eb9c2b43/attachment-0001.html>