Bug 114459 - Text import dialog does not reflect the final import results
Summary: Text import dialog does not reflect the final import results
Status: RESOLVED DUPLICATE of bug 39829
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.6.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-12-14 11:03 UTC by darrask
Modified: 2017-12-26 11:47 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description darrask 2017-12-14 11:03:16 UTC
Description:
Libreoffice Calc gives a correct preview of CSV files even when the region setting for comma symbols is not matched by the CSV numbers contained within (in the locale and in the Libreoffice settings).

After importing, the commas are lost if they do not match the one set in the locale or Libreoffice.

Some history of the bug is here:
https://askubuntu.com/questions/986169/commas-from-csv-only-partially-imported-in-libreoffice-calc

Steps to Reproduce:
1.Save a CSV file with numbers containing commas that do not match the Libreoffice or locale settings for comma symbols (possibly: mix some text values in that column)
2. open the file with calc, look at the preview in the text import dialog
3. Look at the final results in Calc, commas are gone

Actual Results:  
Commas are gone in Calc after text import

Expected Results:
Correct behavior should be: the preview in the text import dialog should reflect how the file is really going to be imported, based on libreoffice or locale settings.


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0
Comment 1 Xavier Van Wijmeersch 2017-12-14 15:35:37 UTC
Thank for reporting the bug, but your version of LO is EOL
Upgrade to the latest version and try again.
If your not agree you can reopen the bugreport
Comment 2 darrask 2017-12-17 06:08:30 UTC
I reopened the bug. It still happens in Libreoffice 5.4.3.2.
Comment 3 Xisco Faulí 2017-12-18 08:46:35 UTC
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone
else confirms it.
Comment 4 Buovjaga 2017-12-26 11:44:54 UTC
Bug 39829 covers also the preview aspect of this.

For now, try this: in the preview window, click the column type (Standard) of the problematic column (I assume Coefficients) and set the Column type from the dropdown to US English.

The problem you describe is probably due to the confusion of thousands separators.

*** This bug has been marked as a duplicate of bug 39829 ***
Comment 5 Buovjaga 2017-12-26 11:47:31 UTC
(In reply to Buovjaga from comment #4)
> Bug 39829 covers also the preview aspect of this.
> 
> For now, try this: in the preview window, click the column type (Standard)
> of the problematic column (I assume Coefficients) and set the Column type
> from the dropdown to US English.
> 
> The problem you describe is probably due to the confusion of thousands
> separators.
> 
> *** This bug has been marked as a duplicate of bug 39829 ***

Apologies, I did the previous change accidentally in ninja mode, so no email notification was sent