Is there a way to copy literal formulas?

[DanaTheSane]

I have a calc spreadsheet dozens of formulae that are all slightly different (column offsets, locking, etc), but I’d like to make a similar change to all of them (without clicking through each one and copying down).

Is there a way to copy the literal formulas to a text editor so I can use search and replace or a script to rewrite all of the formulas, then paste them back in to the a sheet?

[erAck]

You can use Find&Replace in Calc, which also finds and replaces text in cell formulas, even supporting search with regular expressions.