[Libreoffice-bugs] [Bug 143395] Max function only works in arrays of less that 150 cells in length

[bugzilla-daemon at bugs.documentfoundation.org]

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

Regina Henschel <rb.henschel at t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|NEEDINFO                    |RESOLVED

--- Comment #3 from Regina Henschel <rb.henschel at t-online.de> ---
The cells in lines 150, 155, 395, 415, 420, 493, 680, 685 and 752 contain the
error value #N/A.
The function MAX cannot skip cells with error values, but propagate the error.

In case you will not remove the error values (find & replace), you can use the
formula =MAX(IFNA(L1:L825;"")). You need to enter it as matrix formula (Ctrl +
Shift + Enter).

-- 
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/20210716/984d5c96/attachment.htm>