Created attachment 129403 [details] The problematic document Attached XLS file in Excel spreads to 10 pages. When opened in Calc it still takes 10 pages (with content slipping 5 lines down), but in Page Break view it indicates there are 18 pages to print. Even in print preview with "Suppress output of empty pages" on (default) Calc wants to print 14 pages with the last four being (at least visually) empty. I have no idea what settings wrong import may cause this.
Created attachment 129404 [details] Screenshot of the document in LO 5.1.4 and Excel 2013 side by side
Thank you for reporting the bug. I can confirm that the bug is present in LibreOffice Version: 5.1.4.2 Build ID: 1:5.1.4-0ubuntu1
In Page Break view when I selected all empty rows from the last one, to the one after last line of your text and clicked delete, then it looks like problem solved (screenshots in link: http://imgur.com/a/jmWZW ).
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Columns I-L are hidden. Column L has text up to L454. So it makes sense that LO initially sets print area up to row 454. Dupe of 35591. *** This bug has been marked as a duplicate of bug 35591 ***
it seems this bug is a different bug from 35591, as this bug is about hidden columns, while the bug 35591 is about hidden cells.. that is not supported by MS excel. (Format Cells -> Cell Protection -> Hide when printing) they are stored, and calculated differently.
Attila Szűcs committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/2bf3e0d00e3bccb5b250642ee0d3fdbe6cae8ecc tdf#104502 sc: skip hidden columns at printing pages It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in: Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 72841008bf422dfd8553240b3a78f0474d03523c CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded Jumbo