Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.