Ask Your Question
0

How make cells to be calculated?

asked 2015-12-15 10:35:18 +0200

lhodeniz gravatar image

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 flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2015-12-15 19:18:26 +0200

pierre-yves samyn gravatar image

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

edit flag offensive delete link more

Comments

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

JohnSUN gravatar imageJohnSUN ( 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)

pierre-yves samyn gravatar imagepierre-yves samyn ( 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...

JohnSUN gravatar imageJohnSUN ( 2015-12-16 10:21:30 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-12-15 10:35:18 +0200

Seen: 47 times

Last updated: Dec 15 '15