Protect All Formulas

[Mxbutterfield]

Hi everyone,

I want to protect all cells containing a formula. In excel I used the following:

1. Highlight all cells
2. Format, unprotect
3. Go To function, select formulas (highlights all cells containing formulas, not data or empty)
4. Format, protect
5. Protect sheet

Is there an easy way to do this in calc?

[Lupp]

Easy? Depends.

If there are no cells preset to accept strings only (under Format Cells...>Numbers>Format code>@) and containing something starting with the character = (correction thanks to JohnSun: or the pair of characters {= } , you find cells containing a formula with the help of >Edit>Find & Replace.

Enable Regular expressions.
Enter ^= behind Find: Correction: Edit ^\{?= behind Find:
Select Formulae behind Search in:
Click Find All
All the cells containing formulae are now selected, but the mode of selection is non-standard. Therefore you need to:
Ctrl+Click on one of the found cells twice.
Rightclick on that cell now to open the context menu.
Select the menu item Format Cells... and make the settings you want.

See this example. So easy!

If there are texts … containing = as the first character … : Edit your question and append this specific requirement.

[JohnSUN]

Perhaps string for Find must be ^[=|\{]?

[Lupp]

Thanks for reminding me of array-formulae.
I will edit my answer and replace the excample.

[JohnSUN]

Yes, this easy way present