# How make cells to be calculated?

if the contents of one cell is "2+3" how I can let LOOC calculate it and give me result "5" I know if i enter "=" in the beginning of cell it will calculate that cell, but I have many cells like that, how to solve it?

edit retag close merge delete

Sort by » oldest newest most voted

Hi

You can use Find & Replace to insert automatically the "=" in the relevant cells:

• Select the cells
• EditFind & Replace
• Search For: .*
• Replace With: =&
• Unfold Other options
• Check Current selection only & Regular expressions
• Click Replace All

Explanations: check Regular expressions tells Calc to use .* and & as "codes". The first means "any character", whatever the number. The second means "same thing". So we replace the cell contents, whatever it is, with an equal sign followed by the original content.

Regards

more

What about search all (not Current selection only) with ^[^=].+?

( 2015-12-16 05:09:24 +0200 )edit

@JohnSUN - Well, I suppose that there are cells containing values and texts, which are not to be converted into formulas (#REF)

( 2015-12-16 08:13:46 +0200 )edit

Yes, you're absolutely right, I did not consider this variant. In this case, it could be replaced by =IF(ISREF(&);"&";&). But it will turn the whole sheet in unreadable nonsense...

( 2015-12-16 10:21:30 +0200 )edit