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.edmo...@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+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
--
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
