[libreoffice-users] Re: Is it possible to show cell value with text
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
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
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.**htmlhttp://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
[libreoffice-users] How to movea sum of all worksheet in one summary to a new spreadsheet
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] 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
Re: [libreoffice-users] Auto changes on a new spreadsheet set for next year
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
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 rcr...@yahoo.com 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-lists/how-to-unsubscribe/ Posting guidelines + more:
Re: [libreoffice-users] Macro Problem: Extending a Chart's X-axis
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 drjle...@aol.com 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
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 fobe...@enteract.com 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
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.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.**htmlhttp://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 -- 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]
-- 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
The concatenates text strings whereas + tries to add them and fails! On 12 November 2012 04:28, Viral Orpe viral.o...@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.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.comhttp://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 -- 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
