Hi.
I am on 3.6.3. I get the effect you describe under "Finally" in your
reply all the time. Possibly this was an over complicated example. A
more simple example would be to have the contents "=C4" (no "") in a
cell as text displaying as =C4 and not equal to the contents of C4.
Steve
On 2013-06-13 12:42, Tim Deaton wrote:
Maybe it's a difference between the different language settings, or
the operating system. I'm using LO Version 3.6.6.2 (Build ID:
f969faf) on Windows 7 64-bit, and my language setting is USA English.
First I copied the formula from below, including the curly brackets,
and pasted it into calc. It behaved as a string, not a formula.
Next, I copied it again, and then changed the S31 to S32. Still
behaved as a string.
Third, I typed the formula in from scratch. Still behaved as a string.
Fourth, I grabbed the handle on the bottom right corner of the cell
and dragged down to copy. Still a string.
But about this time, I noticed that the first two cells had blank
spaces after the end of the entry. the third and forth cells (the one
I had typed from scratch, and the copy made by dragging down from that
one) didn't.
Finally, I clicked into the fourth cell to change S31 to S32. When I
did so, the curly brackets disappeared, the cell references took on
colors, and the lines appeared around the cells included in the
arrays. BUT - when I hit ENTER, the text became a string again,
complete with the curly brackets that had disappeared while I was
editing it.
Maybe if I knew something about the kind of math represented by these
functions, I'd have a better clue. But I know nothing about that
level of math.
-- Tim
===========================
On 6/12/2013 6:07 PM, Steve Edmonds wrote:
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
<[email protected]>:
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: [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
--
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
