Re: [libreoffice-users] Page break is not correct with printing
Hi :) openSuSE probably allows you to install all the basic Microsquish fonts in a single package. In Ubuntu it's called ttf-mscorefonts-installer although i have a feeling that it's renamed in Ubuntu and that all other distros use the same name as each other with only Ubuntu going it's own way. You can probably find the correct package most easily by opening your package-manager and then using it's search feature to look for trebuchet verdana comic sans or one of the other slightly unusual fonts. I suspect that searching for "Arial" or "Times New Roman" would probably bring up tons of free equivalents instead and those might still have the tiny discrepancy. Another thing to have checked is that; Format - Page - Page really is set to A4 just before you try to print it. The problem is usually the other way around, ie that Windows users are set to US Letter by default and everyone else is set to A4. However it sounds like it might be the other way around for once. At least the person sending out the document is trying to be compatible with other people. The Xls format is usually the one that does work with other programs and suites. Problems usually only happen with XlsX. However all editable formats, especially Microsquish ones, do have slight differences on different machines. Kingsoft is trying to follow along behind Microsquish Office but is always lagging behind and can't innovate or get ahead. That alone could lead it to slowly die through stagnation. Another potential problem with Kingsoft is that if it keeps following MS Office tooo closely then MS might be able to shut it down due to copyright violations. Being based in China might protect them from that but it might become difficult to use or develop (or translate) in the rest of the world. Right now it is a good temporary solution to have alongside LibreOffice. There is nothing forcing you to have only 1, unless your machine is VERY low spec. I think i would use Kingsoft ONLY if i had big problems with a specific document in LO and even then only use it to convert DocX or XlsX into a better format for LO to use. So far i've been fairly lucky. Anyway, glad to hear you fixed the immediate problem! Congrats and regards from Tom :) On 3 August 2014 14:48, Spencer Graves wrote: > On 8/3/2014 4:00 AM, Mark Bourne wrote: > >> Albert Oszkó wrote: >> >>> Hi all, >>> >>> I am new to this list, and I subscribed to try to get some help >>> previously asked on the opensuse forum, but could not get a good answer >>> yet. I copy some of my letters sent to that list >>> >>> In every month I get a kind of form, an Excel sheet which should be >>> filled, then printed and undersigned in the last row . The original >>> document is created in MS Office 2010 AFAIK, but is saved in *.xls, not >>> xlsx format. When I open it in LibreOffice, it looks just fine, but when >>> it comes to printing, the last row, the undersign, slips to a new page. >>> I was advised to use Kingsoft Office. This originally Chinese package >>> was praised to the heavens in terms of MS compatibility and usability, >>> so I gave it a try. Hmmm. My sheet fell apart, and while it recognized >>> that it was edited with Arial Narrow font, the typography was simply >>> ugly. The letters was in different distances from each other. I read a >>> lot, including forums, so I met Softmakers Freeoffice. I installed it. >>> The outlook is a bit vintage, but that should not be a problem. Opened >>> my document, looked fine, but just as for LO, the last row slipped to a >>> new page ( the original document fits on a single A4 page). >>> >>> Pdf export seems to work. But there is an interesting thing I noticed: >>> Earlier we got that document for a whole year, and a month was >>> represented by a tab. When I exported that Excel sheet opend by LO to >>> Pdf, then the 1st, 3d, etc sheets were OK, that is, fit to a page, but >>> the even ones had the last line on a new page. Interesting, isn't it? >>> >>> So is there a workaround? I would cling to LO, if possible. What is the >>> reason that it still cannot render a not too complicated MS document >>> correctly. >>> >>> I use LO with openSUSE 13.1 and KDE 4.13.3 >>> >>> Any hints and opinions are welcome. >>> >> >> It sounds like the form just about fits on a page for the original >> author. Any slight difference in fonts, spacing etc. could push the last >> row onto a second page. Similarly, if the sheet only just fits the width of >> a page, the last column can get pushed off by slight variations. Even >> different versions of MS Excel can end up rendering the same document >> slightly differently. Particularly if you don't have the same fonts >> installed as are used in the document, in which case substitutes are used. >> >> A few potential workarounds: >> 1. Format > Page > Sheet > Scale > Fit ... on number of pages > 1 >> 2. Format > Page > Page, Slightly reduce top and bottom margins >> 3. Slightly reduce the height of one or more
Re: [libreoffice-users] Page break is not correct with printing
On 8/3/2014 4:00 AM, Mark Bourne wrote: Albert Oszkó wrote: Hi all, I am new to this list, and I subscribed to try to get some help previously asked on the opensuse forum, but could not get a good answer yet. I copy some of my letters sent to that list In every month I get a kind of form, an Excel sheet which should be filled, then printed and undersigned in the last row . The original document is created in MS Office 2010 AFAIK, but is saved in *.xls, not xlsx format. When I open it in LibreOffice, it looks just fine, but when it comes to printing, the last row, the undersign, slips to a new page. I was advised to use Kingsoft Office. This originally Chinese package was praised to the heavens in terms of MS compatibility and usability, so I gave it a try. Hmmm. My sheet fell apart, and while it recognized that it was edited with Arial Narrow font, the typography was simply ugly. The letters was in different distances from each other. I read a lot, including forums, so I met Softmakers Freeoffice. I installed it. The outlook is a bit vintage, but that should not be a problem. Opened my document, looked fine, but just as for LO, the last row slipped to a new page ( the original document fits on a single A4 page). Pdf export seems to work. But there is an interesting thing I noticed: Earlier we got that document for a whole year, and a month was represented by a tab. When I exported that Excel sheet opend by LO to Pdf, then the 1st, 3d, etc sheets were OK, that is, fit to a page, but the even ones had the last line on a new page. Interesting, isn't it? So is there a workaround? I would cling to LO, if possible. What is the reason that it still cannot render a not too complicated MS document correctly. I use LO with openSUSE 13.1 and KDE 4.13.3 Any hints and opinions are welcome. It sounds like the form just about fits on a page for the original author. Any slight difference in fonts, spacing etc. could push the last row onto a second page. Similarly, if the sheet only just fits the width of a page, the last column can get pushed off by slight variations. Even different versions of MS Excel can end up rendering the same document slightly differently. Particularly if you don't have the same fonts installed as are used in the document, in which case substitutes are used. A few potential workarounds: 1. Format > Page > Sheet > Scale > Fit ... on number of pages > 1 2. Format > Page > Page, Slightly reduce top and bottom margins 3. Slightly reduce the height of one or more blank rows (if any) being used for spacing. Ideally get the original author to make sure the form fits on a single page with plenty of space to spare (horizontally as well as vertically), so you (and others) don't have to keep adjusting it every time. That will help ensure the form is usable across different systems and software versions. Might it be feasible to explain the problem to the original source of that Excel file and ask if it could be tested in LO ;-) As Mark suggested, it might still not solve the problem if the original source has some other difference with what you have. However, it should get you closer -- and it could help spread awareness of LO ;-) [Some governmental entities in France now use LO, not MS. I'm told that Google employees routinely use either Linux or Max OS, not Windows. And Google pays software developers to support Linux development to fix bugs that are problems for them and introduce new features they want. Large organizations can do that and still save money from what they are currently paying MS.] Spencer Mark. -- To unsubscribe e-mail to: users+unsubscr...@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] Page break is not correct with printing
On 3/08/14 11:00 pm, Mark Bourne wrote: Albert Oszkó wrote: Hi all, I am new to this list, and I subscribed to try to get some help previously asked on the opensuse forum, but could not get a good answer yet. I copy some of my letters sent to that list In every month I get a kind of form, an Excel sheet which should be filled, then printed and undersigned in the last row . The original document is created in MS Office 2010 AFAIK, but is saved in *.xls, not xlsx format. When I open it in LibreOffice, it looks just fine, but when it comes to printing, the last row, the undersign, slips to a new page. I was advised to use Kingsoft Office. This originally Chinese package was praised to the heavens in terms of MS compatibility and usability, so I gave it a try. Hmmm. My sheet fell apart, and while it recognized that it was edited with Arial Narrow font, the typography was simply ugly. The letters was in different distances from each other. I read a lot, including forums, so I met Softmakers Freeoffice. I installed it. The outlook is a bit vintage, but that should not be a problem. Opened my document, looked fine, but just as for LO, the last row slipped to a new page ( the original document fits on a single A4 page). Pdf export seems to work. But there is an interesting thing I noticed: Earlier we got that document for a whole year, and a month was represented by a tab. When I exported that Excel sheet opend by LO to Pdf, then the 1st, 3d, etc sheets were OK, that is, fit to a page, but the even ones had the last line on a new page. Interesting, isn't it? So is there a workaround? I would cling to LO, if possible. What is the reason that it still cannot render a not too complicated MS document correctly. I use LO with openSUSE 13.1 and KDE 4.13.3 Any hints and opinions are welcome. It sounds like the form just about fits on a page for the original author. Any slight difference in fonts, spacing etc. could push the last row onto a second page. Similarly, if the sheet only just fits the width of a page, the last column can get pushed off by slight variations. Even different versions of MS Excel can end up rendering the same document slightly differently. Particularly if you don't have the same fonts installed as are used in the document, in which case substitutes are used. A few potential workarounds: 1. Format > Page > Sheet > Scale > Fit ... on number of pages > 1 2. Format > Page > Page, Slightly reduce top and bottom margins 3. Slightly reduce the height of one or more blank rows (if any) being used for spacing. Ideally get the original author to make sure the form fits on a single page with plenty of space to spare (horizontally as well as vertically), so you (and others) don't have to keep adjusting it every time. That will help ensure the form is usable across different systems and software versions. Mark. I have had this problem caused by the font. The font on one computer was the same as the other computer (Arial on both) but the font package was not the exact same file. When I deleted and replaced the Arial on the second computer with the Arial file from the first computer then the document displayed the same. This is one argument for embedding the font in the document. It can be worse if the same font is not available or and a different font is substituted. For you the solution may be to ask the person writing the form to reduce the font 0.5 point so that everything fits on the page with extra space available. Steve -- To unsubscribe e-mail to: users+unsubscr...@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] Page break is not correct with printing
2014-08-03 13:00 keltezéssel, Mark Bourne írta: Albert Oszkó wrote: Hi all, I am new to this list, and I subscribed to try to get some help previously asked on the opensuse forum, but could not get a good answer yet. I copy some of my letters sent to that list In every month I get a kind of form, an Excel sheet which should be filled, then printed and undersigned in the last row . The original document is created in MS Office 2010 AFAIK, but is saved in *.xls, not xlsx format. When I open it in LibreOffice, it looks just fine, but when it comes to printing, the last row, the undersign, slips to a new page. I was advised to use Kingsoft Office. This originally Chinese package was praised to the heavens in terms of MS compatibility and usability, so I gave it a try. Hmmm. My sheet fell apart, and while it recognized that it was edited with Arial Narrow font, the typography was simply ugly. The letters was in different distances from each other. I read a lot, including forums, so I met Softmakers Freeoffice. I installed it. The outlook is a bit vintage, but that should not be a problem. Opened my document, looked fine, but just as for LO, the last row slipped to a new page ( the original document fits on a single A4 page). Pdf export seems to work. But there is an interesting thing I noticed: Earlier we got that document for a whole year, and a month was represented by a tab. When I exported that Excel sheet opend by LO to Pdf, then the 1st, 3d, etc sheets were OK, that is, fit to a page, but the even ones had the last line on a new page. Interesting, isn't it? So is there a workaround? I would cling to LO, if possible. What is the reason that it still cannot render a not too complicated MS document correctly. I use LO with openSUSE 13.1 and KDE 4.13.3 Any hints and opinions are welcome. It sounds like the form just about fits on a page for the original author. Any slight difference in fonts, spacing etc. could push the last row onto a second page. Similarly, if the sheet only just fits the width of a page, the last column can get pushed off by slight variations. Even different versions of MS Excel can end up rendering the same document slightly differently. Particularly if you don't have the same fonts installed as are used in the document, in which case substitutes are used. A few potential workarounds: 1. Format > Page > Sheet > Scale > Fit ... on number of pages > 1 2. Format > Page > Page, Slightly reduce top and bottom margins 3. Slightly reduce the height of one or more blank rows (if any) being used for spacing. Ideally get the original author to make sure the form fits on a single page with plenty of space to spare (horizontally as well as vertically), so you (and others) don't have to keep adjusting it every time. That will help ensure the form is usable across different systems and software versions. Mark. Dear Mark, Thank you for the hint. Your 1st suggestion did not work, but another option from the same menu sequence did the job: Format > Page > Sheet > Scale > Fit printing regions for width/height (or something similar, my locale is Hungarian) Thanks, Albert -- To unsubscribe e-mail to: users+unsubscr...@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] Page break is not correct with printing
Albert Oszkó wrote: Hi all, I am new to this list, and I subscribed to try to get some help previously asked on the opensuse forum, but could not get a good answer yet. I copy some of my letters sent to that list In every month I get a kind of form, an Excel sheet which should be filled, then printed and undersigned in the last row . The original document is created in MS Office 2010 AFAIK, but is saved in *.xls, not xlsx format. When I open it in LibreOffice, it looks just fine, but when it comes to printing, the last row, the undersign, slips to a new page. I was advised to use Kingsoft Office. This originally Chinese package was praised to the heavens in terms of MS compatibility and usability, so I gave it a try. Hmmm. My sheet fell apart, and while it recognized that it was edited with Arial Narrow font, the typography was simply ugly. The letters was in different distances from each other. I read a lot, including forums, so I met Softmakers Freeoffice. I installed it. The outlook is a bit vintage, but that should not be a problem. Opened my document, looked fine, but just as for LO, the last row slipped to a new page ( the original document fits on a single A4 page). Pdf export seems to work. But there is an interesting thing I noticed: Earlier we got that document for a whole year, and a month was represented by a tab. When I exported that Excel sheet opend by LO to Pdf, then the 1st, 3d, etc sheets were OK, that is, fit to a page, but the even ones had the last line on a new page. Interesting, isn't it? So is there a workaround? I would cling to LO, if possible. What is the reason that it still cannot render a not too complicated MS document correctly. I use LO with openSUSE 13.1 and KDE 4.13.3 Any hints and opinions are welcome. It sounds like the form just about fits on a page for the original author. Any slight difference in fonts, spacing etc. could push the last row onto a second page. Similarly, if the sheet only just fits the width of a page, the last column can get pushed off by slight variations. Even different versions of MS Excel can end up rendering the same document slightly differently. Particularly if you don't have the same fonts installed as are used in the document, in which case substitutes are used. A few potential workarounds: 1. Format > Page > Sheet > Scale > Fit ... on number of pages > 1 2. Format > Page > Page, Slightly reduce top and bottom margins 3. Slightly reduce the height of one or more blank rows (if any) being used for spacing. Ideally get the original author to make sure the form fits on a single page with plenty of space to spare (horizontally as well as vertically), so you (and others) don't have to keep adjusting it every time. That will help ensure the form is usable across different systems and software versions. Mark. -- To unsubscribe e-mail to: users+unsubscr...@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] Page break is not correct with printing
Hi all, I am new to this list, and I subscribed to try to get some help previously asked on the opensuse forum, but could not get a good answer yet. I copy some of my letters sent to that list In every month I get a kind of form, an Excel sheet which should be filled, then printed and undersigned in the last row . The original document is created in MS Office 2010 AFAIK, but is saved in *.xls, not xlsx format. When I open it in LibreOffice, it looks just fine, but when it comes to printing, the last row, the undersign, slips to a new page. I was advised to use Kingsoft Office. This originally Chinese package was praised to the heavens in terms of MS compatibility and usability, so I gave it a try. Hmmm. My sheet fell apart, and while it recognized that it was edited with Arial Narrow font, the typography was simply ugly. The letters was in different distances from each other. I read a lot, including forums, so I met Softmakers Freeoffice. I installed it. The outlook is a bit vintage, but that should not be a problem. Opened my document, looked fine, but just as for LO, the last row slipped to a new page ( the original document fits on a single A4 page). Pdf export seems to work. But there is an interesting thing I noticed: Earlier we got that document for a whole year, and a month was represented by a tab. When I exported that Excel sheet opend by LO to Pdf, then the 1st, 3d, etc sheets were OK, that is, fit to a page, but the even ones had the last line on a new page. Interesting, isn't it? So is there a workaround? I would cling to LO, if possible. What is the reason that it still cannot render a not too complicated MS document correctly. I use LO with openSUSE 13.1 and KDE 4.13.3 Any hints and opinions are welcome. Thanks and regards, Albert -- To unsubscribe e-mail to: users+unsubscr...@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
