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

2012-11-11 Thread dave_ 
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.

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

2012-11-11 Thread 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

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

2012-11-11 Thread 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

[libreoffice-users] How to movea sum of all worksheet in one summary to a new spreadsheet

2012-11-11 Thread dave_ 
I have to keep a "log" on my results with a summary weekly final results.

My worksheet has seven tabs (Monday - Sunday), I need a final 'weekly'
summary on two results in my 'daily' log.
Here what I have:
(cell c4 is my daily total for failures and c8 is my shipping totals for all
days).

For example on Mondays worksheet in cell d5 I have "total failures =" and d6
I have "units shipped =" 
in e5 I have the following:
=sum(c4+Tuesday.c4+Wednesday.c4+Thursday.c4+Friday.c4+Saturday.c4+Sunday.c4)
in e6 I have the following:
=sum(c8+Tuesday.c8+Wednesday.c8+Thursday.c8+Friday.c8+Saturday.c8+Sunday.c8)

My problem is:
On Monday I create a new weekly log that carries over the last work day (for
example, copy Friday log to the new week on Monday). There is other data
that is running all the time, so the last work day is carried to the next
week.

When I try to copy the values in e5 and e6 to the  new week I get a "ref"
error, if I rewrite it manually it works.

My question is how can I copy e5 and e6 correctly to the new weekly
worksheet?

I hope this is clear and thanks ahead for any help or suggestions.






--
View this message in context: 
http://nabble.documentfoundation.org/How-to-movea-sum-of-all-worksheet-in-one-summary-to-a-new-spreadsheet-tp4018041.html
Sent from the Users mailing list archive at Nabble.com.

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

[libreoffice-users] Book Preview button in Print Preview Screen

2012-11-11 Thread CVAlkan 
Just for the record: I'm using Writer 3.6.1.2 on Ubuntu 12.04, but I don't
think either makes a difference.

When using "2-up," the Print Preview screen defaults to showing the first
page on the left. There is a button called "Book Preview" (just left of the
(+) magnifier button) that permits the display to show the odd-numbered
pages on the left, as in a printed book or other material. This is, of
course, quite useful for reviewing layouts more realistically.

Since that is what I'm creating, I would like to set the "Book Preview" as
the default for the "Print Preview" display (yes, I acknowledge my laziness,
but isn't the fact that I use a word processor instead of a typewriter
sufficient proof of that?); it would be even cooler if that display choice
could be set on a per-document basis as well, but I don't want to be too
greedy.

I've searched around, but haven't run across anything that would allow me to
do that. Does anyone know if such a setting exists and, if so, how to set
it?

Otherwise, I guess I'll just toss it in at the bottom of the massive list of
requested enhancements.

Thanks.




--
View this message in context: 
http://nabble.documentfoundation.org/Book-Preview-button-in-Print-Preview-Screen-tp4018042.html
Sent from the Users mailing list archive at Nabble.com.

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

[libreoffice-users] Macro Problem: Extending a Chart's X-axis

2012-11-11 Thread Jonathan Levi 

I don't know if this is the right list to query, but I'm having trouble writing 
a simple Basic macro to extend a chart's X-axis. The bottom of the chart starts 
off looking like this:

|   |
|---|
1   2   3   4

My macro is:

Sub Main
Dim Doc As Object 
Dim Charts As Object 
Dim Chart as Object 
Doc = ThisComponent
Charts = Doc.Sheets(0).Charts 
Chart = Charts.getByIndex(0).EmbeddedObject
Chart.Diagram.XAxis.Max = Chart.Diagram.XAxis.Max + 4
End Sub

and in the end, I want the bottom of the chart to be:

| |
|-|
1 2 3 4 5 6 7 8

Instead, I get

|   |
|---|
1234

I'm sure the problem has something to do with the fact that the Format > Data 
Ranges... menu item's content remains unchanged, i.e., stays

$Sheet1.$A$1:$A$5

instead of changing to

$Sheet1.$A$1:$A$9

which gives the chart the appearance I want. Any ideas re modules, services, 
methods to get/set the chart's data range? TIA,

Jonathan




 

-- 
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] How to move a sum of all worksheet in one summary to a new spreadsheet

