https://bugs.freedesktop.org/show_bug.cgi?id=56723
Jens S <j...@tdcspace.dk> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED
--- Comment #1 from Jens S <j...@tdcspace.dk> ---
SUMPRODUCT is not the problem. It is the way you use the function DATEVALUE you
will find the problem. DATEVALUE now need a localized text-string like "1-1" or
what else you have defined under Function - Options - Language - Dateinput
pattern (which should be something like this for most EU-countries:
D-;D-M;D-M-Y).
Furthermore you should know that DATEVALUE("1-1") only refer to the current
year (2013) and your table is from 2012.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
