2012/11/13 Viral Orpe <viral.o...@yahoo.com>: > Thanks Johnny, > > Season's Greetings!! > (Today we are celebrating Diwali Festival and New Year here - India) > > I would like to know what is this language used to talk to Calc? > And would appreciate any pointers to any literature, guides etc. > > I know C and have worked with formulas - this combination is new to me.
I am not sure what you are asking. So far in this thread we have only talked about cell formulas, as far as I have seen. Those are the same as those in Excel, at least most of them. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ > > Thanks, > Regards, > Viral Orpe :) > > ________________________________ > From: Johnny Rosenberg <gurus.knu...@gmail.com> > To: Viral Orpe <viral.o...@yahoo.com> > Sent: Monday, November 12, 2012 11:42 PM > > Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with > text > > 2012/11/12 Viral Orpe <viral.o...@yahoo.com>: >> 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? > > =A1 & B1 > is the same as > =CONCATENATE(A1;B1) > > > Kind regards > > Johnny Rosenberg > ジョニー・ローゼンバーグ > > >> 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 <john.cl...@nailsea.net> >> To: Dan Lewis <elderdanle...@gmail.com> >> Cc: "users@global.libreoffice.org" <users@global.libreoffice.org> >> 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 <elderdanle...@gmail.com> 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. >>>> >>> 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: users+help@global.libreoffice.** >>> org <users%2bh...@global.libreoffice.org> >>> 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: users+h...@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 >> -- >> For unsubscribe instructions e-mail to: users+h...@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 >> > > -- For unsubscribe instructions e-mail to: users+h...@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