Re: [libreoffice-users] Re: Is it possible to show cell value with text

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 <gurus.knugum@gmail.com>
To: LibreOffice Användare <users@global.libreoffice.org> 
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 <viral.orpe@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.knugum@gmail.com>
> To: Viral Orpe <viral.orpe@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.orpe@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.clegg@nailsea.net>
> > To: Dan Lewis <elderdanlewis@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 <elderdanlewis@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%2Bhelp@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+help@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+help@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+help@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+help@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