Edmonds [mailto:[hidden email]]
Subject:[libreoffice-users] Calc- findreplace with specific
April 18, 2020, 8:25 PM
Hi.EditFind and ReplaceEnter cat say in find (to find instances of cat)Enter cat in replaceClick other optionsFormat.On font select Bold.
Steve- there is no format option within the FindReplace
screen and "other options".
Then click replace allSteveOn 19/04/2020 10:23, Peter Dutton
I want to find a specific word and replace that word with a
bold version of it.
At 18:23 18/04/2020 -0400, Peter Dutton wrote:
>In Calc I want to find a specific word and replace that word with a
>bold version of it.
I think this depends on whether the word you refer to is the total
contents of a cell or just part of it. Formatting in a spreadsheet is
generally handled on a cell basis, not by character. So although you
can indeed manually set part of the contents of a cell to, say, bold,
I don't think there is going to be any way to apply this automatically.
And I don't see any way to achieve what you want as local formatting,
even if the word is the entire contents of a cell. But there is a workaround:
o Create a cell style including the Bold attribute.
o Select an appropriate cell range - perhaps even an entire sheet or sheets.
o Use Conditional Formatting to apply the Bold cell style to any cell
whose contents are exactly your word.