Bug 143395

Summary: Max function only works in arrays of less that 150 cells in length
Product: LibreOffice Reporter: Mark Lytle <mlytle0>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal CC: rb.henschel
Priority: medium    
Version: 7.0.6.2 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: This is the file I'm having trouble with, Change the max command to anything larger than 149, it fails

Description Mark Lytle 2021-07-15 21:11:35 UTC 
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
Comment 1 Regina Henschel 2021-07-15 23:53:57 UTC 
I cannot confirm the problem. Are you sure, that all cells contain numbers?

Please attach the failing document.
Comment 2 Mark Lytle 2021-07-16 00:03:45 UTC 
Created attachment 173615 [details]
This is the file I'm having trouble with,  Change the max command to anything larger than 149, it fails
Comment 3 Regina Henschel 2021-07-16 00:41:53 UTC 
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).
Comment 4 Mark Lytle 2021-07-16 01:47:19 UTC 
Thank you, I didn't know that.

Regards,
Mark Lytle