[libreoffice-users] Re: create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

2012-02-03 Thread Alex Thurgood
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

Re: [libreoffice-users] Changing default margins and font for a group of users

2012-02-03 Thread Carl
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

[libreoffice-users] Re: Changing default margins and font for a group of users

2012-02-03 Thread Andreas Säger
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

[libreoffice-users] Re: create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

2012-02-03 Thread Andreas Säger
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

[libreoffice-users] Re: create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

2012-02-03 Thread Alex Thurgood
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 EditExchangeDatabase... Thanks for testing, OOo 2.4.3 is going back a bit in

Re: [libreoffice-users] Changing default margins and font for a group of users

2012-02-03 Thread Fernand Vanrie
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 =

[libreoffice-users] Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Gordon Burgess-Parker
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?

Re: [libreoffice-users] How to Enable Thesaurus

2012-02-03 Thread webmaster for Kracked Press Productions
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

[libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread 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

Re: [libreoffice-users] Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Tom Davies
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 gbpli...@gmail.com wrote: From: Gordon Burgess-Parker gbpli...@gmail.com Subject: [libreoffice-users] Renaming Tabs in a

Re: [libreoffice-users] How to Enable Thesaurus

2012-02-03 Thread Tom Davies
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

Re: [libreoffice-users] Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread 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 :) I tried adding this Macro: Sub Rename_Tabs() Dim x As Long, suffix As String Dim v as Variant suffix = 12 v =

Re: [libreoffice-users] How to Enable Thesaurus

2012-02-03 Thread webmaster for Kracked Press Productions
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

Re: [libreoffice-users] How to Enable Thesaurus

2012-02-03 Thread Tom Davies
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

Re: [libreoffice-users] How to Enable Thesaurus

2012-02-03 Thread webmaster for Kracked Press Productions
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

Re: [libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Ing. Jiří Hladůvka
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

[libreoffice-users] Re: Problem printing an .xls file

2012-02-03 Thread Maurice Batey
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'

Re: [libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Stefan Weigel
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

Re: [libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Gordon Burgess-Parker
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

Re: [libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Gordon Burgess-Parker
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

Re: [libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Tom Davies
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

Re: [libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Gordon Burgess-Parker
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

[libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Andreas Säger
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

Re: [libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Gordon Burgess-Parker
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

[libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Tom
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,

Re: [libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Gordon Burgess-Parker
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

[libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Andreas Säger
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

[libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Tom
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:

[libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Andreas Säger
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

Re: [libreoffice-users] Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread drew
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

Re: [libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Dan Lewis
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 :)

Re: [libreoffice-users] Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Stefan Weigel
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:

Re: [libreoffice-users] Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread drew
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

Re: [libreoffice-users] Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Tom Davies
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

Re: [libreoffice-users] Problem pasting spreadsheet cells into Impress

2012-02-03 Thread Cor Nouws
Hi, Tanstaafl wrote (31-01-12 12:42) On 2012-01-30 3:36 PM, Cor Nouws oo...@nouenoff.nl 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

[libreoffice-users] Sorting Rows: Merged Cells Error

2012-02-03 Thread Rich Shepard
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.

[libreoffice-users] [PDF instead of Postscript - Printing] Re: Problem printing an .xls file

2012-02-03 Thread NoOp
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

Re: [libreoffice-users] Sorting Rows: Merged Cells Error

2012-02-03 Thread Tom Davies
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