https://bugs.documentfoundation.org/show_bug.cgi?id=156183
Bug ID: 156183
Summary: DATA > TEXT TO COLUMNS : trashes cells on the right to
the one being converted
Product: LibreOffice
Version: 7.5.4.2 release
Hardware: x86-64 (AMD64)
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Text to columns to a single column trashes cells on the right to the one being
converted when converting dates. Converting from column A to a single output
column, removes the content of column B
Also, performing, for instance, Text to columns on Column A, with three output
columns, affets Column D even if it should just affect columns A,B,C
Steps to Reproduce:
1. Create a new sheet
2. Format cell A1 as text
3. Enter '2020-01-01' in A1
4. Enter 'Goes trashed' in B1
5. Select A1
6. Data->Text to columns
7. Click on 'Standard' above the Cell text
8. Select Date (YMD) (as the text is YMD, but the bug happens on all Date
types)
9. Press OK
Actual Results:
A1 is now an actual date (formatting as number shows 43831)
B1 has been trashed
Expected Results:
B1 shoud be preserved, as we elected to convert to ONLY ONE COLUMN
Reproducible: Always
User Profile Reset: No
Additional Info:
It happens on older versions too and on different computers too (linux & older
macos)
The bug is independent of locales, it happens with any date format and under
different langauges as well
--
You are receiving this mail because:
You are the assignee for the bug.
