[libreoffice-users] Re: using fields in a text document
Le 25/06/11 00:53, lee a écrit : Hi Lee, If you want to look at using Python, try using the example TableSample.py and mailmerge.py which are included with your LibreOffice installation. Otherwise, there are several PHP classes and a PERL module that let you manipulate ODT/ODC documents to your heart's content. I mean if you are going to script your work and you don't want to learn Basic, you at least have several other ways of attaining the same objective. Alex -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Error saving LibreOffice Documents under MacOSX 10.7
Le 25/06/11 18:30, Mark Byrn a écrit : Hi Mark, Same problem here and using latest Mac OS X Lion 10.7 beta (build 11A494A) - no matter what format you try to save it in, the same error occurs. Error saving the document...testfile.odt is not a file where testfile.odt was just an example name. The same errors occurs when using the export feature. ` If you are not already on it, please add your comments to the bug issue I posted in my previous response. Alex -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: BASE: bug in table designer
Le 24/06/11 21:37, Tom Cloyd a écrit : Hi Tom, Thanks for this thorough investigation of the behavior I described. I'm glad it was replicated. I don't think this problem is (for me anyway) much of an impediment, but I HAVE noticed other problems with default values. To wit: default values set up in the table designer, do not appear in forms when a new record is created and the table field is linked to list box. The list box display remains blank. This happens if the default value is in the table, OR if it's set in the list box properties. Neither has any effect in the form, not even when the table/view browser (press F4 to get this) is active. Known behaviour, and this is actually currently by design (well it was designed by the people at Oracle). The table/field creation functionality does not transmit default values to the underlying database, you are supposed to use a corresponding form for this and define the default there rather than at the database level. This was done because it was felt it was too difficult (i.e. developer time intensive) for OOo to be able to manage all of the possible driver return handling for all of the various possible database connections out there. However, it does appear that even the form based default setting of values does not work as intended, i.e. the values are not necessarily passed from the form to the underlying db...File a bug, if you like, but I'm pretty sure one has been filed already. Alex -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: BASE: bug in table designer
Hi :) I seem to be given credit for doing a thorough investigation in the quoting. Obviously i'm not unhappy with that! lol. The right person was thanked at the time but i can't remember who that was. Several good names spring to mind. Regards from Tom :) - Original Message From: Alexander Thurgood alex.thurg...@gmail.com To: users@global.libreoffice.org Sent: Sat, 25 June, 2011 23:17:17 Subject: [libreoffice-users] Re: BASE: bug in table designer Le 24/06/11 21:37, Tom Cloyd a écrit : Hi Tom, Thanks for this thorough investigation of the behavior I described. I'm glad it was replicated. I don't think this problem is (for me anyway) much of an impediment, but I HAVE noticed other problems with default values. To wit: default values set up in the table designer, do not appear in forms when a new record is created and the table field is linked to list box. The list box display remains blank. This happens if the default value is in the table, OR if it's set in the list box properties. Neither has any effect in the form, not even when the table/view browser (press F4 to get this) is active. Known behaviour, and this is actually currently by design (well it was designed by the people at Oracle). The table/field creation functionality does not transmit default values to the underlying database, you are supposed to use a corresponding form for this and define the default there rather than at the database level. This was done because it was felt it was too difficult (i.e. developer time intensive) for OOo to be able to manage all of the possible driver return handling for all of the various possible database connections out there. However, it does appear that even the form based default setting of values does not work as intended, i.e. the values are not necessarily passed from the form to the underlying db...File a bug, if you like, but I'm pretty sure one has been filed already. Alex -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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] Page Format
Hi On Fri, 2011-06-24 at 20:42 -0700, badaveil wrote: Firstly, the default paper format is Letter but I want it set to A4 so that every time I open the text document, it automatically sets paper format to A4. Secondly, the default page margin is 0.79inch but I want it set to 1 inch so that every time I open the text document, it automatically sets the margin format to 1 inch for left, right, top and bottom. Please advice. -- View this message in context: http://nabble.documentfoundation.org/Page-Format-tp3107071p3107071.html Sent from the Users mailing list archive at Nabble.com. One way is to open the default using FILETEMPLATESEDIT and select the default.ott. Edit (below) the file and save to overwrite the original. To change the default settings for margins, paper size FORMATPAGE and set the values for margins to what you want and select the default paper size. -- Jay Lozier jsloz...@gmail.com -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: using fields in a text document
Am 25.06.2011 00:53, schrieb lee: Hello Lee Friederdelo...@googlemail.com writes: [...] ther is a Basic example for a macro to export to PDF its not clean code, but it should work: [...] if you want I can translate this code in clean code without using the dispatcher Hm, I just tried out the macro recorder and recorded a macro that exports my document as PDF. It looks very much like the one you posted. It even stores the permissions password I entered in readable form. Yes I also did it with the macro recorder, but I can translate it to better code if you want (the dispatcher is not reliable ). It strikes me odd that I shall have to learn another programming language to do something this simple ... What programming languages do you know? You can write macros in Basic, Python , JavaScript , and even in C, C++ ,Java and some more ,if you know how to call the Uno API . But Basic is really simple. (No useless bracket for example. And how to write a for loop or something similar easy is not hard to learn in any language.) The Problem is how to use the Uno API no mater programming language you prefer. (...) Hm. I have created a database to use instead of a spreadsheet. When I'm trying to mail the document to myself as PDF, I can specify Properties in the mailmerge wizard. There I could apparently add a text message so that the PDF is sent as an attachment to it. I could use that to mail the PDF documents to myself with the reference number in the text part for easy further processing, or I might even be able to send them without any further processing. Unfortunately, LO crashes when I try to send the message: , | X Error: BadMatch (invalid parameter attributes) 8 | Major opcode: 42 (X_SetInputFocus) | Resource id: 0x5001822 | # | # A fatal error has been detected by the Java Runtime Environment: | # | # SIGSEGV (0xb) at pc=0x7f2cabeb5751, pid=21389, tid=139829845436192 | # | # JRE version: 6.0_18-b18 | # Java VM: OpenJDK 64-Bit Server VM (16.0-b13 mixed mode linux-amd64 ) | # Derivative: IcedTea6 1.8.7 | # Distribution: Debian GNU/Linux unstable (sid), package 6b18-1.8.7-4 Have you tried it with a stable Version | # Problematic frame: | # C [libuno_sal.so.3+0x43751] rtl_uString_release+0x1 | # | # An error report file with more information is saved as: | # /home/lee/hs_err_pid21389.log | # | # If you would like to submit a bug report, please include | # instructions how to reproduce the bug and visit: | # http://icedtea.classpath.org/bugzilla | # | | [error occurred during error reporting , id 0xb] ` This seems to be Java problem, and not a LO bug. regards Frieder -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Command line (convert) parameter(s)
Hi :) I think it might be the file-name pdf that might be wrong? Try ls or dir to check the file-name. I suspect the correct file-name is either .pdf or pdf.pdf Regards from Tom :) From: lee l...@yun.yagibdah.de To: users@global.libreoffice.org Sent: Sat, 25 June, 2011 3:03:04 Subject: Re: [libreoffice-users] Re: Command line (convert) parameter(s) NoOp gl...@sbcglobal.net writes: On 06/22/2011 02:33 AM, Stephan Zietsman wrote: --convert-to output_file_extension[:output_filter_name] [-outdir ouput_dir] files Batch convert files. If -outdir is not specified then current working dir is used as output_dir. Eg. -convert-to pdf *.doc -convert-to pdf:writer_pdf_Export -outdir /home/user *.doc This doesn't work: , | lee@yun:~/tmp$ libreoffice --headless --convert-to pdf test.odt ` ... pops up a dialogue box saying /home/lee/tmp/pdf does not exist. Please note the --headless option; it's another bug that it pops up a dialogue box nonetheless. Please note that in the example, it's -convert-to. So what should it be, --convert-to or -convert-to? -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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][windows] Page Format
This is the very first thing I changed - but you do need a work around tools options LibreOffice Writer General change Measurement to Inch and change Tab Stops to 0.5 View Both Horizontal Vertical rulers should now say Inch There are unfortunately 2 problems you are now faced with 1) There are no default page settings (there should be, but there isn't) So you need to click out of Options and go back to your default page Change your page settings to as you choose (1 A4) then save as a template - as a test I saved as one inch.ott Close down the document. and you should be back to the front page. now click on File Recent Documents one inch - which is as good as I could get this work around. If you now try to save the page, save is blanked out (which is good) forcing you now save as your new name new doc_1.odt - do not forget to change it from *.ott to *.odt (the default should come up as *.odt, but comes up as *.ott which is bad) as you do not want to save every document as a template when you are in a hurry. Aside:- I did try to open the one inch template from within File new templates docs Now whilst it could see one inch only by by clicking on organise but I could find no way to open it - which is the 2nd problem if you want to open it this way, you will always have to use Recent Documents John B - On 25/06/2011 04:42, badaveil wrote: Firstly, the default paper format is Letter but I want it set to A4 so that every time I open the text document, it automatically sets paper format to A4. Secondly, the default page margin is 0.79inch but I want it set to 1 inch so that every time I open the text document, it automatically sets the margin format to 1 inch for left, right, top and bottom. Please advice. -- View this message in context: http://nabble.documentfoundation.org/Page-Format-tp3107071p3107071.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Command line (convert) parameter(s)
Hi :) The error message is very specific. It says /home/lee/tmp/pdf does not exist which means there is no file called pdf in the /home/lee/tmp folder. Maybe he has missed the ending of the file-name. Or maybe he is looking in the wrong folder. Regards from Tom :) From: Nuno J. Silva nunojsi...@ist.utl.pt To: users@global.libreoffice.org Sent: Sat, 25 June, 2011 12:06:54 Subject: Re: [libreoffice-users] Re: Command line (convert) parameter(s) On 2011-06-25, Tom Davies wrote: lee l...@yun.yagibdah.de wrote: NoOp gl...@sbcglobal.net writes: --convert-to output_file_extension[:output_filter_name] [-outdir ouput_dir] files This doesn't work: , | lee@yun:~/tmp$ libreoffice --headless --convert-to pdf test.odt ` ... pops up a dialogue box saying /home/lee/tmp/pdf does not exist. [...] I think it might be the file-name pdf that might be wrong? Try ls or dir to check the file-name. I suspect the correct file-name is either .pdf or pdf.pdf According to the documentation NoOp quoted, the pdf is supposed to be just the extension. -- Nuno J. Silva (aka njsg) gopher://sdf-eu.org/1/users/njsg -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Command line (convert) parameter(s)
Tom Davies tomdavie...@yahoo.co.uk writes: The error message is very specific. It says /home/lee/tmp/pdf does not exist which means there is no file called pdf in the /home/lee/tmp folder. Maybe he has missed the ending of the file-name. Or maybe he is looking in the wrong folder. The message is even correct, only that's besides the point considering what I was telling LO to do :) -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: using fields in a text document
Twayne twa...@twaynesdomain.com writes: In news:87iprv49kt@yun.yagibdah.de, lee l...@yun.yagibdah.de typed: John B jo...@email2.me writes: The mailmerge tool requires an address list, which is something I don't have and don't want to create in this case. Without a maling list data file you pretty much limit yourself out of a very easy process. Somehow you've not been clear with your message or you don't understand somethng IMO. You're right in that I can't use the mailmerge tool without some sort of list providing the data I need to insert into the document, since that's the way the tool is supposed to work. If it would work, I could use it. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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] using fields in a text document
Steven Shelton ste...@sheltonlegal.net writes: I do *some* of that on a regular basis in my law office, since I send out a lot of letters that are virtually identical (Dear TITLE FIRSTNAME LASTNAME, This letter is to remind you that your HEARING_TYPE is scheduled to take place on HEARING_DATE at HEARING_TIME before Judge JUDGENAME . . .). What I ended up doing is just putting a blank page at the beginning of the document where I list all the variables, then I just fill them in there. How exactly do you do that? I tried to find something about this in the documentation without success. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: using fields in a text document
Frieder delo...@googlemail.com writes: Am 25.06.2011 00:53, schrieb lee: Yes I also did it with the macro recorder, but I can translate it to better code if you want (the dispatcher is not reliable ). Exporting to PDF has turned out to be unreliable in LO, too. It strikes me odd that I shall have to learn another programming language to do something this simple ... The Problem is how to use the Uno API no mater programming language you prefer. True --- is there a good documentation about it? Hm. I have created a database to use instead of a spreadsheet. When I'm trying to mail the document to myself as PDF, I can specify Properties in the mailmerge wizard. There I could apparently add a text message so that the PDF is sent as an attachment to it. I could use that to mail the PDF documents to myself with the reference number in the text part for easy further processing, or I might even be able to send them without any further processing. Unfortunately, LO crashes when I try to send the message: Have you tried it with a stable Version No, I only tried the version that is in Debian testing. Libreoffice is not in Debian stable. LO 3.3.3 is in unstable. I could try to install it, only it probably has so many dependencies that it isn't advisable. | # Problematic frame: | # C [libuno_sal.so.3+0x43751] rtl_uString_release+0x1 | # | # An error report file with more information is saved as: | # /home/lee/hs_err_pid21389.log | # | # If you would like to submit a bug report, please include | # instructions how to reproduce the bug and visit: | # http://icedtea.classpath.org/bugzilla | # | | [error occurred during error reporting , id 0xb] ` This seems to be Java problem, and not a LO bug. There seem to be two bugs, one with using the mailmerge tool and another one with reporting the bug. Anyway, they shouldn't use java for LO. It doesn't really matter what the problem is, it's just not working, and one bug after another turns up. After having learned a little about LO, it seems to be still in a beta stage, and I need something that does work. It's sad that there has been only very little progress in the reliability of WYSIWYG word processors over the last 15--20 years. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Command line (convert) parameter(s)
Tom Davies tomdavie...@yahoo.co.uk writes: Ahah. Ok, have you tried a single - as well as a doubled one -- ? Did that just confuse it so that it outputs the quick help thing again? or did it just appear to do nothing? Always top-posting ... No, I haven't tried a single - because that won't make sense. There's no single - with options that have a - in their names. Well, I just tried, and it works. Still either the help text or the option needs to be fixed, and that --headless doesn't do what it's supposed to as well ... -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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] Page Format
Planas has a much better Idea than mine And it sorts out the default saving problems (it auto defaults to .odt) in Commands, You can even click on your named template and a new field appears as set as default template And - don't be afraid, as a new click field in commands also appears reset to default I will now use this myself from now on Whilst my method might be 1 click quicker, the below method is by far better. John On 25/06/2011 07:05, planas wrote: Hi On Fri, 2011-06-24 at 20:42 -0700, badaveil wrote: Firstly, the default paper format is Letter but I want it set to A4 so that every time I open the text document, it automatically sets paper format to A4. Secondly, the default page margin is 0.79inch but I want it set to 1 inch so that every time I open the text document, it automatically sets the margin format to 1 inch for left, right, top and bottom. Please advice. -- View this message in context: http://nabble.documentfoundation.org/Page-Format-tp3107071p3107071.html Sent from the Users mailing list archive at Nabble.com. One way is to open the default using FILETEMPLATESEDIT and select the default.ott. Edit (below) the file and save to overwrite the original. To change the default settings for margins, paper size FORMATPAGE and set the values for margins to what you want and select the default paper size. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: using fields in a text document
On 25/06/2011 14:07, lee wrote: Friederdelo...@googlemail.com writes: Am 25.06.2011 00:53, schrieb lee: Yes I also did it with the macro recorder, but I can translate it to better code if you want (the dispatcher is not reliable ). Exporting to PDF has turned out to be unreliable in LO, too. It strikes me odd that I shall have to learn another programming language to do something this simple ... The Problem is how to use the Uno API no mater programming language you prefer. True --- is there a good documentation about it? Hm. I have created a database to use instead of a spreadsheet. When I'm trying to mail the document to myself as PDF, I can specify Properties in the mailmerge wizard. There I could apparently add a text message so that the PDF is sent as an attachment to it. I could use that to mail the PDF documents to myself with the reference number in the text part for easy further processing, or I might even be able to send them without any further processing. Unfortunately, LO crashes when I try to send the message: Have you tried it with a stable Version No, I only tried the version that is in Debian testing. Libreoffice is not in Debian stable. LO 3.3.3 is in unstable. I could try to install it, only it probably has so many dependencies that it isn't advisable. | # Problematic frame: | # C [libuno_sal.so.3+0x43751] rtl_uString_release+0x1 | # | # An error report file with more information is saved as: | # /home/lee/hs_err_pid21389.log | # | # If you would like to submit a bug report, please include | # instructions how to reproduce the bug and visit: | # http://icedtea.classpath.org/bugzilla | # | | [error occurred during error reporting , id 0xb] ` This seems to be Java problem, and not a LO bug. There seem to be two bugs, one with using the mailmerge tool and another one with reporting the bug. Anyway, they shouldn't use java for LO. It doesn't really matter what the problem is, it's just not working, and one bug after another turns up. After having learned a little about LO, it seems to be still in a beta stage, and I need something that does work. It's sad that there has been only very little progress in the reliability of WYSIWYG word processors over the last 15--20 years. --- I am with you on this (excluding Lotus Word Pro), frustration I have tried the mailmerge facility in LO and I as yet cannot get anywhere with it. Having got to insert address block which on my system is greyed out. I have made a small data base Select Address List create Then entered some dummy names and addresses, then click ok and saved as a csv file then clicked on the file name, then OK on the window box (which took a few clicks to appear - minor bug) Then nothing - the Finish button is still greyed out - Big Bug regards John B -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: using fields in a text document
Am 25.06.2011 15:07, schrieb lee: Friederdelo...@googlemail.com writes: Am 25.06.2011 00:53, schrieb lee: Yes I also did it with the macro recorder, but I can translate it to better code if you want (the dispatcher is not reliable ). Exporting to PDF has turned out to be unreliable in LO, too. do you men the Macro you produced with the macro recorder ? The macro recorder uses the dispatcher, and the dispatcher is not reliable as I already mentioned. It strikes me odd that I shall have to learn another programming language to do something this simple ... The Problem is how to use the Uno API no mater programming language you prefer. True --- is there a good documentation about it? Yes there is: http://wiki.services.openoffice.org/wiki/Category:Tutorial and specially the export to pdf: http://wiki.services.openoffice.org/wiki/API/Tutorials/PDF_export Hm. I have created a database to use instead of a spreadsheet. When I'm trying to mail the document to myself as PDF, I can specify Properties in the mailmerge wizard. There I could apparently add a text message so that the PDF is sent as an attachment to it. I could use that to mail the PDF documents to myself with the reference number in the text part for easy further processing, or I might even be able to send them without any further processing. Unfortunately, LO crashes when I try to send the message: Have you tried it with a stable Version No, I only tried the version that is in Debian testing. Libreoffice is not in Debian stable. LO 3.3.3 is in unstable. I could try to install it, only it probably has so many dependencies that it isn't advisable. maybe you should try another distribution like Suse, Fedora or Ubuntu (but don't try the Unity desktop its terrible. Use the XFCE desktop(Xubuntu) instead, it is similar to Gnome2 but much lighter and faster) . The problem with Debian is, that the stable version is to old, and the testing and unstable is to unstable. | # Problematic frame: | # C [libuno_sal.so.3+0x43751] rtl_uString_release+0x1 | # | # An error report file with more information is saved as: | # /home/lee/hs_err_pid21389.log | # | # If you would like to submit a bug report, please include | # instructions how to reproduce the bug and visit: | # http://icedtea.classpath.org/bugzilla | # | | [error occurred during error reporting , id 0xb] ` This seems to be Java problem, and not a LO bug. There seem to be two bugs, one with using the mailmerge tool and another one with reporting the bug. Anyway, they shouldn't use java for LO. but there is still a lot of Java code in LO. They are working hard to translate it into C++ code, but it will take a while. It doesn't really matter what the problem is, it's just not working, and one bug after another turns up. After having learned a little about LO, it seems to be still in a beta stage, and I need something that does work. It's sad that there has been only very little progress in the reliability of WYSIWYG word processors over the last 15--20 years. The LO code contains about 600 lines of code. it is not easy to think of all the functions, if you ad some new code. So some bugs are unavoidable. Regards Frieder -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Command line (convert) parameter(s)
On Sat, 25 Jun 2011 13:58:14 +0200, lee wrote: Tom Davies tomdavie...@yahoo.co.uk writes: The error message is very specific. It says /home/lee/tmp/pdf does not exist which means there is no file called pdf in the /home/lee/tmp folder. Maybe he has missed the ending of the file-name. Or maybe he is looking in the wrong folder. The message is even correct, only that's besides the point considering what I was telling LO to do :) The problem is the OP used double hyphens, when LO requires a single hyphen, even for long options. $ libreoffice -headless -convert-to pdf foo.odt works fine. -jh -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Command line (convert) parameter(s)
On 2011-06-25, Jonathan) {$@(R.)daria.co.uk (Hudson wrote: On Sat, 25 Jun 2011 13:58:14 +0200, lee wrote: Tom Davies tomdavie...@yahoo.co.uk writes: The error message is very specific. It says /home/lee/tmp/pdf does not exist which means there is no file called pdf in the /home/lee/tmp folder. Maybe he has missed the ending of the file-name. Or maybe he is looking in the wrong folder. The message is even correct, only that's besides the point considering what I was telling LO to do :) The problem is the OP used double hyphens, when LO requires a single hyphen, even for long options. $ libreoffice -headless -convert-to pdf foo.odt works fine. I've seen this described with one and two hyphens. Here, GNU/Linux, help text shows only one hyphen. But if I'm understanding the code (also see a message in the developers list about the change[1]), the idea is to move long options to --. The code (in the source tree) currently recognizes both ways (one dash and two dashes), and just warns the one-dash way is deprecated: ,[desktop/source/app/cmdlineargs.cxx, line 648] | if (bDeprecated) | /* ... */ | fprintf(stderr, Warning: %s is deprecated. Use -%s instead.\n, sArg.getStr(), sArg.getStr()); ` Also, here is the detection code (comments are mine, they're not in the code): ,[desktop/source/app/cmdlineargs.cxx, line 417] | bool bDeprecated = false; | | // If this is a long option (starts with two dashes) ... | if (aArg.matchIgnoreAsciiCaseAsciiL(RTL_CONSTASCII_STRINGPARAM(--))) | { | // ... ignore the dashes. | oArg = ::rtl::OUString(aArg.getStr()+2, aArg.getLength()-2); | } | | // Long options starting with a single dash are deprecated | else if (aArg.toChar() == '-') | { | // For now, ignore the dash and accept the argument, but | // register the deprecated use (user will be warned later). | bDeprecated = true; | oArg = ::rtl::OUString(aArg.getStr()+1, aArg.getLength()-1); | } ` [I've not updated the source recently, so this is some days old. If there were changes to the file, line numbers may have changed.] Now I don't know if this is the code was used for the current builds. At least LibreOffice 3.3.3 here does not recognize two dashes for long options, and does not warn about single dash being deprecated. If it isn't used for lee's build, it explains the error -- Tom is right, I guess lee's LibO just ignored --convert-to and used pdf as a filename to open. Lee, try with only one dash. (Yes, I'd not expect only a single dash for long options, but it seems that this was, until recently, the way LibO/OOo did it.) [1] http://permalink.gmane.org/gmane.comp.documentfoundation.libreoffice.devel/4529 -- Nuno J. Silva (aka njsg) gopher://sdf-eu.org/1/users/njsg -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Error saving LibreOffice Documents under MacOSX 10.7
Same problem here and using latest Mac OS X Lion 10.7 beta (build 11A494A) - no matter what format you try to save it in, the same error occurs. Error saving the document...testfile.odt is not a file where testfile.odt was just an example name. The same errors occurs when using the export feature. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: using fields in a text document
Frieder delo...@googlemail.com writes: Am 25.06.2011 15:07, schrieb lee: Friederdelo...@googlemail.com writes: Am 25.06.2011 00:53, schrieb lee: The Problem is how to use the Uno API no mater programming language you prefer. True --- is there a good documentation about it? Yes there is: http://wiki.services.openoffice.org/wiki/Category:Tutorial and specially the export to pdf: http://wiki.services.openoffice.org/wiki/API/Tutorials/PDF_export Ah, thanks :) Unfortunately, LO crashes when I try to send the message: Have you tried it with a stable Version No, I only tried the version that is in Debian testing. Libreoffice is not in Debian stable. LO 3.3.3 is in unstable. I could try to install it, only it probably has so many dependencies that it isn't advisable. maybe you should try another distribution like Suse, Fedora or Ubuntu (but don't try the Unity desktop its terrible. No way, I'm not going to dump my perfectly working system just to be able to run a more recent version of some software. I could probably download the latest sources and compile them myself, but I don't feel inclined to go to much effort to get a broken word processing software to work. I'd probably only find either the same bugs or new ones. The problem with Debian is, that the stable version is to old, and the testing and unstable is to unstable. That's not true. Stable can be old, and as long as it does what you need it to, it isn't too old. Testing isn't unstable at all. I haven't tried unstable or experimental except for a few packages every now and then I needed a more recent version of. Anyway, they shouldn't use java for LO. but there is still a lot of Java code in LO. They are working hard to translate it into C++ code, but it will take a while. It's good to hear that they are working on removing it :) It doesn't really matter what the problem is, it's just not working, and one bug after another turns up. After having learned a little about LO, it seems to be still in a beta stage, and I need something that does work. It's sad that there has been only very little progress in the reliability of WYSIWYG word processors over the last 15--20 years. The LO code contains about 600 lines of code. it is not easy to think of all the functions, if you ad some new code. So some bugs are unavoidable. It comes down to that beyond a certain point, the effort that needs to be put into making it easier to achieve a particular result exceeds the effort that must be put into achieving the particular result. In this case, unfortunately I've reached that point. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: using fields in a text document
John B jo...@email2.me writes: I have tried the mailmerge facility in LO and I as yet cannot get anywhere with it. Hm, it's not too difficult to get to the point where you could finally save, print or send your documents. Just make sure that there are no unmatched fields. As someone described, you can even drag and drop fields from a database into your document. I could use mailmerge if it would reliably send the documents rather than sometimes say 0 of 0 messages sent despite there are two messages to be sent --- and if the PDF created that way wasn't messed up. And it would even be really useful if changing the properties when sending documents as PDF would work rather than crash LO. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: using fields in a text document
Hi :) It might be a good time to file a bug-report about the pdf properties issue http://wiki.documentfoundation.org/BugReport Regards from Tom :) From: lee l...@yun.yagibdah.de To: users@global.libreoffice.org Sent: Sat, 25 June, 2011 20:32:18 Subject: Re: [libreoffice-users] Re: using fields in a text document John B jo...@email2.me writes: I have tried the mailmerge facility in LO and I as yet cannot get anywhere with it. Hm, it's not too difficult to get to the point where you could finally save, print or send your documents. Just make sure that there are no unmatched fields. As someone described, you can even drag and drop fields from a database into your document. I could use mailmerge if it would reliably send the documents rather than sometimes say 0 of 0 messages sent despite there are two messages to be sent --- and if the PDF created that way wasn't messed up. And it would even be really useful if changing the properties when sending documents as PDF would work rather than crash LO. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: using fields in a text document
Am 25.06.2011 21:32, schrieb lee: Hi Lee John Bjo...@email2.me writes: I have tried the mailmerge facility in LO and I as yet cannot get anywhere with it. Hm, it's not too difficult to get to the point where you could finally save, print or send your documents. Just make sure that there are no unmatched fields. As someone described, you can even drag and drop fields from a database into your document. I could use mailmerge if it would reliably send the documents rather than sometimes say 0 of 0 messages sent despite there are two messages to be sent --- and if the PDF created that way wasn't messed up. And it would even be really useful if changing the properties when sending documents as PDF would work rather than crash LO. If you are still interested in a reliable macro that can export to PDF with a password I have coded some lines for You: (StarBasic code) sub export_pdf_with_password odoc=ThisComponent.CurrentController.Frame sURL = file:///C:/Users/Nansen/Documents/RundschreibenTest0096.pdf 'variable to hold the Path dim args1(5) as new com.sun.star.beans.PropertyValue 'args1(0).Name = UseTaggedPDF 'args1(0).Value= true args1(0).Name = ExportFormFields 'just schow the contens of the Form.Filds args1(0).Value= false args1(1).Name = Printing ' you don't need that. args1(1).Value= 2 args1(2).Name = RestrictPermissions 'If true, selects to restrict some permissions. The permissions can be changed only when the user enters the correct password. args1(2).Value= true args1(3).Name = PermissionPassword args1(3).Value= www2 'coud be a variable args1(4).Name = EncryptFile 'If true, selects to encrypt the PDF document with a password. The PDF file can be opened only when the user enters the correct password. args1(4).Value= true args1(5).Name = DocumentOpenPassword args1(5).Value= www 'coud be a variable 'here you can enter some more options from the http://wiki.services.openoffice.org/wiki/API/Tutorials/PDF_export if you want dim args2(2) as new com.sun.star.beans.PropertyValue args2(0).Name = FilterName args2(0).Value = writer_pdf_Export args2(1).Name = FilterData args2(1).Value = args1 thisComponent.storeToURL(sURL,args2()) end sub I have done a complete solution for your hole problem (not totally complete jett). I used a database (instead of a Calc file) . I can send the solution to you but I think you have to reconnect the Writer-document and the Database on your computer. Regards Frieder -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: using fields in a text document
Hi :) I have been wondering about trying to run a more stable version of LO on Debian. Can Debian run PPA repos from Ubuntu? or is that a bit hitmiss due to differences within the Debian family? Even if you are not able to get the 3.3.3 or 3.3.2 from the Debian repos the untweaked debs from the LO/TDF website might be an improvement on what you have now. There are instructions on the wiki for installing more than 1 version of LO/OOo at a time so that you can test without throwing away anything that you have set-up so far. I don't know if that is a good route tho? Regards from Tom :) -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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