Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Mark Stanton
Yup, same here. I found nice manuals, but all just basic ones (not Basic), and no macros. The forum post looks like it's got some useful ones, but no conditional pictures, unless I missed that. Regards, and thanks Mark Stanton One small step for mankind... -- For unsubscribe instructions

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Cor Nouws
drew wrote (08-02-12 17:41) There was also a fellow in Germany a couple years back who put together a Base system for managing a Dance School - this included a nice set of tools for doing mail merge IIRC - I'll root around a bit and see if I can come up with that link, in addition to what

Re: [libreoffice-users] Default path for templates

2012-02-09 Thread Eduardo Maldonado
Thanks, Dan. I have done that, a folder under /common, and puted there my templates. And the solution is fine for me. El 8 de febrero de 2012 20:42, Dan Lewis elderdanle...@gmail.com escribió: On Wed, 2012-02-08 at 18:49 +0100, Eduardo Maldonado wrote: Hi all. I have created two

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Mark Stanton
The thing that started this thread though was my need for conditional pictures. Can that be done without macros? Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Default path for templates

2012-02-09 Thread Ron Johnson
On 02/09/2012 06:13 AM, Dan Lewis wrote: [snip] The path he needs to use ends in .../template/common because his LO installation is on a server. This permits people from other computers to use LO and the same templates. If templates are placed in the common folder, they will not be

Re: [libreoffice-users] Re: [Put on shelf] Re: Unable to connect to Access DB

2012-02-09 Thread Ian Whitfield
OK Guys Don't we need a Known Problems List here somewhere???!!! This is something you come across on many Software Sites as new versions come out. I think it would help a lot of people who are investigating moving TO the new Software OR moving UP TO the latest version. I can start off by

Re: [libreoffice-users] Re: [Put on shelf] Re: Unable to connect to Access DB

2012-02-09 Thread Tom Davies
Hi :) The French team made a very nice FAQ (=Frequently Asked Questions) and that 'is' being translated into English but Documentation is a very tiny team and needs a lot more people if we want things like that to get done.  People would rather show-off on a list like this than put the work in

[libreoffice-users] experiences with Impress and KDE and/or nvidia and/or presenter console ?

2012-02-09 Thread Cor Nouws
Hi all, I see some issues in BugZilla around these things. Issues that I cannot (or seldom) reproduce. But I've no idea how that works for others .. So: would be great if people here can give their experiences. Even better would be to add useful comments to bugzilla, that help the devs to

Re: [libreoffice-users] Re: [Put on shelf] Re: Unable to connect to Access DB

2012-02-09 Thread Nino Novak
Ian, On Thursday 09 February 2012, Ian Whitfield wrote: Don't we need a Known Problems List here somewhere???!!! you've seen this one: http://wiki.documentfoundation.org/ReleaseNotes/3.5#Most_annoying_bugs Nino -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org

Re: [libreoffice-users] Default path for templates

2012-02-09 Thread Dan Lewis
Comments inline On Thu, 2012-02-09 at 06:32 -0600, Ron Johnson wrote: On 02/09/2012 06:13 AM, Dan Lewis wrote: [snip] The path he needs to use ends in .../template/common because his LO installation is on a server. This permits people from other computers to use LO and the

Re: [libreoffice-users] Default path for templates

2012-02-09 Thread Ron Johnson
On 02/09/2012 08:15 AM, Dan Lewis wrote: Comments inline On Thu, 2012-02-09 at 06:32 -0600, Ron Johnson wrote: [snip] What I'm perceiving is that LO doesn't follow the standard Unix search hierarchy of first looking locally (~/.libreoffice/3/user/template) and then in /usr/share (the

Re: [libreoffice-users] Problem impression choice of source of paper

2012-02-09 Thread Jay Lozier
On 02/09/2012 08:17 AM, Jean Milot wrote: Hi, With all the software, i can choose the source of paper and it works. But when i want to impress and choose the source of paper on LO, it doesn't work : the source of paper don't change. I don't know if the problem appears with all the printers

Re: [libreoffice-users] Base question - report exception on faultless query

2012-02-09 Thread Jay Lozier
On 02/09/2012 09:33 AM, Mark Stanton wrote: Thanks for that Fernand (yes, I know this is a while back, but I never said :-) ). And, nearly thirty years of software development has convinced me that upper case is good for built in keywords, in this case SELECT tc, camelcase is good for

Re: [libreoffice-users] Re: [Put on shelf] Re: Unable to connect to Access DB

