https://bugs.documentfoundation.org/show_bug.cgi?id=148054
Bug ID: 148054
Summary: With "Text to Column" function when first column
hidden data is not parsed
Product: LibreOffice
Version: 7.2.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
1. Copy and Paste this data into a single column:
Expires 3/8/22
Expires 3/8/22
Expires 4/30/22
2. Select all three rows
3. Data -> Text to columns
4. Select Fixed Width
5. In 'Fields' Set a dividing mark at position 8, just before the Date in the
data
6. Choose 'Hide' for the first column Type and 'Date (MDY)' for the second
column.
7. Click the 'OK' button.
8. Observe: Data is not parsed, it's unchanged in the original column.
--
You are receiving this mail because:
You are the assignee for the bug.