[Libreoffice-ux-advise] [Bug 94977] Calc: Decimal number parsing when importing CSV -- function of US English labeled filter needs to be clear (comment 7)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #11 from V Stuart Foote <vstuart.foote at utsa.edu> ---
@@Eike, *

(In reply to Eike Rathke from comment #10)
> But it does more than that. It effectively sets en-US locale parsing for
> that column's import, which not only affects the decimal separator but also
> group separator, date format and day and month names. So actually the
> current label reflects reality..

Ugh! That is even more obscure. Then in addition to the "US English" (wouldn't
want to break anything), would it be reasonable to add two simpler and specific
entries to the SCSTR_COLUMN_USER picklist, and the code to support them, in the
column parser?

"Point - decimal mark"
"Comma - decimal mark"

P.S. -- poked around in the source... could follow it as far as
http://opengrok.libreoffice.org/xref/core/sc/source/ui/dbgui/scuiasciiopt.cxx#240
and populates the list box.  But I'm quickly lost in looking for indication it
can distinguish a range of data formats that might be in the column. So no idea
how involved this may be--Sorry.

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