2012-02-09 Thread Ian Whitfield
On 09/02/2012 15:48, Nino Novak wrote: Don't we need a Known Problems List here somewhere???!!! you've seen this one: http://wiki.documentfoundation.org/ReleaseNotes/3.5#Most_annoying_bugs No I had not - Thanks Nino. But why NEVER any mention of Base problems!!!??? I still think a User Based

Re: [libreoffice-users] LO Base questions

2012-02-09 Thread Ian Whitfield
On 07/02/2012 20:08, drew wrote: Periodically you should perform the following. When finished using the database, open the SQL window. Menu [FileSQL] In the command window enter: SHUTDOWN COMPACT You should, after a short while receive in the status field the message: 1: Command successfully

[libreoffice-users] Re: Export as PDF in LO 3.5

2012-02-09 Thread CVAlkan
Tinkerer: No, it's not just you, at least regarding the Writer module. The Export to PDF function has been broken for some time, but seems to be related to the size of the output pdf document (it seems to work just fine for me on smaller files), but I can't confirm that. I have experienced the

Re: [libreoffice-users] Re: [Put on shelf] Re: Unable to connect to Access DB

2012-02-09 Thread Nino Novak
On Thursday 09 February 2012, Ian Whitfield wrote: On 09/02/2012 15:48, Nino Novak wrote: Don't we need a Known Problems List here somewhere???!!! you've seen this one: http://wiki.documentfoundation.org/ReleaseNotes/3.5#Most_annoying_bugs No I had not - Thanks Nino. But why

[libreoffice-users] PUNO - Building on CentOS6 Fails

2012-02-09 Thread Adam Tauno Williams
I have PUNO 0.9 / php-5.3.3-3.el6_2.6.x86_64 / openoffice.org-sdk-3.2.1-19.6.el6_0.5.x86_64 http://www.wstech2.net/?do=0a,01,05 Building make all fails with - /tmp/PUNO/puno.cpp: At global scope: /tmp/PUNO/puno.cpp:52: warning: deprecated conversion from string constant to ‘char*’

Re: [libreoffice-users] Re: Export as PDF in LO 3.5

2012-02-09 Thread Cor Nouws
Hi, CVAlkan wrote (09-02-12 16:25) No, it's not just you, at least regarding the Writer module. The Export to PDF function has been broken for some time, but seems to be related to the size of the output pdf document (it seems to work just fine for me on smaller files), but I can't confirm

Re: [libreoffice-users] Re: Export as PDF in LO 3.5

2012-02-09 Thread Cor Nouws
Cor Nouws wrote (09-02-12 16:49) Currently I test Andrews Macro document http://www.pitonyak.org/oo.php Is a tough job, but still running ... Got a stiff neck from the van running ;-) but after 28 minutes the 609 kB ODT-file is exported to a 2.0 MB PDF. The four Calc files that I had

Re: [libreoffice-users] LO Base questions

2012-02-09 Thread drew
On Thu, 2012-02-09 at 17:12 +0200, Ian Whitfield wrote: On 07/02/2012 20:08, drew wrote: Periodically you should perform the following. When finished using the database, open the SQL window. Menu [FileSQL] In the command window enter: SHUTDOWN COMPACT You should, after a short while

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Fernand Vanrie
hallo Mark , The thing that started this thread though was my need for conditional pictures. Can that be done without macros? In theory we can use a WRITER DOC a FORM and a IMAGECONTROL, but even after i resolved the problem to store image-data in a database field, and pointed the

Re: [libreoffice-users] Re: Export as PDF in LO 3.5

2012-02-09 Thread Krunoslav Šebetić
On Thu, 2012-02-09 at 07:25 -0800, CVAlkan wrote: The Export to PDF function has been broken for some time, but seems to be related to the size of the output pdf document (it seems to work just fine for me on smaller files), but I can't confirm that. Hey, This is my first mail and I am

Re: [libreoffice-users] Re: Export as PDF in LO 3.5

2012-02-09 Thread Dan Lewis
On Thu, 2012-02-09 at 18:39 +0100, Krunoslav Šebetić wrote: On Thu, 2012-02-09 at 07:25 -0800, CVAlkan wrote: The Export to PDF function has been broken for some time, but seems to be related to the size of the output pdf document (it seems to work just fine for me on smaller files),

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Fernand Vanrie
Mark, me again, I did a bit more testing, now i can store en review a image in a database, using a Form and a image control, but there is still the problem that there is nothing like a imagefield to recall and show the stored image date when running a merge operation. Fernand hallo Mark

[libreoffice-users] Basic Addon Builder

