Description: Importing a CSV file, the last cell in lines that ending in ", " is imported as garbage (random characters that change with each attempt) instead of consisting of a single space. Steps to Reproduce: 1. Open CSV file (containing lines that end in ", "); 2. In the "Text Import" dialog chose "Separated by | Comma"; 3. Finish importing and look at the last value in each line. Actual Results: The last cell for every line that ends in ", " in the CSV contains random characters. Expected Results: The last cell for every line that ends in ", " in the CSV should contain only a space character. Reproducible: Always User Profile Reset: No Additional Info: This problem already existed in LibreOffice 6 versions.
Created attachment 172199 [details] Small file that shows the described problem
Can't repro using Version: 7.1.3.2 (x64) / LibreOffice Community Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1 CPU threads: 12; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: en-US (ru_RU); UI: en-US Calc: threaded
No repro Version: 7.1.3.2 / LibreOffice Community Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1 CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
(In reply to fabio from comment #0) > Additional Info: > This problem already existed in LibreOffice 6 versions. > User Profile Reset: No I'd suggest to try in safe mode or to reset user profile
Resetting the user profile did not fix the issue but helped me notice there is another condition for it to happen: "String delimiter" must be empty. If quotes or any other character are used as "String delimiter" the problem does no occur. Thanks for your prompt answers.
(In reply to fabio from comment #5) Repro. (A sidenote: when replying to a NEEDINFO, please set status back to UNCONFIRMED, not to REOPENED :-))
(In reply to Mike Kaganski from comment #6) > (A sidenote: when replying to a NEEDINFO, please set status back to > UNCONFIRMED, not to REOPENED :-)) Thanks for the tip. It's the first time I'm using Bugzilla.
https://gerrit.libreoffice.org/c/core/+/115839
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/6155689bb6f1d72f29b43ac5ae94b32522ef9b42 tdf#142395: properly handle "no string delimiter" case It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/c55f64f1f4bcd37f071225c8fedca4265f2a59e3 tdf#142395: properly handle "no string delimiter" case It will be available in 7.1.5. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/f4a9dcc471f5cefb2c16e104a270339afa88b4d7 tdf#142395: sc: Add UItest It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Just confirmed the issue is solved in 7.1.5 as expected. Thank you once again for your work.
*** Bug 136013 has been marked as a duplicate of this bug. ***