Bug 146142 - Automatic number formatting not undone after search and replace
Summary: Automatic number formatting not undone after search and replace
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.6.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Find-Search Calc-Cells
  Show dependency tree / graph
 
Reported: 2021-12-09 09:56 UTC by Dennis Junker
Modified: 2023-10-06 05:08 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Dennis Junker 2021-12-09 09:56:38 UTC 
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.
Comment 1 m_a_riosv 2021-12-09 21:45:49 UTC 
Reproducible, the behavior, it's not the same as working directly on the cells.