https://bugs.documentfoundation.org/show_bug.cgi?id=146142
Bug ID: 146142
Summary: Automatic number formatting not undone after search
and replace
Product: LibreOffice
Version: 7.1.6.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
Description:
After replacing e.g. 31122020 with 31.12.2020 using the search and replace
function, the cells are formatted as dates. When undoing the replacement the
number-format stays, writing all 7 or 8-digit numbers as dd.mm.yyyy.
Steps to Reproduce:
1. Replace "([0-9]{1,2})([0-9]{2})([0-9]{4})" by "$1.$2.$3" using regular
expressions (german date format)
2. Undo replacement
Actual Results:
Previous cell value interpreted as date
Expected Results:
Previous cell value shown with the previous format
Reproducible: Always
User Profile Reset: No
Additional Info:
Automatic date detection is enabled and set to german date format.
--
You are receiving this mail because:
You are the assignee for the bug.