Ask Your Question

How make cells to be calculated? [closed]

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

lhodeniz gravatar image

updated 2020-08-07 03:27:52 +0100

Alex Kemp 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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-07 03:28:13.825030

1 Answer

Sort by » oldest newest most voted

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

pierre-yves samyn gravatar image


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.


edit flag offensive delete link more


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

JohnSUN gravatar imageJohnSUN ( 2015-12-16 05:09:24 +0100 )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 +0100 )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 +0100 )edit

Question Tools

1 follower


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

Seen: 66 times

Last updated: Dec 15 '15