2012-11-11 Thread Brian Barker 

At 08:37 11/11/2012 -0800, Dave Wagner wrote:

[...]
in e5 I have the following:
=sum(c4+Tuesday.c4+Wednesday.c4+Thursday.c4+Friday.c4+Saturday.c4+Sunday.c4)
in e6 I have the following:
=sum(c8+Tuesday.c8+Wednesday.c8+Thursday.c8+Friday.c8+Saturday.c8+Sunday.c8)

My problem is: On Monday I create a new weekly log that carries over 
the last work day (for example, copy Friday log to the new week on 
Monday). There is other data that is running all the time, so the 
last work day is carried to the next week.  When I try to copy the 
values in e5 and e6 to the  new week I get a "ref" error, if I 
rewrite it manually it works.


What you have in E5 and E6 are formulae, not values as such.  When 
you copy these, the formulae - not just the values - are copied over 
by default, and the cell references are modified in the usual 
way.  If you see #REF errors, this is because the adjusted cell 
references now address cells which do not exist or are 
inaccessible.  (It's not quite clear to me whether you are copying 
into another part of the same sheet or a new sheet in the same 
document or even a new document.  But it doesn't really matter: the 
problem is the same in any case.)



My question is how can I copy e5 and e6 correctly to the new weekly worksheet?


As you suggest, you need to paste the values in E5 and E6 into the 
target cells, not the formulae which generate these values.  When you 
paste, use Edit | Paste Special... (or Ctrl+Shift+V) instead of 
ordinary Paste.  In the Paste Special dialogue, untick "Paste all" if 
necessary, and then ensure that Numbers is ticked but Formulas is *not* ticked.



I hope this is clear ...


Yup.

I trust this helps.

Brian Barker


--
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] Auto changes on a new spreadsheet set for next year

2012-11-11 Thread Paul Stear 
Brian,
Thank you so much, I have been away so have not tried your solution yet but it 
does look good.
I will test this in the morning, this could save me hours of work
Thank again
Paul

On Thursday 08 Nov 2012 14:19:22 Brian Barker wrote:
> At 11:45 08/11/2012 +, Paul Stear wrote:
> >I have the same spreadsheet set I use each year.  The new
> >spreadsheet for 2013 will need to reference fields in the 2012
> >spreadsheet.  For the past few years I have manually changed the
> >Readings-2012 in every instance (well over 100).
> >
> >I would like to be able to construct the spreadsheets with a method
> >to change the current year, eg 2013 minus 1 to give 2012 inserted so
> >that the ref in the 2013 spreadsheet reads;-
> >='file:///home/fred/Generation Readings-2012.ods'#$Jan.A68
> >
> >Is this possible?
> 
> Yes.  You need to concatenate the required year value with the
> strings required before and after it.  Suppose that you have the
> current year - 2013 in your example - in A1 of your new
> spreadsheet.  You need to concatenate "'file:///home/fred/Generation
> Readings-" with A1-1 and ".ods'#$Jan.A68".  Note that the two single
> quotes are part of the string you are creating and the four double
> quotes delimit the two text strings, so the first string has a single
> quote immediately following its opening double quote.  You can carry
> out this concatenation using the & operator:
> ="'file:///home/fred/Generation Readings-"&A1-1&".ods'#$Jan.A68"
> (The numerical expression A1-1 is converted to a string value
> automatically.)
> 
> You might expect this to work, but it doesn't.  The formula above
> results in a text string which is interpreted literally and not as a
> cell reference to the other spreadsheet file.  But the trick you need
> is available in the INDIRECT() function, which provides the necessary
> conversion.  So the formula which works is
> =INDIRECT("'file:///home/fred/Generation Readings-"&A1-1&".ods'#$Jan.A68")
> 
> I trust this helps.
> 
> Brian Barker
-- 
mail sent using kmail and kubuntu
-- 
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] Zotero field codes no longer show up after update...linux

2012-11-11 Thread Tom Davies 
Hi :)
The codes still being in the contents.xml sounds like good news.  It sounds as 
though the data is there and just needs to be accessed.  



First thing in any data-recovery  scenarios is to make a copy of the file on a 
different drive/partition to the one affected and then work on the copy rather 
than the original.  In most cases you would also need to avoid doing any 
read/writes to/from the affected drive.  


