[prev in list] [next in list] [prev in thread] [next in thread] 

List:       libreoffice-ux-advise
Subject:    [Libreoffice-ux-advise] CALC: For empty cells MONTH() function returns '12' instead of error message
From:       michael.meeks () suse ! com (Michael Meeks)
Date:       2012-04-26 8:34:25
Message-ID: 1335429265.19186.222.camel () linux-yjtf ! site
[Download RAW message or body]


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


[prev in list] [next in list] [prev in thread] [next in thread]