Description: The wrong value is in column D. The last rows should show the value as "57,101", but Libreoffice makes it "57101". The preview dialog shows the separation correctly. Seems as a format function is interfering with the value rendering. Because when I want to manually edit the value 57101 with entering a comma-sign after 57 it changes right back. Tested with 7.0.2.2 and also 6.3 Actual Results: field value shows 57101 Expected Results: field value shows 57,101 Reproducible: Always User Profile Reset: No Additional Info: Version: 7.0.2.2 Build ID: 8349ace3c3162073abd90d81fd06dcfb6b36b994 CPU threads: 16; OS: Mac OS X 10.15.7; UI render: default; VCL: osx Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Created attachment 166369 [details] dialog when opening csv file with correct formating
The wrong value is in column D. The last rows should show the value as "57,101", but Libreoffice makes it "57101". The preview dialog shows the separation correctly. Seems as a format function is interfering with the value rendering. Because when I want to manually edit the value 57101 with entering a comma-sign after 57 it changes right back.
Created attachment 166370 [details] csv file
This is probably a usage error on import. Data in column D are imported using *Standard* setting (see attached screenshot https://bugs.documentfoundation.org/attachment.cgi?id=166369) for the column, which means that LibreOffice tries to detect numbers as such. 57,101 is English US format using ',' as thousands separator and LibreOffice recognizes that as a number. Hence it is imported correctly (as per settings) as '57101' The intention seems to be to import as text and import needs to be set to *Text* to achieve the desired result.
Created attachment 166373 [details] Import Filter Setting for Text Field Please see the attachment for the import filter setting *Column type: Text* to import "57,101" as "57,101".