2012-02-09 Thread blesko
Has anyone recently used or edited the BasicAddonBuilter macro? I recently used it and ran into a problem with an addon I built. The labels on my new macro are not showing up . Drew suggested it might be a language file missing? http://nabble.documentfoundation.org/file/n3730282/labels.png Beth

Re: [libreoffice-users] Basic Addon Builder

2012-02-09 Thread drew
On Thu, 2012-02-09 at 10:14 -0800, blesko wrote: Has anyone recently used or edited the BasicAddonBuilter macro? I recently used it and ran into a problem with an addon I built. The labels on my new macro are not showing up . Drew suggested it might be a language file missing? Didn't forget -

Re: [libreoffice-users] Re: Export as PDF in LO 3.5

2012-02-09 Thread Steve Edmonds
On 2012-02-10 04:25, CVAlkan wrote: Tinkerer: No, it's not just you, at least regarding the Writer module. The Export to PDF function has been broken for some time, but seems to be related to the size of the output pdf document (it seems to work just fine for me on smaller files), but I

Re: [libreoffice-users] Basic Addon Builder

2012-02-09 Thread drew
On Thu, 2012-02-09 at 13:16 -0500, drew wrote: On Thu, 2012-02-09 at 10:14 -0800, blesko wrote: Has anyone recently used or edited the BasicAddonBuilter macro? I recently used it and ran into a problem with an addon I built. The labels on my new macro are not showing up . Drew suggested it

Re: [libreoffice-users] Basic Addon Builder

2012-02-09 Thread Beth Lesko
I just reviewed my installation of 3.4.4 and decided I need to download and install 3.4.5. I'm on Ubuntu and pieced together an install and I jsut realized that was none too smart... As soon as I've installed it, I will attempt to build it again and run a test with windows to see if it fixed it.

Re: [libreoffice-users] Basic Addon Builder

2012-02-09 Thread drew
On Thu, 2012-02-09 at 13:29 -0500, Beth Lesko wrote: I just reviewed my installation of 3.4.4 and decided I need to download and install 3.4.5. I'm on Ubuntu and pieced together an install and I jsut realized that was none too smart... As soon as I've installed it, I will attempt to build it

Re: [libreoffice-users] Re: [Put on shelf] Re: Unable to connect to Access DB

2012-02-09 Thread Tom Davies
Hi :) I think they avoid listing the Base problems because there are not enough electrons in the world.  Possibly i'm just having a bad day and it will all look much happier tomorrow tho. Regards from Tom :) --- On Thu, 9/2/12, Nino Novak nn.l...@kflog.org wrote: From: Nino Novak

Re: [libreoffice-users] Re: Export as PDF in LO 3.5

2012-02-09 Thread Tom Davies
Hi :) Can you use Cups to print-to-file and choose Pdf instead of Ps that way?  Tim does something like that although i have never understood how.  Regards from Tom :) --- On Thu, 9/2/12, CVAlkan fobe...@enteract.com wrote: From: CVAlkan fobe...@enteract.com Subject: [libreoffice-users] Re:

Re: [libreoffice-users] Default path for templates

2012-02-09 Thread Eduardo Maldonado
That's correct, Dan. $USER_LO_DIR//user/template are personal templates, only for each user. $LO_INST_DIR//template/common are collective templates, for all user of system. And my problem is for collective/corporate templates. Thank you. El 9 de febrero de 2012 13:13, Dan Lewis

[libreoffice-users] Re: Mailmerge, working, fairly well, but...

2012-02-09 Thread Alex Thurgood
Le 09/02/2012 19:03, Fernand Vanrie a écrit : Hi Fernand, I did a bit more testing, now i can store en review a image in a database, using a Form and a image control, but there is still the problem that there is nothing like a imagefield to recall and show the stored image date when running a

[libreoffice-users] Programatically changing the properties of a multselection (group)

2012-02-09 Thread Russell D Mileham
I am building a Base form where I would like to group several controls and enable/disable them based on the actions of the user. When I group the controls, the Enabled property can be set in the Properties: Multiselection dialog through the GUI, but I can't seem to figure out how to access the

Re: [libreoffice-users] Programatically changing the properties of a multselection (group)

2012-02-09 Thread Jay Lozier
On 02/09/2012 02:34 PM, Russell D Mileham wrote: I am building a Base form where I would like to group several controls and enable/disable them based on the actions of the user. When I group the controls, the Enabled property can be set in the Properties: Multiselection dialog through the

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Cor Nouws
Mark Stanton wrote (09-02-12 12:35) The thing that started this thread though was my need for conditional pictures. Can that be done without macros? Ah, did miss the start of the thread. Depends on the amount / size of pictures of course. With random pictures, as the data itself, I would not

