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

Thanks for the reply, please click into the cell and change S31 to S32. 
Do the contents change into a formula or stay as text.
Steve
On 2013-06-13 09:59, NickKolok wrote:
>   Greetings from Russia!
>
> I opened LibreOffice Calc (4.0.3) fnd simply copy-pasted the following:
> {=MMULT(MINVERSE(A14:R31),S14:S31)}
>
> into an empty cell on a empty book.
> It is displaying as text, not calculating a formula.What am I d oing wrong?
>
>
> Четверг, 13 июня 2013, 9:44 +12:00 от Steve Edmonds <steve.edmonds@ptglobal.com>:
> > 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
> >
> > --
> > 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


--
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