[Libreoffice-bugs] [Bug 39829] L10n decimal and thousands separator selection for CSV (or other delimiter) text being imported to Calc

[bugzilla-daemon]

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

Heiko Tietze  changed:

   What|Removed |Added

 CC|libreoffice-ux-advise@lists |tietze.he...@gmail.com
   |.freedesktop.org|
   Keywords|needsUXEval |
 Resolution|--- |WONTFIX
 Status|NEW |RESOLVED

--- Comment #11 from Heiko Tietze  ---
We discussed the topic in the design session.

While Excel provides an "Advanced..." dialog where the user can define the
delimiters, the supposed workflow in LibreOffice is to select it via Language.
That means in case of 1,2;1,3 it should be "German", and that reads the values
as numbers 1.1, 1.2... even when locale setting is US English. 

So the request is a WF.

But we should update the preview to make it clear what language means.
Bug 118298 - Update preview in CSV import dialog when the language is changed

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 39829] L10n decimal and thousands separator selection for CSV (or other delimiter) text being imported to Calc

[bugzilla-daemon]

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

Heiko Tietze  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=11
   ||8298

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 39829] L10n decimal and thousands separator selection for CSV (or other delimiter) text being imported to Calc

[bugzilla-daemon]

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

--- Comment #10 from Heiko Tietze  ---
Think we are talking about 1,2;1,3;1,4 vs. 1.1,1.2,1.3 and both should be read
as numerical values independently from the locale. I'm running en_US and 1,2 is
taken as a string. So what we could do UI wise is to enhance the Detect special
number function and also convert comma-delimited strings to numbers.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 39829] L10n decimal and thousands separator selection for CSV ( or other delimiter) text being imported to Calc

[bugzilla-daemon]

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

Heiko Tietze  changed:

   What|Removed |Added

  Component|LibreOffice |Calc

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 39829] L10n decimal and thousands separator selection for CSV (or other delimiter) text being imported to Calc

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=39829

V Stuart Foote vstuart.fo...@utsa.edu changed:

   What|Removed |Added

   Keywords||l10n
 Status|UNCONFIRMED |NEW
 CC||libreoffice-ux-advise@lists
   ||.freedesktop.org,
   ||vstuart.fo...@utsa.edu
  Component|Spreadsheet |ux-advise
Summary|Error handling decimal  |L10n decimal and thousands
   |separator in csv import |separator selection for CSV
   ||(or other delimiter) text
   ||being imported to Calc
 Ever confirmed|0   |1

--- Comment #6 from V Stuart Foote vstuart.fo...@utsa.edu ---
As in comment 3, functional workarounds already exist for handling decimal
marker of CSV (or other separators) during multiple language text import to
Calc. 

However, it would be a reasonable L10n enhancement of the Calc Text Import
dialog to add support to specify the resulting number formats on
import--decimal separator and thousands separator--and display sample in the
Preview area.

Enhancement would be to provide additional control of the imported number
format independent of the User Interface Language setting (Tools - Options -
Language Settings - Language) or the Language setting picked for the source
CSV text file.

From UX perspective could either specify the resulting Language setting, or
possibly could define output field for decimal separator and thousands
separators. Or maybe both.

Closing 39830 as duplicate of this enhancement request.

-- 
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 39829] L10n decimal and thousands separator selection for CSV (or other delimiter) text being imported to Calc

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=39829

--- Comment #7 from V Stuart Foote vstuart.fo...@utsa.edu ---
*** Bug 39830 has been marked as a duplicate of this bug. ***

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