Re: [libreoffice-users] printing non-standard page sizes
Hi Matthew, Matthew Monaco schrieb: I've always had a lot of trouble printing when I setup a custom page size in the page properties. It seems like the print dialog tries to find the best fit of the predefined page sizes. Yes. The printer tells what paper size it is able to handle. And LO searches the best fitting from them. Unfortunately, the printer does not tell whether this paper size is really available. So your printer might go into a waiting mode and you have to enter the paper manually. Furthermore, I have no clue what the manual option is attempting to do. Is there something I'm missing here? The behavior is different for Writer, Calc, Draw and Impress. Generally there are two ways to get fitting of page format and paper size. You can tell your printer what to do. For example my printer can print with scaling 80%. Or you can tell LO what to do. Especially Draw and Calc have a lot of options. You should describe a concrete task, if you want detailed help. Kind regards Regina -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Writer images disappeared!
Tony Just downloaded 3.4.2 from Filehippo, tested and at this moment cannot find any bug fixes from 3.4.1. However, the disappearing pics still happens in this version for saving in .docx format Now, I know some people are not keen on this work around, but if you paste your picture into a text box (Insertframe), it works. You have to remove the box borders so that the text box does not show *and* they will stop the pictures moving around. regards John XP sp3 LO 3.4.2- OOO340m1 (Build:201) -- On 22/07/2011 10:50, Tony Royston wrote: Thank you Jorge, I will try that and report back my findings. Tony. -Original Message- From: jorge [mailto:jrodrigue...@cpcecr.com] Sent: Friday,22 July, 2011 0:34 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Writer images disappeared! Hi I suggest you to do this: 1) Save the original document (.docx) as .odt 2) Look if .odt document is correct 3) If it is correct save .odt document as .docx 4) Look if it is correct. Regards, Jorge Rodríguez El mié, 20-07-2011 a las 16:22 +0100, Tom Davies escribió: Hi :) Can you try saving as Doc instead of DocX? The older format often produces much better results. Regards from Tom :) From: Tony Roystontony.roys...@mercyships.org To: users@global.libreoffice.orgusers@global.libreoffice.org Sent: Wed, 20 July, 2011 16:02:23 Subject: [libreoffice-users] Writer images disappeared! Hi everyone, I have a Writer question. I am using 3.4.1 on Vista, and I successfully opened a docx file containing text and photos. I did some minor text editing, then saved the document with a new filename but still as a docx. When I opened that file, the images had disappeared! Any ideas? It's not a disaster as I still have the original document, but I would like to be able to save images with docx! Thanks, Tony Royston. This message and any attachments may be privileged or otherwise protected from disclosure - Mercy Ships. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3779 - Release Date: 07/21/11 16:13:00 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Writer images disappeared!
On 07/22/2011 08:47 AM, John B wrote: Now, I know some people are not keen on this work around, but if you paste your picture into a text box (Insertframe), it works. You have to remove the box borders so that the text box does not show *and* they will stop the pictures moving around. Interesting. Historically, I had to remove pictures from text frames before they would export (so I stopped placing images in text boxes if I had to later convert to an MSO file format). John, I take your comment to say that this should work (image in a frame) if the text frame is not visible. Tony, are your images embedded in the document, or are they inserted as links? How are the images anchored? I always anchor AS CHARACTER when I want to export to an MSO format Are the images in a text frame? If yes, what happens if you have an image that is NOT in a text frame? -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Writer images disappeared!
Andrew /#//John, I take your comment to say that this should work (image in a frame) if the text frame is not visible. //#/ It works either way, with or without borders, I mentioned having to remove boarders because they come as a default with the frame (annoying) - I would get rid of them!. I use text boxes all the time. regards John B -- On 22/07/2011 14:20, Andrew Douglas Pitonyak wrote: On 07/22/2011 08:47 AM, John B wrote: Now, I know some people are not keen on this work around, but if you paste your picture into a text box (Insertframe), it works. You have to remove the box borders so that the text box does not show *and* they will stop the pictures moving around. Interesting. Historically, I had to remove pictures from text frames before they would export (so I stopped placing images in text boxes if I had to later convert to an MSO file format). John, I take your comment to say that this should work (image in a frame) if the text frame is not visible. Tony, are your images embedded in the document, or are they inserted as links? How are the images anchored? I always anchor AS CHARACTER when I want to export to an MSO format Are the images in a text frame? If yes, what happens if you have an image that is NOT in a text frame? No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3779 - Release Date: 07/21/11 16:13:00 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Writer images disappeared!
Hi :) I think the DocX format throws images around to some very strange places and often stacked on top of each nearly off the page. I think the text frame blocks them from moving far and could be left visible to provide a nice frame. Personally i think sticking to Odt or Doc or even Pdf formats would be easier. Pdf can't be edited by many people but does have the advantage of looking exactly the same on every machine. I think the problem is not so severe when there are only 1 or 2 pictures in the entire document which suggests that using Draw might be better as it a much larger number of embedded images more easily, but of course that might mean using an Open Document Format or a picture format or Pdf rather than DocX. Regards from Tom :) From: Andrew Douglas Pitonyak and...@pitonyak.org To: users@global.libreoffice.org Sent: Fri, 22 July, 2011 14:20:04 Subject: Re: [libreoffice-users] Writer images disappeared! On 07/22/2011 08:47 AM, John B wrote: Now, I know some people are not keen on this work around, but if you paste your picture into a text box (Insertframe), it works. You have to remove the box borders so that the text box does not show *and* they will stop the pictures moving around. Interesting. Historically, I had to remove pictures from text frames before they would export (so I stopped placing images in text boxes if I had to later convert to an MSO file format). John, I take your comment to say that this should work (image in a frame) if the text frame is not visible. Tony, are your images embedded in the document, or are they inserted as links? How are the images anchored? I always anchor AS CHARACTER when I want to export to an MSO format Are the images in a text frame? If yes, what happens if you have an image that is NOT in a text frame? -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Writer images disappeared!
Andrew, Thanks for your reply. The images are embedded and not in a frame. The anchoring used is whatever is default, I didn't select anything specific. I shall try altering the anchoring, and using a frame, and see what happens. Regards, Tony. -Original Message- From: Andrew Douglas Pitonyak [mailto:and...@pitonyak.org] Sent: Friday,22 July, 2011 13:20 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Writer images disappeared! On 07/22/2011 08:47 AM, John B wrote: Now, I know some people are not keen on this work around, but if you paste your picture into a text box (Insertframe), it works. You have to remove the box borders so that the text box does not show *and* they will stop the pictures moving around. Interesting. Historically, I had to remove pictures from text frames before they would export (so I stopped placing images in text boxes if I had to later convert to an MSO file format). John, I take your comment to say that this should work (image in a frame) if the text frame is not visible. Tony, are your images embedded in the document, or are they inserted as links? How are the images anchored? I always anchor AS CHARACTER when I want to export to an MSO format Are the images in a text frame? If yes, what happens if you have an image that is NOT in a text frame? -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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 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
RE: [libreoffice-users] Writer images disappeared!
Thanks John, I will try that. So, no real difference from 3.4.1 to 3.4.2 then? OK, so I wouldn't expect too many changes, but the odd bug fix would be nice!! Tony. -Original Message- From: John B [mailto:jo...@email2.me] Sent: Friday,22 July, 2011 12:47 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Writer images disappeared! Tony Just downloaded 3.4.2 from Filehippo, tested and at this moment cannot find any bug fixes from 3.4.1. However, the disappearing pics still happens in this version for saving in .docx format Now, I know some people are not keen on this work around, but if you paste your picture into a text box (Insertframe), it works. You have to remove the box borders so that the text box does not show *and* they will stop the pictures moving around. regards John XP sp3 LO 3.4.2- OOO340m1 (Build:201) -- On 22/07/2011 10:50, Tony Royston wrote: Thank you Jorge, I will try that and report back my findings. Tony. -Original Message- From: jorge [mailto:jrodrigue...@cpcecr.com] Sent: Friday,22 July, 2011 0:34 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Writer images disappeared! Hi I suggest you to do this: 1) Save the original document (.docx) as .odt 2) Look if .odt document is correct 3) If it is correct save .odt document as .docx 4) Look if it is correct. Regards, Jorge Rodríguez El mié, 20-07-2011 a las 16:22 +0100, Tom Davies escribió: Hi :) Can you try saving as Doc instead of DocX? The older format often produces much better results. Regards from Tom :) From: Tony Roystontony.roys...@mercyships.org To: users@global.libreoffice.orgusers@global.libreoffice.org Sent: Wed, 20 July, 2011 16:02:23 Subject: [libreoffice-users] Writer images disappeared! Hi everyone, I have a Writer question. I am using 3.4.1 on Vista, and I successfully opened a docx file containing text and photos. I did some minor text editing, then saved the document with a new filename but still as a docx. When I opened that file, the images had disappeared! Any ideas? It's not a disaster as I still have the original document, but I would like to be able to save images with docx! Thanks, Tony Royston. This message and any attachments may be privileged or otherwise protected from disclosure - Mercy Ships. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3779 - Release Date: 07/21/11 16:13:00 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted 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
[libreoffice-users] Compute difference
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(). -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Writer images disappeared!
Tony Some in-bedded pictures are more in-bedded than others, when this happens I blow the picture up as big as I can, then use screen print, paste into my Picture editor (Paint Shop Pro), crop my desktop to just the picture and save as a .jpg or just copy paste into the word text box - simples. It may seem complex, but its very quick and of course it does help if you have 2 monitors. regards John On 22/07/2011 15:03, Tony Royston wrote: Andrew, Thanks for your reply. The images are embedded and not in a frame. The anchoring used is whatever is default, I didn't select anything specific. I shall try altering the anchoring, and using a frame, and see what happens. Regards, Tony. -Original Message- From: Andrew Douglas Pitonyak [mailto:and...@pitonyak.org] Sent: Friday,22 July, 2011 13:20 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Writer images disappeared! On 07/22/2011 08:47 AM, John B wrote: Now, I know some people are not keen on this work around, but if you paste your picture into a text box (Insertframe), it works. You have to remove the box borders so that the text box does not show *and* they will stop the pictures moving around. Interesting. Historically, I had to remove pictures from text frames before they would export (so I stopped placing images in text boxes if I had to later convert to an MSO file format). John, I take your comment to say that this should work (image in a frame) if the text frame is not visible. Tony, are your images embedded in the document, or are they inserted as links? How are the images anchored? I always anchor AS CHARACTER when I want to export to an MSO format Are the images in a text frame? If yes, what happens if you have an image that is NOT in a text frame? No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3779 - Release Date: 07/21/11 16:13:00 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] help recovering?
I do not know if this will help, but viewers can be more forgiving than editors. Try http://www.officeviewers.com/ or http://visioo-writer.tuxfamily.org/EN/index_3.html if it does - you will have to copy paste back into LO again you might have to google a few more until you find one that works. regards John B -- On 22/07/2011 17:42, JeepNut wrote: Hoping for some good news here. Am using the openSuSE branded version of LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice-3.3.3.1 on openSuSE 11.3 and KDE 4.4.4-1.5. Was editing a document that is pretty important (to me at least) and during the process had tried to add a footnote. I was editing the text in the footnote and almost immediately there was some flashing of the screen and LibreOffice crashed, locking up the entire PC. No mouse control, no keyboard control, nothing. So I had to reset the PC. Now the document is fubar. When I try to open it, LibreOffice attempts to recover but fails. Then it tries to repair the file but opens only a blank page. I've tried to open it without an extension and get a list of a variety of application types to attempt any modicum of recovery, but no matter what I try to open it with it either fails, or opens in a file of unreadable gibberish. I'd be THRILLED if someone would be able to actually recover this document for me. Nothing secret in it, I'd be happy to email it to anyone who'd like to give it a try. Even just to get back the text out of it so that I could rebuild would be fabulous. Any chance at all to recover? -- View this message in context: http://nabble.documentfoundation.org/help-recovering-tp3191906p3191906.html Sent from the Users mailing list archive at Nabble.com. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3781 - Release Date: 07/22/11 10:32:00 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] help recovering?
Hi :) If it's saved in odt or docX then you could try opening the file with an archive manager. I might be able to have a look in Ubuntu using LibreOffice 3.3.2 if you send me the attachment off-list. Regards from Tom :) From: John B jo...@email2.me To: users@global.libreoffice.org Sent: Fri, 22 July, 2011 18:37:22 Subject: 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 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: help recovering?
On 07/22/2011 09:42 AM, 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? ... Open it with archive manager and see if there is any info in content.xml. Any surviable text should be in that file. BTW: Do you by chance have an intel graphics card in your system? -- 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] 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
Re: [libreoffice-users] Writer images disappeared!
Hi :) The 3.4.1 is development branch for 'early adopters' and has some advanced features but also has oddities and maybe even regressions. It's a bit like seeing a play or a movie on the opening night or in the first week. I suspect that the 3.4.2 will be much the same. The 3.3.3 is the latest release of the stable branch and supported for a year apparently although it's not clear exactly what that means. A bit like watching a football match after everyone has told you all about the highlights and who won. It lacks some of the newer features but it's less quirky, less surprises. Anyone with the 3.4.1 is probably well advised to install the 3.3.3 alongside for when they need reliability but it's not easy so this guide should help with that. http://wiki.documentfoundation.org/Installing_in_parallel Regards from Tom :) From: Tony Royston tony.roys...@mercyships.org To: users@global.libreoffice.org users@global.libreoffice.org Sent: Fri, 22 July, 2011 15:05:31 Subject: RE: [libreoffice-users] Writer images disappeared! Thanks John, I will try that. So, no real difference from 3.4.1 to 3.4.2 then? OK, so I wouldn't expect too many changes, but the odd bug fix would be nice!! Tony. -Original Message- From: John B [mailto:jo...@email2.me] Sent: Friday,22 July, 2011 12:47 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Writer images disappeared! Tony Just downloaded 3.4.2 from Filehippo, tested and at this moment cannot find any bug fixes from 3.4.1. However, the disappearing pics still happens in this version for saving in .docx format Now, I know some people are not keen on this work around, but if you paste your picture into a text box (Insertframe), it works. You have to remove the box borders so that the text box does not show *and* they will stop the pictures moving around. regards John XP sp3 LO 3.4.2- OOO340m1 (Build:201) -- On 22/07/2011 10:50, Tony Royston wrote: Thank you Jorge, I will try that and report back my findings. Tony. -Original Message- From: jorge [mailto:jrodrigue...@cpcecr.com] Sent: Friday,22 July, 2011 0:34 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Writer images disappeared! Hi I suggest you to do this: 1) Save the original document (.docx) as .odt 2) Look if .odt document is correct 3) If it is correct save .odt document as .docx 4) Look if it is correct. Regards, Jorge Rodríguez El mié, 20-07-2011 a las 16:22 +0100, Tom Davies escribió: Hi :) Can you try saving as Doc instead of DocX? The older format often produces much better results. Regards from Tom :) From: Tony Roystontony.roys...@mercyships.org To: users@global.libreoffice.orgusers@global.libreoffice.org Sent: Wed, 20 July, 2011 16:02:23 Subject: [libreoffice-users] Writer images disappeared! Hi everyone, I have a Writer question. I am using 3.4.1 on Vista, and I successfully opened a docx file containing text and photos. I did some minor text editing, then saved the document with a new filename but still as a docx. When I opened that file, the images had disappeared! Any ideas? It's not a disaster as I still have the original document, but I would like to be able to save images with docx! Thanks, Tony Royston. This message and any attachments may be privileged or otherwise protected from disclosure - Mercy Ships. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3779 - Release Date: 07/21/11 16:13:00 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted 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
[libreoffice-users] Given up spellchecking?
Writer seems to have stopped spellchecking, even though I have the standard dictionary set correctly (I think, to English -UK), and all the other language options I can find being set correctly, and in fact set the same way as before it (recently) stopped spell checking. A manual spell check finds no errors whatsoever (I've put some in, to make sure), there are no words underlined in red to indicate misspelling, and if I put in an incorrectly spelled word, LO doesn't complain. More than that, each time I access the dialog (sic :-) ) to set the hyphenating, it presents itself as English (USA), however many times I set it to English (UK). This is LO 3.3.2, under Fedora (15). It was working until very recently. A large proportion of KDE has updated in the last couple of days, but I don't see that this should have a bearing on this part of LO. Any ideas? Regards Mark Stanton One small step for mankind... -- 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
Hi :) I think John's answer was mostly so you could copypaste into the right places! To do the formatting in the first part of his answer click on the cell and then look up at the menus at the top of the LibreOffice window. The menus should be something like File .. View ... Edit ... (err i can't remember) ... Format ... (more i can't remember) ... Window ... Help So, click on the Format menu, choose Cell and a pop-up box should appear with lots of tabs at the top. Choose the first one, General (or something). Somewhere on the left should be an option for Date which then gives you various sub-options. Hope this helps but there is a guide with screen-shots somewhere that might help so don't worry if it's not obvious. See Chapter 5 http://www.libreoffice.org/get-help/documentation/ Regards from Tom :) From: Dave Douglas ddougl...@farmersagent.com To: users@global.libreoffice.org Sent: Fri, 22 July, 2011 20:06:33 Subject: Re: [libreoffice-users] Compute difference Thanks, but I am not a programmer. I have troubles being understood in English. Is there a way of doing it through the menus? Feeling unworthy, Dave -Original Message- From: John B Sent: Friday, July 22, 2011 12:00 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Compute difference Try this b4 is formatted to Date, 31/Dec c4 is text to d4 is formatted to Date, 31/dec E4 = ((-B4+D4)/7 +(1/7) f4= Trunc(e4) g4= (+e4-F4)*7 then type in your 2 dates into b4 and d4 as in 01/07/2011 and 22/07/2011 regards John B On 22/07/2011 15:15, Jérôme Fenal wrote: Hi all, I need to do a difference in days between two dates, _without_ taking into account leap years (e.g. considering all years are 365 days long). The right way to do that would be to use function DAYS360(date1;date2;method) using method = 3 as in other financial functions, but it does seems to be implemented (only 0 non 0 are meaningful for this function currently). Does anybody know how to still do this without ressorting to a procedural language ? Regards, J. PS: I'll be digging into BZ to see if there is already a request for such an enhancement to DAYS360(). No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3779 - Release Date: 07/21/11 16:13:00 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted Introducing the Farmers Value Program - Big Discounts on Business Services Visit us on the web at http://www.farmersbusinessinsurance.com/farmers-value-program.html -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Given up spellchecking?
Hi :) Grrr, this does seem to happen in LibreOffice occasionally. It's not just you and probably nothing to do with the updates in KDE either. I can't remember how to solve it but it's in one of the messy threads if you are able to search them? I think it's something to do with Tools - Options - Language Settings and then both the Languages and Writing Aids have settings you need to re-set (hopefully just once more). The chap that knows most about this is likely to be on-line a little later and might be able to help better. There is probably a bug-report about it already http://wiki.documentfoundation.org/BugReport Good luck and regards from Tom :) From: Mark Stanton m...@vowleyfarm.co.uk To: users@global.libreoffice.org Sent: Fri, 22 July, 2011 20:36:24 Subject: [libreoffice-users] Given up spellchecking? Writer seems to have stopped spellchecking, even though I have the standard dictionary set correctly (I think, to English -UK), and all the other language options I can find being set correctly, and in fact set the same way as before it (recently) stopped spell checking. A manual spell check finds no errors whatsoever (I've put some in, to make sure), there are no words underlined in red to indicate misspelling, and if I put in an incorrectly spelled word, LO doesn't complain. More than that, each time I access the dialog (sic :-) ) to set the hyphenating, it presents itself as English (USA), however many times I set it to English (UK). This is LO 3.3.2, under Fedora (15). It was working until very recently. A large proportion of KDE has updated in the last couple of days, but I don't see that this should have a bearing on this part of LO. Any ideas? Regards Mark Stanton One small step for mankind... -- 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] Calc: Enter works as paste, even when Enter is reserved for edit mode.
Hi :) It might be better to use a different key. Enter can get messy and confusing Regards from Tom :) From: mrelwood mrelw...@yahoo.com To: users@global.libreoffice.org Sent: Fri, 22 July, 2011 1:56:18 Subject: [libreoffice-users] Calc: Enter works as paste, even when Enter is reserved for edit mode. In the prefs I selected to use Enter key for entering edit mode. Now whenever I have cells copied to the clipboard, instead of entering the edit mode, Enter key functions as paste. Two shorttcuts shouldn't overlap like this. I didn't find a preference to turn of Enter-pasting. -- View this message in context: http://nabble.documentfoundation.org/Calc-Enter-works-as-paste-even-when-Enter-is-reserved-for-edit-mode-tp3190065p3190065.html Sent from the Users mailing list archive at Nabble.com. -- 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] Incorrect row height when opening a Calc file.
Hi :) Ouch. That is really inconvenient. Please could you post a bug-report about it? http://wiki.documentfoundation.org/BugReport Regards from Tom :) From: mrelwood mrelw...@yahoo.com To: users@global.libreoffice.org Sent: Thu, 21 July, 2011 23:52:02 Subject: [libreoffice-users] Incorrect row height when opening a Calc file. I created an .xls file with OpenOffice 3.3 on OSX 10.6.8. Opening the file now on OSX 10.7, OpenOffice shows the document correctly (row height 0,67cm), but LibreOffice shows the row height at around 0,44cm, which makes about a third of the text to be chopped off. The issue appears in about 7% of my .xls files, and on some the text is chopped just slightly. It's not a big deal to re-adjust the row height for a few documents, but this might be something the devs would like to look into. One of the files with the issue can be found at: http://db.tt/uBzFayj -- View this message in context: http://nabble.documentfoundation.org/Incorrect-row-height-when-opening-a-Calc-file-tp3189917p3189917.html Sent from the Users mailing list archive at Nabble.com. -- 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] Incorrect row height when opening a Calc file.
On 7/22/2011 1:24 PM, Tom Davies wrote: Hi :) Ouch. That is really inconvenient. Please could you post a bug-report about it? http://wiki.documentfoundation.org/BugReport Regards from Tom :) From: mrelwoodmrelw...@yahoo.com To: users@global.libreoffice.org Sent: Thu, 21 July, 2011 23:52:02 Subject: [libreoffice-users] Incorrect row height when opening a Calc file. I created an .xls file with OpenOffice 3.3 on OSX 10.6.8. Opening the file now on OSX 10.7, OpenOffice shows the document correctly (row height 0,67cm), but LibreOffice shows the row height at around 0,44cm, which makes about a third of the text to be chopped off. The issue appears in about 7% of my .xls files, and on some the text is chopped just slightly. It's not a big deal to re-adjust the row height for a few documents, but this might be something the devs would like to look into. One of the files with the issue can be found at: http://db.tt/uBzFayj You can adjust height and width of all rows and columns simultaneously. Click the space at the corner, top of the row numbers, left of the column letters (this selects the entire spreadsheet) next drag the first row bottom line downward as much as you like. It will adjust all rows. Same for columns. Joe Conner, Poulsbo, WA USA -- 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] Incorrect row height when opening a Calc file.
Hi :) Yes it's fixable but it shouldn't break in the first place. A double click on the line between any 2 rows adjusts all the rows to their optimal height once the entire sheet has been selected with Ctrl A or as described by Joe so it's very quick to fix but that needs to be done every time the spreadsheet is opened when saved as xls. Regards from Tom :) From: JOE Conner joeconner2...@gmail.com To: users@global.libreoffice.org; mrelwood mrelw...@yahoo.com Sent: Fri, 22 July, 2011 22:05:59 Subject: Re: [libreoffice-users] Incorrect row height when opening a Calc file. On 7/22/2011 1:24 PM, Tom Davies wrote: Hi :) Ouch. That is really inconvenient. Please could you post a bug-report about it? http://wiki.documentfoundation.org/BugReport Regards from Tom :) From: mrelwoodmrelw...@yahoo.com To: users@global.libreoffice.org Sent: Thu, 21 July, 2011 23:52:02 Subject: [libreoffice-users] Incorrect row height when opening a Calc file. I created an .xls file with OpenOffice 3.3 on OSX 10.6.8. Opening the file now on OSX 10.7, OpenOffice shows the document correctly (row height 0,67cm), but LibreOffice shows the row height at around 0,44cm, which makes about a third of the text to be chopped off. The issue appears in about 7% of my .xls files, and on some the text is chopped just slightly. It's not a big deal to re-adjust the row height for a few documents, but this might be something the devs would like to look into. One of the files with the issue can be found at: http://db.tt/uBzFayj You can adjust height and width of all rows and columns simultaneously. Click the space at the corner, top of the row numbers, left of the column letters (this selects the entire spreadsheet) next drag the first row bottom line downward as much as you like. It will adjust all rows. Same for columns. Joe Conner, Poulsbo, WA USA -- 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] Incorrect row height when opening a Calc file.
Da: Tom Davies tomdavie...@yahoo.co.uk A: users@global.libreoffice.org Inviato: Ven 22 luglio 2011, 23:45:30 Oggetto: Re: [libreoffice-users] Incorrect row height when opening a Calc file. Hi :) Yes it's fixable but it shouldn't break in the first place. A double click on the line between any 2 rows adjusts all the rows to their optimal height once the entire sheet has been selected with Ctrl A or as described by Joe so it's very quick to fix but that needs to be done every time the spreadsheet is opened when saved as xls. Regards from Tom :) From: JOE Conner joeconner2...@gmail.com To: users@global.libreoffice.org; mrelwood mrelw...@yahoo.com Sent: Fri, 22 July, 2011 22:05:59 Subject: Re: [libreoffice-users] Incorrect row height when opening a Calc file. On 7/22/2011 1:24 PM, Tom Davies wrote: Hi :) Ouch. That is really inconvenient. Please could you post a bug-report about it? http://wiki.documentfoundation.org/BugReport Regards from Tom :) From: mrelwoodmrelw...@yahoo.com To: users@global.libreoffice.org Sent: Thu, 21 July, 2011 23:52:02 Subject: [libreoffice-users] Incorrect row height when opening a Calc file. I created an .xls file with OpenOffice 3.3 on OSX 10.6.8. Opening the file now on OSX 10.7, OpenOffice shows the document correctly (row height 0,67cm), but LibreOffice shows the row height at around 0,44cm, which makes about a third of the text to be chopped off. The issue appears in about 7% of my .xls files, and on some the text is chopped just slightly. It's not a big deal to re-adjust the row height for a few documents, but this might be something the devs would like to look into. One of the files with the issue can be found at: http://db.tt/uBzFayj You can adjust height and width of all rows and columns simultaneously. Click the space at the corner, top of the row numbers, left of the column letters (this selects the entire spreadsheet) next drag the first row bottom line downward as much as you like. It will adjust all rows. Same for columns. Joe Conner, Poulsbo, WA USA - - - Hello all, I'm not sure this is what you want, but if you change the character size of your default style, you can open your documents with the right row height. You can do this through the style and formatting window (F11), editing -- default (right clic it) and then -- character size. If you just want to use this for certain documents, you can create a model with your desired height. Here is your file with trebuchet size 16 as default. http://dl.dropbox.com/u/9434397/Tapsa%20Kansa%20-%20Paattyneet%20on%20Paivat%20-%20F.xls Namastè! cico :) -- 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] Given up spellchecking?
Mark On Fri, 2011-07-22 at 20:36 +0100, Mark Stanton wrote: Writer seems to have stopped spellchecking, even though I have the standard dictionary set correctly (I think, to English -UK), and all the other language options I can find being set correctly, and in fact set the same way as before it (recently) stopped spell checking. A manual spell check finds no errors whatsoever (I've put some in, to make sure), there are no words underlined in red to indicate misspelling, and if I put in an incorrectly spelled word, LO doesn't complain. More than that, each time I access the dialog (sic :-) ) to set the hyphenating, it presents itself as English (USA), however many times I set it to English (UK). This is LO 3.3.2, under Fedora (15). It was working until very recently. A large proportion of KDE has updated in the last couple of days, but I don't see that this should have a bearing on this part of LO. Any ideas? Regards Mark Stanton One small step for mankind... Check under TOOLSOPTIONS in the Options Box under Language Settings then Writing Aids and make sure that dictionaries and utilities are available and assuming they are that they are selected. On my system Ubuntu/Pinguy 11.04, LO 3.4.1) the spell checker is Hundspell. Also, make sure the option the options in the center group of check boxes are enabled and in the bottom check box that at least top two are checked for checking spelling and grammar as you go. Truthfully I am not sure way this problem occurred. My guess is that the KDE update unintentionally changed a setting thinking you had KOffice installed. -- Jay Lozier jsloz...@gmail.com -- 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] Incorrect row height when opening a Calc file.
Hi :) Weirdly i just re-opened that xls and this time it did get the heights correct, even before i tried setting the default font size. I do have a lot of the settings in Tools - Options + Load/Save set to maximise compatibility with MS Excel. Regards from Tom :) From: El Cico elcico2...@yahoo.it To: users@global.libreoffice.org Cc: mrelw...@yahoo.com Sent: Sat, 23 July, 2011 0:42:38 Subject: Re: [libreoffice-users] Incorrect row height when opening a Calc file. Da: Tom Davies tomdavie...@yahoo.co.uk A: users@global.libreoffice.org Inviato: Ven 22 luglio 2011, 23:45:30 Oggetto: Re: [libreoffice-users] Incorrect row height when opening a Calc file. Hi :) Yes it's fixable but it shouldn't break in the first place. A double click on the line between any 2 rows adjusts all the rows to their optimal height once the entire sheet has been selected with Ctrl A or as described by Joe so it's very quick to fix but that needs to be done every time the spreadsheet is opened when saved as xls. Regards from Tom :) From: JOE Conner joeconner2...@gmail.com To: users@global.libreoffice.org; mrelwood mrelw...@yahoo.com Sent: Fri, 22 July, 2011 22:05:59 Subject: Re: [libreoffice-users] Incorrect row height when opening a Calc file. On 7/22/2011 1:24 PM, Tom Davies wrote: Hi :) Ouch. That is really inconvenient. Please could you post a bug-report about it? http://wiki.documentfoundation.org/BugReport Regards from Tom :) From: mrelwoodmrelw...@yahoo.com To: users@global.libreoffice.org Sent: Thu, 21 July, 2011 23:52:02 Subject: [libreoffice-users] Incorrect row height when opening a Calc file. I created an .xls file with OpenOffice 3.3 on OSX 10.6.8. Opening the file now on OSX 10.7, OpenOffice shows the document correctly (row height 0,67cm), but LibreOffice shows the row height at around 0,44cm, which makes about a third of the text to be chopped off. The issue appears in about 7% of my .xls files, and on some the text is chopped just slightly. It's not a big deal to re-adjust the row height for a few documents, but this might be something the devs would like to look into. One of the files with the issue can be found at: http://db.tt/uBzFayj You can adjust height and width of all rows and columns simultaneously. Click the space at the corner, top of the row numbers, left of the column letters (this selects the entire spreadsheet) next drag the first row bottom line downward as much as you like. It will adjust all rows. Same for columns. Joe Conner, Poulsbo, WA USA - - - Hello all, I'm not sure this is what you want, but if you change the character size of your default style, you can open your documents with the right row height. You can do this through the style and formatting window (F11), editing -- default (right clic it) and then -- character size. If you just want to use this for certain documents, you can create a model with your desired height. Here is your file with trebuchet size 16 as default. http://dl.dropbox.com/u/9434397/Tapsa%20Kansa%20-%20Paattyneet%20on%20Paivat%20-%20F.xls Namastè! cico :) -- 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] printing non-standard page sizes
Hi Matthew, On Fri, 2011-07-22 at 11:43 -0400, Matthew Monaco wrote: On 07/22/2011 08:17 AM, Regina Henschel wrote: Hi Matthew, Matthew Monaco schrieb: I've always had a lot of trouble printing when I setup a custom page size in the page properties. It seems like the print dialog tries to find the best fit of the predefined page sizes. Yes. The printer tells what paper size it is able to handle. And LO searches the best fitting from them. Unfortunately, the printer does not tell whether this paper size is really available. So your printer might go into a waiting mode and you have to enter the paper manually. Furthermore, I have no clue what the manual option is attempting to do. Is there something I'm missing here? The behavior is different for Writer, Calc, Draw and Impress. Generally there are two ways to get fitting of page format and paper size. You can tell your printer what to do. For example my printer can print with scaling 80%. Or you can tell LO what to do. Especially Draw and Calc have a lot of options. You should describe a concrete task, if you want detailed help. Kind regards Regina Ok, concrete task: printing envelopes (writer). Set page size to 6.3 x 4.7 (landscape). Type out address and return address. File Print _select printer_ properties button paper tab No matter what I do here I cannot print correctly to a specified paper size. Either the text becomes distorted or it prints outside the bounds of the page. However, I know I'm capable of printing to this size just fine because I can from Abiword, gedit, firefox, etc. They all use a standard print dialog. I like LO a lot more, but I'm forced to use Abiword whenever printing envelopes. You could try setting the page size to the appropriate envelope size by using FORMATPAGE and under the Page Tab in the Paper Format section select the correct Format in the Format list box. -- Jay Lozier jsloz...@gmail.com -- 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] Incorrect row height when opening a Calc file.
its an excellent tip.thanks for this.was not aware of this. On 23 July 2011 02:35, JOE Conner joeconner2...@gmail.com wrote: On 7/22/2011 1:24 PM, Tom Davies wrote: Hi :) Ouch. That is really inconvenient. Please could you post a bug-report about it? http://wiki.**documentfoundation.org/**BugReporthttp://wiki.documentfoundation.org/BugReport Regards from Tom :) __**__ From: mrelwoodmrelw...@yahoo.com To: users@global.libreoffice.org Sent: Thu, 21 July, 2011 23:52:02 Subject: [libreoffice-users] Incorrect row height when opening a Calc file. I created an .xls file with OpenOffice 3.3 on OSX 10.6.8. Opening the file now on OSX 10.7, OpenOffice shows the document correctly (row height 0,67cm), but LibreOffice shows the row height at around 0,44cm, which makes about a third of the text to be chopped off. The issue appears in about 7% of my .xls files, and on some the text is chopped just slightly. It's not a big deal to re-adjust the row height for a few documents, but this might be something the devs would like to look into. One of the files with the issue can be found at: http://db.tt/uBzFayj You can adjust height and width of all rows and columns simultaneously. Click the space at the corner, top of the row numbers, left of the column letters (this selects the entire spreadsheet) next drag the first row bottom line downward as much as you like. It will adjust all rows. Same for columns. Joe Conner, Poulsbo, WA USA -- Unsubscribe instructions: E-mail to users+help@global.libreoffice.**orgusers%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- 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] printing non-standard page sizes
On 07/22/2011 08:32 PM, planas wrote: Hi Matthew, On Fri, 2011-07-22 at 11:43 -0400, Matthew Monaco wrote: On 07/22/2011 08:17 AM, Regina Henschel wrote: Hi Matthew, Matthew Monaco schrieb: I've always had a lot of trouble printing when I setup a custom page size in the page properties. It seems like the print dialog tries to find the best fit of the predefined page sizes. Yes. The printer tells what paper size it is able to handle. And LO searches the best fitting from them. Unfortunately, the printer does not tell whether this paper size is really available. So your printer might go into a waiting mode and you have to enter the paper manually. Furthermore, I have no clue what the manual option is attempting to do. Is there something I'm missing here? The behavior is different for Writer, Calc, Draw and Impress. Generally there are two ways to get fitting of page format and paper size. You can tell your printer what to do. For example my printer can print with scaling 80%. Or you can tell LO what to do. Especially Draw and Calc have a lot of options. You should describe a concrete task, if you want detailed help. Kind regards Regina Ok, concrete task: printing envelopes (writer). Set page size to 6.3 x 4.7 (landscape). Type out address and return address. File Print _select printer_ properties button paper tab No matter what I do here I cannot print correctly to a specified paper size. Either the text becomes distorted or it prints outside the bounds of the page. However, I know I'm capable of printing to this size just fine because I can from Abiword, gedit, firefox, etc. They all use a standard print dialog. I like LO a lot more, but I'm forced to use Abiword whenever printing envelopes. You could try setting the page size to the appropriate envelope size by using FORMATPAGE and under the Page Tab in the Paper Format section select the correct Format in the Format list box. When there happens to be an envelope sizes the corresponds, everything is OK. However not all envelopes are standard. -- 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