Re: [libreoffice-users] Re: Printer always selects PDF instead of Postscript
On Thu, 02 Feb 2012 01:31:47 -0500 Jay Lozier jsloz...@gmail.com dijo: On 02/01/2012 05:45 PM, TJ wrote: On 01/25/2012 01:56 PM, Don C. Myers wrote: I'm using LibreOffice 3.4.4 from the Mageia 1 repositories with KDE, trying to print to a Deskjet 5650 printer, and I'm having problems with this, too. My problem is related to that experienced by the Arch user in your second link, in that landscape -oriented spreadsheets from Calc aren't printing properly - to say the least. Mine prints fine until it gets to the 8.5 inch mark, then it prints a truncated version of the last column over and over until the edge of the paper. Print Preview looks fine, and while I haven't tried it yet I suspect printing to a pdf file would work, too. Changing the printer language to Postscript fixes it. I haven't noticed the problem with other applications yet, but then I don't print much as a regular rule, just this time of year. I didn't have the problem last year, when I was using Mandriva 2010.2 and OpenOffice. I can try to remember to change the printer language on every document I make in the future, but like Mr. Jordan I think it's a pain in the butt to remember to change it if I go to print old documents. I tried running spadmin as root to change the default, but for some reason Mageia wouldn't do it. Probably just as well, as I'm very much out of my element when it comes to command line noodling. It shouldn't have to be that way, anyway. There should be an easy way to make Postscript the default, if you want. I have not noticed any problems printing from Linux Mint 12. I would check the default printer settings and test the printer with another non-LO program to see if the problem is with the printer set up. The printer could be set up to default everywhere to pdf not to postscript. Let me clarify a few things. I first noticed this when printing to a Laserjet 4M+. I also have a 5SiMx, an 8000DN, and a Xerox Phaser 7400DN. The problem happens with most of them. And I have several printers installed for each physical printer, and it doesn't matter which one I select. I always get text with the font metrics messed up. This problem does not occur with any other program. This includes Abiword, Kword, Gedit, and Scribus - the usual programs I use for printing text. It did not occur with OpenOffice.org. I do not know if OOo used the same default to PDF as LibreOffice, and I cannot easily check because it is no longer installed. I could wipe out Fedora 16 and install Linux Mint, but the last time I changed distros it took almost a week to get everything reinstalled and reconfigured back the way I had it. I have a zillion programs installed, some of which took hours of tweaking to get them running. And I require these programs for my work. So, for now at least, I'm stuck with Fedora 16. Besides, I don't think the problem is in Fedora. From reading others' responses it appears that all we need to do is change the default from PDF to Postscript. I should add that just today I discovered another problem. I needed to print six copies of a one-page document (to give a paper copy to six different people). I remembered to check Postscript, but when the copies came out of the printer copy 2 was on the back of copy 1, copy 4 on the back of copy 3, and copy 6 on the back of copy 5. The only ways I can find to stop this behavior were to print one copy and click on the Print button six times, or disable the duplexer in the printer and try to remember to re-enable it afterward. LAME. But I will post this under another thread later. It's time for bed. -- 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: How get LibreO-Base working?
On 01/02/2012 19:51, Andreas Säger wrote: Am 01.02.2012 19:36, Pertti Rönnberg wrote: All of you. Thanks very much for your kindness to bother answering - and for the very interesting discussions. My conclusion is that LO-Base (and OO-Base ?) is not yet - and perhaps will not be as mentioned in the desciption at LO-Wikipedia: A database management program http://en.wikipedia.org/wiki/Database_management_program, similar to Microsoft Access .. etc http://en.wikipedia.org/wiki/Microsoft_Access. The difference amounts to a multi-million Dollar budget and a decade of development. OOo Base was maintained by 2 Sun/Oracle employees. It is similar to Access. Access is named Access because you can access databases with it. In *addition* Access provides the JET database engine which embeds a database backend in the frontend file. Unfortunately, most people work with JET which is why Access has a bad reputation among professionals. I've seen very nice Access frontends for MySQL databases. We use LO base and MySQL also with very nice results :-) Base connects ODF documents with databases. In *addition* it can embed a HSQLDB into the frontend file which is basically a zip archive with configuration and Writer documents. Unfortunately, most people use the embedded HSQLDB which is why Base has such a bad reputation. If you ever had created some relational database backend using any database specific, mature tool for the database, you would acknowledge how straight-forward Base connects your database with this office suite. Simply do your database with a database program. Base is not a database program. -- 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: how to create mailmerge with libre base only without using libre calc.
Hi :) Should someone put those links on the documentation page? http://wiki.documentfoundation.org/Documentation/Publications It would be really nice if people would just update that page so that everyone can see the content improving. I can tidy up formatting if required so don't worry about making a mess. What i can't do is find good content. There is so much junk out there that's its difficult to spot the jems that are worth linking to. Regards from Tom :) --- On Thu, 2/2/12, Alex Thurgood alex.thurg...@gmail.com wrote: From: Alex Thurgood alex.thurg...@gmail.com Subject: [libreoffice-users] Re: how to create mailmerge with libre base only without using libre calc. To: users@global.libreoffice.org Date: Thursday, 2 February, 2012, 7:32 Le 02/02/2012 02:04, sonic a écrit : Hi Sonic, Dear BRO, SIR,SIS, May I know is there any other alternative ways to create mail merge with libre base and generate report from libre base without opening other program like libre writer or libre calc to do it.. which mean that , want to using 1 program only to do all the job that's libre base . Short answer : for mailmerge, no. You must use Base in combination with Writer If you want a report, you can : (1) use the Oracle Report Builder, which is a built-in extension, accessible, for example, via a Base (ODB) file ; (2) use a Calc file and design your own report using data ranges; (3) use a Writer file, and insert your data fields from the table or query of your choice ; (4) write an external program using python, javascript, beanshell, perl, php, etc to manipulate ODF compliant XML and interface that with your datasource. If there any tutorial or suggestion pls do let me know tQ your's help are much appreciated... Information and tutorials for manipulating ODF XML : http://stackoverflow.com/questions/3477597/how-to-generate-odf-charts-with-perl http://search.cpan.org/~jmgdoc/OpenOffice-OODoc-2.125/OODoc/Intro.pod http://cpanforum.com/threads/3039 http://www.opendocsociety.org/tools/odf-tools/ http://letscript.wordpress.com/2011/09/30/from-mysql-to-opendocument-format-with-perl/ Information about using Calc or the Report Builder to make reports : http://wiki.services.openoffice.org/wiki/SUN_Report_Builder/Documentation http://user.services.openoffice.org/en/forum/viewtopic.php?f=75t=18511 http://user.services.openoffice.org/en/forum/viewtopic.php?f=100t=23727 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 -- 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: Printer always selects PDF instead of Postscript
Hi :) When i upgrade my OS i keep the existing one working and just set a new partition for the new one. Generally for me it's a 3 step process 1. Create a largish partition, say 20Gb for something bloated (like Ubuntu, Mint, Fedora, openSUSE etc) (err bloat = more functionality built-in so it's not always bad). Install the new thing with it's /home on the same partition. Test it, update it, tweak and play around and perhaps even make a complete mess of it. After install i set the boot-menu to default to my working distro not the one i am test-driving. 2. Install to an old tiny partition but during install set /home to use my vast partition (relatively). Again set the boot-menu to my older but fully functioning distro that i am familiar with. 3. When i am happy about the new one i switch the boot-menu to the newer one. So, i always default into something i know works well enough for me and familiar enough that i can meet deadlines without having to deal with unexpected surprises, well mostly. I have even managed to do this with Windows but GnuLinux tends to make it easy or even wants to do it that way by default. Back when i was a bit of a distro-hopper i sometimes had to scavenge hard-drives from old 'dead' machines in order to get space for a new partition. Even the most bloated distro can fit on ancient crumbling drives that no respectable person would normally consider using. Hmm, well i do have a 100 MB hard-drive somewhere and a 1 or 2Gb one but they are really museum pieces. Regards from Tom :) --- On Thu, 2/2/12, John Jason Jordan joh...@comcast.net wrote: From: John Jason Jordan joh...@comcast.net Subject: Re: [libreoffice-users] Re: Printer always selects PDF instead of Postscript To: users@global.libreoffice.org Date: Thursday, 2 February, 2012, 7:18 On Thu, 02 Feb 2012 01:31:47 -0500 Jay Lozier jsloz...@gmail.com dijo: On 02/01/2012 05:45 PM, TJ wrote: On 01/25/2012 01:56 PM, Don C. Myers wrote: I'm using LibreOffice 3.4.4 from the Mageia 1 repositories with KDE, trying to print to a Deskjet 5650 printer, and I'm having problems with this, too. My problem is related to that experienced by the Arch user in your second link, in that landscape -oriented spreadsheets from Calc aren't printing properly - to say the least. Mine prints fine until it gets to the 8.5 inch mark, then it prints a truncated version of the last column over and over until the edge of the paper. Print Preview looks fine, and while I haven't tried it yet I suspect printing to a pdf file would work, too. Changing the printer language to Postscript fixes it. I haven't noticed the problem with other applications yet, but then I don't print much as a regular rule, just this time of year. I didn't have the problem last year, when I was using Mandriva 2010.2 and OpenOffice. I can try to remember to change the printer language on every document I make in the future, but like Mr. Jordan I think it's a pain in the butt to remember to change it if I go to print old documents. I tried running spadmin as root to change the default, but for some reason Mageia wouldn't do it. Probably just as well, as I'm very much out of my element when it comes to command line noodling. It shouldn't have to be that way, anyway. There should be an easy way to make Postscript the default, if you want. I have not noticed any problems printing from Linux Mint 12. I would check the default printer settings and test the printer with another non-LO program to see if the problem is with the printer set up. The printer could be set up to default everywhere to pdf not to postscript. Let me clarify a few things. I first noticed this when printing to a Laserjet 4M+. I also have a 5SiMx, an 8000DN, and a Xerox Phaser 7400DN. The problem happens with most of them. And I have several printers installed for each physical printer, and it doesn't matter which one I select. I always get text with the font metrics messed up. This problem does not occur with any other program. This includes Abiword, Kword, Gedit, and Scribus - the usual programs I use for printing text. It did not occur with OpenOffice.org. I do not know if OOo used the same default to PDF as LibreOffice, and I cannot easily check because it is no longer installed. I could wipe out Fedora 16 and install Linux Mint, but the last time I changed distros it took almost a week to get everything reinstalled and reconfigured back the way I had it. I have a zillion programs installed, some of which took hours of tweaking to get them running. And I require these programs for my work. So, for now at least, I'm stuck with Fedora 16. Besides, I don't think the problem is in Fedora. From reading others' responses it appears that all we need to do is change the default from PDF to Postscript. I should add that just today I discovered another problem. I needed to print six copies of a one-page document (to give a paper copy to six
Re: [libreoffice-users] LO Writer - Strange behavior of paragraph styles
Hi :) It sounds like it's going completely crazy. Have you tried renaming your user-profile to see if it's some weird settings? http://wiki.documentfoundation.org/Documentation/UserProfile Is it a new fresh install of LibreOffice? Which Operating System or platform; ie Windows, Ubuntu, soem other GnuLinux, Mac or Bsd? Which version of LO, 3.5.0 perhaps? Has your machine got any strange usb-dongles plugged in by some joker work-mate? Retrevo or somewhere was advertising a usb-dongle that could be set to do crazy stuff at timed or 'random' intervals. It beats chattering teeth or a whoppee cushion i guess. We have not heard of other people having this problem but that doesn't mean it's not happening to other people so it would be great if we could work out how to fix it quickly. Regards from Tom :) --- On Thu, 2/2/12, John D. Herron paradox.her...@bluewin.ch wrote: From: John D. Herron paradox.her...@bluewin.ch Subject: [libreoffice-users] LO Writer - Strange behavior of paragraph styles To: users@global.libreoffice.org Date: Thursday, 2 February, 2012, 4:23 Hi, everyone. Running LO 3.4.3 OOO340m1 (Build:302) on Ubuntu 11.04 (Linux 2.6.38-generic-pae) w/ Gnome 2.32.1. Find myself having to cope with some very strange behavior of paragraph styles, not previously encountered in any version of OOo. I defined my 'Default' style as follows: font Ubuntu 12 regular, no indents, single spacing, 0.00 before and after, justified. As I begin a new document and type a one-line paragraph, then press Return to start a new paragraph, all is OK. If I press Return once more (adding an empty line), the previous paragraph gets indented without any prompting! When I go back to the previous paragraph with ArrowUp, the style changes - without any prompting! - to Text Body... If I go back to the beginning of any Default or Text Body paragraph and press Return twice, the paragraph is transformed into text that is both bold and increased in size... All of this, though, merely scratches the surface of my paragraph-style misadventures in LO. It's enough to drive me insane, to the point where I'm seriously considering returning to one of the recent versions of OpenOffice. FWIW i DID carefully read the manual on styles and templates. Like I said: no problems in OOo, a disaster in LO. As an aside: can anyone tell me what difference there is between 'Default' and 'Text body'? Can anyone offer any suggestions on how to correct / troubleshoot this? Thanks in advance. john -- 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: ppt files not displaying correctly
Hi :) If he is using a Mac would he be willing to Save As ... Odp (Odp is the OpenDocument Format for presentations). Mac users tend to be more willing (ime) to use non-MS formats, sometimes as a matter of principle, but they don't always have the techie skills and professors might not have the time. Regards from Tom :) --- On Thu, 2/2/12, Jeffrey Martin dogs...@gmail.com wrote: From: Jeffrey Martin dogs...@gmail.com Subject: [libreoffice-users] Re: ppt files not displaying correctly To: users@global.libreoffice.org Date: Thursday, 2 February, 2012, 3:48 I found out that if I click on layout for each slide it fixes the text box issue for that slide, but the slide number is still in the wrong place. On Wed, Feb 1, 2012 at 9:39 PM, Jeffrey Martin dogs...@gmail.com wrote: One of my professors makes his powerpoint slides available, but when I load them in Libreoffice they are a little off. Instead of the page number being in the lower right hand corner the page number is in the upper left corner and obscured partially by the slide. When you select the note tab the text box for the notes is on the left side and has a width of one character. I noticed the professor is using a Mac, but if he's using MS Office then the ppt should be the same. It displays correctly on the PC's in the library. -Jeff -- Jeffrey John Martin dogs...@gmail.com -- Jeffrey John Martin dogs...@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
Am 02.02.2012 01:52, sonic wrote: Hi bro, Do you have any alternative ways to do in libre base.. directly is there any tutorial for doing mail merge in libre base. yes i found out already can upgrade or edit data in spreadsheet after registered the spreadsheet in base.. TQ regards, sonic Once you have a Base document connected and registered, you can hit F4 in Writer, select the table or query you are interested in and then drag the column headers from the right pane of the data source browser into the document. This will import the required placeholders on the fly and you can arrange these database fields like any other type of Writer field. Then you start printing and confirm that you are going to print a serial letter. In the next dialog you may restrict the incoming row set by some filter or manual selection and you may choose to print into another Writer document. If you need some fixed filters (for instance all rows where name, zip, city and address are not empty), then you may add a query to the database document and use the query instead of the table. This is where it becomes very convenient that Base provides a database view on your spreadsheet tables. -- 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: Problems with format in Calc
Am 01.02.2012 12:05, Jean Milot wrote: Hi all, I have a date in a cell : 2012-01-02 I would like to have the day so i change format : Date / but when i change the format. I have the apparition of ' at the beginning of the cell. If i remove it it works i obtain the day. For now, i use : JOURSEM(date) Thanks. Just don't tag your numeric values as text. Number formats don't apply to text values. -- 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: emacs mode?
Am 29.01.2012 15:27, lee wrote: Hi, is there an emacs mode available for at least writer? I keep pressing the keys I use in emacs in writer without thinking, so it would be nice to have an emacs mode ... Either you prefer to write human language in emacs or you prefer writing in a text processor. Both concepts are radically different from each other. Most of the emacs functionality has no equivalent in Writer. -- 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] LO Writer - Strange behavior of paragraph styles
On 02/02/2012 at 05:23, John D. Herron paradox.her...@bluewin.ch wrote: As an aside: can anyone tell me what difference there is between 'Default' and 'Text body'? As Cor pointed out (in rather harsh way, if you ask me), probably you did not read documentation carefully enough. Styles are hierarchical (in web-world it's called cascade). You may open new document in Writer, press F11 and set Hierarchical from drop-down list at the bottom of new window. You will see that all styles in entire document are child of Default style. In other words, changes made in Default style will be present in all other styles. Changes in that style should be keep to minimum - ideally, you should change only font family and size there. You should *not* apply Default style directly to any paragraph. For your main text you should use Text body style. Although I find behavior of your LO rather odd, I would recommend you to use Text body as default style for paragraphs in your document. This is what you should do in the first place. Hopefully it will solve your problem as well. BTW, I have never encountered a problem like this in any LO or OOo version, so it is possible that these packages you did install are simply broken. You should try to rename your ~/.libreoffice (and ~/.openoffice!) as well, as Tom advises. -- Best regards Mirosław Zalewski -- 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: ppt files not displaying correctly
Hi :) Jeffrey sent me the latest pptx file off-list but i couldn't upload it to Nabble because it's too large at 7.8Mb and some of the images are copyrighted so i wasn't sure about it anyway. Would it be useful for me to remove the images and post like that? or would that lose everything useful? Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/ppt-files-not-displaying-correctly-tp3708887p3710128.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] Problems with format in Calc
Hi :) Ouch. I don't know how to get rid of the comma :( Is it even possible? I have a feeling that it would involve a horribly complicated line continuing after the in order to try to get it to do a backspace. Even if it's possible it's likely to be best avoided. Perhaps post a bug-report/'feature request'? Regards from Tom :) --- On Thu, 2/2/12, Thomas Damratowski tomraymond...@gmail.com wrote: From: Thomas Damratowski tomraymond...@gmail.com Subject: Re: [libreoffice-users] Problems with format in Calc To: users@global.libreoffice.org Date: Thursday, 2 February, 2012, 0:32 changes to the day, but adds a ',' at the end of the day monday,. Running Windows 7 LibreOffice 3.4.5 OOO340m1 (Build:502) On Wed, Feb 1, 2012 at 6:13 PM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) The ' over-rides the formatting and sets it as text. Did you type the ' or did it just appear magically? Was there a typo when you set the date format? Regards from Tom :) --- On Wed, 1/2/12, Johnny Rosenberg gurus.knu...@gmail.com wrote: From: Johnny Rosenberg gurus.knu...@gmail.com Subject: Re: [libreoffice-users] Problems with format in Calc To: users@global.libreoffice.org Date: Wednesday, 1 February, 2012, 22:11 2012/2/1 Jean Milot jmi...@dotriver.eu: Hi all, I have a date in a cell : 2012-01-02 I would like to have the day so i change format : Date / but when i change the format. I have the apparition of ' at the beginning of the cell. If i remove it it works i obtain the day. For now, i use : JOURSEM(date) Thanks. works for me, LibreOffice 3.3.4, Ubuntu 10.10. The cell displays ”onsdag” (Swedish for Wednesday) for today's date (2012-02-01) and ”måndag” (monday) for 2012-01-02. You didn't mention your operating system or version of LibreOffice, maybe there is a bug in your version? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- 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 -- 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: table - automatically copy text
Thanks folks. I think the solution is in the use of fields. I confess I have little understanding of them, and the help resources frankly aren't very helpful. Can someone suggest how I can set up a field where the output is copied to the same field in other places of the document? Paul. -- View this message in context: http://nabble.documentfoundation.org/table-automatically-copy-text-tp3704908p3710321.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] LibreOffice Base tutorial
Hi :) Thanks for passing the link along. It has led to a few interesting developments for the documentation team. Nothing hugely exciting but still a good step forwards. Thanks Alex too for his links. Sorry i was in a bad mood again. I will try to find the links and add to the documentation wiki. Thanks and regards from Tom :) --- On Tue, 31/1/12, drew d...@baseanswers.com wrote: From: drew d...@baseanswers.com Subject: [libreoffice-users] LibreOffice Base tutorial To: users@global.libreoffice.org Date: Tuesday, 31 January, 2012, 23:00 Howdy List, Just wanted to pass this URl along: http://www.fhi.rcsed.ac.uk/rbeaumont/virtualclassroom/chap8/libreoffice_base.html Haven't had the chance to read through all of the lessons but it looks reasonably complete. //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 -- 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] create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ
Wow! Just to be absolutely crystal clear, when you say If you need some fixed filters (for instance all rows where name, zip, city and address are not empty), then you may add a query to the database document and use the query instead of the table. 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. If so, is it new (3.4.5) functionality? Regards Mark Stanton One small step for mankind... -- 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: How to fix “error exists on this page” PDF error from LibreOffice 3.4 generated documents?
Dear Tom, The issue is resolved, Kindly refer the following forum link: http://forums.adobe.com/thread/464841 -- 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] Problems with format in Calc
2012/2/2 Tom Davies tomdavie...@yahoo.co.uk: Hi :) Ouch. I don't know how to get rid of the comma :( Is it even possible? I have a feeling that it would involve a horribly complicated line continuing after the in order to try to get it to do a backspace. Even if it's possible it's likely to be best avoided. I had no comma, but I did some fiddling with it and found that there is a comma if the language is set to English (US). Language set to English (Great Britain) does not produce a comma, nor does Swedish (my default language). Anyway, English (US) displays ”wednesday,” but NNN displays only ”wednesday”, so that's probably how to get rid of the comma, if there is one… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Perhaps post a bug-report/'feature request'? Regards from Tom :) --- On Thu, 2/2/12, Thomas Damratowski tomraymond...@gmail.com wrote: From: Thomas Damratowski tomraymond...@gmail.com Subject: Re: [libreoffice-users] Problems with format in Calc To: users@global.libreoffice.org Date: Thursday, 2 February, 2012, 0:32 changes to the day, but adds a ',' at the end of the day monday,. Running Windows 7 LibreOffice 3.4.5 OOO340m1 (Build:502) On Wed, Feb 1, 2012 at 6:13 PM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) The ' over-rides the formatting and sets it as text. Did you type the ' or did it just appear magically? Was there a typo when you set the date format? Regards from Tom :) --- On Wed, 1/2/12, Johnny Rosenberg gurus.knu...@gmail.com wrote: From: Johnny Rosenberg gurus.knu...@gmail.com Subject: Re: [libreoffice-users] Problems with format in Calc To: users@global.libreoffice.org Date: Wednesday, 1 February, 2012, 22:11 2012/2/1 Jean Milot jmi...@dotriver.eu: Hi all, I have a date in a cell : 2012-01-02 I would like to have the day so i change format : Date / but when i change the format. I have the apparition of ' at the beginning of the cell. If i remove it it works i obtain the day. For now, i use : JOURSEM(date) Thanks. works for me, LibreOffice 3.3.4, Ubuntu 10.10. The cell displays ”onsdag” (Swedish for Wednesday) for today's date (2012-02-01) and ”måndag” (monday) for 2012-01-02. You didn't mention your operating system or version of LibreOffice, maybe there is a bug in your version? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- 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 -- 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] emacs mode?
2012/2/2 lee l...@songoku.yagibdah.de: webmaster for Kracked Press Productions webmas...@krackedpress.com writes: On 01/29/2012 03:16 PM, Mirosław Zalewski wrote: emacs seems to me that it is used for mainframe programming editors, not word processors. You can do lots of things with emacs. It´s not at all limited to the programming of mainframes. Yes, I remember the early 1990's when I played MUD in Emacs and later I also used Emacs for IRC. Good old days… :) Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- 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: [libreoffice-users] Re: How to fix “error exists on this page” PDF error from LibreOffice 3.4 generated documents?
Hi :) Thanks for the link. I don't see any solution other than editing the coding of the document! If that is good enough then great but i think somewhere there needs to be a bug-report filed about this. It's really up to them tho as it seems to be an Adobe problem imo. When i used a non-Adobe Pdf reader i had no trouble at all with the uploaded pdf Ubuntu 10.04 (or perhaps 10.10) using Document Viewer 2.32.0 from the Evince people. Regards from Tom :) --- On Thu, 2/2/12, Prashant Patil prashan...@ext.icicibank.com wrote: From: Prashant Patil prashan...@ext.icicibank.com Subject: [libreoffice-users] Re: How to fix “error exists on this page” PDF error from LibreOffice 3.4 generated documents? To: users@global.libreoffice.org Date: Thursday, 2 February, 2012, 11:09 Dear Tom, The issue is resolved, Kindly refer the following forum link: http://forums.adobe.com/thread/464841 -- 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: table - automatically copy text
Hi :) The help-files have fallen into a gap between 2 teams and we still haven't resolved that as both teams are a tad busy. The best documentation is at http://wiki.documentfoundation.org/Documentation/Publications or the official site http://www.libreoffice.org/get-help/documentation/ The wiki has more and more recent versions but everything on the official site is on the wiki. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/table-automatically-copy-text-tp3704908p3710979.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: table - automatically copy text
I've figured out how to use cross-references fields. That seems to do what I need. Thanks again, Paul. -- View this message in context: http://nabble.documentfoundation.org/table-automatically-copy-text-tp3704908p3711089.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] Refencing calc results in writer
I'm trying to do some calculations in writer that are more complex than the formulas that are provided in the tables. I'm forced to resort to calc for those formulas. I'm trying to figure out how to incorporate the results into a table in writer. So far all I've been able to figure out is how to display the results, that is the cell in calc with the formula results, in the writer table. I would like to be able to reference the results in my table in writer. For example to include the results of the calculation in a total in another cell of the table. So far all I'm able to do is to get an image of the calc cell, but it won't let me reference it in my table. Any ideas? Thanks, Paul -- View this message in context: http://nabble.documentfoundation.org/Refencing-calc-results-in-writer-tp376p376.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] Refencing calc results in writer
On 02/02/2012 03:32 PM, paulwhitehurst wrote: I'm trying to do some calculations in writer that are more complex than the formulas that are provided in the tables. I'm forced to resort to calc for those formulas. I'm trying to figure out how to incorporate the results into a table in writer. So far all I've been able to figure out is how to display the results, that is the cell in calc with the formula results, in the writer table. I would like to be able to reference the results in my table in writer. For example to include the results of the calculation in a total in another cell of the table. So far all I'm able to do is to get an image of the calc cell, but it won't let me reference it in my table. Any ideas? Thanks, Paul -- View this message in context: http://nabble.documentfoundation.org/Refencing-calc-results-in-writer-tp376p376.html Sent from the Users mailing list archive at Nabble.com. Instead of Writer's table, how about embedding Calc spreadsheet in Writer? Insert - Object - OLE Object - LibreOffice 3.4 Spreadsheet -- 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: Refencing calc results in writer
Am 02.02.2012 21:32, paulwhitehurst wrote: I would like to be able to reference the results in my table in writer. For example to include the results of the calculation in a total in another cell of the table. So far all I'm able to do is to get an image of the calc cell, but it won't let me reference it in my table. Any ideas? Thanks, Paul This is called a DDE field. InsertFieldOther... Type: DDE Name: some name Statement: soffice ~/Documents/OOo/ldof.ods FirstMonday FirstMonday is the name of a cell calculating next month's first Monday. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] How to Enable Thesaurus
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 -- 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 02.02.2012 18:57, Mark Stanton wrote: Wow! Just to be absolutely crystal clear, when you say If you need some fixed filters (for instance all rows where name, zip, city and address are not empty), then you may add a query to the database document and use the query instead of the table. 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. If so, is it new (3.4.5) functionality? Regards Mark Stanton One small step for mankind... I do so since OOo 1.0. -- 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
Works running Windows 7 LibreOffice 3.4.5 OOO340m1 (Build:502) On Thu, Feb 2, 2012 at 4:57 PM, Mick Sulley m...@sulley.info 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 -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to Enable Thesaurus
Try this one; Download this British English [You did want British English correct?] dictionary that has a Thesaurus built into it. Then install it [with the Extension Manager]. Then see if you have a Thesaurus. IF you do, then you did not have a working one installed that LO can use. http://libreoffice-na.us/English-3.4-installs/add-on-dictionaries-large-list/kpp-british-english-dictionary-390K-word-list.oxt The American version is what I use with Ubuntu 10.04 LTS. Actually this file comes from my work trying to make a set of good English dictionaries for LO. If you decide it works for you, go to the Extension Center and decide which British English [American, or Canadian version as well] you would like to use. http://extensions.libreoffice.org/extension-center/american-british-canadian-spelling-hyphen-thesaurus-dictionaries On 02/02/2012 07:47 PM, Jay Lozier wrote: On 02/02/2012 06:41 PM, Thomas Damratowski wrote: Works running Windows 7 LibreOffice 3.4.5 OOO340m1 (Build:502) On Thu, Feb 2, 2012 at 4:57 PM, Mick Sulleym...@sulley.info 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) Which Ubuntu version do you have? If you have synaptic installed, check to see which dictionaries/thesauri you have installed for LO. You can search using Libreoffice, hunspell, and myspell. 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 -- 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 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 -- 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: Windows Explorer Extension
Problem is back in the 3.5 RC2 -- View this message in context: http://nabble.documentfoundation.org/Windows-Explorer-Extension-tp3414735p3712053.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
