On 12/06/2013 22:44, Steve Edmonds wrote:
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
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
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
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:
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
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
Ditch the curly braces. They prevent the formula inside from being recognized
as a formula.
-Original Message-
From: Tim Deaton [mailto:t...@timdeaton.org]
Sent: Wednesday, June 12, 2013 05:42 PM
To: Steve Edmonds
Cc: NickKolok; LibreOffice
Subject: Re: [libreoffice-users] Showing
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.
Steve
On 2013-06-13 14:50, Dennis E. Hamilton wrote:
Ditch the curly braces. They prevent the formula inside from being
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
The single-' works in front of numerals.
Sometimes it works in front of a formula and sometimes it doesn't. Typing a
space before the = or the {= seems to work consistently instead. Good idea.
I just checked in LibO 4.0.1.2 on Windows XP SP3.
-Original Message-
From: Brian Barker
10 matches
Mail list logo