Bug 124520 - FORMATTING (suggested feature): Find/Replace could search for a string and replace only formatting in target cells (e.g. bacground color) - useful for searching large tables
Summary: FORMATTING (suggested feature): Find/Replace could search for a string and re...
Status: RESOLVED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.2.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-04-03 10:07 UTC by leoncio
Modified: 2019-05-02 11:31 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description leoncio 2019-04-03 10:07:33 UTC
Description:
when using find/replace it could find targeted strings in cells and e.g. change background of those cells so they are easily identifiable.
Currently "replace" allows string-for-string replacement, general format change, no format change in "string-targeted" cells only, though.
(for review: such a feature is present in MS Excel)


Steps to Reproduce:
1. use Find/Replace and type in a string to search for in 'find' box
2. replace box should be left emtpty, but 'cell styles' should be chosen 
3. both find and replace boxes are affected, instead of 'replace' only, which renders the change impossible 

Actual Results:
no such feature

Expected Results:
ability to change format in cells with a given string


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
enhancement suggestion (not a bug)
Comment 1 Xisco Faulí 2019-05-02 11:31:26 UTC
You can use the Format Paintbrush for changing the format quickly -> https://help.libreoffice.org/Common/Copying_Attributes_With_the_Format_Paintbrush
Closing as RESOLVED WONTFIX