Summary: | In Calc "text to columns" produces two rows out of one row of data | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Wolfgang Minderle <wdmind> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED WORKSFORME | ||
Severity: | normal | CC: | miguelangelrv, wdmind |
Priority: | medium | ||
Version: | 7.5.0.0 alpha0+ | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Windows (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: |
Result of "Text to Columns" function in Calc
Sample file for bug verification |
Description
Wolfgang Minderle
2024-04-02 17:47:27 UTC
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. |