However, in this case i think it's quite different.  It sounds as though the 
data is there but it's just not being accessed.  The questions are simply 

1.  why not 

2.   how do we fix it.

Obviously the 2nd question is the most important one.  

I would still work from a new copy of the file instead of the original, if 
possible.  Just in case something goes badly wrong while trying to fix it.  


Have you tried renaming your User Profile?  It's often a quick fix for all 
sorts of weird behaviours as it blocks LO from using all the assorted 
Extensions you might have installed and also gets all settings and 
configurations "back to factory defaults".  Since you are only renaming the 
profile you can copy chunks back to regain the settings and Extensions.  

http://wiki.documentfoundation.org/Documentation/UserProfile

I think i would try that first and then try re-installing the Zotero 
Extension.  I might have tried re-installing the Zotero Extension first, got 
nowhere, and then tried the User Profile and another reinstall of the 
Extension.  


I think the next thing i would try is re-installing the older version of LO but 
use the appropriate one from the official LO website.  I would probably install 
in parallel
http://wiki.documentfoundation.org/Installing_in_parallel
Again this type of reinstall (like renaming the User Profile) would be "back at 
factory defaults" so you would need to reinstall the Zotero Extension for this 
version of LO too.  


Normally when you upgrade or just do a fresh install of LO it picks up your 
previous User Profile but the instructions in the "Installing in Parallel" wiki 
hopefully set-up a new location for the 2nd version's User Profile.  


Regards from
Tom :)  






>
> From: rcrath 
>To: users@global.libreoffice.org 
>Sent: Sunday, 11 November 2012, 0:47
>Subject: [libreoffice-users] Zotero field codes no longer show up after 
>update...linux
> 
>Running Linux Mint LMDE, libreoffice 3.5.4-6.   upon updating system, which I
>think updated libreoffice too, the fields for zotero no longer show in the
>document.  If I unzip the document and look at content.xml, the codes are
>there, but they do not show in openoffice.  I can however add new citations
>from zotero no prob, it just does not recognize what I already nhave done. 
>As far as I can tell, I have the same prob in the windows version 3.6.2.2.
>
>I have thousands of hours of work invested here, and it would take thousands
>of hours to renter all the footnotes, so this is a huge problem for me.  Has
>this happened to anyone else?
>
>Steps to reproduce:
>1. update using apt-get upgrade
>2. open a document with zotero citations in it. citations should show in
>gray but they do not, they show as normal text in both footnotes and
>parenthetical cites.
>3. can add new citations to a document, but the old ones will no longer be
>seen and do not update: no connection to zotero except for newly entered
>citations.  
>4. unzip odt file and view content.xml.  code for old citations appears in
>the document.  
>5. open in a linux box that has not recently been updated and the citations
>reappear.  update that computer and repeat.  
>6. ask for help at zotero forums, get told it is a problem with libreoffice
>"by definition" since it is the field codes not showing. 
>7. Checked it on several computers in several locations and once updated
>they no longer connect to the zotero database properly.
>The update for the laptop I am using now was from (1:3.5.3-0ubuntu1) to
>1:3.5.4-0ubuntu1.1 in Linux mint 13 (maya/precise), but the same thing
>happened running Linux Mint debian (tracks testing) on both a 32 and a 64
>bit machine.  
>
>Current behavior:
>zotero fields not showing up in gray or connecting to zotero dbase, only new
>citations recognized and in gray
>
>Expected behavior:
>previous as well as new zotero citations and bibliographies highlighted in
>gray and connected to zotero database
>
>plz help, as this affects two books and many articles and thousands of hours
>of work!
>
>Platform (if different from the browser): 
>Linux mint 12 (same problem on Linux Mint debian, which tracks a modified
>version of debian testing.)  
>
>
>
>
>--
>View this message in context: 
>http://nabble.documentfoundation.org/Zotero-field-codes-no-longer-show-up-after-update-linux-tp4017984.html
>Sent from the Users mailing list archive at Nabble.com.
>
>-- 
>For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>Problems? http://www.libreoffice.org/get-help/mailing-lis

Re: [libreoffice-users] Macro Problem: Extending a Chart's X-axis

