At 09:44 13/06/2013 +1200, 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.
I think you can type this - complete with the braces - and have it
appear as a text string and not be interpreted as a formula, in
fact. If you wanted it to be an array formula, you would need not to
enter the braces but to use Ctrl+Shift+Enter (instead of simple
Enter) to complete the entry; the braces are then added automatically
to the display you see in the Input Line (as well as in the cell if
you have the display of formulae selected). You probably know that.
At 10:07 13/06/2013 +1200, Steve Edmonds wrote:
... please click into the cell and change S31 to S32. Do the
contents change into a formula or stay as text.
That is indeed where you appear to have a problem: editing the text
string makes Calc reinterpret it as an array formula, which is what
you are trying to prevent.
At 09:44 13/06/2013 +1200, Steve Edmonds wrote:
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.
Yes, this does generally work, but I think there may be one of two
problems here. It does seem that if you enter what would be a
formula but prefix it with the apostrophe, the string remains text
and not interpreted as a formula, but the apostrophe remains
displayed. I don't know why this should be, but it clearly gets in your way.
Another point worth mentioning is that if you have Custom Quotes
selected in AutoCorrect Options, then the apostrophe will be
instantly converted to an opening single quote mark and will continue
to display. To avoid this whilst retaining custom quotes, use Edit |
Undo (or Ctrl+Z) immediately after typing the apostrophe to undo the
automatic correction. Oh, but if you have existing leading custom
quotes in the same column, you will see automatic suggestions and
will need to Undo twice.
So how to do what you require? Here are some workarounds:
o Enter a space before the text. This will fool Calc!
o Enter the formula =T("{=MMULT(MINVERSE(A14:R31),S14:S31)}") instead.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: [email protected]
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