[libreoffice-users] Re: Mailmerge, working, fairly well, but...

2012-02-09 Thread Andreas Säger
Am 09.02.2012 20:14, Alex Thurgood wrote: Le 09/02/2012 19:03, Fernand Vanrie a écrit : Hi Fernand, I did a bit more testing, now i can store en review a image in a database, using a Form and a image control, but there is still the problem that there is nothing like a imagefield to recall and

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Mark Stanton
Hi Fernand, I'm quite happy with the (idea of the) macro solution, I was just interested if there was another simpler/easier one. I really don't want to put images in a table, particularly in this case where the picture is either 'A' or 'B', although I s'pose if I can get it there as a result

[libreoffice-users] Re: Mailmerge, working, fairly well, but...

2012-02-09 Thread Alex Thurgood
Le 09/02/2012 21:27, Andreas Säger a écrit : Hi Andreas, I use to store pictures as references to files in the same directory as the odb document. This way all you need to store in a VARCHAR field is the file names of the pictures. In a form you can bind a picture control to the text field

[libreoffice-users] Re: Mailmerge, working, fairly well, but...

2012-02-09 Thread Andreas Säger
Am 09.02.2012 21:58, Alex Thurgood wrote: Agreed, but can you set it up to make the paragraph as invisible depending on whether or not you have a varchar string ? I imagine so, but that is the question that the original poster was asking. Your macro would need to take care of that piece of

Re: [libreoffice-users] Programatically changing the properties of a multselection (group)

2012-02-09 Thread Russell D Mileham
On Thu, 09 Feb 2012 15:05:43 -0500 Jay Lozier jsloz...@gmail.com wrote: Can you post a copy of the form and code on Nabble or somewhere else so others can look at. Just send a message with the appropriate links. There are couple on the list who are very good a macros. I will work on

Re: [libreoffice-users] Re: Export as PDF in LO 3.5

2012-02-09 Thread Don C. Myers
Hi All, I'm curious. I've used OpenOffice since version 1.0. I'm not sure if version 1.0 had the export to pdf feature, but I've used it many, many, many times since it has been part of the offering. I ran it in Windows until 3 years ago, and since then in Linux (Ubuntu 8.10, 9.04, 9.10,

Re: [libreoffice-users] Programatically changing the properties of a multselection (group)

2012-02-09 Thread Tom Davies
Hi :) A good guide to macros is listed at the bottom of the Programmers section of 3rd party documentation http://wiki.documentfoundation.org/Documentation/Publications#Programmers A direct link to Andrew Pitonyak's page is here http://www.pitonyak.org/oo.php There might be other guides to help

Re: [libreoffice-users] Basic Addon Builder

2012-02-09 Thread Beth Lesko
Here's the new one - testing on XP now... On Thu, Feb 9, 2012 at 1:42 PM, drew d...@baseanswers.com wrote: On Thu, 2012-02-09 at 13:29 -0500, Beth Lesko wrote: I just reviewed my installation of 3.4.4 and decided I need to download and install 3.4.5. I'm on Ubuntu and pieced together an

Re: [libreoffice-users] Re: Export as PDF in LO 3.5

2012-02-09 Thread Tom Davies
Hi :) +1 I've not had any problems with the export to pdf either but i haven't pushed the limits or even done a huge range of different types of things.  I just export the company newsletter of about 12 pages with loads of logos and pictures in it.  Regards from Tom :) --- On Thu, 9/2/12,

Re: [libreoffice-users] Basic Addon Builder

2012-02-09 Thread drew
Hi Beth, Not sure if you mean that you attached the .oxt, the list doesn't allow attachments and stripped it out if you did. For future reference, you can add an attachment to an email and then include both the list address and a direct address for someone - the list will strip it out, the

[libreoffice-users] Paragraph format problem

2012-02-09 Thread .
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a hundreds of paragraphs that need to be fixed so that they fit the width of the pages in which they are located. Presently, the paragraphs are about 4 wide and all have the non-printing character at the end of each text line that looks like

Re: [libreoffice-users] Paragraph format problem

2012-02-09 Thread Dotan Cohen
On Fri, Feb 10, 2012 at 00:19, . pe...@aleksandrsolzhenitsyn.net wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a hundreds of paragraphs that need to be fixed so that they fit the width of the pages in which they are located. Presently, the paragraphs are about 4 wide and all

[libreoffice-users] Re: Basic Addon Builder

