[Libreoffice-ux-advise] [Bug 94977] [FILEOPEN] Convenient decimal numbers parsing when opening CSV

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=94977

V Stuart Foote <vstuart.foote at utsa.edu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |vstuart.foote at utsa.edu

--- Comment #9 from V Stuart Foote <vstuart.foote at utsa.edu> ---
Agree with OP the "US English" is a rather unclear label to indicate handling
of decimal mark formatting for import of source CSV.  But, the GUI drop-down
list of columnar type Text import parsing filters in SCSTR_COLUMN_USER has been
that way since early in OOo.

The action of the GUI sets a parsing filter for Decimal Mark as decimal point
-- as in English language usage (US & British Commonwealth), helping those
locals where Decimal Mark defaults to a decimal comma.

The label should probably reflect that.  So would agree that a change in label
from "US English" -> "Point - Decimal Mark" would be clearer UI.

=-ref-=
http://opengrok.libreoffice.org/xref/core/sc/source/ui/src/scstring.src


And though not currently supported by filter, IMHO adding a "Comma - Decimal
Mark" might be appropriate as a new enhancement, to handle data coming the
opposite direction.

And in this vein, one could make the argument of a need to filter import
UniCode CSV text of other positional numeral systems, i.e. Indic, Eastern
Arabic, Hindi, and some of the CTL and CJK encoded texts. But think that would
be another much more ambitious enhancement.

-- 
You are receiving this mail because:
You are on the CC list for the bug.