| Summary: | csv import | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Christian Weiss <amiganer> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | amiganer, miguelangelrv |
| Priority: | medium | ||
| Version: | 6.0.2.1 release | ||
| Hardware: | All | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | csv file with the correct numbers | ||
|
Description
Christian Weiss
2018-03-09 13:47:21 UTC
Created attachment 140503 [details]
csv file with the correct numbers
id and coordinates of star systems from E:D (Elite Dangerous, a Game)
What language have you select on the import? (In reply to m.a.riosv from comment #2) > What language have you select on the import? That which are given by standart: "Zeichensatz" is UTF-8 "Sprache" is Standart - Deutsch (Deutschland) "Trennoption" is Komma "Zeichenketten-Trenner" is " "Weitere Optionen" is "Werte in Hochkomma als Text formatieren" Sorry, I use the german version, I don't know the english word for the options. Bye, Christian If I'm not wrong, decimal separator in Deutsch is comma, while csv uses dot. The language is for the csv imported file, so depends on the dates, use English(UK) or English(USA), or whatever language with dot as decimal separator. There is another option clicking on column(s) head and selecting the column type properly US (English). With English (UK) works fine for me with your attached file. (In reply to m.a.riosv from comment #4) > If I'm not wrong, decimal separator in Deutsch is comma, while csv uses dot. > > The language is for the csv imported file, so depends on the dates, use > English(UK) or English(USA), or whatever language with dot as decimal > separator. > There is another option clicking on column(s) head and selecting the column > type properly US (English). > > With English (UK) works fine for me with your attached file. Than: Why is it only the number at the end and all other numbers in that line are imported correct? If german is the problem, than all numbers should be imported by deleting the "." (= as 1k separator) and none of my numbers should have a decimal separation. That is why I opened a bug report, I think, that behavior is not correct. I know: The decimal separator in German is "," and the 1k separator is "." (oposit to other languages). Bye, Christian (In reply to Christian Weiss from comment #5) > (In reply to m.a.riosv from comment #4) > ... > Than: Why is it only the number at the end and all other numbers in that > line are imported correct? If german is the problem, than all numbers should > be imported by deleting the "." (= as 1k separator) and none of my numbers > should have a decimal separation. With German as language, numbers with dot are imported as text not as numbers (they are aligned to the left not to the right). And in those number with just three decimal places the dot is taken as thousand separator, has no meaning interpreter as such with two decimals. > > That is why I opened a bug report, I think, that behavior is not correct. So seems the behavior is correct. > > I know: The decimal separator in German is "," and the 1k separator is "." > (oposit to other languages). No oposit, there are other languages with the same separators like Spanish. |