Bug 152838 - Search and Replace : Regular expression not work in Calc
Summary: Search and Replace : Regular expression not work in Calc
Status: RESOLVED DUPLICATE of bug 43107
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-01-02 12:49 UTC by Adrien D
Modified: 2023-01-02 15:21 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 Adrien D 2023-01-02 12:49:43 UTC 
Hello,

In LibreOffice Calc module, eplacing SPACES with CARRIAGE RETURNS not work.

To reproduce : 
1- In a cell, enter : word1 word2 word3 word4
2- Press Ctrl+H
3- Search field enter a space character. Replace, type \n and Check Regular expression box
4- Click on Search and Replace.

Actual result : 
word1\nword2\nword3\nword4

Expected Result : 
word1
word2
word3
word4

Note : Same manipulations works well with Writer module.
Comment 1 Rainer Bielefeld Retired 2023-01-02 15:21:16 UTC 
With Query <https://bugs.documentfoundation.org/buglist.cgi?cmdtype=dorem&remaction=run&namedcmd=DUPs152838&sharer_id=19321>
I found 'Bug 43107 - Regular expression "\n" in replace field inputs "\n" instead of line(paragraph?) break', which describes exactly the same like this one.

Effect indeed is still REPRODUCIBLE with Server Installation of Version: 7.5.0.0.alpha0+  Build ID: 2a7fcaf582df3ada57ca519b50e29011973a1b6f
CPU-Threads: 12; BS: Windows 10.0 Build 19044; UI render: default; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: Calc: threaded |  Elementary Theme  |  Special devUserProfile  (based on my normal one)

and already with OOo 3.2.0

*** This bug has been marked as a duplicate of bug 43107 ***