[Libreoffice-bugs] [Bug 143395] Max function only works in arrays of less that 150 cells in length
https://bugs.documentfoundation.org/show_bug.cgi?id=143395 --- Comment #4 from Mark Lytle --- Thank you, I didn't know that. Regards, Mark Lytle -- 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
[Libreoffice-bugs] [Bug 143395] Max function only works in arrays of less that 150 cells in length
https://bugs.documentfoundation.org/show_bug.cgi?id=143395 Regina Henschel changed: What|Removed |Added Resolution|--- |NOTABUG Status|NEEDINFO|RESOLVED --- Comment #3 from Regina Henschel --- 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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 143395] Max function only works in arrays of less that 150 cells in length
https://bugs.documentfoundation.org/show_bug.cgi?id=143395 --- Comment #2 from Mark Lytle --- Created attachment 173615 --> https://bugs.documentfoundation.org/attachment.cgi?id=173615=edit This is the file I'm having trouble with, Change the max command to anything larger than 149, it fails -- 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
[Libreoffice-bugs] [Bug 143395] Max function only works in arrays of less that 150 cells in length
https://bugs.documentfoundation.org/show_bug.cgi?id=143395 Regina Henschel changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 CC||rb.hensc...@t-online.de --- Comment #1 from Regina Henschel --- I cannot confirm the problem. Are you sure, that all cells contain numbers? Please attach the failing document. -- 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