https://bugs.documentfoundation.org/show_bug.cgi?id=92212
--- Comment #2 from Andreas Säger <[email protected]> --- OK. Then LibreOffice imports wrong numbers because date acceptance patterns interfer with locale settings in text import options. However, I can delete the date acceptance patterns and I can use English patterns. No matter what I do, LO 4.4.3 fails to import French/German numbers with thousands separators. I can confirm that the problem occurs with French(France) locale too, interestingly under Windows and Linux. Also interestingly, the "special numbers" option makes no difference when used in French context. Importing 1.234,98 from text file with German base locale and English date acceptance pattern [D/;D/M;D/M/;D/M/Y]: OS + Import Lang + Special_Number --> Result ---------------------------------------------------- Windows + French + SpeciaNum=1 --> Text Windows + French + SpeciaNum=0 --> Text Windows + German + SpeciaNum=0 --> Number Windows + German + SpeciaNum=1 --> Text Linux + French + SpeciaNum=0 --> Text Linux + French + SpeciaNum=1 --> Text Linux + German + SpeciaNum=0 --> Number Linux + German + SpeciaNum=1 --> Number Hundreds of support requests confirm that the whole text import is incomprehensible and I think it is broken as well. Revert to the clear and comprehensible behaviour of OpenOffice.org 2 but eliminate any acceptance of D-M dates. Nobody is ever confronted with any csv files where "1-2" or "1/2" is meant to be a date value. "1-2" or "1/2" is only meant to be a date value when the string comes from a keyboard. -- 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
