Re: [libreoffice-users] Showing cell contents as text in calc. (Not evaluating the formula the text represents)

[david_lynch]

 On 12/06/2013 22:44, Steve Edmonds wrote:
Hi.
I want to enter {=MMULT(MINVERSE(A14:R31),S14:S31)} in a cell and to 
display this as the text "{=MMULT(MINVERSE(A14:R31),S14:S31)}" 
(without the "" quotes). Formatting the cell as text doesn't help. I 
thought once you could prepend with a ' to define the characters 
following as left aligned text but not show the '. This does not seem 
to work any more, there must be a simple solution I am missing.
Cheers, steve
If you put {=MMULT(MINVERSE(A14:R31),S14:S31)} in, say, A1. A2 with 
=FORMULA(A1), will display
{=MMULT(MINVERSE(A14:R31),S14:S31)} in A2.

David Lynch

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted