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

[bugzilla-daemon]

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

V Stuart Foote  changed:

   What|Removed |Added

 CC||vstuart.fo...@utsa.edu

--- Comment #9 from V Stuart Foote  ---
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 the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Joel Madero  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||libreoffice-ux-advise@lists
   ||.freedesktop.org
  Component|Calc|ux-advise
 Ever confirmed|0   |1

--- Comment #8 from Joel Madero  ---
Requesting UX input and throwing this to NEW.

I don't particularly like changing the label but I'm not entirely sure the
extent of impact that selecting the language has (outside of apparently what
you've encountered). Thus UX advise is best here to determine how to move
forward.

-- 
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

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

[bugzilla-daemon]

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

--- Comment #4 from Matthias Ronge  ---
Created attachment 119954
  --> https://bugs.documentfoundation.org/attachment.cgi?id=119954=edit
The import dialog I see

-- 
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

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

[bugzilla-daemon]

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

Matthias Ronge  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

--- Comment #7 from Matthias Ronge  ---
@m.a.riosv: The numbers column can be selected “US English” as you explained,
which causes the import to work like expected. The problem was for me that I
failed to guess that function from that label. I would never have come to the
idea to set a language to a non text column (In what language is 42?). If I
would have been asked what that setting is for, I would have guessed it would
set the syllabificator’s or spell checker’s dictionary.

Perhaps a first correction to this would be to change the label to something
more self-descriptive, perhaps “Decimal separator is .”?

-- 
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

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

[bugzilla-daemon]

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

--- Comment #3 from Matthias Ronge  ---
Created attachment 119953
  --> https://bugs.documentfoundation.org/attachment.cgi?id=119953=edit
Simple import test file

-- 
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

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

[bugzilla-daemon]

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

--- Comment #5 from Matthias Ronge  ---
Created attachment 119955
  --> https://bugs.documentfoundation.org/attachment.cgi?id=119955=edit
The result of the import process

-- 
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

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

[bugzilla-daemon]

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

--- Comment #6 from Matthias Ronge  ---
Created attachment 119956
  --> https://bugs.documentfoundation.org/attachment.cgi?id=119956=edit
What, imho, the result of the import should be

-- 
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

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

[bugzilla-daemon]

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

Joel Madero  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||jmadero@gmail.com
 Ever confirmed|0   |1

--- Comment #2 from Joel Madero  ---
Please attach a simple test file so that it's easy for us to see what you're
seeing. Marking as NEEDINFO - once you attach a sample set to UNCONFIRMED.
Thanks

-- 
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

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

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 CC||miguelangelrv@libreoffice.o
   ||rg

--- Comment #1 from m.a.riosv  ---
Hi @Matthias, thanks for reporting.

There are at least two ways for select it in the import window.

- The securer way is select the column clicking on their head and in the column
type select US English. You can use Shift or Ctrl key for a quick selection of
several columns.

- Selecting as Language for input a language with those as default as English
(UK), it has dot as decimal point and dates like in other EU countries.

-- 
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