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

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.
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 (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.
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 wrong?

Четверг, 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 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:
Problems? 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.