Ask Your Question

Is there a way to copy literal formulas?

asked 2016-11-15 18:09:56 +0200

DanaTheSane gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-11-15 18:48:03 +0200

erAck gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-11-15 18:09:56 +0200

Seen: 49 times

Last updated: Nov 15 '16