2012-11-11 Thread Tom Davies 
Hi :)
Could you cheat?  Could the data-range that gives you 1, 2, 3, 4 be extended 
and then edit the chart to pick-up the additional values?  I don't think you 
would need corresponding Y values.  Hopefully avoiding needing a macro might 
simplify things.  
Regards from
Tom :) 





>
> From: Jonathan Levi 
>To: users@global.libreoffice.org 
>Sent: Sunday, 11 November 2012, 17:54
>Subject: [libreoffice-users] Macro Problem: Extending a Chart's X-axis
> 
>
>I don't know if this is the right list to query, but I'm having trouble 
>writing a simple Basic macro to extend a chart's X-axis. The bottom of the 
>chart starts off looking like this:
>
>|           |
>|---|
>1   2   3   4
>
>My macro is:
>
>Sub Main
>Dim Doc As Object 
>Dim Charts As Object 
>Dim Chart as Object 
>Doc = ThisComponent
>Charts = Doc.Sheets(0).Charts 
>Chart = Charts.getByIndex(0).EmbeddedObject
>Chart.Diagram.XAxis.Max = Chart.Diagram.XAxis.Max + 4
>End Sub
>
>and in the end, I want the bottom of the chart to be:
>
>|             |
>|-|
>1 2 3 4 5 6 7 8
>
>Instead, I get
>
>|           |
>|---|
>1234
>
>I'm sure the problem has something to do with the fact that the Format > Data 
>Ranges... menu item's content remains unchanged, i.e., stays
>
>$Sheet1.$A$1:$A$5
>
>instead of changing to
>
>$Sheet1.$A$1:$A$9
>
>which gives the chart the appearance I want. Any ideas re modules, services, 
>methods to get/set the chart's data range? TIA,
>
>Jonathan
>
>
>
>
>
>
>-- 
>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] Book Preview button in Print Preview Screen

2012-11-11 Thread Tom Davies 
Hi :)
The list of enhancement requests is not like a waiting list or a queue.  It's 
more like a pool.  People pluck out things they like the look of and have a 
go.  Different people have different reasons for liking the look of something.  
Some people are looking for "Easy Hacks" while others are ready for more of a 
challenge and that's just 1 aspect.  So, it might be a good plan to 1st post 
the enhancement request and then look around for work-arounds.  

Have you considered 'printing' to file and set the format to PDF?  That might 
give a result that you can hang onto and look through at leisure rather than 
having to get through it all in one go.  
Regards from
Tom :)  






>
> From: CVAlkan 
>To: users@global.libreoffice.org 
>Sent: Sunday, 11 November 2012, 17:14
>Subject: [libreoffice-users] Book Preview button in Print Preview Screen
> 
>Just for the record: I'm using Writer 3.6.1.2 on Ubuntu 12.04, but I don't
>think either makes a difference.
>
>When using "2-up," the Print Preview screen defaults to showing the first
>page on the left. There is a button called "Book Preview" (just left of the
>(+) magnifier button) that permits the display to show the odd-numbered
>pages on the left, as in a printed book or other material. This is, of
>course, quite useful for reviewing layouts more realistically.
>
>Since that is what I'm creating, I would like to set the "Book Preview" as
>the default for the "Print Preview" display (yes, I acknowledge my laziness,
>but isn't the fact that I use a word processor instead of a typewriter
>sufficient proof of that?); it would be even cooler if that display choice
>could be set on a per-document basis as well, but I don't want to be too
>greedy.
>
>I've searched around, but haven't run across anything that would allow me to
>do that. Does anyone know if such a setting exists and, if so, how to set
>it?
>
>Otherwise, I guess I'll just toss it in at the bottom of the massive list of
>requested enhancements.
>
>Thanks.
>
>
>
>
>--
>View this message in context: 
>http://nabble.documentfoundation.org/Book-Preview-button-in-Print-Preview-Screen-tp4018042.html
>Sent from the Users mailing list archive at Nabble.com.
>
>-- 
>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

2012-11-11 Thread 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
>> 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
-- 
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

[libreoffice-users]

2012-11-11 Thread satenderkumar 



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

2012-11-11 Thread 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
> .
> >>
> >  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 
> > 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