The & concatenates text strings whereas + tries to add them and fails!
On 12 November 2012 04:28, Viral Orpe <[email protected]> wrote: > Hi John, > > Checked your reply on list-archives :) > Somehow must have missed on 6th Nov when it first appeared. > > Please, what is the & stand for? > Dave_ had asked the question with a + > > So, I guess this is some standard way of doing things(name?) with slightly > diff syntax. > > I have never known it can be done that way - text and formula together in > a cell. > I have always used adjacent cells - one with the text part and another > with the formula. > > Any pointers would be great. > > Thanks, > Regards, > Viral Orpe :) > --------------------------------------------------------------------------------------------------- > > Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz > Memory : 4GB, DDR3 > OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) > > LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) > > --------------------------------------------------------------------------------------------------- > > ------------------------------ > *From:* John Clegg <[email protected]> > *To:* Dan Lewis <[email protected]> > *Cc:* "[email protected]" <[email protected]> > *Sent:* Sunday, November 11, 2012 9:59 PM > *Subject:* Re: [libreoffice-users] Re: Is it possible to show cell value > with text > > This was a thread from 5th November which I answered to the group. He > thanked me but got fooled by the stupid group reply settings. > > > On 11 November 2012 16:24, Dan Lewis <[email protected]> wrote: > > > On 11/11/2012 11:03 AM, dave_ wrote: > > > >> Thanks for the solution. > >> > >> > >> > >> -- > >> View this message in context: http://nabble.** > >> documentfoundation.org/Is-it-**possible-to-show-cell-value-** > >> with-text-tp4016842p4018036.**html< > http://nabble.documentfoundation.org/Is-it-possible-to-show-cell-value-with-text-tp4016842p4018036.html > > > > >> Sent from the Users mailing list archive at Nabble.com<http://nabble.com/> > . > >> > > How can we give you a solution when you have not yet given us the > > problem? It appears that you are using Calc. But what to you mean by show > > cell value"? Where is the text located? Are you referring to a cell > > containing twenty-seven rather than 27 for example? Or perhaps ten > november > > two thousand twelve instead of 10 Nov 2012 or Nov 10, 2012? > > Please be more specific. > > > > --Dan > > > > -- > > For unsubscribe instructions e-mail to: [email protected].** > > org <users%[email protected]> > > Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** > > unsubscribe/< > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > > Posting guidelines + more: http://wiki.**documentfoundation.org/** > > Netiquette <http://wiki.documentfoundation.org/Netiquette> > > List archive: http://listarchives.**libreoffice.org/global/users/< > http://listarchives.libreoffice.org/global/users/> > > > All messages sent to this list will be publicly archived and cannot be > > deleted > > > > > > -- > For unsubscribe instructions 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 > > > > -- For unsubscribe instructions 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
