At 11:32 13/06/2013 +0100, David Lynch wrote:
On 12/06/2013 22:44, Steve Edmonds wrote:
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.
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.
If you put that text into A1, I don't think that is true. The text
itself is not a formula, so the result of the FORMULA() reference is
#N/A. But yes: if you enter that into A1 *as an array formula*
(without typing the braces and using Ctrl+Shift+Enter), that is
indeed what happens. Then you have to remember, when you edit what
is in A1 (as the questioner required), to use Ctrl+Shift+Enter
instead of simple Enter each time to confirm the edit.
Brian Barker
--
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