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


The & concatenates text strings whereas + tries to add them and fails!


On 12 November 2012 04:28, Viral Orpe <viral.orpe@yahoo.com> wrote:

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?
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<http://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

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.