[Libreoffice-ux-advise] CALC: For empty cells MONTH() function returns '12' instead of error message

[Michael Meeks]

On Thu, 2012-04-26 at 07:57 +0200, Rainer Bielefeld wrote:
> that's completely correct, but astonishing, as you can see in Bug 49135
> <https://bugs.freedesktop.org/show_bug.cgi?id=49135>.

	Oh - I added some details there wrt. what we want to do for
interoperability reasons. To some degree the corner-cases in
spreadsheets are expected to be interoperable, while each of them can be
quite surprising :-)

	eg. what do you get if you multiply an error by a boolean ? ;-) sadly
some people rely (often inadvertently) on these corner cases behaviours
and complain when they don't do as they expect.

	HTH,

		Michael.

-- 
michael.meeks at suse.com  <><, Pseudo Engineer, itinerant idiot