Description: trying to open a multi-space delimited file. As soon as I enable [X] Merge delimiters, only the first column is visible and available to load. Steps to Reproduce: 1. open space delimited file 2. select Space as delimiter (file contents visible, with empty colums) 3. select Merge delimiters (all but first column disappear, and do not load) Actual Results: Only first column is loaded. If first character on each record is the same as the selected delimiter, no data is visible or loaded. e.g., Other = / and records contain: /home/userid/... Expected Results: all data after first delimiter disappears and is not loaded Reproducible: Always User Profile Reset: No Additional Info: merge delimiters, remove intervening cells, display data in adjacent cells, load data as expected.
Created attachment 183452 [details] one-space delimited sample file Select Space delimiters. Data appears in adjacent cells as expected: [x][a][b][c][d][e][f] Select Merge delimiters and visible data is now: [x][ ][ ][ ][ ][ ][ ] OK: only first column is loaded.
Created attachment 183453 [details] 3-space delimited file Select Space delimiters. Data appears in adjacent cells as expected: [x][ ][ ][a][ ][ ][b][ ][ ][c][ ][ ][d][ ][ ][e][ ][ ][f] Select Merge delimiters and visible data is now: [x][ ][ ][ ][ ][ ][ ][ ][ ][ ][ ][ ][ ][ ][ ][ ][ ][ ][ ] OK: only first column is loaded.
Oops... copied/pasted and forgot to remove "adjacent"
Reproducible. Seems something strange with spaces. Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 1b1a066b935158dc029939520c8fe70b029cb311 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Works for me with: Version: 7.4.2.3 (x64) / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL
This seems to have begun at the below commit. Adding Cc: to Eike Rathke ; Could you possibly take a look at this one? Thanks a712d763e6c037d9c5690c595a4ef275ab5d5b4f is the first bad commit commit a712d763e6c037d9c5690c595a4ef275ab5d5b4f Author: Jenkins Build User <tdf@pollux.tdf> Date: Sun Oct 2 17:14:14 2022 +0200 source cf777cfcb22647b1f2d6ace307fbcc4f6d2cca30 https://git.libreoffice.org/core/+/cf777cfcb22647b1f2d6ace307fbcc4f6d2cca30
Also in 7.4.3.1.0+
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/5db9d8356c8fdc732942357cd2171ba27eda8647 Resolves: tdf#151947 Merging separators must not scan for field end It will be available in 7.5.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.
Pending review https://gerrit.libreoffice.org/c/core/+/142527 for 7-4 https://gerrit.libreoffice.org/c/core/+/142528 for 7-4-3
Looks fixed to me... Thanks! Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: ab4e40941e9ebae83f98ba918440b03eac5bdcaa CPU threads: 20; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb) Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Jumbo
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/881fb6f7c06444c58551f71730d97c51a840fbf5 Resolves: tdf#151947 Merging separators must not scan for field end It will be available in 7.4.4. 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.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-4-3": https://git.libreoffice.org/core/commit/271b5d979a5b498c3e44b031af7dc3002355a0fd Resolves: tdf#151947 Merging separators must not scan for field end It will be available in 7.4.3. 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.