Re: [libreoffice-users] Sorting Rows: Merged Cells Error
Hi :) When you find and select the merged cells i think that option changes from "Merge cells" to "unmerge cells". Any chance of uploading the file to Nabble? If it's confidential then don't as this is a public mailing-list. Regards from Tom :) --- On Fri, 3/2/12, Rich Shepard wrote: From: Rich Shepard Subject: [libreoffice-users] Sorting Rows: Merged Cells Error To: users@global.libreoffice.org Date: Friday, 3 February, 2012, 23:58 I have a spreadsheet sent by a client as .xlsx and saved by me as .ods. When I try to sort the rows on one tab I am prevented from doing so by this error message: "Ranges containing merged cells can only be sorted without formats." How do I identify what cells have been merged? I see none. And, once identified do I unmerge them by putting the cursor in one of the cells and selecting Edit -> Merge cells? Rich -- 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] [PDF instead of Postscript - Printing] Re: Problem printing an .xls file
On 02/03/2012 09:30 AM, Maurice Batey wrote: > On Fri, 27 Jan 2012 17:25:00 +, I wrote: > >> Before I raise this in a Bug report > > See: https://bugs.freedesktop.org/show_bug.cgi?id=45340 > > A workaround has been found by 'TJ' in the Mandriva newsgroup: > >When in LO's 'print file', go in to Printer Settings and change > 'PDF' to 'Postscript' (any level). > > (Unfortunately the change does not stick, unless the document is > changed and Saved.) > > The reason why OpenOffice is able to print the file perfectly is that > it already uses Postscript in the output. > For background to that, see: > > https://issues.apache.org/ooo/show_bug.cgi?id=94173 > > where the proposed change from Postscript to PDF (to solve *other* > problems) did not make it into OpenOffice before it ws handed over to > Apache, whereas they *did* make it into LO! > Actually they did indeed make it to OOo-dev 3.4.0 DEV300m106 (Build:9582) as that build has the same issue as LO. That said... I wouldn't shoot the messenger in the case of 94173; Till Kamppeter pretty much rocks IMO & if he's aware of the situation you can pretty much bet that he'll work with you to resolve. I suspect that your issue is the same as John Jason Jordan's issue ("Printer always selects "PDF" instead of Postscript" thread). A possible workaround: Open spadmin (printer administration) & select the printer 'Properties|Device|Printer Language type: PostScript Level 2. Close spadmin & open LO (3.3.x or 3.4.x) and you should be ok for that printer. You can check by closing & reopening LO & 'File|Printer Settings||Properties|Device|'. - In LibreOffice 3.3.4 you should see 'from device driver'. - In LibreOffice 3.5.0rc2 you should see 'PostScript Level 2'. Again, it's a possible workaround & certainly not a fix. But give it a try & see if it works for you. -- 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] Sorting Rows: Merged Cells Error
I have a spreadsheet sent by a client as .xlsx and saved by me as .ods. When I try to sort the rows on one tab I am prevented from doing so by this error message: "Ranges containing merged cells can only be sorted without formats." How do I identify what cells have been merged? I see none. And, once identified do I unmerge them by putting the cursor in one of the cells and selecting Edit -> Merge cells? Rich -- 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] Problem pasting spreadsheet cells into Impress
Hi, Tanstaafl wrote (31-01-12 12:42) On 2012-01-30 3:36 PM, Cor Nouws wrote: I tried in 3.4.5 and it works there fine too. Ctrl-V creates a nice Impress-table with the content that I copy from Calc. But... we don't want to convert the copied cells into an Impress Table when pasting them, [...] Hmm. I then I was mislead by (one of) your first post(s) in this thread: Tanstaafl wrote (13-01-12 22:17) Whenever I try to copy some cells from a spreadsheet and paste the into an Impress Presentation Libreoffice (and Openoffice used to do the same thing) totally locks up goes into never-never land, and I have to kill it. Sorry about that, -- - Cor - http://nl.libreoffice.org -- 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] Renaming Tabs in a spreadsheet in bulk.
Hi Drew :) Thanks for that. Some of it even makes sense to me. It looks completely different from the excel one. A fresh re-write rather than a translation. I'm hoping that a few more of these real-world examples will help me make sense of the various guides on macros someday. Thanks and regards from Tom :) --- On Fri, 3/2/12, drew wrote: From: drew Subject: Re: [libreoffice-users] Renaming Tabs in a spreadsheet in bulk. To: users@global.libreoffice.org Date: Friday, 3 February, 2012, 22:14 On Fri, 2012-02-03 at 16:06 +, Gordon Burgess-Parker wrote: > On 03/02/2012 15:50, Tom Davies wrote: > > Hi :) > > Have you opened the ods as an archived-file / zip-file? Are the tab-labels > > in the contents.xml in there? > > Regards from > > Tom :) > > > > > > > > I tried adding this Macro: > > Sub Rename_Tabs() > Dim x As Long, suffix As String > Dim v as Variant > suffix = " 12" > v = Split("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",") > *For x = 1 To Worksheets.Count* > If Not IsError(Application.Match(Left(Sheets(x).Name, 3), v, 0)) Then > Sheets(x).Name = Left(Sheets(x).Name, 3) & suffix > End If > Next > End Sub Ok - well, here is a quick replacement, should do the trick for you Sub Rename_Tabs() Dim x As Long, suffix As String Dim v as Variant Dim CurrentFile as object Dim WorkSheets as Variant ' LibreOffice ships with a collection of useful macros in a libary ' TOOLS which must be loaded explicity BasicLibraries.loadLibrary("Tools") suffix = " 12" v = Split("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",") CurrentFile = thisComponent ' thisComponent is a pseudo variable that always returns the current ' document on your desktop ' from here on out it should be fairy clear ' WorkSheets = CurrentFile.getSheets For x = 0 To Worksheets.Count -1 ' the IndexinArry function in 'tools' is similar to MATCH in VBA If IndexinArray(Left(WorkSheets(x).Name, 3), v) <> -1 Then WorkSheets(x).Name = Left(WorkSheets(x).Name, 3) & suffix End If Next End Sub Best of luck, //drew > > But it fell over on the bolded portion. I'm not a macro person and this > was copied from one in Excel that worked OK. > Anyone tell me what I need to replace the bolded bit with? > -- 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] Renaming Tabs in a spreadsheet in bulk.
On Fri, 2012-02-03 at 16:06 +, Gordon Burgess-Parker wrote: > On 03/02/2012 15:50, Tom Davies wrote: > > Hi :) > > Have you opened the ods as an archived-file / zip-file? Are the tab-labels > > in the contents.xml in there? > > Regards from > > Tom :) > > > > > > > > I tried adding this Macro: > > Sub Rename_Tabs() > Dim x As Long, suffix As String > Dim v as Variant > suffix = " 12" > v = Split("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",") > *For x = 1 To Worksheets.Count* > If Not IsError(Application.Match(Left(Sheets(x).Name, 3), v, 0)) Then > Sheets(x).Name = Left(Sheets(x).Name, 3) & suffix > End If > Next > End Sub Ok - well, here is a quick replacement, should do the trick for you Sub Rename_Tabs() Dim x As Long, suffix As String Dim v as Variant Dim CurrentFile as object Dim WorkSheets as Variant ' LibreOffice ships with a collection of useful macros in a libary ' TOOLS which must be loaded explicity BasicLibraries.loadLibrary("Tools") suffix = " 12" v = Split("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",") CurrentFile = thisComponent ' thisComponent is a pseudo variable that always returns the current ' document on your desktop ' from here on out it should be fairy clear ' WorkSheets = CurrentFile.getSheets For x = 0 To Worksheets.Count -1 ' the IndexinArry function in 'tools' is similar to MATCH in VBA If IndexinArray(Left(WorkSheets(x).Name, 3), v) <> -1 Then WorkSheets(x).Name = Left(WorkSheets(x).Name, 3) & suffix End If Next End Sub Best of luck, //drew > > But it fell over on the bolded portion. I'm not a macro person and this > was copied from one in Excel that worked OK. > Anyone tell me what I need to replace the bolded bit with? > -- 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] Renaming Tabs in a spreadsheet in bulk.
Hi Gordon, Am 03.02.2012 17:06, schrieb Gordon Burgess-Parker: > On 03/02/2012 15:50, Tom Davies wrote: >> Hi :) >> Have you opened the ods as an archived-file / zip-file? Are the >> tab-labels in the contents.xml in there? >> Regards from >> Tom :) Did you try Toms hint? > I tried adding this Macro: > > Sub Rename_Tabs() > Dim x As Long, suffix As String > Dim v as Variant > suffix = " 12" > v = Split("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",") > *For x = 1 To Worksheets.Count* > If Not IsError(Application.Match(Left(Sheets(x).Name, 3), v, > 0)) Then > Sheets(x).Name = Left(Sheets(x).Name, 3) & suffix > End If > Next > End Sub > > But it fell over on the bolded portion. I'm not a macro person and > this was copied from one in Excel that worked OK. > Anyone tell me what I need to replace the bolded bit with? (a) Do you want to have this question answered? Or (b) do you want to be helped with your problem? If (a) then replace For x = 1 To Worksheets.Count by For x = 0 To thisComponent.Sheets.count-1 If (b) please recognize that your problem derives from an unfortunate data layout, just as Andreas and Jiri have been pointing out. However you could try to handle your situation by either replacing the relevant values inside the content.xml, just as Tom has been indicating. This can be done by the Search&Replace functionality of any simple text editor. Or, if you would rather have a BASIC macro doing the job, you will need to dive into the StarOffice object modell, which is very different to Excel, which is why it´s little help to present an Excel macro for this task. http://wiki.documentfoundation.org/Macros could be a starting point. Regards, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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: Renaming Tabs in a spreadsheet in bulk.
On Fri, 2012-02-03 at 20:45 +0100, Andreas Säger wrote: > Am 03.02.2012 20:27, Tom wrote: > > Hi :) > > So really all you need is a translation of the Excel macro below. Calc uses > > a completely different language, or at least different enough that the below > > coding wont work. > > Regards from > > Tom :) > > > > > > Meanwhile you should know that the language is more or less the same. > The thing you talk to is rather different. You have to tell different > things in the same language when you speak Basic to Excel. Might there be another method? I just unzipped a Calc spreadsheet. Then I looked at the Context.xml. I found: "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] Renaming Tabs in a spreadsheet in bulk.
On Fri, 2012-02-03 at 16:06 +, Gordon Burgess-Parker wrote: > On 03/02/2012 15:50, Tom Davies wrote: > > Hi :) > > Have you opened the ods as an archived-file / zip-file? Are the tab-labels > > in the contents.xml in there? > > Regards from > > Tom :) > > > > > > > > I tried adding this Macro: > > Sub Rename_Tabs() > Dim x As Long, suffix As String > Dim v as Variant > suffix = " 12" > v = Split("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",") > *For x = 1 To Worksheets.Count* > If Not IsError(Application.Match(Left(Sheets(x).Name, 3), v, 0)) Then > Sheets(x).Name = Left(Sheets(x).Name, 3) & suffix > End If > Next > End Sub > > But it fell over on the bolded portion. I'm not a macro person and this > was copied from one in Excel that worked OK. > Anyone tell me what I need to replace the bolded bit with? > Ah - yeah, there a couple of VBA -> LibOBasic gottyas there.. I don't mind transformig that snippet - have a conf. call starting in just a couple of minutes, but if no one else has already done so by the time I'm off that will post it up.. //drew -- 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] Re: Renaming Tabs in a spreadsheet in bulk.
Am 03.02.2012 20:27, Tom wrote: Hi :) So really all you need is a translation of the Excel macro below. Calc uses a completely different language, or at least different enough that the below coding wont work. Regards from Tom :) Meanwhile you should know that the language is more or less the same. The thing you talk to is rather different. You have to tell different things in the same language when you speak Basic to Excel. -- 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] Re: Renaming Tabs in a spreadsheet in bulk.
Hi :) If one or 2 individuals can't do a neat macro they don't need to but other people have been know to generously show they can do neat little bits for people. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Renaming-Tabs-in-a-spreadsheet-in-bulk-tp3713315p3714085.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] Re: Renaming Tabs in a spreadsheet in bulk.
Am 03.02.2012 17:06, Gordon Burgess-Parker wrote: But it fell over on the bolded portion. I'm not a macro person and this was copied from one in Excel that worked OK. Anyone tell me what I need to replace the bolded bit with? Please, do us all a favour and run Excel. -- 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: Renaming Tabs in a spreadsheet in bulk.
On 03/02/2012 19:25, Andreas Säger wrote: Am 03.02.2012 20:02, Gordon Burgess-Parker wrote: And as an addendum, I have a similar sheet in Excel. I asked the same question in the MS Excel forum and was immediately given a macro by an Excel specialist to do this without any lecturing on my method of data collection... This is not a rent-a-coder-for-nothing service where Calc specialists fix your broken data layout. *PLONK*. MORON -- 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] Re: Renaming Tabs in a spreadsheet in bulk.
Hi :) So really all you need is a translation of the Excel macro below. Calc uses a completely different language, or at least different enough that the below coding wont work. Regards from Tom :) Gordon Burgess-Parker wrote > > I tried adding this Macro: > > Sub Rename_Tabs() > Dim x As Long, suffix As String > Dim v as Variant > suffix = " 12" > v = Split("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",") > *For x = 1 To Worksheets.Count* > If Not IsError(Application.Match(Left(Sheets(x).Name, 3), v, 0)) > Then > Sheets(x).Name = Left(Sheets(x).Name, 3) & suffix > End If > Next > End Sub > > But it fell over I'm not a macro person and this was copied from one > in Excel that worked OK. Anyone tell me what ... [Calc would need > instead] ... ? > -- View this message in context: http://nabble.documentfoundation.org/Renaming-Tabs-in-a-spreadsheet-in-bulk-tp3713315p3714053.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: Renaming Tabs in a spreadsheet in bulk.
On 03/02/2012 19:25, Andreas Säger wrote: Am 03.02.2012 20:02, Gordon Burgess-Parker wrote: And as an addendum, I have a similar sheet in Excel. I asked the same question in the MS Excel forum and was immediately given a macro by an Excel specialist to do this without any lecturing on my method of data collection... This is not a rent-a-coder-for-nothing service where Calc specialists fix your broken data layout. Sorry mate, my data IS NOT BROKEN. Take your arrogant self serving attitude and STUFF IT WHERE THE SUN DOESN'T SHINE. -- 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] Re: Renaming Tabs in a spreadsheet in bulk.
Am 03.02.2012 20:02, Gordon Burgess-Parker wrote: And as an addendum, I have a similar sheet in Excel. I asked the same question in the MS Excel forum and was immediately given a macro by an Excel specialist to do this without any lecturing on my method of data collection... This is not a rent-a-coder-for-nothing service where Calc specialists fix your broken data layout. -- 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: Renaming Tabs in a spreadsheet in bulk.
On 03/02/2012 19:12, Tom Davies wrote: Hi :) Yes, i think these guys are talking about data-storage and ignoring accountancy principles. Most places i have seen have different tabs for different months or for different quarters and that allows reports to show bank reconciliations, outstanding payments, prepayments, accruals for a set date without those figures then getting messed-up by subsequent postings. It's just that we have had a lot of posts about databases recently which is an area we need to get more development work going on. Apols and regards from Tom :) Thanks - if I'd wanted to create a database I wouldn't be using a spreadsheet! Base or Access would be my application of choice... -- 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: Renaming Tabs in a spreadsheet in bulk.
Hi :) Yes, i think these guys are talking about data-storage and ignoring accountancy principles. Most places i have seen have different tabs for different months or for different quarters and that allows reports to show bank reconciliations, outstanding payments, prepayments, accruals for a set date without those figures then getting messed-up by subsequent postings. It's just that we have had a lot of posts about databases recently which is an area we need to get more development work going on. Apols and regards from Tom :) --- On Fri, 3/2/12, Gordon Burgess-Parker wrote: From: Gordon Burgess-Parker Subject: Re: [libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk. To: users@global.libreoffice.org Date: Friday, 3 February, 2012, 19:02 On 03/02/2012 18:59, Gordon Burgess-Parker wrote: > On 03/02/2012 18:05, Stefan Weigel wrote: >> Hi, >> >> Am 03.02.2012 16:50, schrieb Andreas Säger: >> >>> Am 03.02.2012 16:05, Gordon Burgess-Parker wrote: I have a spreadsheet that is used for monthly and annual collection of data, with monthly tabs, Jan 2011, Feb 2011 etc. Is there a way to rename 2011 to 2012 in bulk, or do I have to do each one manually? >>> Splitting up equally structured data across many sheets is *always* >>> a huge mistake. Don't do that. >> Yes, can´t confirm this strong enough! >> >> Have a look into Calc Guide Chapter 8 >> (http://www.libreoffice.org/get-help/documentation/#cg), especially >> read the third rule on page 24. >> >> Cheers, >> Stefan >> >> > Yeah. OK. As someone who has been a Systems and Management Accountant (NOT a > pseudo-database administrator) for 30 years and has used spreadsheets at > advanced level with separate tabs for calendar-month data (as have all the > colleagues I have worked with over that period in many different > organisations) this is all very interesting but totally irrelevant to my > question. > And as an addendum, I have a similar sheet in Excel. I asked the same question in the MS Excel forum and was immediately given a macro by an Excel specialist to do this without any lecturing on my method of data collection... -- 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: Renaming Tabs in a spreadsheet in bulk.
On 03/02/2012 18:59, Gordon Burgess-Parker wrote: On 03/02/2012 18:05, Stefan Weigel wrote: Hi, Am 03.02.2012 16:50, schrieb Andreas Säger: Am 03.02.2012 16:05, Gordon Burgess-Parker wrote: I have a spreadsheet that is used for monthly and annual collection of data, with monthly tabs, Jan 2011, Feb 2011 etc. Is there a way to rename 2011 to 2012 in bulk, or do I have to do each one manually? Splitting up equally structured data across many sheets is *always* a huge mistake. Don't do that. Yes, can´t confirm this strong enough! Have a look into Calc Guide Chapter 8 (http://www.libreoffice.org/get-help/documentation/#cg), especially read the third rule on page 24. Cheers, Stefan Yeah. OK. As someone who has been a Systems and Management Accountant (NOT a pseudo-database administrator) for 30 years and has used spreadsheets at advanced level with separate tabs for calendar-month data (as have all the colleagues I have worked with over that period in many different organisations) this is all very interesting but totally irrelevant to my question. And as an addendum, I have a similar sheet in Excel. I asked the same question in the MS Excel forum and was immediately given a macro by an Excel specialist to do this without any lecturing on my method of data collection... -- 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: Renaming Tabs in a spreadsheet in bulk.
On 03/02/2012 18:05, Stefan Weigel wrote: Hi, Am 03.02.2012 16:50, schrieb Andreas Säger: Am 03.02.2012 16:05, Gordon Burgess-Parker wrote: I have a spreadsheet that is used for monthly and annual collection of data, with monthly tabs, Jan 2011, Feb 2011 etc. Is there a way to rename 2011 to 2012 in bulk, or do I have to do each one manually? Splitting up equally structured data across many sheets is *always* a huge mistake. Don't do that. Yes, can´t confirm this strong enough! Have a look into Calc Guide Chapter 8 (http://www.libreoffice.org/get-help/documentation/#cg), especially read the third rule on page 24. Cheers, Stefan Yeah. OK. As someone who has been a Systems and Management Accountant (NOT a pseudo-database administrator) for 30 years and has used spreadsheets at advanced level with separate tabs for calendar-month data (as have all the colleagues I have worked with over that period in many different organisations) this is all very interesting but totally irrelevant to my question. -- 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: Renaming Tabs in a spreadsheet in bulk.
Hi, Am 03.02.2012 16:50, schrieb Andreas Säger: > Am 03.02.2012 16:05, Gordon Burgess-Parker wrote: >> I have a spreadsheet that is used for monthly and annual >> collection of >> data, with monthly tabs, Jan 2011, Feb 2011 etc. >> Is there a way to rename 2011 to 2012 in bulk, or do I have to do >> each >> one manually? > Splitting up equally structured data across many sheets is *always* > a huge mistake. Don't do that. Yes, can´t confirm this strong enough! Have a look into Calc Guide Chapter 8 (http://www.libreoffice.org/get-help/documentation/#cg), especially read the third rule on page 24. Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Re: Problem printing an .xls file
On Fri, 27 Jan 2012 17:25:00 +, I wrote: > Before I raise this in a Bug report See: https://bugs.freedesktop.org/show_bug.cgi?id=45340 A workaround has been found by 'TJ' in the Mandriva newsgroup: When in LO's 'print file', go in to Printer Settings and change 'PDF' to 'Postscript' (any level). (Unfortunately the change does not stick, unless the document is changed and Saved.) The reason why OpenOffice is able to print the file perfectly is that it already uses Postscript in the output. For background to that, see: https://issues.apache.org/ooo/show_bug.cgi?id=94173 where the proposed change from Postscript to PDF (to solve *other* problems) did not make it into OpenOffice before it ws handed over to Apache, whereas they *did* make it into LO! -- /\/\aurice -- 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: Renaming Tabs in a spreadsheet in bulk.
Dne 3.2.2012 16:50, Andreas Säger napsal(a): Am 03.02.2012 16:05, Gordon Burgess-Parker wrote: I have a spreadsheet that is used for monthly and annual collection of data, with monthly tabs, Jan 2011, Feb 2011 etc. Is there a way to rename 2011 to 2012 in bulk, or do I have to do each one manually? Splitting up equally structured data across many sheets is *always* a huge mistake. Don't do that. Simply put everything in one table and add a field for the month. There are dozends of features which allow you to get data and calculations for any category of a single table. Listen to that smart advice from Andreas. And do it better by adding another field (column) for year and line_ID. That line_ID I mean something that identifies the line content. Let's say you have in each sheet report line labeled "Turnover", line labeled "Costs" and line labeled "Number of employes". Those line labels can be the line_ID but better is to add a numeric key because of sorting. Then use the data-pilot to filter and select desired year and month. The final report you can edit and format using the marvelous VLOOKUP function - lookup in the data-pilot values belonging to line_IDs. Resume: - keep unformatted data in Sheet1 - this is your database - have selected time period filtered in datapilot in Sheet2 - define once, change filter only - format a nice presentation of v-looked-up values in Sheet3 - define once - it presents data of Sheet2 Regards, Jiri -- Ing. Jiří Hladůvka - REVIDA http://www.revida.sk mailto:m...@revida.sk -- 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 Enable Thesaurus
I do not think that the LO Extension Center would be a good place for that. We need to keep non-LO packages off the LO Extension and Template sites. As for the Thesaurus in LibreOffice, well you need to install a dictionary/thesaurus .oxt file as the easiest way to get one working with LO. I know there are Thesaurus files in the Ubuntu repository, but I do not know how to get LO to access them properly. There seems to be several file formats for Ubuntu's internal/repository spelling and thesaurus data files. LO must be able access them properly to use them. Since Windows does not include such files, as far as I can tell, would the developers create the coding for each type of Linux dictionary/thesaurus repository based file formats when Mac and Windows might not have them? Would these file be in all the Ubuntu, Debian, Red Hat, openSUSE, etc, based distros, or only in some of them? I would not want to be the one responsible for testing LO to see if it works with each and every distro's repository-based spelling dictionary and thesaurus files. It is much easier to just work with the ones enabled through the installing of the .oxt file based ones. http://libreoffice-na.us/English-3.4-installs/dictionary.html is the list of all the .oxt dictionary and thesaurus files I know of, except any new ones listed in the LO Extension Center that I have not listed [yet]. There are over 200 dictionaries [last counted] listed, with over 20 localized Spanish ones. So, to be honest, I would rather deal with using a .oxt file-based thesaurus and dictionary than try to get what Ubuntu has to work with LO. As for the question about stand-alone Thesaurus for Ubuntu, for now Artha would be the easiest route to go. Install it, then run it. You will not see it's window coming up normally. You have to do a "ctrl-alt-w" to have the window pop up for use. The package stays in memory, or partly, until you reboot [or at least as far as I know it does]. I have used it a few times though. Actually it is more than just a Thesaurus. There is a "Relatives" tab system that lists their titles called: Synonyms, Antonyms, Derivatives, Related to, Attributes, Similar, Domain, Causes, Entails, Kind of, Kinds, Part of, and Parts. What all these options will show, I have no real clue, but they are listed. On 02/03/2012 11:17 AM, Tom Davies wrote: Hi :) Ahh, i wasn't think of being that organised. I was just thinking of adding a link to the page that we already have. That would make your Extensions page a central point which would be great imo as there is a lot of great stuff there and other packages are possibly not quite so good even before doing more work on it. Regards from Tom :) --- On Fri, 3/2/12, webmaster for Kracked Press Productions wrote: From: webmaster for Kracked Press Productions Subject: Re: [libreoffice-users] How to Enable Thesaurus To: users@global.libreoffice.org Date: Friday, 3 February, 2012, 16:07 Sorry, Artha is not something I have dealt with, except testing it out on my Ubuntu system. If you think there needs to be a page listing all of the possible dictionary and thesaurus options for Ubuntu and Windows, well if I have the time I might think about doing one. But for now, I have a good one for LO within my .oxt dictionary/thesaurus/hyphenation files. Outside of LO, I thing Artha might be a useful one. On 02/03/2012 10:56 AM, Tom Davies wrote: Hi :) Would it be reasonably easy to add a link to the Artha one on Tim's dictionary Extensions page? If that page could be a one-stop-shop it might be good for keeping track of all those things and a good one to sign-post people to. Regards from Tom :) --- On Fri, 3/2/12, webmaster for Kracked Press Productions wrote: From: webmaster for Kracked Press Productions Subject: Re: [libreoffice-users] How to Enable Thesaurus To: users@global.libreoffice.org Date: Friday, 3 February, 2012, 15:00 On 02/02/2012 09:13 PM, Doug wrote: On 2/2/2012 4:57 PM, Mick Sulley wrote: Running - LibreOffice 3.3.4 OOO330m19 (Build:401) tag libreoffice-3.3.3.1, Ubuntu package 1:3.3.4-0ubuntu1 Language is English (UK) How can I enable the Thesaurus? If I go to Tools> Language, Thesaurus is greyed out If I go to Tools> Options> Language Settings> Writing Aids I see OpenOffice.org New Thesaurus and it is ticked. Am I missing something here? Thanks Mick Don't know about LO Thesaurus, but a nice free-standing one, which also doubles as a dictionary, is Artha. Check your repos for that--it's in PCLOS. --doug Yes, I have Artha as a stand-alone one. You can get it off the distros as well, and I believe there is a Windows version as well. But if you need one to be used in LibreOffice, my set of English dictionaries have one that has over 140,000 word/phrase listings to get a result from. All you have to do is download and install one of my American English, British English, or Canadian English, .oxt
Re: [libreoffice-users] How to Enable Thesaurus
Hi :) Ahh, i wasn't think of being that organised. I was just thinking of adding a link to the page that we already have. That would make your Extensions page a central point which would be great imo as there is a lot of great stuff there and other packages are possibly not quite so good even before doing more work on it. Regards from Tom :) --- On Fri, 3/2/12, webmaster for Kracked Press Productions wrote: From: webmaster for Kracked Press Productions Subject: Re: [libreoffice-users] How to Enable Thesaurus To: users@global.libreoffice.org Date: Friday, 3 February, 2012, 16:07 Sorry, Artha is not something I have dealt with, except testing it out on my Ubuntu system. If you think there needs to be a page listing all of the possible dictionary and thesaurus options for Ubuntu and Windows, well if I have the time I might think about doing one. But for now, I have a good one for LO within my .oxt dictionary/thesaurus/hyphenation files. Outside of LO, I thing Artha might be a useful one. On 02/03/2012 10:56 AM, Tom Davies wrote: > Hi :) > Would it be reasonably easy to add a link to the Artha one on Tim's > dictionary Extensions page? If that page could be a one-stop-shop it might > be good for keeping track of all those things and a good one to sign-post > people to. > Regards from > Tom :) > > > --- On Fri, 3/2/12, webmaster for Kracked Press > Productions wrote: > > From: webmaster for Kracked Press Productions > Subject: Re: [libreoffice-users] How to Enable Thesaurus > To: users@global.libreoffice.org > Date: Friday, 3 February, 2012, 15:00 > > On 02/02/2012 09:13 PM, Doug wrote: >> On 2/2/2012 4:57 PM, Mick Sulley wrote: >>> Running - >>> LibreOffice 3.3.4 >>> OOO330m19 (Build:401) >>> tag libreoffice-3.3.3.1, Ubuntu package 1:3.3.4-0ubuntu1 >>> Language is English (UK) >>> >>> How can I enable the Thesaurus? >>> >>> If I go to Tools> Language, Thesaurus is greyed out >>> >>> If I go to Tools> Options> Language Settings> Writing Aids >>> I see OpenOffice.org New Thesaurus and it is ticked. >>> >>> Am I missing something here? >>> >>> Thanks >>> Mick >>> >> Don't know about LO Thesaurus, but a nice free-standing one, which also >> doubles as a dictionary, is Artha. Check your repos for that--it's in PCLOS. >> >> --doug >> > Yes, I have Artha as a stand-alone one. You can get it off the distros as > well, and I believe there is a Windows version as well. > > But if you need one to be used in LibreOffice, my set of English dictionaries > have one that has over 140,000 word/phrase listings to get a result from. > All you have to do is download and install one of my American English, > British English, or Canadian English, .oxt files and install it through the > Extension Manager. > > You can get them at the Extension Center http://extensions.libreoffice.org/ > and look for the Dictionaries for any version. Or you can go to my portal > and download them from there. > http://libreoffice-na.us/English-3.4-installs/dictionary.html#english They > start with "kpp" in the dictionary file list. There are a total of 11 > dictionaries to choose from. All you have to do is choose the version of > English [American, British, or Canadian], and choose the spelling word list > count size [98K, 217K, 390K, and 638K words in the list]. You can install > all of them, but only keep one of each English version enabled at a time. > Hopefully, soon I will be uploading an update with about 1K of computer > technical words and terms that were missing from these word lists. I have > been busy so I will need a bit of time to make the updates available online > in the Extension Center and my portal. > > > > > -- 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 -- 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 Enable Thesaurus
Sorry, Artha is not something I have dealt with, except testing it out on my Ubuntu system. If you think there needs to be a page listing all of the possible dictionary and thesaurus options for Ubuntu and Windows, well if I have the time I might think about doing one. But for now, I have a good one for LO within my .oxt dictionary/thesaurus/hyphenation files. Outside of LO, I thing Artha might be a useful one. On 02/03/2012 10:56 AM, Tom Davies wrote: Hi :) Would it be reasonably easy to add a link to the Artha one on Tim's dictionary Extensions page? If that page could be a one-stop-shop it might be good for keeping track of all those things and a good one to sign-post people to. Regards from Tom :) --- On Fri, 3/2/12, webmaster for Kracked Press Productions wrote: From: webmaster for Kracked Press Productions Subject: Re: [libreoffice-users] How to Enable Thesaurus To: users@global.libreoffice.org Date: Friday, 3 February, 2012, 15:00 On 02/02/2012 09:13 PM, Doug wrote: On 2/2/2012 4:57 PM, Mick Sulley wrote: Running - LibreOffice 3.3.4 OOO330m19 (Build:401) tag libreoffice-3.3.3.1, Ubuntu package 1:3.3.4-0ubuntu1 Language is English (UK) How can I enable the Thesaurus? If I go to Tools> Language, Thesaurus is greyed out If I go to Tools> Options> Language Settings> Writing Aids I see OpenOffice.org New Thesaurus and it is ticked. Am I missing something here? Thanks Mick Don't know about LO Thesaurus, but a nice free-standing one, which also doubles as a dictionary, is Artha. Check your repos for that--it's in PCLOS. --doug Yes, I have Artha as a stand-alone one. You can get it off the distros as well, and I believe there is a Windows version as well. But if you need one to be used in LibreOffice, my set of English dictionaries have one that has over 140,000 word/phrase listings to get a result from. All you have to do is download and install one of my American English, British English, or Canadian English, .oxt files and install it through the Extension Manager. You can get them at the Extension Center http://extensions.libreoffice.org/ and look for the Dictionaries for any version. Or you can go to my portal and download them from there. http://libreoffice-na.us/English-3.4-installs/dictionary.html#english They start with "kpp" in the dictionary file list. There are a total of 11 dictionaries to choose from. All you have to do is choose the version of English [American, British, or Canadian], and choose the spelling word list count size [98K, 217K, 390K, and 638K words in the list]. You can install all of them, but only keep one of each English version enabled at a time. Hopefully, soon I will be uploading an update with about 1K of computer technical words and terms that were missing from these word lists. I have been busy so I will need a bit of time to make the updates available online in the Extension Center and my portal. -- 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] Renaming Tabs in a spreadsheet in bulk.
On 03/02/2012 15:50, Tom Davies wrote: Hi :) Have you opened the ods as an archived-file / zip-file? Are the tab-labels in the contents.xml in there? Regards from Tom :) I tried adding this Macro: Sub Rename_Tabs() Dim x As Long, suffix As String Dim v as Variant suffix = " 12" v = Split("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",") *For x = 1 To Worksheets.Count* If Not IsError(Application.Match(Left(Sheets(x).Name, 3), v, 0)) Then Sheets(x).Name = Left(Sheets(x).Name, 3) & suffix End If Next End Sub But it fell over on the bolded portion. I'm not a macro person and this was copied from one in Excel that worked OK. Anyone tell me what I need to replace the bolded bit with? -- 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 Enable Thesaurus
Hi :) Would it be reasonably easy to add a link to the Artha one on Tim's dictionary Extensions page? If that page could be a one-stop-shop it might be good for keeping track of all those things and a good one to sign-post people to. Regards from Tom :) --- On Fri, 3/2/12, webmaster for Kracked Press Productions wrote: From: webmaster for Kracked Press Productions Subject: Re: [libreoffice-users] How to Enable Thesaurus To: users@global.libreoffice.org Date: Friday, 3 February, 2012, 15:00 On 02/02/2012 09:13 PM, Doug wrote: > On 2/2/2012 4:57 PM, Mick Sulley wrote: >> Running - >> LibreOffice 3.3.4 >> OOO330m19 (Build:401) >> tag libreoffice-3.3.3.1, Ubuntu package 1:3.3.4-0ubuntu1 >> Language is English (UK) >> >> How can I enable the Thesaurus? >> >> If I go to Tools > Language, Thesaurus is greyed out >> >> If I go to Tools > Options > Language Settings > Writing Aids >> I see OpenOffice.org New Thesaurus and it is ticked. >> >> Am I missing something here? >> >> Thanks >> Mick >> > Don't know about LO Thesaurus, but a nice free-standing one, which also > doubles as a dictionary, is Artha. Check your repos for that--it's in PCLOS. > > --doug > Yes, I have Artha as a stand-alone one. You can get it off the distros as well, and I believe there is a Windows version as well. But if you need one to be used in LibreOffice, my set of English dictionaries have one that has over 140,000 word/phrase listings to get a result from. All you have to do is download and install one of my American English, British English, or Canadian English, .oxt files and install it through the Extension Manager. You can get them at the Extension Center http://extensions.libreoffice.org/ and look for the Dictionaries for any version. Or you can go to my portal and download them from there. http://libreoffice-na.us/English-3.4-installs/dictionary.html#english They start with "kpp" in the dictionary file list. There are a total of 11 dictionaries to choose from. All you have to do is choose the version of English [American, British, or Canadian], and choose the spelling word list count size [98K, 217K, 390K, and 638K words in the list]. You can install all of them, but only keep one of each English version enabled at a time. Hopefully, soon I will be uploading an update with about 1K of computer technical words and terms that were missing from these word lists. I have been busy so I will need a bit of time to make the updates available online in the Extension Center and my portal. -- 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] Renaming Tabs in a spreadsheet in bulk.
Hi :) Have you opened the ods as an archived-file / zip-file? Are the tab-labels in the contents.xml in there? Regards from Tom :) --- On Fri, 3/2/12, Gordon Burgess-Parker wrote: From: Gordon Burgess-Parker Subject: [libreoffice-users] Renaming Tabs in a spreadsheet in bulk. To: users@global.libreoffice.org Date: Friday, 3 February, 2012, 15:05 I have a spreadsheet that is used for monthly and annual collection of data, with monthly tabs, Jan 2011, Feb 2011 etc. Is there a way to rename 2011 to 2012 in bulk, or do I have to do each one manually? -- 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] Re: Renaming Tabs in a spreadsheet in bulk.
Am 03.02.2012 16:05, Gordon Burgess-Parker wrote: I have a spreadsheet that is used for monthly and annual collection of data, with monthly tabs, Jan 2011, Feb 2011 etc. Is there a way to rename 2011 to 2012 in bulk, or do I have to do each one manually? Splitting up equally structured data across many sheets is *always* a huge mistake. Don't do that. Simply put everything in one table and add a field for the month. There are dozends of features which allow you to get data and calculations for any category of a single table. -- 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 Enable Thesaurus
On 02/02/2012 09:13 PM, Doug wrote: On 2/2/2012 4:57 PM, Mick Sulley wrote: Running - LibreOffice 3.3.4 OOO330m19 (Build:401) tag libreoffice-3.3.3.1, Ubuntu package 1:3.3.4-0ubuntu1 Language is English (UK) How can I enable the Thesaurus? If I go to Tools > Language, Thesaurus is greyed out If I go to Tools > Options > Language Settings > Writing Aids I see OpenOffice.org New Thesaurus and it is ticked. Am I missing something here? Thanks Mick Don't know about LO Thesaurus, but a nice free-standing one, which also doubles as a dictionary, is Artha. Check your repos for that--it's in PCLOS. --doug Yes, I have Artha as a stand-alone one. You can get it off the distros as well, and I believe there is a Windows version as well. But if you need one to be used in LibreOffice, my set of English dictionaries have one that has over 140,000 word/phrase listings to get a result from. All you have to do is download and install one of my American English, British English, or Canadian English, .oxt files and install it through the Extension Manager. You can get them at the Extension Center http://extensions.libreoffice.org/ and look for the Dictionaries for any version. Or you can go to my portal and download them from there. http://libreoffice-na.us/English-3.4-installs/dictionary.html#english They start with "kpp" in the dictionary file list. There are a total of 11 dictionaries to choose from. All you have to do is choose the version of English [American, British, or Canadian], and choose the spelling word list count size [98K, 217K, 390K, and 638K words in the list]. You can install all of them, but only keep one of each English version enabled at a time. Hopefully, soon I will be uploading an update with about 1K of computer technical words and terms that were missing from these word lists. I have been busy so I will need a bit of time to make the updates available online in the Extension Center and my portal. -- 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] Renaming Tabs in a spreadsheet in bulk.
I have a spreadsheet that is used for monthly and annual collection of data, with monthly tabs, Jan 2011, Feb 2011 etc. Is there a way to rename 2011 to 2012 in bulk, or do I have to do each one manually? -- 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] Changing default margins and font for a group of users
Carl , With the joined code you can make the wanted "NewWritterTemplate.ott" working Hope it helps Fernand Sub set_new_writerTemplate() GlobalScope.BasicLibraries.loadLibrary("myTools") sNode = "org.openoffice.Setup/Office/Factories/com.sun.star.text.TextDocument" sProperty = "ooSetupFactoryTemplateFile" '*OPGELET* the file must been in the Template directory ! 'moet in een TEMPLATE-directorie staan, anders werkt het NIET* sValue = "file:///t:/template/tools/New_WriterTemplate.ott" setOOoSetupValue(sNode, sProperty, sValue) End Sub Function setOOoSetupValue(sNodePath$, sProperty$, sValue$) as boolean on error goto exitErr Dim bReturn as Boolean, xconfig, xAccess dim aArgs(0) as Object dim aPropValue as new com.sun.star.beans.PropertyValue xconfig = createunoservice("com.sun.star.configuration.ConfigurationProvider") aPropValue.Name = "nodepath" aPropValue.Value = sNodePath '"org.openoffice.Office.Linguistic" aArgs(0) = aPropValue xAccess = xconfig.createinstanceWithArguments("com.sun.star.configuration.ConfigurationUpdateAccess",aArgs()) xAccess.setPropertyValue(sProperty, sValue) xAccess.commitchanges bReturn = True exitErr: setOOoSetupValue = bReturn End Function Function getOOoSetupValue(sNodePath$,sProperty$) Dim aConfigProvider, oNode, args(0) As new com.sun.star.beans.PropertyValue aConfigProvider = createUnoService("com.sun.star.configuration.ConfigurationProvider") args(0).Name = "nodepath" args(0).Value = sNodePath oNode = aConfigProvider.createInstanceWithArguments("com.sun.star.configuration.ConfigurationAccess", args()) getOOoSetupValue = oNode.getbyname(sProperty) End Function As far as I understand I should be able to set the default font and font size in the main.xcd file The only problem is that Im not sure what the format should be... :( I tried the template way. I created a template and copied it to every machine via a script. It does not seem to get used though. I think I need to tell every installation that it should use this file as the default template. How would this be done? Also in the main.xcd file? On 25/01/2012 14:20, Tom Davies wrote: Hi :) There is a folder called "templates" in the user-profile http://wiki.documentfoundation.org/Documentation/UserProfile but there seem to be other weird places too and i am not sure which is used and whether any of them are not used. Looking in Tools - Options - Paths You can see that the templates path is has a few different alternatives rather than just one but did not seem to include the path to the folder in the user-profile! Aaaargh!! Is it easy enough to add an extra path? Regards from Tom :) --- On Wed, 25/1/12, Jay Lozier wrote: From: Jay Lozier Subject: Re: [libreoffice-users] Changing default margins and font for a group of users To: users@global.libreoffice.org Date: Wednesday, 25 January, 2012, 8:06 On 01/25/2012 01:11 AM, Carl wrote: The user data is saved on a mapped drive on the server and the user profile is on the local PC as part of the user's windows profile. Yes all these users are using different flavours of Windows Can you push a template out over your network? I am not sure of the exact location of the template folder, but should be similar for all the Windows machines (I use Linux). I would look for LO in the Program folder and navigate to the template folder. You could have a problem with 32 and 64 bit locations. On 24/01/2012 16:38, Jay Lozier wrote: On 01/24/2012 03:39 AM, Carl wrote: Hi, I need to change the default margins and font in Libreoffice Writer and Calc for a group of about 100 users. How can I do this without having to go and do it manually on every PC? Regards Carl Werner Where is the user data stored? If on a server, create a new default template and update the appropriate file in each user folder (or alternately change the default template location). If locally, I do not have a good idea. Also, what OS's are involved, I assume Windows. -- Jay Lozier jsloz...@gmail.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
[libreoffice-users] Re: create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ
Le 03/02/2012 15:22, Andreas Säger a écrit : Hi Andreas, Hi Alex, I just tested OOo 2.4.3. Same thing. The mail merge dialog does not catch the current mail merge record set that is correctly identified in dialog Edit>ExchangeDatabase... Thanks for testing, OOo 2.4.3 is going back a bit in time... So an unimplemented feature then ? I remember with StarOffice 5.x and OpenOffice.org 1.x, the SDB files contained clickable links to the Queries (the properties of which could be edited, as I recall) which meant that you didn't have to worry about assigning the query each time. Seems that that possibility was lost when the StarDesktop functionality was removed and Base 2.0 was developed. Alex -- 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] Re: create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ
Am 03.02.2012 11:30, Alex Thurgood wrote: I would hasard a guess that this actually stopped working (i.e. having a query referenced within the mailmerge template or the configuration parameters) when Sun/Oracle redesigned the mailmerge wizard (sometime in the 3.x development branch I think). Of course, it could actually be a LO bug, I haven't compared versions to see whether it works in the one (e.g. OOo 3.2.1) and not the other (LO 3.3.x). Alex Hi Alex, I just tested OOo 2.4.3. Same thing. The mail merge dialog does not catch the current mail merge record set that is correctly identified in dialog Edit>ExchangeDatabase... -- 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] Re: Changing default margins and font for a group of users
Am 03.02.2012 13:46, Carl wrote: As far as I understand I should be able to set the default font and font size in the main.xcd file The only problem is that Im not sure what the format should be... :( I tried the template way. I created a template and copied it to every machine via a script. It does not seem to get used though. I think I need to tell every installation that it should use this file as the default template. How would this be done? Also in the main.xcd file? http://wiki.services.openoffice.org/wiki/Documentation/Administration_Guide/Adding_Template_Files -- 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] Changing default margins and font for a group of users
As far as I understand I should be able to set the default font and font size in the main.xcd file The only problem is that Im not sure what the format should be... :( I tried the template way. I created a template and copied it to every machine via a script. It does not seem to get used though. I think I need to tell every installation that it should use this file as the default template. How would this be done? Also in the main.xcd file? On 25/01/2012 14:20, Tom Davies wrote: Hi :) There is a folder called "templates" in the user-profile http://wiki.documentfoundation.org/Documentation/UserProfile but there seem to be other weird places too and i am not sure which is used and whether any of them are not used. Looking in Tools - Options - Paths You can see that the templates path is has a few different alternatives rather than just one but did not seem to include the path to the folder in the user-profile! Aaaargh!! Is it easy enough to add an extra path? Regards from Tom :) --- On Wed, 25/1/12, Jay Lozier wrote: From: Jay Lozier Subject: Re: [libreoffice-users] Changing default margins and font for a group of users To: users@global.libreoffice.org Date: Wednesday, 25 January, 2012, 8:06 On 01/25/2012 01:11 AM, Carl wrote: The user data is saved on a mapped drive on the server and the user profile is on the local PC as part of the user's windows profile. Yes all these users are using different flavours of Windows Can you push a template out over your network? I am not sure of the exact location of the template folder, but should be similar for all the Windows machines (I use Linux). I would look for LO in the Program folder and navigate to the template folder. You could have a problem with 32 and 64 bit locations. On 24/01/2012 16:38, Jay Lozier wrote: On 01/24/2012 03:39 AM, Carl wrote: Hi, I need to change the default margins and font in Libreoffice Writer and Calc for a group of about 100 users. How can I do this without having to go and do it manually on every PC? Regards Carl Werner Where is the user data stored? If on a server, create a new default template and update the appropriate file in each user folder (or alternately change the default template location). If locally, I do not have a good idea. Also, what OS's are involved, I assume Windows. -- Jay Lozier jsloz...@gmail.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
[libreoffice-users] Re: create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ
Le 02/02/2012 18:57, Mark Stanton a écrit : Hi Mark, You are saying that it is possible to mailmerge using a query to supply the data? I know that's what it looks like you said, but there's just been a long thread here that concluded this was not possible, so I'm just checking. The other thread did not say that. The question from the original post was how to make sure that the Query was selected by default for the mailmerge, without having to manually select it each time. For whatever reason, bug ou incomplete functionality, one does not appear to be able to do this, hence the suggestion that a View be used instead because is a View appears to be handled like a table for the purposes of mailmerge. As Andreas says, it has been possible to use a Query for mailmerge for at least 10 years (StarOffice, OpenOffice.org, now LibreOffice), but apparently (and I don't remember when this happened or whether it was always like that), at present one has to manually redefine the particular Query each time the mailmerge is used. I would hasard a guess that this actually stopped working (i.e. having a query referenced within the mailmerge template or the configuration parameters) when Sun/Oracle redesigned the mailmerge wizard (sometime in the 3.x development branch I think). Of course, it could actually be a LO bug, I haven't compared versions to see whether it works in the one (e.g. OOo 3.2.1) and not the other (LO 3.3.x). Alex -- 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