Description: Importing a csv dokument with default settings like: aasd 0.234 0.625 will not import "0.", but only 234 and 625. However in the import dialog it is displayed correctly as "0.234" and 0.625 Steps to Reproduce: 1. open attached csv 2. click on "OK" 3. Actual Results: Values are imported as XXX, like 234 and 625 Expected Results: Values should be imported as 0.XXX Reproducible: Always User Profile Reset: Yes Additional Info: Version: 6.4.4.2 Build-ID: 1:6.4.4-0ubuntu0.20.04.1 CPU-Threads: 8; BS: Linux 5.4; UI-Render: Standard; VCL: gtk3; Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE Calc: threaded
Created attachment 164382 [details] Test case csv
(In reply to Phillip Sz from comment #0) > Additional Info: > Version: 6.4.4.2 > Build-ID: 1:6.4.4-0ubuntu0.20.04.1 > CPU-Threads: 8; BS: Linux 5.4; UI-Render: Standard; VCL: gtk3; > Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE > Calc: threaded German locale uses comma (,) as the decimal point symbol instead of period (.), and period (.) is used as separator in long numbers, such as 1.000.000.000 for a (US) billion. So in your case values like 0.234 are intepreted as integer 0234 instead of 234/1000. To import CSV files with period as decimal point, you probably need to change "Decimal separator key" to period in Tool > Options > Language Settings > Languages, and unselect "Same as locale setting". Maybe there is a setting in the CSV import dialog, but my cursory search didn't find anything.
(In reply to Ming Hua from comment #2) > (In reply to Phillip Sz from comment #0) > > Additional Info: > > Version: 6.4.4.2 > > Build-ID: 1:6.4.4-0ubuntu0.20.04.1 > > CPU-Threads: 8; BS: Linux 5.4; UI-Render: Standard; VCL: gtk3; > > Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE > > Calc: threaded > German locale uses comma (,) as the decimal point symbol instead of period > (.), and period (.) is used as separator in long numbers, such as > 1.000.000.000 for a (US) billion. So in your case values like 0.234 are > intepreted as integer 0234 instead of 234/1000. > > To import CSV files with period as decimal point, you probably need to > change "Decimal separator key" to period in Tool > Options > Language > Settings > Languages, and unselect "Same as locale setting". Maybe there is > a setting in the CSV import dialog, but my cursory search didn't find > anything. You are right, the german local is the problem and you can even change it in the import dialog. However I notice some very strange behaviour. If I import the value "0.1234" and "0.12", it will be imported as string (I think? At least I can not add to it), even with a german local. Only if you have a number with three digits after the dot it will be imported as number 123. Also see testcase2.csv I would propose to make it consistent for all cases. Thanks!
Created attachment 164387 [details] testcase2
There is no problem to import these CSV test files. You do not need to change the decimal separator in Tools > Options > Language Settings > Languages. What you need to do is to select the right type of the column under Fields. In your case the correct type is "US English" that has the dot as decimal separator. After importing in Calc you will see all your numeric data interpreted as numbers (right aligned) with your local decimal separator. So closing as WorksForMe. Please feel free to reopen if you disagree. Best regards. JBF
A proper time frame with the help of teachers can guide you to become a good developer. The https://www.puretravel.com/blog/2021/08/18/4-creative-writing-tips-to-improve-your-travel-writing/ shares some of the ways and platforms that you can use to continue your work.