[Libreoffice-bugs] [Bug 116258] Severe Bug: Libre Office Calc: csv Import --> correct preview , wrong numbers imported

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 Status|REOPENED|RESOLVED
 CC||miguelangelrv@libreoffice.o
   ||rg
 Resolution|--- |NOTABUG

--- Comment #9 from m.a.riosv  ---
The matter is you can choose the language for the imported file, not for the
generated file, choosing English(UK) or English (USA) works properly they have
dot as decimal separator, but which depends if there are dates.
The preview shows how data are taken to columns in different fields, but not
the final format.
I think not a bug.
Sure there is room for improvement, but please better in a new bug report, as
request for enhancement.

-- 
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 116258] Severe Bug: Libre Office Calc: csv Import --> correct preview , wrong numbers imported

[bugzilla-daemon]

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

--- Comment #8 from GerardF  ---
> Ok. the behaviour has something to do with the DE locale.
> 
> But your answer did not explain
> why 0.05 and 0.1 gets imported correctly 
> (at least looking correctly, even if it is interpreted as text)
> and 0.005 becomes read as a number, here as number "5"

dots with group(s) of 3 digits are imported as numbers.
Example 123.456 or .005

Without group of 3, example 0.1 or 0.05 it is text.

> In addition to it your answer does not explain why the preview shows the
> correct numbers.
> 
> It still seems pretty buggy to me.
> 
> The behaviour is not predictable for the user.

I can agree with this part. Preview should shows text and numbers in the way
they will be imported.

-- 
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 116258] Severe Bug: Libre Office Calc: csv Import --> correct preview , wrong numbers imported

[bugzilla-daemon]

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

kontak...@t-online.de changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|NOTABUG |---
 Ever confirmed|0   |1

--- Comment #7 from kontak...@t-online.de ---
(In reply to GerardF from comment #6)
> In DE locale, comma is decimal separator and dot is thousand separator.
> so 0.05 is impoted as text 0.05 and 0.005 (3 digits after dot) is imported
> as 5.
> 
> No bug here.
> Just choose correct locale or English US column type in import dialog.



Ok. the behaviour has something to do with the DE locale.

But your answer did not explain
why 0.05 and 0.1 gets imported correctly 
(at least looking correctly, even if it is interpreted as text)
and 0.005 becomes read as a number, here as number "5"

In addition to it your answer does not explain why the preview shows the
correct numbers.

It still seems pretty buggy to me.

The behaviour is not predictable for the user.

-- 
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 116258] Severe Bug: Libre Office Calc: csv Import --> correct preview , wrong numbers imported

[bugzilla-daemon]

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

GerardF  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 CC||gerard.farg...@orange.fr
 Resolution|--- |NOTABUG

--- Comment #6 from GerardF  ---
In DE locale, comma is decimal separator and dot is thousand separator.
so 0.05 is impoted as text 0.05 and 0.005 (3 digits after dot) is imported as
5.

No bug here.
Just choose correct locale or English US column type in import dialog.

-- 
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 116258] Severe Bug: Libre Office Calc: csv Import --> correct preview , wrong numbers imported

[bugzilla-daemon]

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

V Stuart Foote  changed:

   What|Removed |Added

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

--- Comment #5 from V Stuart Foote  ---
Can not reproduce on Windows 10 Pro 64-bit en-US with
Version: 6.0.2.1 (x64)
Build ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
CPU threads: 8; OS: Windows 10.0; UI render: GL; 
Locale: en-US (en_US); Calc: group

The column is imported as 0.005 for this local.

-- 
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 116258] Severe Bug: Libre Office Calc: csv Import --> correct preview , wrong numbers imported

[bugzilla-daemon]

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

--- Comment #4 from Xavier Van Wijmeersch  ---
reproduce with

Version: 5.4.1.2
Build ID: ea7cb86e6eeb2bf3a5af73a8fac570321527
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 6.0.1.1
Build ID: SlackBuild for 6.0.1 by Eric Hameleers
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 6.0.3.0.0+
Build ID: 45d59e98f4905475648d5e3ccacfa1279eb69a18
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

but not with

Version: 5.3.8.0.0+
Build ID: 7f1297d9b4f449eb9ada8008fb21b7046d1a8f19
CPU Threads: 8; OS Version: Linux 4.14; UI Render: default; VCL: kde4; Layout
Engine: new; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:libreoffice-5-3, Time:
2017-11-10_15:56:34
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 6.1.0.0.alpha0+
Build ID: ab63510e104c4b8e42982390357af1281c4b11a7
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
2018-03-05_01:01:02
Locale: nl-BE (en_US.UTF-8); Calc: group

-- 
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 116258] Severe Bug: Libre Office Calc: csv Import --> correct preview , wrong numbers imported

[bugzilla-daemon]

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

--- Comment #3 from kontak...@t-online.de ---
Created attachment 140419
  --> https://bugs.documentfoundation.org/attachment.cgi?id=140419=edit
imported csv file with errors

-- 
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 116258] Severe Bug: Libre Office Calc: csv Import --> correct preview , wrong numbers imported

[bugzilla-daemon]

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

--- Comment #2 from kontak...@t-online.de ---
Created attachment 140418
  --> https://bugs.documentfoundation.org/attachment.cgi?id=140418=edit
preview

-- 
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 116258] Severe Bug: Libre Office Calc: csv Import --> correct preview , wrong numbers imported

[bugzilla-daemon]

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

--- Comment #1 from kontak...@t-online.de ---
Created attachment 140417
  --> https://bugs.documentfoundation.org/attachment.cgi?id=140417=edit
csv to import

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