| Summary: | Automatic number formatting not undone after search and replace | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Dennis Junker <junker> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | ||
| Severity: | normal | CC: | buzea.bogdan, miguelangelrv |
| Priority: | medium | ||
| Version: | 7.1.6.2 release | ||
| Hardware: | All | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 102847, 108252 | ||
Reproducible, the behavior, it's not the same as working directly on the cells. |
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.