Ditch the curly braces. They prevent the formula inside from being recognized as a formula.
-----Original Message----- From: Tim Deaton [mailto:[email protected]] 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 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 -- 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
