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

Eike Rathke <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG
                 CC|                            |[email protected]

--- Comment #2 from Eike Rathke <[email protected]> ---
The value in A1 is of type text, not date or serial date number, therefor
MONTH(A1) gives a #VALUE! result that is propagated to the remainder of the
formula. In the earlier versions of OOo and Excel you mentioned that worked
only if the document is loaded in a locale where month names match the one used
in A1 and produces an error in all other locales. Which is the reason this is
not accepted anymore.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to