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 <gurus.knu...@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.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