Re: [libreoffice-users] Showing cell contents as text in calc. (Not evaluating the formula the text represents)

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 
> > > <steve.edmonds@ptglobal.com>:
> > > > 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: users+unsubscribe@global.libreoffice.org
> > > > 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: users+unsubscribe@global.libreoffice.org
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