[Libreoffice-bugs] [Bug 49135] For empty cells MONTH() function returns '12' instead of error message.

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=49135

Rainer Bielefeld <LibreOffice at bielefeldundbuss.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|NOTOURBUG                   |NOTABUG

--- Comment #10 from Rainer Bielefeld <LibreOffice at bielefeldundbuss.de> 2012-04-28 22:21:31 UTC ---
@Sascha Nemecek
Of course, that is a weighing of competing interests. I see a priority for a 
reliable, unique exception handling of all functions. The result is that you
will have to check for empty cells in an extra step to avoid miscalculations.
That priority will not be changed only because you have an application where
you need an extra exception handling. But if your problem is a typical one it
can be discussed to extend the old concept. But that is very complex, new
behavior may not change results in existing spreadsheets, but offer new
capabilities, be in accordance with ODF definitions, ... . Before a developer
starts to implement (where he additionally will check all these aspects) it
should have been proven that these conditions are fulfilled by a new concept. 

If you have ideas for a more general solution, you should discuss that on
<libreoffice-ux-advise at lists.freedesktop.org>

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.