Bug 160491 - In Calc "text to columns" produces two rows out of one row of data
Summary: In Calc "text to columns" produces two rows out of one row of data
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.0.0 alpha0+
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-04-02 17:47 UTC by Wolfgang Minderle
Modified: 2024-04-05 22:10 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Result of "Text to Columns" function in Calc (376.00 KB, image/png)
2024-04-02 17:53 UTC, Wolfgang Minderle
Details
Sample file for bug verification (62.50 KB, application/vnd.ms-excel)
2024-04-04 14:45 UTC, Wolfgang Minderle
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Wolfgang Minderle 2024-04-02 17:47:27 UTC
Description:
The function "text to columns" in Calc produces two rows out of one row of data. The same function in Excel works correctly.

Steps to Reproduce:
1. Mark the data you want to divide into columns.
2. Define the separator in the "text to columns" menu.
3. Hit "OK".

Actual Results:
The "text to column" feature produces two lines (rows) of partially redundant data instead of only one line of data divided into columns.

Expected Results:
One line (row) of input data should result in one line of output data.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 12; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: en-PH (en_PH); UI: en-US
Calc: CL threaded
Comment 1 Wolfgang Minderle 2024-04-02 17:53:26 UTC
Created attachment 193447 [details]
Result of "Text to Columns" function in Calc

The screenshot shows the double lines produced by Calc.
Comment 2 m_a_riosv 2024-04-03 00:34:41 UTC
Please attach a sample file.
Comment 3 Armondo Lopez 2024-04-03 20:59:57 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. 

(Note that the attachment will be public. Please remove any sensitive information before attaching it. See <https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F> for further detail.)
Comment 4 Wolfgang Minderle 2024-04-04 14:45:55 UTC
Created attachment 193492 [details]
Sample file for bug verification

The error occurs on Sheet #12 'DoorDrawerFrontsALTSListing'. Mark column H and then try "Text to Columns" with separator SPACE. You will see double lines (additional rows) even in the preview window of the function.
Comment 5 m_a_riosv 2024-04-04 23:25:37 UTC
Because there is a line break at the end of the text.
I2: =CODE(RIGHT(H2)) -> 10
Comment 6 Wolfgang Minderle 2024-04-05 16:38:01 UTC
Thank you for supporting.