Ask Your Question

Cells and Text Interpretation [closed]

asked 2012-07-27 09:41:55 +0200

lordjules gravatar image

updated 2012-08-12 13:16:00 +0200

tohuwawohu gravatar image

I am trying to insert a table into libre-office writer and then put an = sign in one of the cells. I need the cell to interpret the = sign as text rather than an operand. How can I do this?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 03:59:14.131648

3 Answers

Sort by » oldest newest most voted

answered 2012-07-28 09:32:37 +0200

manj_k gravatar image

updated 2012-07-28 09:48:24 +0200

Menu ToolsAutoCorrect Options...Replace

Replace: #=
With: =

☑ Text only → New → OK

Menu FormatAutoCorrect☑ While Typing
Type: #= <space>

image description

edit flag offensive delete link more

answered 2012-07-27 22:43:05 +0200

m.a.riosv gravatar image

Maybe there is some trick, but I can't find it.

But putting one space before =. Then if it is only one, deleted the space. If there are several cells use Find/Replace, Ctrl+H.

edit flag offensive delete link more

answered 2012-07-28 02:02:51 +0200

w_whalley gravatar image

Left-click in the cell and hold down the button while you drag to an adjacent cell, then back to the target cell so that the cell is highlighted. Then you can enter an equal sign without triggering the formula box.

edit flag offensive delete link more

Question Tools


Asked: 2012-07-27 09:41:55 +0200

Seen: 727 times

Last updated: Jul 28 '12