Error or incorrect search parameters
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
veb86 · 2025-02-04 08:21

I am trying to replace text in the entire sheet. The text is replaced
in regular cells, the text specified in the formulas does not change.
Is it possible to replace text inside the formulas?

----------------------------------------------------------------------
wp · 2025-02-04 12:22

No, search does not go into the formulas. If you want to rename a
worksheet set its Name, and all formulas referring to this sheet are
updated.

----------------------------------------------------------------------
veb86 · 2025-02-04 13:08

Quote from: wp on February 04, 2025, 01:22:52 pmNo, search does not go
into the formulas.
I'm rewriting part of the code and I have another solution, but I
wanted to make it look nice)))

Quote from: wp on February 04, 2025, 01:22:52 pmIf you want to rename
a worksheet set its Name, and all formulas referring to this sheet are
updated.
This option is not suitable for my task.