Product: Spreadsheet
Type: changed
Title: MIN/MAX/MINA/MAXA return 0 if no value at all
Posted by: [EMAIL PROTECTED]
Affected: sc
Effective from: cws odff
*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [ ]
UI relevant [ ]
*Description*
-------------
For MS-Excel interoperability the functions MIN() and MAX() now return
0 if no numeric value and no error was encountered in the cell
range(s) passed as cell reference(s), note that text cells are ignored
by MIN/MAX. The functions MINA() and MAXA() return 0 if no value
(numeric or text) and no error was encountered. The functions
previously returned an error in these cases. Passing a literal string
argument to MIN() or MAX(), e.g. MIN("string"), still results in an error.
Send feedback to [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
