Thanks Dan, Link/Guides look good :)
Regards, Viral Orpe ________________________________ From: Dan Lewis <[email protected]> To: [email protected] Sent: Wednesday, November 14, 2012 8:29 AM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text http://wiki.documentfoundation.org/Documentation/Publications Download the Calc Guide from this link. It may help. --Dan On 11/13/2012 08:06 PM, Viral Orpe wrote: > 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
