Bug 97927 - Make the search and replace function replace all cell content.
Summary: Make the search and replace function replace all cell content.
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-02-17 09:42 UTC by Pepe
Modified: 2016-02-17 15:18 UTC (History)
1 user (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 Pepe 2016-02-17 09:42:18 UTC 
(First of all, sorry for bad english)

Example:

Cell content: abcde12345

Search pattern: abc*

The search matches the cell (OK).

Replace by: hello

Result cell: hellode12345
(replaces only the search pattern).

Desired result: hello
(Replace the entire conten)

Make an option for selecting if the user wants to replace only the match pattern or the entire cell content (This is the default ms excel behavior).

Thank you
Comment 1 Buovjaga 2016-02-17 13:50:33 UTC 
It is enough to use:
abc.*

as the search pattern.

Is it ok for you?
Comment 2 Pepe 2016-02-17 15:18:00 UTC 
Yes, it works perfect.

Thank you and I apologize for the inconvenience.