Apache OpenOffice (AOO) Bugzilla – Issue 63177
MAX returns Err:502 on empty list
Last modified: 2006-03-15 02:00:57 UTC
This is an MS Excel compatibility issue. In OO Calc, The MAX() function returns Err:502 when the cell list contains empty values. In MS excel the MAX() function returns 0. I'd attach a simple spreadsheet as an example as recommended in the FAQ about issue reporting, but I don't see how to do that from this issue submission form.
Created attachment 34872 [details] Trivial example of MAX returning err:502
duplicated. *** This issue has been marked as a duplicate of 38759 ***
closing.