How to globally change cell Names in Calc formulas?

[Gret939]

Hello -- Can someone advise on how to globally change a cell Name in all formulas in a Calc worksheet (and/or workbook of multiple sheets)? There is the Modify button in the Define Names dialogue box, but it appears to only make a copy of the modified Name, and ADD the new Name to the list of Names, but doesn't change any of the Names used in the sheet formulas. I have a large, complicated, multi-tab, sheet with numerous financial formulas, using about 100 cell Names. Now working on adding the next sections, but realized I need to change many of the old Names to differentiate those from similar Names will be using in the new sections. Seems like there should be a way to change all occurrences of a Name in all formulas from one spelling to another, without having to manually go through every usage in all the sheets. I'm hoping I just missed something simple and basic. Or maybe there is an alternate approach? Any help is appreciated. Thnx.

[FJCC]

If you want to change the name in the formula, you should use Find & Replace. That might be easy or difficult, depending on what specific names exist. If you post specific examples, someone may have some suggestions. If you try it on your own, be sure to back up your file in case you change more than you intended to.

[Gret939]

FJCC - Thanx for the suggestion -- will give that a try. With the large number of Names to change and the hundreds of formulas in the sheets, it'll be a bit of a tedious process, but if it works, definitely better than trying to manually locate and update everything!! Thnx again.

[Zizi64]

Do yo meant the "managing Named ranges" feature:

[Villeroy]

Replace John with Carl within formula cells

Options: regular expression=ON, search in formulas (not values)
Search: ^=(.*)\<John\>(.*)
Replace: =$1Carl$2
[Replace All]

The search expression matches a leading = followed by any string or nothing, followed by John within word boundaries (not A_John, not John_B), followed by any string or nothing.
The replace expression inserts a leading =, whatever was matched by the first (.*), Carl, whatever was matched by the second (.*)

Caveat: "John" as (part of) a literal string without quotes will be replaced too.
If John occurs more than once in some formula cells, you have to repeat the replacement until the search string is not found anymore.

[Villeroy]

If the references are absolute ones, you can use the same regular expressions as in my post of 07 Jun 2018, 16:03
replacing "John" in formulas: ^=(.*)\<John\>(.*)
with =$1\$X\$99$2 (if John refers to absolute $X$99)