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@lists.freedesktop.org
Reporter: mikekagan...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs