https://bugs.freedesktop.org/show_bug.cgi?id=41563
Summary: Implicit conversion of ambiguous numeric strings
Product: LibreOffice
Version: LibO 3.4.3 release
Platform: Other
OS/Version: All
Status: NEW
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
="2011-10-6"+1 returns 7th of October with any locale setting because it is an
unambiguous ISO date.
All of the following formulas return #VALUE:
="6/10/2011"+1
="10/6/2011"+1
="6.10.2011"+1
=COUNTIF(A1:A5 ; "6.10") should return #VALUE as well. With German locale it
counts how often this year's 6th of October occurs in A1:A5.
I think, this Excelish behaviour is very unfortunate, inconsistent at least.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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
