Re: [libreoffice-users] Lotus WordPro
Dear Brian Being a Lotus Word Pro user myself and with the help of Tom Davis, I did post Divisions / Tabs as a feature request some months ago This is the reply:- https://bugs.freedesktop.org/show_bug.cgi?id=38401 --- Comment #1 from Michael Meeksmichael.me...@novell.com 2011-06-20 07:36:10 PDT --- IMHO implementing the tab feature would take quite some work here, instead it might be good to insert a set of links in the document at the top to allow quick jumping to the various sections; But of course, this is all work. Lets see if some volunteer jumps in to do it - otherwise if you pay someone to do the work, you can have it done as you like I guess. I would think that the more that it is requested the powers to be may see the light, but I suspect it will come down to that old joke about asking for directions where the reply is you should not start from here! Regards John B -- On 06/08/2011 23:20, Roland Hughes wrote: We have been begging for tabbed divisions from the OpenOffice/LO/Symphony community for years. It has become quite obvious that the developers on these projects have only ever used Microsoft Word and can't fathom why anyone would want something other than a clone of that. IBM seriously dropped the ball with WordPro. SmartSuite was THE office suite, bar none. On Sat, 2011-08-06 at 14:01 -0400, Brian Grawburg wrote: For several years Word Pro has been my primary word processing program for all major projects involving multiple chapters and sections within a chapter. For example, training manuals and personal books often consisting of +100 pages and more than a dozen divisions/chapters. I specifically use Word Pro because I can create a division and then easily click on the chapter tab to go to a specific location. If LibreOffice included such an option it would become my only word processing program, and I would quickly write the documenation for this options to show others how to use it. For now, I will only be able to use LibreOffice for short documents. Thanks, Brian Grawburg Wilson, NC USA -- 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] Compute difference
Thanks Tom Dear Dave It does work - you have to format the input cells as stated. b4 is formatted to Date, 31/Dec c4 is text to d4 is formatted to Date, 31/dec then in E4 =days360(b4,d4,3) then input your 2 dates into b4 and d4 as in just type:- 01/07/2011 and 22/07/2011 and the answer in E4 is 21 you might want to add +1 to the E4 formula depending on if you decide the answer in E4 should be 22 I note that 1/7/2011 is the same as 01/07/2011, as is just 1/7 (as it auto inputs this year) regards John B -- On 22/07/2011 20:41, Tom Davies wrote: Hi :) I think John's answer was mostly so you could copypaste into the right places! To do the formatting in the first part of his answer click on the cell and then look up at the menus at the top of the LibreOffice window. The menus should be something like File .. View ... Edit ... (err i can't remember) ... Format ... (more i can't remember) ... Window ... Help So, click on the Format menu, choose Cell and a pop-up box should appear with lots of tabs at the top. Choose the first one, General (or something). Somewhere on the left should be an option for Date which then gives you various sub-options. Hope this helps but there is a guide with screen-shots somewhere that might help so don't worry if it's not obvious. See Chapter 5 http://www.libreoffice.org/get-help/documentation/ Regards from Tom :) From: Dave Douglasddougl...@farmersagent.com To: users@global.libreoffice.org Sent: Fri, 22 July, 2011 20:06:33 Subject: Re: [libreoffice-users] Compute difference Thanks, but I am not a programmer. I have troubles being understood in English. Is there a way of doing it through the menus? Feeling unworthy, Dave -Original Message- From: John B Sent: Friday, July 22, 2011 12:00 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Compute difference Try this b4 is formatted to Date, 31/Dec c4 is text to d4 is formatted to Date, 31/dec E4 = ((-B4+D4)/7 +(1/7) f4= Trunc(e4) g4= (+e4-F4)*7 then type in your 2 dates into b4 and d4 as in 01/07/2011 and 22/07/2011 regards John B On 22/07/2011 15:15, Jérôme Fenal wrote: Hi all, I need to do a difference in days between two dates, _without_ taking into account leap years (e.g. considering all years are 365 days long). The right way to do that would be to use function DAYS360(date1;date2;method) using method = 3 as in other financial functions, but it does seems to be implemented (only 0 non 0 are meaningful for this function currently). Does anybody know how to still do this without ressorting to a procedural language ? Regards, J. PS: I'll be digging into BZ to see if there is already a request for such an enhancement to DAYS360(). No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3779 - Release Date: 07/21/11 16:13:00 -- 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 Introducing the Farmers Value Program - Big Discounts on Business Services Visit us on the web at http://www.farmersbusinessinsurance.com/farmers-value-program.html -- 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 -- 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] Writer images disappeared!
Tony Just downloaded 3.4.2 from Filehippo, tested and at this moment cannot find any bug fixes from 3.4.1. However, the disappearing pics still happens in this version for saving in .docx format Now, I know some people are not keen on this work around, but if you paste your picture into a text box (Insertframe), it works. You have to remove the box borders so that the text box does not show *and* they will stop the pictures moving around. regards John XP sp3 LO 3.4.2- OOO340m1 (Build:201) -- On 22/07/2011 10:50, Tony Royston wrote: Thank you Jorge, I will try that and report back my findings. Tony. -Original Message- From: jorge [mailto:jrodrigue...@cpcecr.com] Sent: Friday,22 July, 2011 0:34 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Writer images disappeared! Hi I suggest you to do this: 1) Save the original document (.docx) as .odt 2) Look if .odt document is correct 3) If it is correct save .odt document as .docx 4) Look if it is correct. Regards, Jorge Rodríguez El mié, 20-07-2011 a las 16:22 +0100, Tom Davies escribió: Hi :) Can you try saving as Doc instead of DocX? The older format often produces much better results. Regards from Tom :) From: Tony Roystontony.roys...@mercyships.org To: users@global.libreoffice.orgusers@global.libreoffice.org Sent: Wed, 20 July, 2011 16:02:23 Subject: [libreoffice-users] Writer images disappeared! Hi everyone, I have a Writer question. I am using 3.4.1 on Vista, and I successfully opened a docx file containing text and photos. I did some minor text editing, then saved the document with a new filename but still as a docx. When I opened that file, the images had disappeared! Any ideas? It's not a disaster as I still have the original document, but I would like to be able to save images with docx! Thanks, Tony Royston. This message and any attachments may be privileged or otherwise protected from disclosure - Mercy Ships. -- 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 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3779 - Release Date: 07/21/11 16:13:00 -- 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] Writer images disappeared!
Andrew /#//John, I take your comment to say that this should work (image in a frame) if the text frame is not visible. //#/ It works either way, with or without borders, I mentioned having to remove boarders because they come as a default with the frame (annoying) - I would get rid of them!. I use text boxes all the time. regards John B -- On 22/07/2011 14:20, Andrew Douglas Pitonyak wrote: On 07/22/2011 08:47 AM, John B wrote: Now, I know some people are not keen on this work around, but if you paste your picture into a text box (Insertframe), it works. You have to remove the box borders so that the text box does not show *and* they will stop the pictures moving around. Interesting. Historically, I had to remove pictures from text frames before they would export (so I stopped placing images in text boxes if I had to later convert to an MSO file format). John, I take your comment to say that this should work (image in a frame) if the text frame is not visible. Tony, are your images embedded in the document, or are they inserted as links? How are the images anchored? I always anchor AS CHARACTER when I want to export to an MSO format Are the images in a text frame? If yes, what happens if you have an image that is NOT in a text frame? No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3779 - Release Date: 07/21/11 16:13:00 -- 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] Writer images disappeared!
Tony Some in-bedded pictures are more in-bedded than others, when this happens I blow the picture up as big as I can, then use screen print, paste into my Picture editor (Paint Shop Pro), crop my desktop to just the picture and save as a .jpg or just copy paste into the word text box - simples. It may seem complex, but its very quick and of course it does help if you have 2 monitors. regards John On 22/07/2011 15:03, Tony Royston wrote: Andrew, Thanks for your reply. The images are embedded and not in a frame. The anchoring used is whatever is default, I didn't select anything specific. I shall try altering the anchoring, and using a frame, and see what happens. Regards, Tony. -Original Message- From: Andrew Douglas Pitonyak [mailto:and...@pitonyak.org] Sent: Friday,22 July, 2011 13:20 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Writer images disappeared! On 07/22/2011 08:47 AM, John B wrote: Now, I know some people are not keen on this work around, but if you paste your picture into a text box (Insertframe), it works. You have to remove the box borders so that the text box does not show *and* they will stop the pictures moving around. Interesting. Historically, I had to remove pictures from text frames before they would export (so I stopped placing images in text boxes if I had to later convert to an MSO file format). John, I take your comment to say that this should work (image in a frame) if the text frame is not visible. Tony, are your images embedded in the document, or are they inserted as links? How are the images anchored? I always anchor AS CHARACTER when I want to export to an MSO format Are the images in a text frame? If yes, what happens if you have an image that is NOT in a text frame? No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3779 - Release Date: 07/21/11 16:13:00 -- 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] help recovering?
I do not know if this will help, but viewers can be more forgiving than editors. Try http://www.officeviewers.com/ or http://visioo-writer.tuxfamily.org/EN/index_3.html if it does - you will have to copy paste back into LO again you might have to google a few more until you find one that works. regards John B -- On 22/07/2011 17:42, JeepNut wrote: Hoping for some good news here. Am using the openSuSE branded version of LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice-3.3.3.1 on openSuSE 11.3 and KDE 4.4.4-1.5. Was editing a document that is pretty important (to me at least) and during the process had tried to add a footnote. I was editing the text in the footnote and almost immediately there was some flashing of the screen and LibreOffice crashed, locking up the entire PC. No mouse control, no keyboard control, nothing. So I had to reset the PC. Now the document is fubar. When I try to open it, LibreOffice attempts to recover but fails. Then it tries to repair the file but opens only a blank page. I've tried to open it without an extension and get a list of a variety of application types to attempt any modicum of recovery, but no matter what I try to open it with it either fails, or opens in a file of unreadable gibberish. I'd be THRILLED if someone would be able to actually recover this document for me. Nothing secret in it, I'd be happy to email it to anyone who'd like to give it a try. Even just to get back the text out of it so that I could rebuild would be fabulous. Any chance at all to recover? -- View this message in context: http://nabble.documentfoundation.org/help-recovering-tp3191906p3191906.html Sent from the Users mailing list archive at Nabble.com. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3781 - Release Date: 07/22/11 10:32:00 -- 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] Compute difference
Try this b4 is formatted to Date, 31/Dec c4 is text to d4 is formatted to Date, 31/dec E4 = ((-B4+D4)/7 +(1/7) f4= Trunc(e4) g4= (+e4-F4)*7 then type in your 2 dates into b4 and d4 as in 01/07/2011 and 22/07/2011 regards John B On 22/07/2011 15:15, Jérôme Fenal wrote: Hi all, I need to do a difference in days between two dates, _without_ taking into account leap years (e.g. considering all years are 365 days long). The right way to do that would be to use function DAYS360(date1;date2;method) using method = 3 as in other financial functions, but it does seems to be implemented (only 0 non 0 are meaningful for this function currently). Does anybody know how to still do this without ressorting to a procedural language ? Regards, J. PS: I'll be digging into BZ to see if there is already a request for such an enhancement to DAYS360(). No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3779 - Release Date: 07/21/11 16:13:00 -- 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: Displaying Negative Numbers as red in Calc
Just a thought I do not know if Widows 7 has compatibility mode, but if it does, try Windows XP compatibility and see if the problem goes away. regards John B - On 17/07/2011 14:26, John B wrote: Hi On my XP SP3, LO 3.4. build 1OOO340m1 (Build:103) - the same as yours I saved as .ods, .xls, .xls (95) .xml and .xmlx, and they all came back perfect Must be a Windows 7, and an iMac bug - worth a report. regards John B -- On 17/07/2011 13:31, Tom Davies wrote: Hi :) I try to make it a triple negative by using red, brackets and a minus sign just to equally annoy everyone Regards from Tom :) From: Tinkererj_taylo...@btinternet.com To: users@global.libreoffice.org Sent: Sun, 17 July, 2011 12:56:35 Subject: [libreoffice-users] Re: Displaying Negative Numbers as red in Calc I have just realised. When showing negative numbers in Red, you should not prefix the number with the minus sign. This makes it a double negative, therefore making the number Red should be minus the minus sign. BTW. Is that a pun? Tink. -- View this message in context: http://nabble.documentfoundation.org/Displaying-Negative-Numbers-as-red-in-Calc-tp3172596p3176644.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
[libreoffice-users] Re: Displaying Negative Numbers as red in Calc
Hi On my XP SP3, LO 3.4. build 1OOO340m1 (Build:103) - the same as yours I saved as .ods, .xls, .xls (95) .xml and .xmlx, and they all came back perfect Must be a Windows 7, and an iMac bug - worth a report. regards John B -- On 17/07/2011 13:31, Tom Davies wrote: Hi :) I try to make it a triple negative by using red, brackets and a minus sign just to equally annoy everyone Regards from Tom :) From: Tinkererj_taylo...@btinternet.com To: users@global.libreoffice.org Sent: Sun, 17 July, 2011 12:56:35 Subject: [libreoffice-users] Re: Displaying Negative Numbers as red in Calc I have just realised. When showing negative numbers in Red, you should not prefix the number with the minus sign. This makes it a double negative, therefore making the number Red should be minus the minus sign. BTW. Is that a pun? Tink. -- View this message in context: http://nabble.documentfoundation.org/Displaying-Negative-Numbers-as-red-in-Calc-tp3172596p3176644.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] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project
Hi As a disgruntled Lotus Smart Suite user, abandoned by IBM as are the Lotus Amipro users, I am well aware of the link between Symphony OOo, as one reduced its support for LSS, so did the other one. In fact IBM have now turned its back permanently on LSS and not so surprisingly in Windows so has OOo; with still thousands and thousands of requests (pleads) for IBM not to do so (there is one request for compatibility - requested some 15,000 times). Whilst at the same time, LO increases its support - all praise to LO I understand from reading the on-line guessing politics that IBM will at some point bring out a Paid for version, to link into Lotus Notes, so is this the Price OOo have had to pay to get IBM's blue interface:- the cost of not being LSS compatible - Hold this space! Beside, IBM's Symphony hardly stood as an office suit with only 3 programs - and it was far to buggy for me. I am very happy for LO to stay on course. regards John B -- On 17/07/2011 22:01, Tom Davies wrote: Hi :) My emails are just my own opinion. I'm not even a proper member yet! Regards from Tom :) From: Andy Browna...@the-martin-byrd.net To: users@global.libreoffice.org Sent: Sun, 17 July, 2011 20:23:30 Subject: Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project Luuk wrote: http://www-03.ibm.com/software/lotus/symphony/buzz.nsf/web_DisPlayPlugin?openunid=955E9C0EC712EC47852578CD0063A209category=announcements s Is it time for the LO-developers to get back with OpenOffice too ? In a word, no. -- 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] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project
I do not think there would be a problem with OOo LO working together in co-operation, its the getting into bed with IBM that could. As they say if you fail to learn from history . Ask Bill Gates, ask Lotus users after IBM took over - it does look good at first, but in the long run. regards John B --- On 18/07/2011 02:03, Roland Hughes wrote: Try KOffice.or as it is now called Calligra. It will be bundled with most major distros next release. http://en.wikipedia.org/wiki/Calligra_Suite On Sun, 2011-07-17 at 20:18 -0400, Paul W wrote: Why don't all the OOo devs just come to TDF? I mean isn't this further splitting up the community? What I want to see is a single powerful office suite to kill Microsoft. I want to see them buried. I want to see a free, open product that is perfect in it's seamlessness, transparency and ease of use. I hope LO is the one to do it. We need to kick some ass! On Sun, Jul 17, 2011 at 6:06 PM, John Bjo...@email2.me wrote: Hi As a disgruntled Lotus Smart Suite user, abandoned by IBM as are the Lotus Amipro users, I am well aware of the link between Symphony OOo, as one reduced its support for LSS, so did the other one. In fact IBM have now turned its back permanently on LSS and not so surprisingly in Windows so has OOo; with still thousands and thousands of requests (pleads) for IBM not to do so (there is one request for compatibility - requested some 15,000 times). Whilst at the same time, LO increases its support - all praise to LO I understand from reading the on-line guessing politics that IBM will at some point bring out a Paid for version, to link into Lotus Notes, so is this the Price OOo have had to pay to get IBM's blue interface:- the cost of not being LSS compatible - Hold this space! Beside, IBM's Symphony hardly stood as an office suit with only 3 programs - and it was far to buggy for me. I am very happy for LO to stay on course. regards John B --**--** --** On 17/07/2011 22:01, Tom Davies wrote: Hi :) My emails are just my own opinion. I'm not even a proper member yet! Regards from Tom :) __**__ From: Andy Browna...@the-martin-byrd.net** To: users@global.libreoffice.org Sent: Sun, 17 July, 2011 20:23:30 Subject: Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project Luuk wrote: http://www-03.ibm.com/**software/lotus/symphony/buzz.** nsf/web_DisPlayPlugin?open**unid=**955E9C0EC712EC47852578CD0063A2** 09category=announcementshttp://www-03.ibm.com/software/lotus/symphony/buzz.nsf/web_DisPlayPlugin?openunid=955E9C0EC712EC47852578CD0063A209category=announcements s Is it time for the LO-developers to get back with OpenOffice too ? In a word, no. -- Unsubscribe instructions: E-mail to users+help@global.libreoffice.**orgusers%2bh...@global.libreoffice.org In case of problems unsubscribing, write to postmaster@documentfoundation. **orgpostmas...@documentfoundation.org Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquettehttp://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 -- 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] How to abbreviate the first name of the author?
You might find this useful If say the name David is in cell C11, then type in D11 =CHAR(CODE(C11)) will return the D the 1st Character regards John B - On 12/07/2011 09:48, Dietrich Bollmann wrote: Hi, for a paper I have to only render the Initials of the first name in the list of references: At the place of: Anderson, David I have to use:Anderson, D. Any idea how to do that with the bibliography tools of libre office? Thanks, Dietrich -- 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] Error in Calc logical functions
Michael Excellent, I did not know ISNUMBER existed, I never needed it before, but for my usage I would remove the word Non-numeric and just leave so the cell would remain blank. I can see that in LO or any other spreadsheet that treats Letters as Numbers, this would be a necessary function. I have learned something today - thanks John B -- On 13/07/2011 13:24, Michael D. Setzer II wrote: How about this formula. =IF(ISNUMBER(A1),IF(A110,True,False),Non-numeric) 1 False 2 False 3 False 4 False 5 False 6 False 7 False 8 False 9 False 10 False 11 True A Non-numeric 13 True 14 True 15 True 16 True 17 True 18 True 19 True 20 True 21 True On 12 Jul 2011 at 20:14, Regina Henschel wrote: Date sent: Tue, 12 Jul 2011 20:14:27 +0200 From: Regina Henschelrb.hensc...@t-online.de To: users@global.libreoffice.org Subject:Re: [libreoffice-users] Error in Calc logical functions Send reply to: users@global.libreoffice.org Alejo C.S. schrieb: Hi all, this is a little example to show what is going on. In A column I have a numeric list from 1 to 21, in the middle I have a letter, lets put A. If a run this function in the next column =IF(A110), this function evaluate the letter A like TRUE, why? 1FALSE 2FALSE 3FALSE 4FALSE 5FALSE 6FALSE 7FALSE 8FALSE 9FALSE 10 FALSE 11 TRUE A TRUE 13 TRUE 14 TRUE 15 TRUE 16 TRUE 17 TRUE 18 TRUE 19 TRUE 20 TRUE 21 TRUE The ODF1.2 spec says (functions are here the comparison operators), These functions return one of True, False, or an Error if Left and Right have different types, but it is implementation-defined which of these results will be returned when the types differ. And OpenOffice.org and LibreOffice have the simple rule number is less than string. Excel and Gnumeric have these results too. Kind regards Regina -- 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 +--+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mi...@kuentos.guam.net mailto:msetze...@gmail.com http://www.guam.net/home/mikes Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +--+ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS SETI10992790.927474 | EINSTEIN 6170633.720851 ROSETTA 3366299.645114 | ABC 6849302.005189 Internal Virus Database is out of date. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3744 - Release Date: 07/04/11 19:35:00 -- 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
Re: [libreoffice-users] Re: Save odt/ods files take too much time
ah But I have one with about the same amount of slides (7.5MB) and it takes 2.2s to open the .odp file and 4.5s for the .pptx A swing to your roundabout maybe! Sorry I cannot repeat your save timings:- When I try to save the .opd saves in 4s and saving in the .pptx comes up with a do you want to save in this format box, then the save bar does not appear, so you cannot tell on 3.4.1 how long it taking but when you add on the time it takes you to click on this extra box, it has to be longer than 4s. regards John B xp sp3 LO 3.4.1 On 12/07/2011 15:23, MichaelB wrote: Oups sorry.. Mo (Mega Octet) = MB (Mega Byte) So ~2.5 MB in my case... -- View this message in context: http://nabble.documentfoundation.org/Save-odt-ods-files-take-too-much-time-tp3162499p3162571.html Sent from the Users mailing list archive at Nabble.com. Internal Virus Database is out of date. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3744 - Release Date: 07/04/11 19:35:00 -- 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: Image problems
Tom I always use text boxes (LO Frames) and place one image inside each box. I love text boxes - I use them all the time - they are stable and you can overlay pictures etc. Text boxes do not tend to jump all over the place or anywhere at all. Remember to click off the edge pullers in LO or else you cannot insert a new one. John B -- On 12/07/2011 16:15, Tom Davies wrote: Hi :) Brilliant! I just had this problem about a week ago. About 12 images on a single page in Writer made it really difficult to keep them all in the same place. Each time i moved one image to it's right place some of the other images jumped about a bit randomly. This time i fell back to using Publisher which also made a bit of a mess but i was able to fudge it. Next time i guess i should use Draw! Thanks and regards from Tom :) From: Twaynetwa...@twaynesdomain.com To: users@global.libreoffice.org Sent: Sun, 10 July, 2011 15:12:50 Subject: [libreoffice-users] Re: Image problems In news:op.vycjy4x2ov9kiw@monster-linux.zuhause, Zak McKrackenzak_mckrac...@openoffice.org typed: Am 07.07.2011, 21:19 Uhr, schrieb Twayne t...@twaynesdomain.com: [...] In case I didn't make it clear, the runaway scrolling occurred when I was moving the pages via the scrollbar so I could watch the page numbers easier. But I could make the same thing happen by scrolling wtih the mouse wheel. Ah, OK. No, I don't have that problem either. My usual fix is just to break a large document into several smaller documents to get LO to handle it, although I haven't created a Master Document yet and don't know if that will bring back the problems. Splitting documents does help (I'm doing that, too), but it can indroduce new problems: If you have rferences across several part documents, that will give you an error message in the individual files, but the correct content in the global one. Which can change line and page breaks, and that can change the layout. Shouldn't be a problem but can become one. Also it took me a while to figure out how to have proper page breaks between single documents. But then, it makes editing a lot easier, especially with many images. They aren't large images either in real estate or file size; they're about 1/16 of a page, most of them, and there may be 6 to 10 smaller ones per page in a table which is apt to really screw up in LO. In my experience, the problem starts with more than one image per paragraph and with more than half the page covered in images. But if you organize them in a table, that'll keep them together. Interesting; tables can be the worst culprits, depending on whatever, I don't know. I've never been able to decide if it was the qty of images or qty of anchors and which cell/s they live in. Hmmm. Depending on whether the table also contains text, you could alternatively arrange them in LO draw and then copy/paste them into the writer document. Then it's really just one object, and that is easier to position than many small ones. I'll have to think about that one a bit; using Draw so it'll only be one object. Sounds plausible, but it might be more work than just splitting the files apart as I've done before. Since these are all pre-existing files I'd have to pull from Writer, Paste into Draw, fix, Paste back into Writer. Wonder if I could get a macro to do that? Probably not. Thanks for your thoughts though! Unless I get a brainstorm from your comments, I think I'll go the split-documents route and Master Document/s if/when the images will stabilize for me. Thanks again, Twayne` Cheers, Zak Internal Virus Database is out of date. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3744 - Release Date: 07/04/11 19:35:00 -- 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] Error in Calc logical functions
Alejo The strange thing is is that if you reverse the logic such as =IF(A111 and then reverse the True False You get the same results table and but with A still being TRUE I am convinced this is a bug, which stops you writing an IF within an IF such as =IF(A111,False,IF(A110,True,False)) which should work - but it doesn't. regards John B On 12/07/2011 18:05, Alejo C.S. wrote: Hi all, this is a little example to show what is going on. In A column I have a numeric list from 1 to 21, in the middle I have a letter, lets put A. If a run this function in the next column =IF(A110), this function evaluate the letter A like TRUE, why? 1FALSE 2FALSE 3FALSE 4FALSE 5FALSE 6FALSE 7FALSE 8FALSE 9FALSE 10 FALSE 11 TRUE A TRUE 13 TRUE 14 TRUE 15 TRUE 16 TRUE 17 TRUE 18 TRUE 19 TRUE 20 TRUE 21 TRUE Thanks a lot in advance C. Internal Virus Database is out of date. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3744 - Release Date: 07/04/11 19:35:00 -- 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] Error in Calc logical functions
Got it Regina is correct, so:- =IF(A150,False,IF(A110,True,False)) Where 50 (or 1000) is higher than any number in your table regards John B On 12/07/2011 19:28, John B wrote: Alejo The strange thing is is that if you reverse the logic such as =IF(A111 and then reverse the True False You get the same results table and but with A still being TRUE I am convinced this is a bug, which stops you writing an IF within an IF such as =IF(A111,False,IF(A110,True,False)) which should work - but it doesn't. regards John B On 12/07/2011 18:05, Alejo C.S. wrote: Hi all, this is a little example to show what is going on. In A column I have a numeric list from 1 to 21, in the middle I have a letter, lets put A. If a run this function in the next column =IF(A110), this function evaluate the letter A like TRUE, why? 1FALSE 2FALSE 3FALSE 4FALSE 5FALSE 6FALSE 7FALSE 8FALSE 9FALSE 10 FALSE 11 TRUE A TRUE 13 TRUE 14 TRUE 15 TRUE 16 TRUE 17 TRUE 18 TRUE 19 TRUE 20 TRUE 21 TRUE Thanks a lot in advance C. Internal Virus Database is out of date. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3744 - Release Date: 07/04/11 19:35:00 Internal Virus Database is out of date. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3744 - Release Date: 07/04/11 19:35:00 -- 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] Error in Calc logical functions
Hello Brian Its none of those, they are not comparable, Ones a text the other is an amount. Therefore A logically is not greater than 10 stands (I hope)! As stated, I used Lotus 123 as my Judge and Jury. John B Ps who is John Bonly? --- On 12/07/2011 23:43, Brian Barker wrote: At 18:25 12/07/2011 +0100, John Bonly wrote: I can repeat this:- and therefore it is actually very wrong, A is not greater than 10, hence it should read False If you think A is not greater than 10, do you think it is less than 10 or equal to 10? ;^) Brian Barker -- 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] Help with formatting footnotes...
1st workaround You could try inserting a text box, I use them all the time, you can move them to where ever and adjust any of the parameters independent of the the main page, even from page to page.. the footnote numbers you can enter manually (eg 1, 2) and use the fonts superscript to look the same. the only draw back as I can see is that when you click on the 1 say, it does not take you to the footnote. Insert Frame (then remove the borders) 2nd work around as far as submitting in .docx format is concerned, .doc is much better!? in translation and MS will open files as if in both, so if you must then you can manually edit file.doc to file.docx, MS and LO will open it - perfectly. regards John B On 06/07/2011 20:33, gena_hill wrote: Hi! I'm new to LibreOffice, and I'm having problems trying to figure out how to format more than one footnotes at a time. Everything else is working beautifully for me, but this is really an important feature for me since I deal with tons of footnotes on a regular basis. Any help would be much appreciated! Thank you! -- View this message in context: http://nabble.documentfoundation.org/Help-with-formatting-footnotes-tp3145923p3145923.html Sent from the Users mailing list archive at Nabble.com. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3744 - Release Date: 07/04/11 19:35:00 -- 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] problem in impress
A shot in the dark, it might be a font problem. I am guessing, but a friend of mine writes Arabic fonts for Middle East Banks Finance Houses and not all of them the use arabic numbers (as strange as that may seem). To check this out, run charmap on your font, if the font has arabic numbers (123...) that maybe the problem regards John B - On 04/07/2011 12:06, Nawfel wrote: I am using ubuntu 11.04 ... LibreOffice 3.3.2 LibreOffice language=French My document is in ODP format My language is Arabic the screenshot of the problem : https://docs.google.com/uc?id=0B2nciG4JCjulZWQyNGM5ZTgtNmQ1MC00ZmM1LTgyNWQtNWFkNDU4ZTI4MzYzexport=downloadhl=en_US -- View this message in context: http://nabble.documentfoundation.org/problem-in-impress-tp3137230p3137230.html Sent from the Users mailing list archive at Nabble.com. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3736 - Release Date: 06/30/11 19:34:00 -- 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: problem in impress
Dear Nawfel In your quest for enlightenment born usually from hours of frustration, you will always find bugs and with LO many many bugs. Hence, I really hope that you persevere with bugzilla yourself. regards John B - On 04/07/2011 14:16, Nawfel wrote: Please report a bug instead of me because i don't understand how bugzilla works -- View this message in context: http://nabble.documentfoundation.org/problem-in-impress-tp3137230p3137520.html Sent from the Users mailing list archive at Nabble.com. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3736 - Release Date: 06/30/11 19:34:00 -- 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] Review on 3.4.1 Mail Merge
Eagerly awaited - for a LO working mail merge from the newly released 3.4.1 Before I did this test, I completely cleaned 3.3.3 using revo-uninstaller to ensure a completely new install. The 1st thing I did was to view existing mail merge data files from 3.3.3 - they were still all screwed up as before. I therefore deleted them, so at to not cause further confusion and start again from new. However, I could not find a way of deleting the old files from the internal list (there is no remove button), once I looked at them. I started from fresh, I created a standard 2 name data base for Mr Smith Mr Blogs. I did this with ease. Now when the MM came to the part that places the data on the letter (6. Edit Document), a few strange things happened, the address line 2, the County and Company names were not present, the post code came before the town name and the title Mr is on a separate line to his name. This is where you have a learn a new game called shuffle and add the field names. So you go back to 3. Insert Address Block, go into edit mode and play with the arrows and create a standard address pattern (which you would have thought would be the default). I considered that this could this be deliberate (because they are so bad) - so as to force you to look and make your own? However, you will only have to do this once, as LO remembers this layout for the next time. Then Create Salutation (tick the boxes), Adjust layout (I did not use this), then Edit document In Edit Document the Field Names are deposited on your letter for the 1st time, the next thing you notice is the weird Spacing between the address lines, you cannot adjust this in the document directly (its frozen), so you have to go to the Edit Document's:- Edit Document (right click) Edit Paragraph style indents spacing Below Paragraph set to 0.00cm - This puts it back to the letter default. Then Personalise Document (this prints all your letters) - this is where you now can see (WYSIWYG) for the 1st time, the full document that will be printed and you realise that there are no spaces or comma's between the fields hence the 1st line looks like MrJohnSmith. To resolve this, you have to go back to Edit Document to put in spaces (and comma's). I could find no way of doing this at making / inserting address block stage, so you will always need to do this on each new mail merge. I saved and Exited I then realised that there were no name(s) after the salutation Dear .., so I went back and tried unsuccessfully to insert it again, the moment you go from Edit Document (where the Dear Mr Smith exists) to Personalise Document, it disappears ( a Bug me thinks). As a work around, whilst in Edit mode, I copied pasted the name, this (the name) stayed when I went on to Personalise Document (annoying but it worked). So I would suggest don't use Create Salutation, make your own, by copying pasting from the main Address block. Also, on testing, other previously known bugs:- As long as you do not click the Insert address block on the 2nd time around (leave it greyed out), then it does not insert a 2nd address block AND the links stay in place. Having exited again, I then edited the data base file (*.csv) by adding a new name (a 3rd name in my case), in the spread sheet format *.csv (it takes a while to find this file and remember to read it in tab format). Re- started the mail merge - and it Worked!! - 3 names. So names addresses can now be entered with ease and without having to open mail merge and mass data can now be pasted into the *csv file - if you so desire! Summary:- Other than a few minor niggles and only the one (easy to get around) bug, that I could find, it's getting there, but most importantly :- its usable. 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][windows] 3.4.1 Click here Place holders for Lotus Wordpro
I am pleased to report that another small step in the right direction for Lotus Wordpro users Click Here Boxes are now fully compatible with LO Placeholders. However, you still cannot tab between them (and in a set sequence) as Wordpro, that's only because LO Place holders do not have this facility in the first place (a shame for forms that need to be completed - you just cannot tab to the next box), you have to move click your mouse instead. Maybe in 3.4.2? Now if only LO would do Wordpro Document Tabs (divisions) - I have a dream!. regards John B xp pro sp3 LO 3.4.1 -- 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] [LibraOffice-Users] - DONT use Reply to for a new thread
Dear Hal I had no Idea this happened, I thought just by putting in a new subject changed the thread. I will make up a template for use for new subjects from now on. John B John, You've written two posts by hitting Reply to: on another email that's about another subject (About the Delete Key on OS X). While that's an easy way to make sure you get the list address without typing it in, it means your new posts, on totally different topics, are rolled up into this thread about the Delete Key. That creates a few problems: 1) Those dealing with the thread on Delete Keys are frustrated because that discussion is now taken over by two other topics and it's harder to follow the discussion, and 2) People that are potentially interested in your topics have a good chance of never seeing them because they're folded up in a topic about Delete Keys and OS X. People that may have answers to your questions may never see your posts because they'll be filed under the other topic, so they may see that topic, decide it doesn't apply to them, and delete the entire thread, including your posts. You can avoid this by not starting new threads by using the Reply to: function and just changing the title -- email programs look at data other than the subject to determine topic threads. Hal On Jul 3, 2011, at 11:10 AM, John B wrote: Eagerly awaited - for a LO working mail merge from the newly released 3.4.1 Before I did this test, I completely cleaned 3.3.3 using revo-uninstaller to ensure a completely new install. The 1st thing I did was to view existing mail merge data files from 3.3.3 - they were still all screwed up as before. I therefore deleted them, so at to not cause further confusion and start again from new. However, I could not find a way of deleting the old files from the internal list (there is no remove button), once I looked at them. I started from fresh, I created a standard 2 name data base for Mr Smith Mr Blogs. I did this with ease. Now when the MM came to the part that places the data on the letter (6. Edit Document), a few strange things happened, the address line 2, the County and Company names were not present, the post code came before the town name and the title Mr is on a separate line to his name. This is where you have a learn a new game called shuffle and add the field names. So you go back to 3. Insert Address Block, go into edit mode and play with the arrows and create a standard address pattern (which you would have thought would be the default). I considered that this could this be deliberate (because they are so bad) - so as to force you to look and make your own? However, you will only have to do this once, as LO remembers this layout for the next time. Then Create Salutation (tick the boxes),Adjust layout (I did not use this), then Edit document In Edit Document the Field Names are deposited on your letter for the 1st time, the next thing you notice is the weird Spacing between the address lines, you cannot adjust this in the document directly (its frozen), so you have to go to the Edit Document's:- Edit Document (right click) Edit Paragraph style indents spacing Below Paragraph set to 0.00cm - This puts it back to the letter default. Then Personalise Document (this prints all your letters) - this is where you now can see (WYSIWYG) for the 1st time, the full document that will be printed and you realise that there are no spaces or comma's between the fields hence the 1st line looks like MrJohnSmith. To resolve this, you have to go back to Edit Document to put in spaces (and comma's). I could find no way of doing this at making / inserting address block stage, so you will always need to do this on each new mail merge. I saved and Exited I then realised that there were no name(s) after the salutation Dear .., so I went back and tried unsuccessfully to insert it again, the moment you go from Edit Document (where the Dear Mr Smith exists) to Personalise Document, it disappears ( a Bug me thinks). As a work around, whilst in Edit mode, I copied pasted the name, this (the name) stayed when I went on to Personalise Document (annoying but it worked). So I would suggest don't use Create Salutation, make your own, by copying pasting from the main Address block. Also, on testing, other previously known bugs:- As long as you do not click the Insert address block on the 2nd time around (leave it greyed out), then it does not insert a 2nd address block AND the links stay in place. Having exited again, I then edited the data base file (*.csv) by adding a new name (a 3rd name in my case), in the spread sheet format *.csv (it takes a while to find this file and remember to read it in tab format). Re- started the mail merge - and it Worked!! - 3 names. So names addresses can now be entered with ease and without having to open mail merge and mass
[libreoffice-users] [LibraOffice-Users] - DONT use Reply to for a new thread
Ok - I use Thunderbird and found out how to switch threads ON, since I have never used them before. Thunderbird now displays in a tree like fashion I thought - that looks good - I will leave that on Then a few new emails came in - and I had to scan to find out where they were posted, because they attach to the bottom of an email tread (maybe even from weeks ago). and not at the very top. Ahh - That is no good for me I need to see them in date order so OFF its gone again. Now, whilst I can see the advantage viewing by thread posting if that's the right term, I doubt that I will ever use it myself. regards John B --- On 03/07/2011 23:45, Nuno J. Silva wrote: On 2011-07-03, Larry Gusaas wrote: On 2011/07/03 3:26 PM Tom Davies wrote: Sorry, i didn't notice this because i don't use Nabble or Gmane for the emailing list. I just use my normal email-client and i imagine most new users do too. Still, it's good to know for the future so thanks for that Hal It has nothing to do with using Nabble or Gmane. I don't know about Nabble, but Gmane is nntp, where message references work the same way (or at least in a very similar way). So using reply-to to start a new thread screws people in Gmane too. Please just do what you want to do. If you want to send a new message, and not reply to some other message, *do not* use the reply to feature of your client, use the new message compose mail or equivalent. It's not hard to copy and paste the list address. Likewise, if you want to reply to another message, use reply to, not new message, compose mail. Just like when you set your power supply to run on 230V (and *not* 110V) when you use your computer in a 230V power network. Most e-mail clients can be set to sort incoming messages into threads. BTW please set your client to attribute messages you are replying to so people can tell what you write and what you are replying to. Tom seems to be using Yahoo webmail. From the little experience I had with webmails, they rarely do a good job of not screwing emails. Tom's mails have attribution, it's just in some uncommon format (MS Outlook-like?). I'm lucky enough to have a client that has an Outlook-deuglify feature, but it still can't fix the outermost attribution in some emails, I just fix these manually. -- 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: SubForms and Photographs in LO Base
Its easy The adopter with the triangle is in the vessel with the pestle and the stable which is able is the program that is true. Please Please forgive me! John B --- On 30/06/2011 17:18, Steven Shelton wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 6/30/2011 12:04 PM, Tom Davies wrote: There is a yellow warning triangle and exclamation mark ! beside the 3.4.x series/branch. Also it firmly says For early adopters only. The 3.3.x series/branch has a big friendly green tick and words saying that it is the stable branch. It could be a little bit clearer but i'm not sure how lol ;) Don't worry, lots of people miss those details too. Well, yes, but early adopters doesn't imply unfinished developer version. It merely implies people who want the latest one first without subsequent bug fixes. The word final implies production ready. I didn't install 3.4 because the warnings made me look at the release notes, which led me to believe there are known bugs that would cause serious problems for my office, but what if I hadn't gotten it from the website? What if someone had given it to me on a CD merely labeled 3.4 Final? There needs to be some clearer information on the site, and if the even-numbered release are development branches, then there should be a warning for users when they install those versions, as well. - -- Steven Shelton -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.12 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk4MoesACgkQXUonIzCvpdOVMQCfYaB3bB6iXlPgxVLJE1xEnE0h Z20AoIXzIvwZYUUSvsHeCy8BanwTUD2u =f6bZ -END PGP SIGNATURE- No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3732 - Release Date: 06/28/11 19:34:00 -- 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] Calc: Text numbers
Hi all I have discovered a really useful feature in calc (one for the future), but its annoying in my particular use this where, say, you enter text into a cell in column E say at E16 the text would be something8,000 btus (or 2.34kw) Machines now if you type in the same column above or below it, say at E7 the number 8, the whole of 8,000 btus (or 2.34kw) Machines appears. I would like to turn this feature off. regards John B xp pro sp3 LO 3.3.3 (3.3.3.1) -- 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] Calc: Text numbers
Dear Tom / Stephan I have not seen this feature before in my Lotus 123 or in my old MS Excel either, it may be that the default settings in these are Off, where as the default in LO (and OOo) is clearly On. I use my calculator for anyone to download from my website and the people who download it, may not have the knowledge to switch it off. http://www.chillypepperhire.co.uk/calculator-downloads.htm - if you enter the number 8 into the Height box you will see what I mean (once you get past the open with LO and it opens in read only and you have to re-save it anyway- annoyance) I was hoping that I could just format the cell in some way so the spreadsheet could be used be anyone and not say OMG when they inadvertently enter a number and text appears (as I did). I suppose the only answer is to re-design the form (unless you know better). regards John B - On 29/06/2011 11:35, Tom Davies wrote: Hi :) For most types of auto-complete you can just tap the Del key or any character (not enter) while the predicted part is still selected/bold/inverse. If you just press enter then the program happily thinks it guessed right. Regards from Tom :) - Original Message From: Stephan Zietsmanszi...@gmail.com To: users@global.libreoffice.org Sent: Wed, 29 June, 2011 10:09:47 Subject: Re: [libreoffice-users][windows] Calc: Text numbers John B wrote: this where, say, you enter text into a cell in column E say at E16 the text would be something8,000 btus (or 2.34kw) Machines now if you type in the same column above or below it, say at E7 the number 8, the whole of 8,000 btus (or 2.34kw) Machines appears. That is called AutoInput I would like to turn this feature off. On Windows it is under: Tools - Cell Content - AutoInput Regards Stephan -- 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 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3732 - Release Date: 06/28/11 19:34:00 -- 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] Calc: Text numbers
Dear Tom On my system it does not work, the autoinput seems to be part of the default settings of the program and unfortunately does not seem to attribute itself to the file. I, turned autoinput Off - my calculator sheet works as it should, I then saved it and closed LO as well. Open LO calc again, autoinput remained off (that's good), then changed the autoinput to the default On, then opened my calculator - and the problem returns regards John B - On 29/06/2011 12:46, Tom Davies wrote: Hi :) Ahah, i think Stephen's answer is best. You will probably need to re-save the document and upload the newly saved document to the right place. Regards from Tom :) - Original Message From: John Bjo...@email2.me To: users@global.libreoffice.org Sent: Wed, 29 June, 2011 12:30:44 Subject: Re: [libreoffice-users][windows] Calc: Text numbers Dear Tom / Stephan I have not seen this feature before in my Lotus 123 or in my old MS Excel either, it may be that the default settings in these are Off, where as the default in LO (and OOo) is clearly On. I use my calculator for anyone to download from my website and the people who download it, may not have the knowledge to switch it off. http://www.chillypepperhire.co.uk/calculator-downloads.htm - if you enter the number 8 into the Height box you will see what I mean (once you get past the open with LO and it opens in read only and you have to re-save it anyway- annoyance) I was hoping that I could just format the cell in some way so the spreadsheet could be used be anyone and not say OMG when they inadvertently enter a number and text appears (as I did). I suppose the only answer is to re-design the form (unless you know better). regards John B - - On 29/06/2011 11:35, Tom Davies wrote: Hi :) For most types of auto-complete you can just tap the Del key or any character (not enter) while the predicted part is still selected/bold/inverse. If you just press enter then the program happily thinks it guessed right. Regards from Tom :) - Original Message From: Stephan Zietsmanszi...@gmail.com To: users@global.libreoffice.org Sent: Wed, 29 June, 2011 10:09:47 Subject: Re: [libreoffice-users][windows] Calc: Textnumbers John B wrote: this where, say, you enter text into a cell in column E say at E16 the text would be something 8,000 btus (or 2.34kw) Machines now if you type in the same column above or below it, say at E7 the number 8, the whole of 8,000 btus (or 2.34kw) Machines appears. That is called AutoInput I would like to turn this feature off. On Windows it is under: Tools - Cell Content - AutoInput Regards Stephan -- 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 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3732 - Release Date: 06/28/11 19:34:00 -- 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 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3732 - Release Date: 06/28/11 19:34:00 -- 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] Calc: Text numbers
Hi Tom Tried - as you suggested (ever hopeful) It works of course the way I want it, when I do download the new saved spreadsheet with the autoinput turned Off . However, if I now turn On the autoinput at any point (as would be everybody elses by default), it starts that autoinput. As I originally thought, its not a function of the sheet itself - so I am looking for another answer. thanks John - On 29/06/2011 14:21, Tom Davies wrote: Hi :) Ok, can you turn it off and leave it off? Save the document, upload it, perhaps change the html to point at the new version (?). Hopefully then your website one should work the way you want it. Regards from Tom :) - Original Message From: John Bjo...@email2.me To: users@global.libreoffice.org Sent: Wed, 29 June, 2011 13:14:41 Subject: Re: [libreoffice-users][windows] Calc: Text numbers Dear Tom On my system it does not work, the autoinput seems to be part of the default settings of the program and unfortunately does not seem to attribute itself to the file. I, turned autoinput Off - my calculator sheet works as it should, I then saved it and closed LO as well. Open LO calc again, autoinput remained off (that's good), then changed the autoinput to the default On, then opened my calculator - and the problem returns regards John B - - On 29/06/2011 12:46, Tom Davies wrote: Hi :) Ahah, i think Stephen's answer is best. You will probably need to re-save the document and upload the newly saved document to the right place. Regards from Tom :) - Original Message From: John Bjo...@email2.me To: users@global.libreoffice.org Sent: Wed, 29 June, 2011 12:30:44 Subject: Re: [libreoffice-users][windows] Calc: Textnumbers Dear Tom / Stephan I have not seen this feature before in my Lotus 123 or in my old MS Excel either, it may be that the default settings in these are Off, where as the default in LO (and OOo) is clearly On. I use my calculator for anyone to download from my website and the people who download it, may not have the knowledge to switch it off. http://www.chillypepperhire.co.uk/calculator-downloads.htm - if you enter the number 8 into the Height box you will see what I mean (once you get past the open with LO and it opens in read only and you have to re-save it anyway- annoyance) I was hoping that I could just format the cell in some way so the spreadsheet could be used be anyone and not say OMG when they inadvertently enter a number and text appears (as I did). I suppose the only answer is to re-design the form (unless you know better). regards John B - - On 29/06/2011 11:35, Tom Davies wrote: Hi :) For most types of auto-complete you can just tap the Del key or any character (not enter) while the predicted part is still selected/bold/inverse. If you just press enter then the program happily thinks it guessed right. Regards from Tom :) - Original Message From: Stephan Zietsmanszi...@gmail.com To: users@global.libreoffice.org Sent: Wed, 29 June, 2011 10:09:47 Subject: Re: [libreoffice-users][windows] Calc: Text numbers John B wrote: this where, say, you enter text into a cell in column E say at E16 the text would be something 8,000 btus (or 2.34kw) Machines now if you type in the same column above or below it, say at E7 the number 8, the whole of 8,000 btus (or 2.34kw) Machines appears. That is called AutoInput I would like to turn this feature off. On Windows it is under: Tools -Cell Content - AutoInput Regards Stephan -- 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 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3732 - Release Date: 06/28/11 19:34:00 -- Unsubscribe instructions: E-mail to users+h
Re: [libreoffice-users] Mail merge
Dear Alex Thanks for the link, I had no idea of the shear quantity of bugs that are in the LO Mail merge feature, had I have known I would never have considered it, especially as there a numerous new ones being reported and the old ones as you say have been there for years - Mail merge in essence not only proves to me that it is unusable, but growing in this arena with others. I would think that greying out this option would be one answer, but then how would we find the bugs? It prompts the question does anything work properly and when I mean properly I mean fully, no bugs, no workarounds, no macro's, no file editing, no putting one thing in front of another, with full up to date documentation tutorials etc. - ( my granddads answer to everything when the revolution comes) At present I use LO as a MS doc reader / converter for incoming email attachments, which seems to work very well (but then excluding *.rtf files) , but I would genuenly like to use LO fully in the future. But after the horror of that Bug list - the developers have some mountain to climb. With word processing, I would have thought that once you get past fonts and indexing - mailmerge comes next in the pecking order. One good thing - I know how to access the bug list before I explore LO further. thanks John B -- On 26/06/2011 22:10, Alexander Thurgood wrote: Le 26/06/11 16:44, John B a écrit : Hi John, 1) On re-opening The database lost its connection to the letter and you had a chore to re-link the data fields in the *.csv file to those in the letter. Known bug. 2) To add a new contact is too complex. Known limitation. Calc Sheets/CSV files are read only when the file is being accessed by the mailmerge, i.e. being used as a datasource, it has been like this for years. 3) Merge, then adds all the fields again in bulk to the letter for a 2nd time, so you have to delete all the 1st batch Seem to recall that this too, is a known bug. 4) I thought maybe it would be better then, to add new contacts to the csv file in Calc No problem there - up until you go back to Mail merge. it corrupts the file in some way (or the 2 are incompatible). All the 1st and last letters of any word are missing, eg, company becomes ompan and zip becomes i, and it does the same to the data, then even when you merge you get nonsense data in the fields on the letter. Henceforth, totally useless. Also known bug, as far as I can remember. Look up the bugs in freedesktop : https://bugs.freedesktop.org/buglist.cgi?quicksearch=libreoffice+mail+merge and also : https://bugs.freedesktop.org/show_bug.cgi?id=34325 Alex Internal Virus Database is out of date. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3714 - Release Date: 06/19/11 19:33:00 -- 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 20:32, lee wrote: 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. I use mail merge all the time - it is quick and a joy, so - I thought that I would have a real go at getting LO mail merge to work this weekend. Mail merge unfortunately turns out to be unacceptably fragile I finally gave up on LO 3.4 after a couple of hours (plus the hours before that) - it just does not work I uninstalled 3.4 and installed 3.3.3 - This worked fine the first time (and never thereafter) to make a letter with the inbuilt standard contact fields (Title, First name etc) and made up 4 contact details I noticed that the contact list is saved as a tab delineated spreadsheet in *.csv format. One useful feature is that mail merge auto posts all the fields onto the letter for you, you can then move them (or delete) to a position of your choosing You can even copy paste fields in the letter so that the same data can appear as many times as you like on the document where you need them. All things at this point are good, excluding the fact that there is no navigation tool bar, hence you cannot just skip to the 3rd address or the 1st or last address whilst looking at the letter. Other than that, it worked exactly as it should. So if its a small, one off and you have made no mistakes - brilliant. closed all down it was at this point thereafter all things went wrong:- 1) On re-opening The database lost its connection to the letter and you had a chore to re-link the data fields in the *.csv file to those in the letter. 2) To add a new contact is too complex. 3) Merge, then adds all the fields again in bulk to the letter for a 2nd time, so you have to delete all the 1st batch 4) I thought maybe it would be better then, to add new contacts to the csv file in Calc No problem there - up until you go back to Mail merge. it corrupts the file in some way (or the 2 are incompatible). All the 1st and last letters of any word are missing, eg, company becomes ompan and zip becomes i, and it does the same to the data, then even when you merge you get nonsense data in the fields on the letter. Henceforth, totally useless. I thought that maybe 3.3.3 is not as stable as it should be, so I installed 3.2 and it is still the same (missing letters etc) Mail merge should be so simple, intuitive and above all reusable. If anybody gets this to work in a stable and repeatable way, please let me know. Also without a WYSIWYG navigation tool bar large databases would be out of the question - you also need navigation for printing, as in practice you want to print the 1st letter (to check), auto skip to the 2nd and if the 1st one is OK then you print print the rest or you can print the next one (one at a time) until you get it right. LO does not have this facility. One strange feature I noticed is that on save / print it merges and generates (in my case) all 4 letters, I assume then if you had a database of 1 names you would have a file with 1 letters (to big). John B Xp Pro sp3 LO 3.4, 3.3.3 3.2 -- 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] 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][windows]General Help and Guidence
Tom I think in view of the comments below, could you please, (if you have one compiled), a complete list of LO links to find LO info; is there a list of frequent questions? This is not sent when you first sign up to [Libreoffice-users] . I notice that links do creep in on a kind of need to know basis and some are starting to re-occur from the same / similar questions. This would seem to indicate the need for such a list from the very start. I have to say that for the Document Foundation - Documents do seem woefully short - but this might not be the case if only I knew where to find them. IMHO what might be trivial to the experts (and in fact may prove globally trivial) or even what might be considered a mega hurdle in programming, I might interpret as a mini bug or an annoyance which can be simply resolved by either a bit of knowledge or a work around. I would hate an email such as this! - but I do understand if you are giving out the same advice, time after time. oh and for us newbies to LO tutorials (the help files are well... lets say basic and need updating). regards John B -- On 24/06/2011 12:02, Tom Davies wrote: Hi :) There is no conflicting advice. Everyone is saying exactly the same thing but perhaps it's not being made clear enough. It is not worth putting the vast amount of effort required into fixing the trivial issue that almost no-one experiences and that has a simple work-around anyway. There is a guide on how to install multiple versions of LibreOffice and OpenOffice and possibly other products developed from the original StarOffice over the last decade or so. http://wiki.documentfoundation.org/Installing_in_parallel The guide is a work-around because a careless, straight install of both occasionally causes intermittent clashes on some machines in certain situations. However, the problems are RARE and only seen in a tiny percentage of systems that have multiple instances installed. At worst the problems do not cause any harm to data or security (except to cause one of the programs to close unexpectedly). They don't open any vulnerabilities in the programs nor in other programs nor in the Operating System. Fixing it requires a major re-write of the code that has been developed over the last 10years or so and if done hastily without proper and considerable planning could cause major breakages. It's not something to rush and is not something that can be sorted over-night!! LibreOffice devs are working at the first step in the process towards sorting it. The work was not supported in OpenOffice although Sun had begun the planning process. So far that first step, being done by LibreOffice devs, has taken an average of over 100 devs over 6 months. Various other benefits have been gained from that, such as tighter, faster, more secure (more stable) code. Code and functionality from other forks have been integrated into the main branch. Other functionality and developments added. Ancient bug-reports have been and are being solved along with newer issues. The program size has been drastically reduced with benefits in download size, install times and general efficiency. So it's NOT trivial, it IS being worked on and there is a simple work-around http://wiki.documentfoundation.org/Installing_in_parallel to prevent the RARE instances of a non-harmful problem which occasionally arises under circumstances that the vast majority of users would NOT experience. If people do ignore all the advice and then fail to read the simple guide that keeps on being pointed to for the very tiny number of people that want to try running both at the same time then there is a high chance they still wont encounter any problems. IF they do (and that is a big IF) then usually turning off the Quick Start in OpenOffice (not LibreOffice) and not opening both at the same time is enough to make sure the minor issue doesn't happen again. It is not worth putting the vast amount of effort required into fixing the trivial issue that almost no-one experiences and that has a simple and reasonably well-publicised work-around anyway. Regards from Tom :) From: aqualungxfekdcugj...@mailinator.com To: users@global.libreoffice.org Sent: Fri, 24 June, 2011 9:59:33 Subject: [libreoffice-users] Re: Mac people Ernest Kurtz wrote: Thank you, Alex. Is there any possibility of having an LO Mac list? This list is deluging my mailbox with queries foreign to my needs and experience. The OpenOffice.org community forum does have a http://user.services.openoffice.org/en/forum/viewforum.php?f=17 Mac-specific section as well as a http://user.services.openoffice.org/en/forum/viewforum.php?f=101 LibreOffice section , and we welcome queries from Mac people and LibO people. I recently started
Re: [libreoffice-users] using fields in a text document
Hi Lee Its called mailmerge you will love it. Tools Mailmerge regards John - On 24/06/2011 14:13, lee wrote: Hi, I have a text document with mostly static data, and since it's kind of a letter, there are a few things that are variable data, like a company name, street, city, eventually a persons name and a salutation. Now I would like to make it so that I can press a button and be presented with a form or the like that lets me fill in the variable data, inserts the data at the appropriate places into the document, saves the document to a file I specify and exports the document as PDF with a password for access rights to the PDF file set. How do I do that? Does it take some kind of advanced programming? No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3714 - Release Date: 06/19/11 19:33:00 -- 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] using fields in a text document
On 24/06/2011 14:56, lee wrote: John Bjo...@email2.me writes: Hi Lee Its called mailmerge you will love it. Tools Mailmerge Please don't top-post. The mailmerge tool requires an address list, which is something I don't have and don't want to create in this case. In lotus wordpro - which is next to pure perfection - you have click here boxes, which you place strategically in the places you need to type your data. They typically say click here to enter the date the when you do, it jumps to the next box. All my fax heders and letterheads have them. Also built in to Lotus Wordpro is an internal mini mail merge simply by typing a new field name wherever you need the data , it will save all your contact details as you go (mail merge on the fly). I have to say as yet I have not seen either of these 2 facilities in LO, however, I would have thought click here boxes were universal and I am just not looking hard enough. regards John B PS - I am trained in all circumstances to be on top! -- 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][windows]General Help and Guidence
interpret as a mini bug or an annoyance which can be simply resolved by either a bit of knowledge or a work around. I would hate an email such as this! - but I do understand if you are giving out the same advice, time after time. oh and for us newbies to LO tutorials (the help files are well... lets say basic and need updating). regards John B -- On 24/06/2011 12:02, Tom Davies wrote: Hi :) There is no conflicting advice. Everyone is saying exactly the same thing but perhaps it's not being made clear enough. It is not worth putting the vast amount of effort required into fixing the trivial issue that almost no-one experiences and that has a simple work-around anyway. There is a guide on how to install multiple versions of LibreOffice and OpenOffice and possibly other products developed from the original StarOffice over the last decade or so. http://wiki.documentfoundation.org/Installing_in_parallel The guide is a work-around because a careless, straight install of both occasionally causes intermittent clashes on some machines in certain situations. However, the problems are RARE and only seen in a tiny percentage of systems that have multiple instances installed. At worst the problems do not cause any harm to data or security (except to cause one of the programs to close unexpectedly). They don't open any vulnerabilities in the programs nor in other programs nor in the Operating System. Fixing it requires a major re-write of the code that has been developed over the last 10years or so and if done hastily without proper and considerable planning could cause major breakages. It's not something to rush and is not something that can be sorted over-night!! LibreOffice devs are working at the first step in the process towards sorting it. The work was not supported in OpenOffice although Sun had begun the planning process. So far that first step, being done by LibreOffice devs, has taken an average of over 100 devs over 6 months. Various other benefits have been gained from that, such as tighter, faster, more secure (more stable) code. Code and functionality from other forks have been integrated into the main branch. Other functionality and developments added. Ancient bug-reports have been and are being solved along with newer issues. The program size has been drastically reduced with benefits in download size, install times and general efficiency. So it's NOT trivial, it IS being worked on and there is a simple work-around http://wiki.documentfoundation.org/Installing_in_parallel to prevent the RARE instances of a non-harmful problem which occasionally arises under circumstances that the vast majority of users would NOT experience. If people do ignore all the advice and then fail to read the simple guide that keeps on being pointed to for the very tiny number of people that want to try running both at the same time then there is a high chance they still wont encounter any problems. IF they do (and that is a big IF) then usually turning off the Quick Start in OpenOffice (not LibreOffice) and not opening both at the same time is enough to make sure the minor issue doesn't happen again. It is not worth putting the vast amount of effort required into fixing the trivial issue that almost no-one experiences and that has a simple and reasonably well-publicised work-around anyway. Regards from Tom :) From: aqualungxfekdcugj...@mailinator.com To: users@global.libreoffice.org Sent: Fri, 24 June, 2011 9:59:33 Subject: [libreoffice-users] Re: Mac people Ernest Kurtz wrote: Thank you, Alex. Is there any possibility of having an LO Mac list? This list is deluging my mailbox with queries foreign to my needs and experience. The OpenOffice.org community forum does have a http://user.services.openoffice.org/en/forum/viewforum.php?f=17 Mac-specific section as well as a http://user.services.openoffice.org/en/forum/viewforum.php?f=101 LibreOffice section , and we welcome queries from Mac people and LibO people. I recently started a thread about having http://nabble.documentfoundation.org/Side-by-side-install-of-LibO-and-OOo-tp3078835p3078835.html l LibreOffice and OpenOffice.org coexist on a computer. I am hearing conflicting stories about this, some people say they have both with no trouble, others talk about serious interference between the two. I believe this situation should be addressed very soon, as it is unacceptable for one program to demand that you uninstall another first, which is the advice given in the LibreOffice 3.3.3 Release Notes. Any suggestions on how to capture developers' attention and convince them of the seriousness of the matter are welcome! -- View this message in context: http://nabble.documentfoundation.org/Mac-people-tp3092380p3103351.html Sent from the Users
Re: [libreoffice-users] using fields in a text document
Dear Lee Using my new found wealth of knowledge supplied be Tom - It looks like: this is how to do it http://www.libreoffice.org/get-help/documentation/ goto chapter 15 - using Forms in writer and it explains how to do it you also have to turn on a tool bar for it (who knew) View toolbars form design I would be so pleased to know if you get this to work. regards John B - On 24/06/2011 14:56, lee wrote: John Bjo...@email2.me writes: Hi Lee Its called mailmerge you will love it. Tools Mailmerge Please don't top-post. The mailmerge tool requires an address list, which is something I don't have and don't want to create in this case. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3714 - Release Date: 06/19/11 19:33:00 -- 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
On 24/06/2011 16:48, lee wrote: John Bjo...@email2.me writes: On 24/06/2011 14:56, lee wrote: John Bjo...@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. In lotus wordpro - which is next to pure perfection - you have click here boxes, which you place strategically in the places you need to type your data. They typically say click here to enter the date the when you do, it jumps to the next box. All my fax heders and letterheads have them. Also built in to Lotus Wordpro is an internal mini mail merge simply by typing a new field name wherever you need the data , it will save all your contact details as you go (mail merge on the fly). I have to say as yet I have not seen either of these 2 facilities in LO, however, I would have thought click here boxes were universal and I am just not looking hard enough. Thank you for bottom-posting :) Hm, that sounds like a nice feature; it's similar to what I'm doing, just without the fields. It's a little more complicated, though, since some of the data I'm entering is repeated at two places (and I enter it twice manually). There would have to be fields that are pointers to other fields already filled in --- perhaps Lotus Wordpro has something like that as well. -- Please accept my apologies for my last posting to you. It was on top and I see you really like bottom postings, I will try not to do it again 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] using fields in a text document
On 24/06/2011 16:48, lee wrote: John Bjo...@email2.me writes: On 24/06/2011 14:56, lee wrote: John Bjo...@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. In lotus wordpro - which is next to pure perfection - you have click here boxes, which you place strategically in the places you need to type your data. They typically say click here to enter the date the when you do, it jumps to the next box. All my fax heders and letterheads have them. Also built in to Lotus Wordpro is an internal mini mail merge simply by typing a new field name wherever you need the data , it will save all your contact details as you go (mail merge on the fly). I have to say as yet I have not seen either of these 2 facilities in LO, however, I would have thought click here boxes were universal and I am just not looking hard enough. Thank you for bottom-posting :) Hm, that sounds like a nice feature; it's similar to what I'm doing, just without the fields. It's a little more complicated, though, since some of the data I'm entering is repeated at two places (and I enter it twice manually). There would have to be fields that are pointers to other fields already filled in --- perhaps Lotus Wordpro has something like that as well. -- Please accept my appologies for my last posting to you. It was on top and I see you really like bottom postings, I will try not to do it again 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][windows] list boxes not stable
Dear Tom Base reminds me of a great strategy game I used to play (well still do occasionally! ) called MUST, where you click on every thing, but, unless you click in a particular sequence nothing happens. However, when you know the sequence its so simple, so obvious - that's Base I assume /I got that field by: 1. using the form wizard to quickly generate a set of text boxes linked to each field in my main table - containers. 2. rearranging the boxes. 3. changing the label field from IDContainer to something more human - record ID. / When I use the Wizard (on Forms), to generate a new form, it generates a spread sheet style page with field names ( i.e. IDContainer) as headers, no text boxes - nothing to play with, nothing would re-arrange - if only it would!. So I now have a completely blank page with just the field names as headers contained within a box. When I click on each header, I only get a drop down box to Add a column, delete a column etc. You see it's the very 1st step (that very 1st sequence) - I just cannot see it. When I use Lotus Approach, the design wizard generates all the Fields individually in the first place, I can pick them up, move them around and place where I like, delete, edit etc etc. - simple - You can make professional Forms very quickly. I am sure that this must be possible in Base. Again when you say / Here, I ran the table through a view, to attach aliases to each field that needed one, then used the view as the form source, and so automatically got the alias as a text box label. / Its easy to say, but unless there are buttons that says: make aliases and Attach aliases through a view, use view as form source (and there is not), I am no closer. /Does that answer your question? (This is all so simple that I have to wonder if somehow I completely misunderstood your question. If so, please try me again.) / Help!, I take up your offer - that's why I need a step by step walk through to make my 1st (movable) field box. regards John B MS XP pro sp3 LO 3.3.3.1 3.4 On 23/06/2011 01:29, Tom Cloyd wrote: John, On 06/22/2011 04:23 AM, John B wrote: Dear Tom I have had my own problems with Base - still to be resolved, but I thought I would check out your trials. I downloaded your file to my desktop, auto-loaded and up came 2 forms:- containers - Old Containers items Result:- the drop down boxes in containers - old, works 100% Yes indeed. But then I started over, so I could have a subform. At that point, using the form wizard was the only way I could see to get one. Still is, dammit. But none of the drop down boxes work on Containers Items Also sometimes the record shows 1 of 4 or 1 of 3 then back to 1 of 2 ( it was random) I could not get this to repeat. - you are absolutely right about this faulty form - I just think that it has become corrupted - IMHO delete and start again. Corrupted? Good thought. I wonder why I didn't think of that? It sure looks like that could be the problem. I haven't yet knowingly had that problem with Base, so I didn't think of it. On opening either form, the icons on the left (on my system) were greyed out, so I could not enter the design / edit mode - which may be a problem with my system - and has thus so far prevented me from designing a form something similar for myself. I realise now (thanks to you - with a form to play with) that you must close the form, return to the front page, right click the form and enter it in Edit mode. Yes. Opening it first, there is no way to go to edit mode. If you think you might want to edit the form, after opening it, you must first open it in edit mode, then switch to execute mode. You can then switch back to edit mode if desired. But this is really annoying as you should always be able to edit / personalise the form on the fly, hence the design / edit icon should never be greyed out. It seems the only way to achieve this is to always open in edit mode!. Agreed on both counts. An interface design flaw, IMHO. In MS Office, you can always turn on design mode, and that's a good feature, I think. When you have time, perhaps you could send me a step by step account of how did you make your 1st field? record ID on the form, I have clicked on everything that looks a likely target but no luck so far. I have many dBase files I would like to import, but Base has proved to be such hard work; and I hope it will be more stable than your 2nd form. This field and its label appear on the first form - containers - old. (old because I gave up on it when I could find no way to attach a subform to it. I could create it, but could not make it appear - a problem to which no one has yet offered a solution. You can see the created subform in the form navigator - ItemsForm.) I
[libreoffice-users][windows] Re: Mac people
Hi Alex One of the benifiets of emailers such as Thunderbird is that they have brilliant email filters built in to them. When I signed up to [libreoffice-users], I had no idea the of the good quality especially the quantity of emails I would receive. So very quickly afterwards, I created a folder just for [libreoffice-users] and I filter into that folder any email with that in the title. However, since I read a rant from a fellow Windows user about OS's and their supporters, I have decided that I would put [windows] in the title as well, to make it quite clear what operating system I am using. I am not suggesting for one minute that anyone should do the same, but if it would help with Mac People (a compromise and keep you in the main system) then you could put [Mac] in the title, then if it is OS orientated, I must admit that for me, I would be glad of the skip opportunity , with so many other interesting and apt emails. Just a thought! John B XP Pro sp3 On 23/06/2011 15:27, Alexander Thurgood wrote: Le 23/06/11 16:00, Ernest Kurtz a écrit : Thank you, Alex. Is there any possibility of having an LO Mac list? This list is deluging my mailbox with queries foreign to my needs and experience. Well it is not within my power to create one, and even if it were, I would have my reservations about doing so because in the majority of cases, most of the main problems are shared across all operating systems. Alex No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3714 - Release Date: 06/19/11 19:33:00 -- 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][windows] Re: Side by side install of LibO and OOo
Hi Being quite new to LibreOffice, when I had problems with running LO OOo at the same time, in trying to understand the problem, I discovered that its not just that LO uses the same file extensions, is that OOo is encoded within LO files with OOo pathways and file names, riddled would be a better word. If you use a file viewer such as that within Ztree, you can see when viewing LO configuration files, that so much is OOo names and OOo pathways. So much so, I cannot think how they would not conflict, just look at the LO registrymodifications.xcu file (hundred or more OOo's) What I find strange is that IBM Open Symphony mini suite (based on OOo) also uses a soffice.exe and if you run all three you will find that you have 3 separate soffice.exe's running. Symphony on the other hand does not conflict in anyway that I can find. So it can be done. My only way out in the end was to deep remove OOo using Revo-Uninstall and just hope that in the future I don't need it !!. If you want to keep LO as the default, then you need to deep clean both LO OOo, then re-install LO first, because for some reason OOo does not overwrite LO. John B xp pro sp3 LO 3.3.3.1 3.4 - On 22/06/2011 19:45, Twayne wrote: In news:itrfh0$4be$1...@dough.gmane.org, NoOpgl...@sbcglobal.net typed: On 06/18/2011 02:52 AM, Cor Nouws wrote: Hi .., aqualung wrote (18-06-11 06:12) It would be nice to have the option of keeping OOo, for the odd case when something that works in it is broken in LibreOffice, or when you need OOo installed in order to provide help to another user who has OOo but not LibO. I think that is a fair idea. The way to do this, I guess, would be to add an option in LibO's installation, e.g.: Thanks for your text. Too me, it looks good, though I am not interested myself at all, since I use parallel installation all the time ;-) Could be handy for you too: http://wiki.documentfoundation.org/Installing_in_parallel This is the issue that I brought up in December on the LO dev list: http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.devel/4130 [Change executable/sh names] Here we are on 3.4.rc1 and no further down the line. You'll need to expand some of the posts in that thread to see that I actually tested by changing the executables names that works. Sample: http://permalink.gmane.org/gmane.comp.documentfoundation.libreoffice.devel/4360 So the issue *still* remains that LO uses OOo .exe names. Does the same in Linux as well: $ ls /opt/libreoffice3.4/program about.png oosplash.bin services.rdb soffice.bin unopkg.bin bootstraprc pythonsetuprc sofficerc versionrc fundamentalrc redirectrcshell spadmin intro.png sbase simpress swriter kdefilepicker scalc smath unoinfo libnpsoplugin.so sdraw soffice unopkg When will LO stand on their own and change these? I think you've hit the nail on the head there. OOo and LO are now two different companies for want of a better word, and I've never heard of any coder wanting to use the same names for their code as another program does. Swriter etc. being common names was an eye opener I'd never thought of, but that same naming convention has been in place for a long time. I would think it falls on LO to do a search destroy on said application names since they're the newest kids on the block. Maybe it needs to be Lwriter or something; anything that's unique and unambiguous. There should be NO common files, period, IMO, so that OOo and LO can do whatever they need to do. Just as AMI, MS, WP, et al can all live together and even be run simultaneiously, so should OOo and LO. Personally I don't care and I'm not sure how valid having to install both is since there are some workarounds that might suffice, but: OTOH, it does seem like they should install peacefully, whatever the actual reason is for the problems; it just makes sense. HTH, Twayne` -- 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][windows] default type and setting for pasting
Dear Roxy (if you are still there) I hope this helps:- on my System I downloaded MS's Optical Intellimouse program and installed (I have an MS intellimouse). I am now able to select the default options for the middle button - I selected paste (ctrl+v) To paste formatted text as copied, just press the wheel To paste as unformatted text, I press the shift key and then the middle button (the wheel), up comes the special paste window box. in Word chose unformatted text and in Calc untick all, excluding text numbers then press OK. Now wherever the cursor is or cell selected, it deposits the text at that point (not where the mouse is) in the format as indicated in the sheets default settings at the top of the page i.e. if the settings say [arial] [6] - that's how the text is pasted at the cursor or in the cell. It seems that it could be a mouse problem? regards John B ms xp pro sp3 LO 3.4.0 On 21/06/2011 16:04, Roxy Robinson wrote: Even with that, there´s still the problem that the text would be inserted where the mouse pointer happens to be rather than where the cursor is. Any idea how to fix that? -- 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] Tutorial for Base Design Forms
Hi can anybody help Having had excellent help from [libreoffice-users] to load a dBase file into Base, I cannot get started in the Create Form in Design View. This is where you layout a single record for say printing the data into boxes on standard pre-printed form or as a layout to make it easier to add/ edit / phone just one record. Usually (or what I am used to) is that on opening the Design form for the 1st time, all the Fields are automatically loaded onto the form from the current database, so I can then decide what shows (what to delete) and where on the page they go. However, when I open the Design form in LO (3.3.3 3.4) it is blank and it has defeated me so far, as to how you load in all the field names. The LO Design Form is a quite complex (powerful!) in any case (even Radio buttons), is there a tutorial on LO Base Design Forms? thanks John B Windows XP Pro Sp3 LO 3.3.3 3.4 -- 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: Tutorial for Base Design Forms
Hi Alex I am hopeless. I tried the wizard in 3.3.3, sure enough the fields were added but displayed as a spreadsheet (as is data) instead of a re-designable format for just one record, AND the design /edit button is greyed out (as are most of the other buttons) and at the top, the wizard says read only. There is also no matrix. So bearing in mind what you said about creating / saving I did that in the hope that when I re-loaded it, I could edit it, but no, it opens in Word and not the Design module of Base. It makes no sense ! - its hard work! Also on some of my larger databases, on attempting to load, the software froze (repeatable), the cure is to delete soffice.exe (Ctrl-Alt-Del) and away it goes (it unfreezes) - I was so surprised. Gr John B --- On 20/06/2011 09:58, Alexander Thurgood wrote: Le 20/06/11 10:41, John B a écrit : Hi John, Rather than start with a blank form, use the wizard to help you create one. After opening your ODB file, click on the Form icon on the left. In the uppermost pane, you should see the possibility to create a new form using the wizard. Choose this option. The wizard will give you the possibility to add the fields that you want to your form, one, several, or all of them. The default settings proposed can be changed once the form has been created. Be warned that there are currently bugs in the wizard that prevent the user from setting the background colour, or anything other than a background colour, and personalising the styles of the presentation of the fields in the form, but again, you should be able to correct these once the form has been created. Alex No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3714 - Release Date: 06/19/11 19:33:00 -- 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] Feature request - Lotus Wordpro tabs
Dear Roland, Tom Alex Wow! - I actually just received a reply (Below) from the bug site:- there was me thinking all that was required was hidden extra code at the top of every page Am I a tabbed page or not? if so what is my name, do I belong to a group, My tab is green - simples I am not a programmer! But, I am more than delighted to get a response from such a source, even though, not the hopeful one I would have wished for. Its a bit like:- If you need BOLD, just put it through the printer twice I guess Roland, from you comments you must have received a similar response to your bug reports? So - Any Volunteers? Regards John B https://bugs.freedesktop.org/show_bug.cgi?id=38401 --- Comment #1 from Michael Meeksmichael.me...@novell.com 2011-06-20 07:36:10 PDT --- IMHO implementing the tab feature would take quite some work here, instead it might be good to insert a set of links in the document at the top to allow quick jumping to the various sections; But of course, this is all work. Lets see if some volunteer jumps in to do it - otherwise if you pay someone to do the work, you can have it done as you like I guess. - Le 20/06/11 01:40, Roland Hughes a écrit : Hi Roland, It won't be anywhere near close. Get a copy of SmartSuit 98 or later and see what a word processor was supposed to be. Shame that such good functionality was left by the wayside by IBM...coz it was damned handy !! Alex --- On 17/06/2011 19:37, Roland Hughes wrote: Dear John, It will not work as a bolt on. I really really REALLY thought IBM was finally going to sort this out, since they have the ENTIRE WordPro file specification. The OpenDocument file format has to have many things added to it in order to support tabbed document divisions. Mainly, it has to have XML to identify those divisions as completely separate sub documents which only allow a small amount of things to carry over from the parent/enclosing document. Each subdocument has its own flags to support current page number, print/hide, previous/next subdocs, etc. Eliminating the existing tabs and replacing them with the Window menu item IS only a programming change. It doesn't require any change to the file specification. Between the above programming change and the tabbed document specification enhancement, the OpenDocument format MUST add complete support for embedding ALL fonts used in the document within the document file. WordPerfect had this feature for decades, and that is one of the major reasons WordPerfect took so long to disappear from the market place, even though it kept charging $400+ for its product. That one little feature, combined with turning off the system wide setting for auto-format-for-default-printer, made a WordPerfect document completely portable. First we have to remove the ugly/nasty/useless tab interface. Then we have to make documents 100% portable. Then we can add tabbed document divisions just like WordPro. On Fri, 2011-06-17 at 19:28 +0100, John B wrote: Dear Roland My mistake, I thought that /[the brain dead//Microsoft//approach of having each document as a tab]/ refers to Lotus Symphony which loads each document in as a separate (big fat pointless) tab - as that is the only word software program I know, that uses those tabs (hence, what do I know!). Whilst I might think Tabs / divisions are a must have, maybe, this should be a bolt on in LibreOffice (for Smartsuite users) and not a bloat on. My eldest son, now uses Smartsuite (an MS convert) to swing proposals around and he is also writing his 1st book. [chapter 1] [chapter 2] Actually, one of the things I would miss would be not to have the ability to change the page settings in each division, how do people cope? Calling all bolt on programmers! regards John -- On 17/06/2011 16:43, Roland Hughes wrote: Dear John, uh-oh...that sounds like an ominous opening!Grin Actually, the they I refer to is every other word processor on the face of the planet. I never abused/relied on the tab system as a document control architecture. I used it to segregate out the portions of a writing project. Each chapter had its own tab, various tabs had notes and clippings from other sources, etc. You could re-arrange the tabs and put together a perfect book by tagging which tabs printed and which didn't. It was a mind blowing architecture. I don't have problems finding client documents which are 20 years old. I create a directory for each client. If I don't do any billable work for that client in 6 years, I simply delete the directory during the next OS/machine upgrade. On Fri
[libreoffice-users] default type and setting for pasting
Dear Lee I thought I would give this a go. I seems that Paste pastes everything and Past Special just what's on the tick list so ctrl +v (up comes the list - delete all the ticks but leave text and numbers) Now from copy ctrl + V gives formatted ctrl + v +ok gives unformatted regards John B LO 3.3.3 On 20/06/2011 01:06, lee wrote: Hi, how do I set a default pasting type so that when pasting, only the text itself is pasted and not the formatting with it? How do I make it so that text, when pasted with the mouse, is inserted at the position of the text cursor where it´s supposed to be inserted, rather than where the mouse pointer happens to be? No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3702 - Release Date: 06/13/11 19:34:00 -- 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] default type and setting for pasting
Dear Roxy How Strange. It must be a windows 7 thing (I hesitate to say bug) I have just booted up my Home computer, which runs 3.4.0 (windows XP sp3) I click on paste special and up comes the window with the tick boxes. Both [3.3.3 3.4] has 4 sections in the window :- Selection, Options, Operations and Shift cells. Selection Options have tick boxes, Operations shift cells are radio buttons. I have just tried your toolbar method pasting as unformatted text - excellent - that's the better way to go I tested (just like me) both methods only work on a untouched cells, if the cells have been formatted previously (bold, font size etc), neither work on my system. regards John --- On 20/06/2011 22:38, Roxy Robinson wrote: John, I use Windows7-64. In my version of LO (3.3.3), and all previous versions of OO LO I have used thus far I also get a window popup when I select Paste Special (it doesn't make any difference how you select it). In my window there is no option to tick any boxes - there are no boxes next to whatever options are in the window. In my window all available options are just listed and you have to select/highlight which option you want. Then you hit OK. But I recently found a much easier and quicker way of accomplishing the same thing. I have used the paste button on the toolbar hundreds of times. While I was copying address info into a spreadsheet recently I notice the drop down arrow next to the Paste Icon on the toolbar. I clicked on the arrow and there are the same options as in that popup window. So now when I want to paste anything as unformatted, I click that down arrow, click that option, and its done. Pretty easy and quick as far as I'm concerned. Roxy Dear Roxy I am using My Daughter rang for me to pick her up from the station - OS. and I did not check it properly Please allow me 1 mistake per year :-[ . The sequence of my events are and my interpretation of Lees request is: 1st, to Copy, highlight the text from anywhere or Cell (or cells) with the mouse (right click, copy) or ctrl+c My shortened version of this was from copy You then click on the cell on the spread sheet you want it to go in (the mouse can go anywhere after that). - which I forgot to mention Then its:- ctrl+shift+V, (or paste special) then ok (you are so right) on my 3.3.3 the paste special brings up a window with a tick list and as long as only the text numbers are ticked, it pastes in the default format. Sorry I said delete the ticks- maybe I should have said untick all the other ticked boxes I know nothing about macros. I thought it was some way of programming a key to type yours faithfully at the bottom of letters for slow typists - obviously not! So:- from copy ctrl + V gives formatted ctrl+shift+v, then ok gives unformatted with only text numbers ticked regards John B - -- On 20/06/2011 20:12, Roxy Robinson wrote: John, what OS are you using? For me, Ctrl+V is Paste only, and does not bring up any list and pastes everything. In Windows, no list is brought up where you can delete any ticks and just leave what you want. By using Ctrl+SHIFT+V I get Paste Special, and that brings up a WINDOW where you HAVE TO highlight what you want to paste. You cannot delete any of the items in the window!!! In Windows, you would have to use the Macro, just previously mentioned to accomplish what Lee wants to do. Roxy Dear Lee I thought I would give this a go. I seems that Paste pastes everything and Past Special just what's on the tick list so ctrl +v (up comes the list - delete all the ticks but leave text and numbers) Now from copy ctrl + V gives formatted ctrl + v +ok gives unformatted regards John B LO 3.3.3 On 20/06/2011 01:06, lee wrote: Hi, how do I set a default pasting type so that when pasting, only the text itself is pasted and not the formatting with it? How do I make it so that text, when pasted with the mouse, is inserted at the position of the text cursor where it´s supposed to be inserted, rather than where the mouse pointer happens to be? No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3702 - Release Date: 06/13/11 19:34:00 -- 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 No virus found in this incoming message. Checked by AVG - www.avg.com
Re: [libreoffice-users] default type and setting for pasting
Lee I am so sorry - I know Please read my later posting on this - and then ignore it anyway as Roxy has come up with a better idea. regards John B - On 20/06/2011 22:43, lee wrote: John Bjo...@email2.me writes: Now from copy ctrl + V gives formatted ctrl + v +ok gives unformatted Hm, I just tried that, neither C-v nor C-V do anything. According to the menu, something should be pasted when pressing these keys ... Perhaps it´s messed up now from my trying to change the keybindings earlier? Doesn´t matter, I never use that anyway and do it with Shift-Insert instead when not using the mouse. Unfortunately, Shift-Insert doesn´t paste unformatted text by default ... -- 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: How can I reset all settings?
Dear Jan I had a similar problem where I needed an as-new clean re-install I spent many hours on this including editing the registry (never a good idea). I wish that I had posted this first, as Roxy's idea of using Revo-Uninstall does the same (if not better) in a matter of minutes. There were other cleaners suggested, but this is the one I chose to try. However, just out of interest, the configuration files are held in docs settings/your user-name?/application data/LibraOffice which is not deleted with the standard windows un-install (bad dog!). If you say (do as I do in Options), change the rulers in Write to inches and the background colour to blue(chart12), you will find that 4 files are changed in this directory. I have absolutely no idea what does what and will probably never need to know. All the best John B On 17/06/2011 21:22, NoOp wrote: On 06/17/2011 12:51 PM, Gérard FARGEOT wrote: Message du 17/06/11 21:23 De : Jan Parttimaa A : users@global.libreoffice.org Copie à : Objet : [libreoffice-users] How can I reset all settings? Hi all! I have a question. How can I reset all settings and toolbars to defaults in LibreOffice? I already tried to unistall and reinstall LibreOffice and yes I restarted PC after unistalling but it didn't work. I still have non-default settings. I use Windows 7 (64-bit). Sincerely Jan Parttimaa Reset your user profile : http://user.services.openoffice.org/en/forum/viewtopic.php?p=58401#p58401 Gérard And change all 'openoffice.org' to 'libreoffice.org' in those instructions. -- 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] search does not find (
Dear Thomas Whilst I am not suggesting you try LibraOffice 3.4, but it works on my computer using 3.4 It was not an exhaustive test but it found ( ) * # [ % - until I got fed up John B On 18/06/2011 03:07, Thomas Blasejewicz wrote: Good morning (Windox XP desktop, LO 3.3.0) just noticed: the search function DOES NOT find ordinary brackets: (, ), [, ] etc. (not regular expression etc. ...) THESE are not any form of special characters. Every software I know of with a search function can find these ASCII characters. What is so special about them, that LO does NOT find them (they are right there on the screen!). Recently I have started working with LO, but this kind of really stupid problems makes me wonder ... In case there is a solution, I would like to hear it. Thank you. Thomas -- 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] *dbf files open in Calc not Base
Hi The standard for many years for Database files was *.dbf (dBase) and I have many. It is very strange that in LibreOffice this opens up in Calc and not Base, no matter how I try to force it. Calc is simply not good enough to handle Database files. This is also confirmed in the File Open lists:- dBase(.dbf) is listed in Calc and it is absent from Base Is this a bug - have I missed something ? regards John B Windows XP Pro Sp3 LibreOffice 3.4 -- 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] Feature request - Lotus Wordpro tabs
Tom Thanks - I have posted the request below today - I will let you know if I get a response. I note that on the new IBM Lotus Symphony Web site - this has to be the most angered and fought for request (1000's), but IBM have now disowned its own software in favour of making the new cut down 3 progs suit not compatible, OOo used to!, but LibreOffice have taken up the challenge in as much as LO can read the files - although the original formatting is a bit hit and miss. [wish-list] /There must be 10's of thousands of Lotus Smart Suite users who use Lotus Wordpro who cannot move (locked in) to any other software because of a brilliant internal tab filing structure within wordpro. This is where you can put standard tabs inside Group tabs. Because Libreoffice thankfully support Lotus Smart Suite documents (and IBM no longer do), you would be the natural inheritor for all these folk. At the moment I am not aware of any other software that even have tab documents within a Word processor so you would be unique. One tab can be for any amount of pages (also called a division). The beauty of tab documents is that in one file you can have all the documents for say one client, one book etc. laid out in say years +2011, +2010 . +1995 or chapters etc. and inside (by clicking the +) the group tab opens up and you can have inside other tabs for all that years correspondence or headings or whatever etc). Now by having them all in one file, then a document produced in say 2000 is not archived or deleted as every time a new document is added the whole file is updated to the current date, so backing up by current date massively improves. I have files on current clients that go back to 1991, the + means that it is a group tab and that there are other tabs inside (and maybe more inside them) etc., Hence its an effective filing structure to handle multi documents. I have group tabs that go like this +1990's +1991 Contracts (then a single tab 12/03/91 Hence, you can also go straight to a division, click on it and Print it as a separate item. You can copy paste, insert, you can move a tab, (like making it the 1st or last page(s) in a document. The problem now is that if a Wordpro document, fully tabbed with say 10 - 1000 Tabs and by transferring it to LibreOfice it just becomes an unmanageable 10 to say 10,000 pages, with no structure. Managing large documents or many documents over a long period of time becomes achievable with Tabs (divisions) I would have thought that this would be useful in any word processor. Please consider this Thank you John Brassington / -- On 10/06/2011 14:42, Tom Davies wrote: Hi :) This guide might help? http://wiki.documentfoundation.org/BugReport I think i would post as a normal bug but put at the start of the subject-line (unless the guide has better advice!) Regards from Tom :) From: John Bjo...@email2.me To: users@global.libreoffice.org Sent: Fri, 10 June, 2011 12:20:01 Subject: [libreoffice-users] Feature request - area? Is there an area where Feature Requests are posted? 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 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3691 - Release Date: 06/09/11 19:34:00 -- 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] Feature request - Lotus Wordpro tabs
Dear Roland It reminds me of that Guinness Ad on Cold Guinness where the barman says your the 15th person today I've told that there is no call for Cold Guinness. I remember the 1st time I saw Lotus Smart Suite, this chap had just 2 files - Private and Business, he opened up the private one and inside were group tabs saying [+Gas], [+Electricity] etc - it thought of course, it was like a Eureka moment. Ask any other software user to find a current client document from 6 months ago let alone 10, 20 years ago!; And of course if you have a client called Fred Bloggs you don't have to think up new file names each time you send a new letter such a fred_blogs_fax_17_06_11_reply_London_office. I am assuming the they you refer to, is IBM thanks John B -- On 17/06/2011 15:20, Roland Hughes wrote: If you visit the bug report site, you will see I have filed several bugs on this issue. They cannot implement WordPro tabs until they implement WordPro windows for documents. Right now they have taken the brain dead Microsoft approach of having each document as a tab. On Fri, 2011-06-17 at 14:56 +0100, John B wrote: Tom Thanks - I have posted the request below today - I will let you know if I get a response. I note that on the new IBM Lotus Symphony Web site - this has to be the most angered and fought for request (1000's), but IBM have now disowned its own software in favour of making the new cut down 3 progs suit not compatible, OOo used to!, but LibreOffice have taken up the challenge in as much as LO can read the files - although the original formatting is a bit hit and miss. [wish-list] /There must be 10's of thousands of Lotus Smart Suite users who use Lotus Wordpro who cannot move (locked in) to any other software because of a brilliant internal tab filing structure within wordpro. This is where you can put standard tabs inside Group tabs. Because Libreoffice thankfully support Lotus Smart Suite documents (and IBM no longer do), you would be the natural inheritor for all these folk. At the moment I am not aware of any other software that even have tab documents within a Word processor so you would be unique. One tab can be for any amount of pages (also called a division). The beauty of tab documents is that in one file you can have all the documents for say one client, one book etc. laid out in say years +2011, +2010 . +1995 or chapters etc. and inside (by clicking the +) the group tab opens up and you can have inside other tabs for all that years correspondence or headings or whatever etc). Now by having them all in one file, then a document produced in say 2000 is not archived or deleted as every time a new document is added the whole file is updated to the current date, so backing up by current date massively improves. I have files on current clients that go back to 1991, the + means that it is a group tab and that there are other tabs inside (and maybe more inside them) etc., Hence its an effective filing structure to handle multi documents. I have group tabs that go like this +1990's +1991 Contracts (then a single tab 12/03/91 Hence, you can also go straight to a division, click on it and Print it as a separate item. You can copy paste, insert, you can move a tab, (like making it the 1st or last page(s) in a document. The problem now is that if a Wordpro document, fully tabbed with say 10 - 1000 Tabs and by transferring it to LibreOfice it just becomes an unmanageable 10 to say 10,000 pages, with no structure. Managing large documents or many documents over a long period of time becomes achievable with Tabs (divisions) I would have thought that this would be useful in any word processor. Please consider this Thank you John Brassington / -- On 10/06/2011 14:42, Tom Davies wrote: Hi :) This guide might help? http://wiki.documentfoundation.org/BugReport I think i would post as a normal bug but put at the start of the subject-line (unless the guide has better advice!) Regards from Tom :) From: John Bjo...@email2.me To: users@global.libreoffice.org Sent: Fri, 10 June, 2011 12:20:01 Subject: [libreoffice-users] Feature request - area? Is there an area where Feature Requests are posted? 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 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3691 - Release Date: 06/09/11
[libreoffice-users] Feature request - Lotus Wordpro tabs
Dear Roland My mistake, I thought that /[the brain dead//Microsoft//approach of having each document as a tab]/ refers to Lotus Symphony which loads each document in as a separate (big fat pointless) tab - as that is the only word software program I know, that uses those tabs (hence, what do I know!). Whilst I might think Tabs / divisions are a must have, maybe, this should be a bolt on in LibreOffice (for Smartsuite users) and not a bloat on. My eldest son, now uses Smartsuite (an MS convert) to swing proposals around and he is also writing his 1st book. [chapter 1] [chapter 2] Actually, one of the things I would miss would be not to have the ability to change the page settings in each division, how do people cope? Calling all bolt on programmers! regards John -- On 17/06/2011 16:43, Roland Hughes wrote: Dear John, uh-oh...that sounds like an ominous opening!Grin Actually, the they I refer to is every other word processor on the face of the planet. I never abused/relied on the tab system as a document control architecture. I used it to segregate out the portions of a writing project. Each chapter had its own tab, various tabs had notes and clippings from other sources, etc. You could re-arrange the tabs and put together a perfect book by tagging which tabs printed and which didn't. It was a mind blowing architecture. I don't have problems finding client documents which are 20 years old. I create a directory for each client. If I don't do any billable work for that client in 6 years, I simply delete the directory during the next OS/machine upgrade. On Fri, 2011-06-17 at 16:17 +0100, John B wrote: Dear Roland It reminds me of that Guinness Ad on Cold Guinness where the barman says your the 15th person today I've told that there is no call for Cold Guinness. I remember the 1st time I saw Lotus Smart Suite, this chap had just 2 files - Private and Business, he opened up the private one and inside were group tabs saying [+Gas], [+Electricity] etc - it thought of course, it was like a Eureka moment. Ask any other software user to find a current client document from 6 months ago let alone 10, 20 years ago!; And of course if you have a client called Fred Bloggs you don't have to think up new file names each time you send a new letter such a fred_blogs_fax_17_06_11_reply_London_office. I am assuming the they you refer to, is IBM thanks John B -- On 17/06/2011 15:20, Roland Hughes wrote: If you visit the bug report site, you will see I have filed several bugs on this issue. They cannot implement WordPro tabs until they implement WordPro windows for documents. Right now they have taken approach of having each document as a tab. On Fri, 2011-06-17 at 14:56 +0100, John B wrote: Tom Thanks - I have posted the request below today - I will let you know if I get a response. I note that on the new IBM Lotus Symphony Web site - this has to be the most angered and fought for request (1000's), but IBM have now disowned its own software in favour of making the new cut down 3 progs suit not compatible, OOo used to!, but LibreOffice have taken up the challenge in as much as LO can read the files - although the original formatting is a bit hit and miss. [wish-list] /There must be 10's of thousands of Lotus Smart Suite users who use Lotus Wordpro who cannot move (locked in) to any other software because of a brilliant internal tab filing structure within wordpro. This is where you can put standard tabs inside Group tabs. Because Libreoffice thankfully support Lotus Smart Suite documents (and IBM no longer do), you would be the natural inheritor for all these folk. At the moment I am not aware of any other software that even have tab documents within a Word processor so you would be unique. One tab can be for any amount of pages (also called a division). The beauty of tab documents is that in one file you can have all the documents for say one client, one book etc. laid out in say years +2011, +2010 . +1995 or chapters etc. and inside (by clicking the +) the group tab opens up and you can have inside other tabs for all that years correspondence or headings or whatever etc). Now by having them all in one file, then a document produced in say 2000 is not archived or deleted as every time a new document is added the whole file is updated to the current date, so backing up by current date massively improves. I have files on current clients that go back to 1991, the + means that it is a group tab and that there are other tabs inside (and maybe more inside them) etc., Hence its an effective filing structure to handle multi documents. I have group tabs that go like this +1990's +1991 Contracts (then a single
Re: [libreoffice-users] Windows Open with - reprise - Call for a cleaner
Dear Tom Roxy /i remember this one getting to a slightly unsatisfactory but 'good enough' result?/ Yes; Thanks to both of you ( and the others for their comments). I can see how easy it is to get off track. I installed the free version of Revo-Uninstaller - brilliant I then tried it out on my weakest link - OpenOffice My non-scientific observation is that OO can uninstall about 50% of itself, whilst Revo uninstalled 99.9%. There were a few OO crumbs left in the Registry (as opposed to the 50 -60 using windows uninstall). This is a definite must have program from now on. However, this does not resolve the windows issue that Open With, as it defaults to the 1st one of the 2 installed. For example now the reverse of my problem is true. LO (good news for me) is now the default, I try to open any file using openwith and the browser button, I manually select OO click on it, but it immediately springs back to LO and opens with LO. There is no way to force capture OO using this method. I have tried this now on a 2nd computer and the results were the same. In all other ways its a reasonable result. Whilst they (OO LO) are using identical file names and pathways, I suppose it will remain like this until one or the other changes the names - maybe soffice.exe will become Loffice.exe. What I do not understand is that Lotus Symphony also uses a soffice.exe and it works fine. so thanks and all hail to LibreOffice-users John B - Hi:) Did you manage to sort this problem out in the end? I know quite a few questions from Thursday and Friday got missed and need to be re-posted. I think i remember this one getting to a slightly unsatisfactory but 'good enough' result? Regards from Tom:) On 11/06/2011 16:10, Roxy Robinson wrote: I would suggest using RevoUninstaller to do ANY program uninstalling, and there is a free version. I have used it with great success for quite a few years. If you use the 4th option from the uninstall dialog window, it will use the programs normal uninstaller, first. Then it scans for all leftovers that has left. You will go through a couple of steps where the program will show you what it has found, including what is left in the registry. It lets you pick and choose what you want to delete, or you can choose all and delete. Very seldom have I ever had it leave any crumbles of a program I no longer wanted on my machine. On the open with issue, always be sure, when you have picked a program to open with from the browse window, that the little box in the bottom, left hand corner of that window is checked. It says something like always open this type file with this program. Just a couple of suggestions that may help you out in the future. Roxy Robinson Thanks for the start: I un-installed just OpenOffice and it made no difference - but I was on the move The finish went like this:- Un-install:- Open office, Lotus Symphony and Libra Office Then in Regedit (about 2 hours):- Delete any mention of the above 3 programs and Delete:- all mentions of soffice.exe, swriter etc Delete the directories for the above in Application Data and the Program folders. Then re-install Libra office 3.4 - it works! - I can now use open with Then I re-installed Lotus Symphony 1 - that works with open with Then I re-installed Open office 3.3 - and now that does NOT work with open with. So its whoever is installed first! I am not too bothered this way around as OpenOffice does not cater for Lotus Smart suite files whilst LibreOffice does all praise to LibreOffice. BUT, none of those 3 gets a star for cleanliness when de-installing. regards John B - On 10/06/2011 21:15, Tom Davies wrote: Hi :) Un-installing OpenOffice often cures weird and unlikely problems especially in Windows. There is still often a clash between OpenOffice and LibreOffice when both are installed on a system. There are some clever ways to install both but i don't have a note of any of the various instructions and have not compared their reliability or effectiveness. Often the main problems occur when the Quick Launcher/Starter is enabled within OpenOffice. Even without that they both use the same names on the command-line, such as soffice --writer so the scope for errors and confusions is quite high. Usually just using the Open with .. and then browsing to the relevant program is enough to push that program to the short-list in the Open with .. option. Regards from Tom :) From: John Bjo...@email2.me To: users@global.libreoffice.org Sent: Fri, 10 June, 2011 14:46:28 Subject: [libreoffice-users
[libreoffice-users] Windows Open with - the answer - Call for a cleaner
Thanks for the start: I un-installed just OpenOffice and it made no difference - but I was on the move The finish went like this:- Un-install:- Open office, Lotus Symphony and Libra Office Then in Regedit (about 2 hours):- Delete any mention of the above 3 programs and Delete:- all mentions of soffice.exe, swriter etc Delete the directories for the above in Application Data and the Program folders. Then re-install Libra office 3.4 - it works! - I can now use open with Then I re-installed Lotus Symphony 1 - that works with open with Then I re-installed Open office 3.3 - and now that does NOT work with open with. So its whoever is installed first! I am not too bothered this way around as OpenOffice does not cater for Lotus Smart suite files whilst LibreOffice does all praise to LibreOffice. BUT, none of those 3 gets a star for cleanliness when de-installing. regards John B - On 10/06/2011 21:15, Tom Davies wrote: Hi :) Un-installing OpenOffice often cures weird and unlikely problems especially in Windows. There is still often a clash between OpenOffice and LibreOffice when both are installed on a system. There are some clever ways to install both but i don't have a note of any of the various instructions and have not compared their reliability or effectiveness. Often the main problems occur when the Quick Launcher/Starter is enabled within OpenOffice. Even without that they both use the same names on the command-line, such as soffice --writer so the scope for errors and confusions is quite high. Usually just using the Open with .. and then browsing to the relevant program is enough to push that program to the short-list in the Open with .. option. Regards from Tom :) From: John Bjo...@email2.me To: users@global.libreoffice.org Sent: Fri, 10 June, 2011 14:46:28 Subject: [libreoffice-users] Windows Open with To open a selected Document with LibreOffice does anyone know how to make LibraOffice appear in the Windows Open With (and stay there). Even when I use the browse within the open with , then locate LibreOffice manually, it still does not work, as when I click on LibreOffice or Writer (applications), its ignored and the system jumps back to the browsing list. Also Libra Office does not appear in the recommended programs list, whilst OpenOffice does and works fine. Windows XP pro sp3 Libre Office 3.3 3.4 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 -- 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] How can I make long words stay on their starting line?
Hi In the past using different software (Ami Pro lotus smartsuite) I had created a text box to go past the margins or reduced the font size to keep it on the same line (or both); it works for me as I don't particularly like word wrapping or word splitting. But these 2 ideas might help in the mean time. John B --- On 10/06/2011 08:49, Stephan Zietsman wrote: never punctual wrote: Thanks for the suggestions so far. I guess hyphenation could be useful in some cases, but it seems to be more of a luxury for me to have that feature at the moment because I'm still not sure how the Tools -- Language -- Hyphenation option works. However, I did look into the Word Wrap option. All the options under Format -- Wrap are greyed out, and I think this is why: http://user.services.openoffice.org/en/forum/viewtopic.php?f=7t=32373start=0 I think that Word Wrap option refers to wrapping around pictures, and not what I want to do (leave the first part of the long word on the line it started on). I think this is why it's greyed out by default; I would have to paste a picture and select it or something in order to set those Word Wrap options. Ron, I think your workaround is very clever, and it worked perfectly with URLs at least. After inserting a space to split the URL, I basically created 2 separate URLs that I could fix by editing the hyperlink. In fact, I can generalize this option to long words that aren't URLs; it would actually be easier in those cases because I would just have to choose a place to split the word and not have to worry about fixing the hyperlinks to make them clickable. But is there a less time consuming and more standardized option? The short term problem with this workaround is that I have to guess at where the word should be split. It would be easier of Libreoffice Writer gave the option of allowing the long word to continue until no more characters fit in the original line instead of just bumping the whole word down to the next line, because then I won't have to figure out the exact point at which no more characters would fit. Splitting it with a space means the user is left to do all the work that could be automated by Libreoffice. The lack of this feature bothers me so much that I'm tempted to learn C++ just to add it :( -- Unsubscribe instructions: E-mail tousers+h...@global.libreoffice.org In case of problems unsubscribing, write topostmas...@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 Hi never punctual, I think hyphenation is probably what you're looking for. It can be applied manually or automatically. I just tested it with your superduperlongURL and it looks like it works. It is described in the wiki, I suggest you read it there: http://help.libreoffice.org/Writer/Hyphenation In summary (taken from the wiki page): To Automatically Hyphenate Text in a Paragraph: 1. Right-click in a paragraph, and choose Paragraph. 2. Click the Text Flow tab. 3. In the Hyphenation area, select the Automatically check box. 4. Click OK. To Automatically Hyphenate Text in Multiple Paragraphs: If you want to automatically hyphenate more than one paragraph, use a paragraph style. For example, enable the automatic hyphenation option for the Default paragraph style, and then apply the style to the paragraphs that you want to hyphenate. 1. Choose Format - Styles and Formatting, and then click the Paragraph Styles icon. 2. Right-click the paragraph style that you want to hyphenate, and then choose Modify. 3. Click the Text Flow tab. 4. In the Hyphenation area, select the Automatically check box. 5. Click OK. 6. Apply the style to the paragraphs that you want to hyphenate. To Manually Hyphenate Single Words: To quickly insert a hyphen, click in the word where you want to add the hyphen, and then press Ctrl+Hyphen(-). Regards Stephan No virus found in this incoming message. Checked by AVG -www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3691 - Release Date: 06/09/11 19:34:00 -- 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] Feature request - area?
Is there an area where Feature Requests are posted? 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
[libreoffice-users] Windows Open with
To open a selected Document with LibreOffice does anyone know how to make LibraOffice appear in the Windows Open With (and stay there). Even when I use the browse within the open with , then locate LibreOffice manually, it still does not work, as when I click on LibreOffice or Writer (applications), its ignored and the system jumps back to the browsing list. Also Libra Office does not appear in the recommended programs list, whilst OpenOffice does and works fine. Windows XP pro sp3 Libre Office 3.3 3.4 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