Actually it depends on your Language Settings. And LibreOffice inherited the problems from OpenOffice...
E.g. for Portuguese (European) the decimal separator is a comma(,) but if I prefer to use a point (because most international publications are formatted according to US notation) when I disable the box "Same as locale setting" it will type the point and as soon as I press enter it will convert it to a date. This is a clear mistake since a point is not a separator in Portugal... i.e. typing 2.3 is converted to 02-03-2010 which is value 40239 -- View this message in context: http://nabble.documentfoundation.org/sum-function-in-libreoffice-calc-doesn-t-seem-to-work-tp1839208p1843520.html Sent from the Users mailing list archive at Nabble.com. -- E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted