Ask Your Question

0

How to hide the escape character before equal sign?

asked 2012-09-14 14:51:07 +0200

gb38
1 ● 1

updated 2013-02-23 01:05:44 +0200

flag of United States

5816 ● 3 ● 50 ● 43

I want to show the contents of a formula. From the LibreOffice wiki:

Telling libreoffice calc that a formula is meant to be text:

If you want to fill a spreadsheet cell with text that looks like a formula, libreoffice can be hindered from evaluating this formula by preceeding this formula by a single quotation mark (').

If I do this, the escape character (=the single quote sign) stays visible. When protecting a number link in ('2012) the escape character is not visible. I expected the same for the equal sign, but it stays visible. Is this a bug?

delete close flag offensive retag edit

2 Answers

Sort by » oldest newest most voted

1

answered 2012-09-14 16:50:16 +0200

flag of Ukraine

2373 ● 2 ● 23 ● 37
http://wmstrong.ru/

You can switch the display mode (formulas or values)

You can also use the function FORMULA

link delete flag offensive edit

Comments

Testing the 'display mode', the equals sign stays visible (and Array Formulae displayed "###" instead of the actual formula)

Testing the function FORMULA, the equals sign was also displayed (and Array Formulae were correctly displayed)

qubit ( 2013-02-23 01:12:04 +0200 )edit

0

answered 2013-04-08 11:38:56 +0200

galou
1 ● 1

updated 2013-04-08 11:39:47 +0200

You can use the T function. '=T("=A1")' will show as "=A1".

link delete flag offensive edit

Resources

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Stats

Asked: 2012-09-14 14:51:07 +0200

Seen: 259 times

Last updated: Apr 08

Related questions

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.

Powered by Askbot version 0.7.43