Ask Your Question
0

How to enter a literal string into a Libre Calc cell?

asked 2020-07-31 20:20:24 +0200

Branko Radovanovic gravatar image

How to enter e.g.

+1/2

...into a cell as a literal string, so that it doesn't get automatically replaced with a formula, but without formatting the cell as text? Normally, one would expect:

'+1/2

...to work (in Excel it does) but in this case it doesn't.

edit retag flag offensive close merge delete

Comments

If the program converts plain +1/2 into a formula, and treats '+1/2 as a string '+1/2, not +1/2, then this is a bug. Program must treat 'somestring as somestring when plain somestring will be treated as special string. Please file it.

Mike Kaganski gravatar imageMike Kaganski ( 2020-08-02 09:32:00 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2020-07-31 22:08:52 +0200

LeroyG gravatar image

If you type '+1/2, you will see '+1/2.

You can type " +1/2" preceding the + with a space (double quotes here are only to show the space), but this will change alignment one space to the right.

Also can use ="+1/2"and will see +1/2 left aligned as text; but this is a formula (double quotes here are mandatory).

Use a text editor, type there +1/2, then copy and paste in the cell. As long as it doesn't start with = it will show as text, while the cell format will remain as number standard. Also can do it with Writer, but will need to choose menu Edit-Paste Special-Paste Unformatted Text (same that Ctrl+Alt+Shift+V).

Edit your question if you want to add more information (Add Answer is reserved for solutions).

Check the mark (Correct answer mark) to the left of the answer that solves your question.

edit flag offensive delete link more
0

answered 2020-07-31 20:30:19 +0200

Opaque gravatar image

updated 2020-07-31 20:34:10 +0200

Hello,

format your cell as text (Format Code: @) before you enter data. This disables input recognition and enter +1/2 directly.

Hope that helps

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-07-31 20:20:24 +0200

Seen: 26 times

Last updated: Jul 31