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 Meeks 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 copy&paste 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 Douglas 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] 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] 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] 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 (Insert>frame), 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!
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 (Insert>frame), 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 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 (Insert>frame), 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 Royston To: "users@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] 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: Tinkerer 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
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 B 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 Brown 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** 09&category=announcements<http://www-03.ibm.com/software/lotus/symphony/buzz.nsf/web_DisPlayPlugin?open&unid=955E9C0EC712EC47852578CD0063A209&category=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.**org In case of problems unsubscribing, write to postmaster@documentfoundation. **org Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette<http://wiki.documentfoundation.org/Netiquette> List archive: http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/> All messages sent to this list will be publicly archived and cannot be deleted -- 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 Brown 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=955E9C0EC712EC47852578CD0063A209&category=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
[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: Tinkerer 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] OASIS - and its Documents
Dear Regina You are a cruel person;-) , I downloaded the documents from OASIS you suggested, to find over 1,500 pages. The first 150 pages is just the Index, (it needs an index to the Index) You must think I am "Sheldon Cooper". Do you think you could reduce it to say 3 paragraphs, with pop ups and an area for me to colour in!. It needs a better Outline at the beginning, to understand the purpose and the overall rationale for a 1st time reader. I notice that it is all >:- Copyright © OASIS Open 2002 - 2011 < How does that effect "The Document Foundation"? - where is the DF. I am not sure how anyone (Excluding Sheldon Cooper! ) could remember the entire contents to formulate whether its a new bug, an old bug or from, "We like it this way" to "There is nobody who can change it". regards John B ----- Hi John, John B schrieb: [..] ** Who is / are OASIS? OASIS is the organization, which prepared the ODF1.0 specification, which then became ISO standard. Now OASIS works on ODF1.2. This is currently in puplic review. For details and download links see http://lists.oasis-open.org/archives/office/201106/msg00061.html We will do our best to help you getting familiar with LibreOffice. 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
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
Hello Regina I have ** inlaid my answers, its good to see such a different and more apt perspective, one I am going to have to get used to. thanks --- On 13/07/2011 14:14, Regina Henschel wrote: Hi John, John B schrieb: Dear Regina The way LO explains (you mention), its not a bug, but that does not mean that it is correct either and can be classed as a false positive. It is not until you have practical use. LO follows the standard ODF and acts the same as main competitors. There are some aspects, (1) You can argue, that the standard should be changed to specify the behavior directly and do not leave it to the implementations. If you think so, you should write an request to OASIS. (2) You think, that LO should behave different to Excel, OOo, and Gnumeric. Then you need very good rationals. (3) You want to achieve something, but might have used a wrong way. Then you should first explain, what you want to achieve. It is likely, that you need different formula. ** Yes I fully understand this, its just when I are used to Lotus 123, then I can understand why you think the way you do; and yes I do think (wish) that LO should emulate 123. In 123, in the main, does not need to do any cell tweaking, it does it all for you. ** Who is / are OASIS? For example if a box ="" (say in B1 which means empty) "box" is "cell"? If you write ="" into a cell, the cell is not empty. Test with ISBLANK() will result in FALSE and tests with ISFORMULA() and ISTEXT() will result in TRUE. It is a common error to consider an empty string as empty cell. then box stays blank ** I can see why you would need all the" IS xyz" functions in LO and Excel, although Excel is not something I would hold up as a good example. **even in LO "" still means empty cell, for the purposes of the sheets default mathematical calculation mechanism (not for other purposes - agreed). **try in cells * E9* =IF(D9="","","full") and then in* F9* =IF(E9="","empty","full") then type in a number / letter into *D9* and then delete* D9 *(toggle)* *you will see what I mean . but if box A1 = a number, then a set amount appears in B1 (in business most people do not like a page full of zero's and unused amounts appearing for no good reason) Then they should format the cell not to show a zero. ** This will not work where you have an amount showing (the false Positive) formatting it to No zero's will only help when a zero appears (how annoying) ** a new command is needed ISFALSEPOSITIVE then ignore! What you _don't_ want to happen is as per LO, if you place any Letter in A1 then the amount shows eg (a very common formula) in B1 =IF(A1=0,"",4.5) - which happens if you put any non number (a space) in A1 even by accident, B1 will show 4.5 (a false positive). So the formula is unsuitable, use =IF(N(A1)=0;"";4.5) for example. But as mentioned above, not showing a zero is a matter of formatting and an empty string is still a string and not a value for to use in number calculations. ** This is only unsuitable in LO (and your stated industry standards)- please accept that again in 123 it is all taken care for you. I have used 123 for nearly 20years! ** I can see I am going to have to think how the LO sheet works before:- how I want it to work. Also if you now add up the row B with false positives, that would give the wrong answer as well. As mentioned before in Lotus 123 this does not happen. That is the crux with "implementation-defined". ** LO / Excel "implementation-defined"(whatever that means?) is such hard work! However, I suppose it depends on your point of view and the software you are used too. But it does mean that in the case Alejo showed, it is a false positive, which has to be manually formula-ed out. It is the old problem with hidden, automatic conversions and the same old rule "Never calculate with strings", but do explicit conversions before. ** There is a fundamental difference between the two method of operation - which I think is the crux of the matter ** In cell say in A3 you have the formula A1+ B1 and the purpose is to add numbers (which is 99% of the time the purpose in spread sheets) **In LO1 + a = #value! (error) > work needs to be done! **In 123 1 + a = 1 (correct) > with no messing about **Hence >/ It is the old problem //and the same old rule "Never calculate with strings"/ - never applied to me, as the original "old" industry standard spreadsheet took care of it. **This is great (and good), because you can "simply" type in text in the middle (say adding up a column in D11 =Sum(d1:d10) then in D6, now if you enter Nil or Not in Stock or FOC etc,123 simply ignored it. T
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(A1>10,"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 Henschel
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(A1>10), 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.documentfo
Re: [libreoffice-users] Error in Calc logical functions
I had another play with this LO logic buster this morning. Whilst in Lotus 123 would only need @IF(A1>10,"True","False") the way LO works the formula needs to be:-( placed in say B1 looking at cell A1) to cater for LO's rationale and possibly to cover prior versions. =IF(A1="","",IF(A1>N,"",IF(A1>10,"True","False"))) N has to max out above any number in your list (eg 1000) as it would appear that any Letter is seen by LO as greater than the highest possible number, to block this and to prevent the table seeing Letters as Numbers you need N. With N in place, if you type in a letter into cell A1, then B1 remains blank and does not to give a false positive (or negative). regards John B ---- On 12/07/2011 19:37, John B wrote: Got it Regina is correct, so:- =IF(A1>50,"False",IF(A1>10,"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(A1<11 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(A1<11,"False",IF(A1>10,"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(A1>10), 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 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] Error in Calc logical functions
Dear Regina The way LO explains (you mention), its not a bug, but that does not mean that it is correct either and can be classed as a false positive. It is not until you have practical use. For example if a box ="" (say in B1 which means empty) then box stays blank but if box A1 = a number, then a set amount appears in B1 (in business most people do not like a page full of zero's and unused amounts appearing for no good reason) What you _don't_ want to happen is as per LO, if you place any Letter in A1 then the amount shows eg (a very common formula) in B1 =IF(A1=0,"",4.5) - which happens if you put any non number (a space) in A1 even by accident, B1 will show 4.5 (a false positive). Also if you now add up the row B with false positives, that would give the wrong answer as well. As mentioned before in Lotus 123 this does not happen. However, I suppose it depends on your point of view and the software you are used too. But it does mean that in the case Alejo showed, it is a false positive, which has to be manually formula-ed out. I cannot see any case where the reverse would be of practical use, if a box is expecting a number and you enter in a letter then "nothing" should be the result - In which case its a bug - unless - you know better? regards John B --- On 12/07/2011 22:08, Regina Henschel wrote: Hi Tom, Tom Davies schrieb: Hi :) It might e worth posting a bug-report http://wiki.documentfoundation.org/BugReport The advice in the guide might be useful but far more useful is the link to post a bug-report. Where do you see a bug? For me the behavior is correct. 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
Re: [libreoffice-users] Mail merge saved into individual documents
This is a pain The way I did it was to print the entire document using the PDF (and not "returning to Mail Merge Wizard" - whilst you are in Personalise Mode), this also gets rid of the blank pages (how strange!), then exporting the PDF file to Paperport, ( by Scansoft - a scanner program) which has the ability to unstack 1 or all the pages (one click) into separate pages with (editable) sequential file names. I have mentioned before with LO mail merge that it needs a tool and navigation bar (preferable one copied from Lotus Word Pro). regards John B --- On 12/07/2011 21:12, nvrk wrote: On Tue, Jul 12, 2011 at 11:21 AM, Steve Edmonds wrote: On 13/07/11 4:14 AM, Olivier Bietzer wrote: Hello, Using LibreOffice after some years under OOo... The Mail merge has an option to save the merged documents into one single document OR into individual documents, with some parameters to give an individual name to each doc... But this does NOT work, it does only create one single document... This was working in an older OOo (3.0 ??) but does not work in 3.3, and neither into LO 3.4.1... Does anyone else see that problem ?? Regards, Olivier Confirmed, suggest you file a bug. steve -- Unsubscribe instructions: E-mail to users+help@global.libreoffice.**org In case of problems unsubscribing, write to postmaster@documentfoundation. **org Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette<http://wiki.documentfoundation.org/Netiquette> List archive: http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/> All messages sent to this list will be publicly archived and cannot be deleted Encountered this some months ago with OOo. Investigation revealed that (1) a bug had been filed; (2) that OOo rewrote the print module for ver3.3.3 which resulted in the fault, and: (3) LibO picked it up from OOo. The solution for me so far is to revert to a OOo version that worked. All the best, nvsoar -- 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(A1>50,"False",IF(A1>10,"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(A1<11 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(A1<11,"False",IF(A1>10,"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(A1>10), 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
Alejo The strange thing is is that if you reverse the logic such as =IF(A1<11 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(A1<11,"False",IF(A1>10,"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(A1>10), 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
Tom That was the very 1st thing I thought, so I ran charmap on Arial and chose an accii code less than a number such as # and it still comes up TRUE. It should either come up as False or Error A bug I think regards John B - On 12/07/2011 18:20, Tom Davies wrote: Hi :) In ascii code the alphabetic characters are 'higher' than the numbers. So A is calculated as being higher than any number. Remember that the machine doesn't really understand letter or numbers as we read them. They are all just binary digits. the binary digit that represents the character A is 'higher' than one representing a number. Regards from Tom :) From: Alejo C.S. To: users@global.libreoffice.org Sent: Tue, 12 July, 2011 18:05:29 Subject: [libreoffice-users] Error in Calc logical functions 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(A1>10), 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
I can repeat this:- and therefore it is actually very wrong, A is not greater than 10, hence it should read False I used Lotus 123 to check this out and is comes up False in 123 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(A1>10), 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] 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: Twayne 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 McKracken typed: Am 07.07.2011, 21:19 Uhr, schrieb Twayne : [...] 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] Re: Save odt/ods files take too much time
Did not spot the .ppt the 1st time around 3.5s open and close - the same John B --- On 12/07/2011 16:12, Johnny Rosenberg wrote: 2011/7/12 John B: 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 Well, isn't .pptx also a compressed file, like .odp? I think it is. 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. What happens if you save as .ppt instead? Regards Johnny Rosenberg ジョニー・ローゼンバーグ 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 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: 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] 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] 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
[libreoffice-users] Re: problem in impress
Nawfel
Actually, I have revisited your example.
I thought originally your hand written "(1" and the "(2" were arabic
characters and not (1 and (2,
I think what you are trying to say is that the ")" should be a "(" and
on the other side of the number instead of 1) and 2). I completely
understand.
In which case I have not a clue - sorry about that.
Best of luck in your endeavors
John B
---
On 04/07/2011 13:00, Nawfel wrote:
if the problem is in the font
why the the problem does not happen in Writer
and why it does not happen when the text is selected
here is a screenshot
https://docs.google.com/uc?id=0B2nciG4JCjulYmVlNzhlYWQtYzI4NC00MzhiLWFlODAtMTRkZTI4ODFmMjk0&export=download&hl=en_US
--
View this message in context:
http://nabble.documentfoundation.org/problem-in-impress-tp3137230p3137328.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] 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=0B2nciG4JCjulZWQyNGM5ZTgtNmQ1MC00ZmM1LTgyNWQtNWFkNDU4ZTI4MzYz&export=download&hl=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
[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
[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
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
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] 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] [3.4] Cutting section in PDF file?
Dear Giles You could open your PDF in adobe first, highlight and copy the desired part content, then close adobe, open in Draw and paste; it pastes as its own box and full size. It works for me, hope this works for you. John xp pro sp3 LO 3.3.3 -- On 29/06/2011 15:01, Gilles wrote: (I first posted through Nabble withouth having subscribed to the mailing-list, so this might be sent twice) Hello , I need to select and cut a squared-section in a PDF file. After opening the file in Draw with the PDF format, I'm shown the whole document as a big image, but I couldn't find if it's possible to select just one part of the page and cut a section. FWIW, the PDF was built with "Xerox WorkCentre 7345" and uses PDF version 1.3 So I used LibreOffice to save the PDF as TIFF, opened it in PaintShopPro (7), and removed the section. But when I re-open the TIFF in LibreOffice so I can save it back to PDF, it's displayed as a very tiny image (about 1/3 of the original as displayed in PaintShopPro), even with Zoom=100%. Does someone know why Draw does this? Is there a way to do this in LibreOffice so I can avoid the PDF -> TIFF -> PDF shuffle? Thank you. -- View this message in context: http://nabble.documentfoundation.org/3-4-Cutting-section-in-PDF-file-tp3121732p3121732.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][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 B 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 B 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 Zietsman 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
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 B 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 Zietsman 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...@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 / 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 Zietsman 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...@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 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. 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] 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 B 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] Re: using fields in a text document
On 25/06/2011 14:07, lee wrote: Frieder 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] 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 FILE>>TEMPLATES>>EDIT and select the default.ott. Edit (below) the file and save to overwrite the original. To change the default settings for margins, paper size FORMAT>>PAGE 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][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] using fields in a text document
On 24/06/2011 16:48, lee wrote: John B writes: On 24/06/2011 14:56, lee wrote: John B 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 "" 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] using fields in a text document
On 24/06/2011 16:48, lee wrote: John B writes: On 24/06/2011 14:56, lee wrote: John B 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 "" 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
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 B 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
[libreoffice-users][windows]General Help and Guidence
Dear Tom Thank you so much /but may be noobs at certain other areas/ I think when it comes to LO, I qualify for ALL areas, hoping to become "Noob the lesser" regards John - On 24/06/2011 15:17, Tom Davies wrote: Hi :) I am sorry about both those 2 previous emails. There is some (limited) documentation at http://www.libreoffice.org/get-help/documentation/ or http://wiki.documentfoundation.org/Documentation The documentation team would greatly appreciate any help and they are a very helpful team. It's a great way to learn a lot and to learn it fast. The documentation is mostly already written but needs a substiantial re-working from the old OpenOffice guides before it can be put on the website i just gave a link to. Partly this is due to extra functionality that has been developed by LibreOffice devs but also the screen-shots need updating and some that was work-in-progress anyway. The first release has only been completed for Writer and Calc and the Starter Guide. Base is the one that needs the most work as a lot of it needs to be pulled together from scratch or scattered blogs and bits of training programs. People are actively working on Draw, Impress and i think Math so more guides should appear over the next few weeks. Lulu are publishing proper books that can be bought http://stores.lulu.com/opendocument with a good percentage of the profit going to TDF. The wiki is a good place to hunt for things that are works-in-progress from the various different teams http://wiki.documentfoundation.org/Main_Page I couldn't find the FAQ page because there seemed to be different ones for each different app (Writer, Calc, Impress etc) and in a lot of different languages. I think the release notes for whichever version you are using might be more useful because each release seems to cure more issues and has more functionality. Development is fast-paced even in the stable 3.3.x branch. Similar questions do arise from new people all the time and that is fine. Different people have different tehnical backgrounds but may be noobs at certain other areas so it's not always easy to guess whether someone might be insulted by a non-technical answer or feel hopelessly overwhelmed by one that is too technical. Usually the best way is to keep asking questions and perhaps give an indication of your own background. Yday in a different forum in a question about getting a printer to work the person had been a web-designer for 20 years but had apparently never needed to trouble-shoot a printer! Asking them to "ping the printer" was the nudge they needed and they were then able to 'guess' the new ip-address for the new printer and their Network Admin was able to take that and fix the Dhcp server to re-issue the old ip-address to the new printer. Errr and an early stage had been someone hadn't plugged the network cable in! So the early answer of "check the leads" helped! None of them could solve the entire problem on their own but together they got it done with just a gentle couple of nudges that a different bunch of people might not have understood and would have had to solve differently. Giving the same advice to different people time-after-time is not a problem. As you pointed out Faqs and Documentation can often help and need to be updated even after they are done first time. Copy&paste can also help but usually questions introduce new slants or bring in different side-issues. The person from earlier needs to take the advice given earlier in other threads where that person has asked the same question; of talking to the devs mailing list, or post a bug-report or check to see if they still have a problem after using the work-arounds. If they had asked the question under a different name or if a different person had asked the question then i would have given a shorter, and more polite, possibly even friendly answer combining some of those ways of moving forwards. Regards from Tom :) From: John B To: users@global.libreoffice.org Sent: Fri, 24 June, 2011 13:49:19 Subject: 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
[libreoffice-users] using fields in a text document
On 24/06/2011 14:56, lee wrote: John B 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 "" 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
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
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: aqualung 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 re
[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
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
[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, NoOp 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
Re: [libreoffice-users][windows] default type and setting for pasting
Dear Lee This may be a work around until this is resolved I downloaded ms intellimouse software, which allows programming different functions of mouse buttons for different programs. I was amazed it worked as I have not used this software before. I selected "settings", "add" libreOffice, on the "wheel button" I selected "Macro" wrote the macro as :>> ctrl+shift+v, down arrow,down arrow, down arrow, enter > saved (ok) then I copied some formatted text and clicked the wheel It placed the text, now unformatted, at the text cursor position and not the mouse position. regards John B Xp pro sp 3 LO 3.3.3.1 On 22/06/2011 16:51, lee wrote: Hi, I´ve entered two feature requests about this: lee writes: how do I set a default pasting type so that when pasting, only the text itself is pasted and not the formatting with it? https://bugs.freedesktop.org/show_bug.cgi?id=38572 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? https://bugs.freedesktop.org/show_bug.cgi?id=38573 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] list boxes not stable
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% 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. 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. 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!. 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. I would also like to use the "Create form" instead of the wizard - it looks a better option than the wizard with its grid system for lining up fields. But I cannot make head nor tale of it. regards John B MS xp pro sp3 LO 3.3.3.1 - On 22/06/2011 08:59, Tom Cloyd wrote: My list box disaster just don't quit. To this point, I've learned that the only quick, simple way to get a list box onto a form is to use the list box wizard. Last night it worked. Tonight it worked. Then, it stopped. I now have a form with 5 list boxes. Three have spontaneously, quite without reason, disabled themselves. They passively display the value in their source table pointed to by the key value in the linked main table fie.d. BUT, the display is now a ghostly gray. I have had to change the background color just to see it at all. They also no longer are a part of the tab order and you cannot click into them at all. Also, the drop down no longer works at all. It is now just a data display field, not a list box. Worthless. I have poured over their properties for over an hour, trying to find the problem. No luck. Another formerly working list box appears still to work, but will not update the main record field to which it is linked (this is the problem I was having last night, before I started using only the wizard to make list boxes). Finally, I find that I can no longer CREATE functioning list boxes, using the wizard, which puts me out of the list box business altogether. I just rebooted, hoping it might help, but it didn't (small chance!). You can download this troubled database for examination HERE <http://www.tomcloyd.com/misc/storage_containers.zip>. Look at the "storage containers > items" form. You'll see that my subform is working fine, The three brown-background list boxes are now duds. The "quadrant" list box appears to work but actually does nothing to the main table. The "macro-container" list box is recently created, and does exactly what the brown boxes do: nothing. Any ideas, anyone? 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] 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] 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 B 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
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://listarchi
[libreoffice-users] default type and setting for pasting
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 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] 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
[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 Meeks 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! 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
Re: [libreoffice-users] Re: How can I reset all settings?
Dear Tastaafl Well said, it also made me laugh Maybe there should be 2 levels of un-install called "un-install all" or "un-install all all" However, just out of interest by renaming the file extension of the file:- registrymodifications.xcu to say >> *.xcc (this file is in Dos & settings/user?/Application Data/3/user) When I opened LO, registrymodifications.xcu was re-created and reset LO to default settings. I then deleted this new file and renamed the old *.xcc back to *.xcu and my old settings were thankfully returned. I think this also neatly resolves this issue of "how do I reset all settings" and without having to de & re-install LO Thanks John B - On 20/06/2011 12:25, Tanstaafl wrote: On 2011-06-18 7:23 AM, John B wrote: 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!). No... good dog... just because I uninstall a program doesn't mean I want my settings deleted. But you are correct - the easiest way to 'start over' is to simply move or delete this directory (best to move it, then if it doesn't fix your problem, you can move it back and not lose all of your settings)... 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] 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
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
[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] "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] 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
[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! 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 a
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 B 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.o
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 B 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] 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 sh
[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 B 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] 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
[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] 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=7&t=32373&start=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
