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
Created attachment 193447 [details] Result of "Text to Columns" function in Calc The screenshot shows the double lines produced by Calc.
Please attach a sample file.
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.)
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.
Because there is a line break at the end of the text. I2: =CODE(RIGHT(H2)) -> 10
Thank you for supporting.