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

 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+unsubscribe@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