Description: A simple vertical array of floating point numbers is copied onto the spreadsheet. The Max function works correctly if the number of cell < 150. Arrays larger than that gives N/A Steps to Reproduce: 1.A simple vertical array of floating point numbers is copied onto the spreadsheet. 2.Implement the Max function. It works correctly if the number of cell < 150. 3.Arrays larger than that gives 'N/A' Actual Results: It works correctly if the number of cell < 150. Arrays larger than that gives N/A Expected Results: That it would work regardless of array size. Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: 4 threads, Linux 5.4 UI render: default; VCL; GTK3 Misc 7.0.6 -3
I cannot confirm the problem. Are you sure, that all cells contain numbers? Please attach the failing document.
Created attachment 173615 [details] This is the file I'm having trouble with, Change the max command to anything larger than 149, it fails
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).
Thank you, I didn't know that. Regards, Mark Lytle