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

[Viral Orpe]

Thanks Dan,

Link/Guides look good :)

Regards,
Viral Orpe 




 From: Dan Lewis 
To: users@global.libreoffice.org 
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 
> To: LibreOffice Användare 
> 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 :
>> 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 
>> To: Viral Orpe 
>> 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 :
>>> 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 
>>> To: Dan Lewis 
>>> Cc: "users@global.libreoffice.org" 
>>> Sent: Sunday, November 11, 2012 9:59 PM
>>> Subject: Re: [libr

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

[Dan Lewis]

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 
To: LibreOffice Användare 
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 :

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 
To: Viral Orpe 
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 :

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 
To: Dan Lewis 
Cc: "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  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 
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/**
Netique

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

[Viral Orpe]

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 
To: LibreOffice Användare  
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 :
> 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 
> To: Viral Orpe 
> 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 :
>> 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 
>> To: Dan Lewis 
>> Cc: "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  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
>>>

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

[Johnny Rosenberg]

2012/11/13 Viral Orpe :
> 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 
> To: Viral Orpe 
> 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 :
>> 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 
>> To: Dan Lewis 
>> Cc: "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  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 
>>> 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/Netiquet

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

[John Clegg]

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


On 12 November 2012 04:28, Viral Orpe  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 
> *To:* Dan Lewis 
> *Cc:* "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  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 
> > 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
>
>
>
>

-- 
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

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

[Viral Orpe]

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 
To: Dan Lewis  
Cc: "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  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 
> 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
-- 
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

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

[John Clegg]

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  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
>> 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 
> 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+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

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

[Dan Lewis]

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
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+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