Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

The thing is that I don't want it recognised as a formula. I want to enter that text as an example or say =C4 as another example and not have it recognised as a formula.
On 2013-06-13 14:50, Dennis E. Hamilton wrote:
Ditch the curly braces.  They prevent the formula inside from being recognized as a formula.

-----Original Message-----
From: Tim Deaton []
Sent: Wednesday, June 12, 2013 05:42 PM
To: Steve Edmonds
Cc: NickKolok; LibreOffice
Subject: Re: [libreoffice-users] Showing cell contents as text in calc. (Not evaluating the formula 
the text represents)

Maybe it's a difference between the different language settings, or the
operating system.  I'm using LO Version (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)

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.
On 2013-06-13 09:59, NickKolok wrote:
   Greetings from Russia!

I opened LibreOffice Calc (4.0.3) fnd simply copy-pasted the following:

into an empty cell on a empty book.
It is displaying as text, not calculating a formula.What am I d oing

Четверг, 13 июня 2013, 9:44 +12:00 от Steve Edmonds
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
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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot
be deleted

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.