[opensuse] Page break in office suites
Hi all, In every month I get a kind of form, an Excel sheet which should be filled and undersigned in the last row and then printed. 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 as for LO, the last row slipped to a new page ( the original document fits on a single A4 page). So is there a workaround? I would cling to LO, if possible. What is the reason that is still cannot render a not too complicated MS document correctly. What about Calligra suite (though it does not accept Okular's latest version, so I did not installed yet)? Any hints and opinions are welcome. I tried all of the above on oS 13.1 and KDE 4.13.3 (both Hungarian) Regards, Albert -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 07/27/2014 11:41 AM, Albert Oszkó wrote:
In every month I get a kind of form, an Excel sheet which should be filled and undersigned in the last row and then printed. 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.
How have you defined the page boundary? This is assuming that this is not an A4/USLetter page size problem. With a spreadsheet the page boundary should be shown by a slightly heavier lines in the basic background cell matrix. This is not the underlines or boxes, this is the cell nature of the spreadsheet, what's tied to moving between cells with the cursor. You can play with this somewhat via Format==>Print_Ranges -- /"\ \ / ASCII Ribbon Campaign X Against HTML Mail / \ -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Le 27/07/2014 18:07, Anton Aylward a écrit :
How have you defined the page boundary?
be also advised than setup changes with the printer involved. A way to cope with this is to write to pdf, verify that the pdf if complete (one page) and print the pdf adjusting it to fill the page jdd -- http://www.dodin.org -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
2014-07-27 18:37 keltezéssel, jdd írta:
Le 27/07/2014 18:07, Anton Aylward a écrit :
How have you defined the page boundary?
be also advised than setup changes with the printer involved. A way to cope with this is to write to pdf, verify that the pdf if complete (one page) and print the pdf adjusting it to fill the page
jdd
Print previews refer to the very same printer(s), and, as I wrote above different printers gave the same result. Albert -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
2014-07-27 18:37 keltezéssel, jdd írta:
Le 27/07/2014 18:07, Anton Aylward a écrit :
How have you defined the page boundary?
be also advised than setup changes with the printer involved. A way to cope with this is to write to pdf, verify that the pdf if complete (one page) and print the pdf adjusting it to fill the page
jdd
Pdf export seems to work, thanks. 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? Regards, Albert -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
* Albert Oszkó
2014-07-27 18:37 keltezéssel, jdd írta:
Le 27/07/2014 18:07, Anton Aylward a écrit :
How have you defined the page boundary?
be also advised than setup changes with the printer involved. A way to cope with this is to write to pdf, verify that the pdf if complete (one page) and print the pdf adjusting it to fill the page
Pdf export seems to work, thanks. 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?
And probably deserves a bug report. -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 Registered Linux User #207535 @ http://linuxcounter.net -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
2014-07-27 18:07 keltezéssel, Anton Aylward írta:
On 07/27/2014 11:41 AM, Albert Oszkó wrote:
In every month I get a kind of form, an Excel sheet which should be filled and undersigned in the last row and then printed. 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.
How have you defined the page boundary?
This is assuming that this is not an A4/USLetter page size problem.
With a spreadsheet the page boundary should be shown by a slightly heavier lines in the basic background cell matrix. This is not the underlines or boxes, this is the cell nature of the spreadsheet, what's tied to moving between cells with the cursor.
You can play with this somewhat via Format==>Print_Ranges
I am looking the document in LO 4.2.5.2 in oS and MS Office 2010 (in Win 7 running in a Virtualbox) simultaneously. The page bounadries are the same: A1:T60, the page margins are the same. The printer is a remote Xerox Phaser 3435 in both cases. But the same problem occurred when the printer was a shared HP P1006 attached to Win XP machine. So this might not be the cause. Regards, Albert -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 07/27/2014 06:41 PM, Albert Oszkó wrote:
So is there a workaround? I would cling to LO, if possible.
- at extreme bottom-right of LO spreadsheet : is there a sliding bar, with 'Minus' sign at one end of the bar, and 'Plus' sign at the other end : - maybe this sliding bar will enable you to shrink page size ? ........... regards -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
2014-07-27 18:47 keltezéssel, ellanios82 írta:
On 07/27/2014 06:41 PM, Albert Oszkó wrote:
So is there a workaround? I would cling to LO, if possible.
- at extreme bottom-right of LO spreadsheet : is there a sliding bar, with 'Minus' sign at one end of the bar, and 'Plus' sign at the other end :
- maybe this sliding bar will enable you to shrink page size ?
...........
regards
You mean, shrink to page? I see the sliders, but they only change the visible size, nit the real one. However, in LO in the menu bar there is an option View -> Preview of page break (or something like that) And to my surprise, that is correctly shows the document! Albert -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
2014-07-27 18:47 keltezéssel, ellanios82 írta:
On 07/27/2014 06:41 PM, Albert Oszkó wrote:
So is there a workaround? I would cling to LO, if possible.
- at extreme bottom-right of LO spreadsheet : is there a sliding bar, with 'Minus' sign at one end of the bar, and 'Plus' sign at the other end :
- maybe this sliding bar will enable you to shrink page size ?
...........
regards
For those, who might have the same problem: Format > Page > Sheet > Scale > Fit printing regions for width/height (or something similar, my locale is Hungarian) did the job Regards, Albert -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
participants (5)
-
Albert Oszkó -
Anton Aylward -
ellanios82 -
jdd -
Patrick Shanahan