https://bugs.documentfoundation.org/show_bug.cgi?id=94977
Bug ID: 94977
Summary: [FILEOPEN] Convenient decimal numbers parsing when
opening CSV
Product: LibreOffice
Version: 5.0.0.5 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: matthias.ro...@zeutschel.de
I am working on a German Windows system. German language uses the dot (".",
U+002E) as thousands separator, but the colon (",", U+002C) as fractions
sparator. However, usually all CSV files I encountered use the dot as separator
for the fractional part of floating point numbers. If I open such a file on a
System working in German, the cells are imported as text, not as fractional
numbers. Even if checking the option "extended number detection" on the CSV
import dialog, it is not possible to parse the numbers as numbers.
This forum post provides a workaround, but it is not convenient:
http://en.libreofficeforum.org/node/287
I would appreciate an improvement of this someway, perhaps allowing to choose
the decimal import seperator from the CSV import dialog, or making the
detection smarter.
--
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
