Hi Johnny, May be I should go through Calc documents/ How to use Calc or something similar!
I have used Excel/Calc in a hands on approach - using the drop down menu one gets after clicking the = sign for entering a formula, a generous use of F1, exploring the menus/ icons on tool-bar and of course, Google. So, (now it seems, obviously) I do not know the full capabilities of either software. I may not have needed/ used/ or thought possible many aspects/ functionalities of these applications that are "standard practice" for most users! And, hence the confusion. Got to get back to the basics.... :) Thanks anyways, 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) ************ Processor : Intel (R) Pentium(R) III Memory : 256MB SDRAM (!?), 20GB IDE OS : Vector Linux - Kernel (???) LibreOffice : Yet to try...... ! --------------------------------------------------------------------------------------------------- ________________________________ From: Johnny Rosenberg <[email protected]> To: LibreOffice Användare <[email protected]> Sent: Tuesday, November 13, 2012 10:14 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text 2012/11/13 Viral Orpe <[email protected]>: > 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 <[email protected]> > To: Viral Orpe <[email protected]> > 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 <[email protected]>: >> 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 <[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. >>>> >>> 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 >> > > -- 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