2012-02-09 Thread Tom
Hi :) You can always upload an attachment to Nabble to keep it with the thread and allow everyone to see it. It worked well in the first post in this thread. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Basic-Addon-Builder-tp3730282p3731113.html Sent

Re: [libreoffice-users] Basic Addon Builder

2012-02-09 Thread Beth Lesko
WooHoo! It's working now - the problem was I created the add on with an incomplete install of LibO on my Ubuntu! I fixed my install and used the BasicAddon creator to re-create it, so it is rendering perfectly in windows now. Thanks for all your help! Beth On Thu, Feb 9, 2012 at 5:23 PM, drew

Re: [libreoffice-users] Paragraph format problem

2012-02-09 Thread .
On 02/09/2012 05:32 PM, Dotan Cohen wrote: On Fri, Feb 10, 2012 at 00:19, . pe...@aleksandrsolzhenitsyn.net wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a hundreds of paragraphs that need to be fixed so that they fit the width of the pages in which they are located.

Re: [libreoffice-users] Paragraph format problem

2012-02-09 Thread Jay Lozier
On 02/09/2012 05:19 PM, . wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a hundreds of paragraphs that need to be fixed so that they fit the width of the pages in which they are located. Presently, the paragraphs are about 4 wide and all have the non-printing character at the end

Re: [libreoffice-users] Paragraph format problem

2012-02-09 Thread Jay Lozier
On 02/09/2012 05:46 PM, . wrote: On 02/09/2012 05:32 PM, Dotan Cohen wrote: On Fri, Feb 10, 2012 at 00:19, .pe...@aleksandrsolzhenitsyn.net wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a hundreds of paragraphs that need to be fixed so that they fit the width of the pages in

[libreoffice-users] Re: Restore Windows Dialogue Problems

2012-02-09 Thread Tom
Hi :) For Macs there is another way out of this but i can't remember it. Somewhere in the fairly recent archives are a couple of other solved threads about this. Apols and regards from Tom :) -- View this message in context:

[libreoffice-users] Re: Paragraph format problem

2012-02-09 Thread Ken Springer
On 2/9/12 3:19 PM, . wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a hundreds of paragraphs that need to be fixed so that they fit the width of the pages in which they are located. Presently, the paragraphs are about 4 wide and all have the non-printing character at the end of

Re: [libreoffice-users] Paragraph format problem

2012-02-09 Thread Calvin Kim
On 02/09/2012 05:46 PM, . wrote: On 02/09/2012 05:32 PM, Dotan Cohen wrote: On Fri, Feb 10, 2012 at 00:19, .pe...@aleksandrsolzhenitsyn.net wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a hundreds of paragraphs that need to be fixed so that they fit the width of the pages in

[libreoffice-users] Re: Restore Windows Dialogue Problems

2012-02-09 Thread Larry Gusaas
On 2012-02-05 4:23 PM Charles Bierwirth wrote: I'm running Libreoffice 3.4.5 on OSX Lion 10.7.2. Recently, I had to forcefully restart my computer. Since then, every time I open Libreoffice the Restore Windows dialogue pops up. See

Re: [libreoffice-users] Paragraph format problem

2012-02-09 Thread jomali
That won't help because the end-of-line indication is part of the structure, not the format of the document. I'm afraid the only way I've ever found to solve this problem is to put a second hard return at the end of each paragraph, do a find and replace of a double hard return, replacing it with

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

2012-02-09 Thread NoOp
On 01/31/2012 11:59 PM, Alex Thurgood wrote: Le 01/02/2012 05:20, NoOp a écrit : Hi, Have you with the stock 3.5RC2? No, I'm not being factitious or disrespectful... but you keep claiming that this all works with your own build from Master I'd appreciate an answer. It even works for

Re: [libreoffice-users] Paragraph format problem

2012-02-09 Thread Brian Barker
At 17:19 09/02/2012 -0500, Dottie Noname wrote: I have a hundreds of paragraphs that need to be fixed so that they fit the width of the pages in which they are located. Presently, the paragraphs are about 4 wide and all have the non-printing character at the end of each text line that looks

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Mark Stanton
In article 4f342906.5010...@nouenoff.nl, Cor Nouws wrote: If there are few available pictures to choose from, it could work with conditional hidden paragraphs. Only two pictures, a first class stamp or a second class stamp, according to whether the address is outside or inside the UK, so it's

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Mark Stanton
In article jh1c19$53k$1...@dough.gmane.org, Alex Thurgood wrote: Agreed, but can you set it up to make the paragraph as invisible depending on whether or not you have a varchar string ? No, that's not quite my question. There will *always* be a picture, and it is either a picture of a first