Description: Not all cells in selection will print if the selection crosses page boundaries - only seems to print up to first page boundary, even where lots of free space remains on the page. Steps to Reproduce: 1. Create spreadsheet which when printed is longer (more rows) than one page. See "Example.ods" attachment 2. View page breaks by print preview. 3. Select some cells which cross the boundary (eg cells A41:A78 in example) 4. Print using "Selected cells" option. Actual Results: Only cells up to the first page boundary are printed (in the example case, only cells A41:A53) Expected Results: All selected cells should be printed. Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: [Information automatically included from LibreOffice] Locale: en-GB Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: yes Version: 6.1.1.2 (x64) Build ID: 5d19a1bfa650b796764388cd8b33a5af1f5baa1b CPU threads: 12; OS: Windows 10.0; UI render: default; Locale: en-GB (en_GB); Calc: CL
Created attachment 145219 [details] Example CALC sheet which demonstrates the issue
Confirm on 6.1.2.1 on windows. From what I remember it is another bug like this.
Created attachment 145255 [details] File with screenshots It's a regression, works with 6.0.7
I will bibisect now with 6.0
I bisect 6.1 on linux: there were bad and good commit: bd800e0c22633dc52985d4218bff88edb55ddf39 is the first bad commit commit bd800e0c22633dc52985d4218bff88edb55ddf39 Author: Jenkins Build User <tdf@pollux.tdf> Date: Wed Dec 13 01:06:51 2017 +0100 source 5217a2a0bf27e496cc429ee45dff7c239b466ae6 source 5217a2a0bf27e496cc429ee45dff7c239b466ae6 :040000 040000 5644483c9cbffe9d488f5c343b429c3cf35fc29f 67166bdeba9fc4e4f8eb5beecea30bdf3143a9c1 M instdir
*** Bug 120268 has been marked as a duplicate of this bug. ***
export to pdf is broken too: https://bugs.documentfoundation.org/show_bug.cgi?id=120268
That commit in Comment 5 is: commit 5217a2a0bf27e496cc429ee45dff7c239b466ae6 Author: Tomaž Vajngerl <tomaz.vajngerl@collabora.co.uk> Date: Tue Dec 12 22:22:32 2017 +0900 tdf#114256 add cache criterium when to recalculate page range size Page range size can only be valid for the input parameters, which includes the document size, which was not taken into account at all before. Now we look at all this parameters to decide if we need to recalculate or not. Change-Id: Ic52ad7516189b395c66f59aabc374c3da85f6a89 Reviewed-on: https://gerrit.libreoffice.org/46300 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Tomaž Vajngerl <quikee@gmail.com>
*** Bug 119189 has been marked as a duplicate of this bug. ***
Adding Cc: to Tomaž Vajngerl
*** Bug 122013 has been marked as a duplicate of this bug. ***
*** Bug 122569 has been marked as a duplicate of this bug. ***
*** Bug 122974 has been marked as a duplicate of this bug. ***
*** Bug 123160 has been marked as a duplicate of this bug. ***
As we are approaching EoL for LO 6.1 and this is not fixed, please consider reverting the cause commit. Seems it made mo trouble than benefit.
(In reply to Timur from comment #15) > As we are approaching EoL for LO 6.1 and this is not fixed, please consider > reverting the cause commit. Seems it made mo trouble than benefit. It would re-introduced tdf#114256 which is another regression. I'll ping Tomaz
Still happening in 6.2 ``` Version: 6.2.0.3 Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62 CPU threads: 8; OS: Mac OS X 10.14.2; UI render: default; VCL: osx; Locale: pl-PL (es_PL.UTF-8); UI-Language: en-US Calc: threaded ```
Unit test is added: https://gerrit.libreoffice.org/#/c/68299/ With ".uno:DefinePrintArea" after making selection of any cells on cross pages, the export works correctly. To make the same thing (correct export of cross pages cells) in LO: 1. Select cells 2. Click Format/Print Ranges/Define 3. Perform export of selection
Serge Krot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/3af17a75409965ab6326902e004f6bf5bc37ac71%5E%21 tdf#120161 calc uitest: print selection on cross pages It will be available in 6.3.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.
Serge Krot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/03b6c20c66047af41ed2f78fe5dd229cd06392e8%5E%21 tdf#120161 sc: use selection to set required printed area It will be available in 6.3.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.
*** Bug 124001 has been marked as a duplicate of this bug. ***
seems to be fixed with my dev build: Version: 6.3.0.0.alpha0+ (x64) Build ID: 11ea5fe055ed345154138c814e38e54c6624ee89 CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: de-DE (de_DE); UI-Language: en-US Calc: threaded https://gerrit.libreoffice.org/plugins/gitiles/core/+log/11ea5fe055ed345154138c814e38e54c6624ee89 can this fix be backported to lo 6.1.6?
Serge Krot committed a patch related to this issue. It has been pushed to "libreoffice-6-2": https://git.libreoffice.org/core/+/f0b71fafd3a2fd6158c5952d601092179cba21e5%5E%21 tdf#120161 sc: use selection to set required printed area It will be available in 6.2.3. 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: 6.3.0.0.alpha0+ Build ID: c196d70337f6b755cfc4c34beda05554c6fab114 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded @Serge Krot, thanks for fixing this issue! Cherry-picked to 6-1 https://gerrit.libreoffice.org/#/c/69263/
Serge Krot committed a patch related to this issue. It has been pushed to "libreoffice-6-1": https://git.libreoffice.org/core/+/0c70e9ab4713a50fec558d6c4e4dfb2517039fc8%5E%21 tdf#120161 sc: use selection to set required printed area It will be available in 6.1.6. 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.
Serge Krot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/87bf5a930a72a12f88a21b450da0dd86348c3077%5E%21 tdf#120161 sc: pdf export unit test It will be available in 6.3.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.
Serge Krot committed a patch related to this issue. It has been pushed to "libreoffice-6-1": https://git.libreoffice.org/core/+/b407d93a055eb2875dfaac9836b082230efe4eff%5E%21 tdf#120161 sc: pdf export unit test It will be available in 6.1.6. 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.
Serge Krot committed a patch related to this issue. It has been pushed to "libreoffice-6-2": https://git.libreoffice.org/core/+/bf50d32a09c39631363181f6c11c93c340504cd4%5E%21 tdf#120161 sc: pdf export unit test It will be available in 6.2.3. 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.
*** Bug 124372 has been marked as a duplicate of this bug. ***
*** Bug 124576 has been marked as a duplicate of this bug. ***
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/94314c0f2e0bee5bcb994b0cbfbfd9af9053eef8 tdf#120161: sc: Move UItest to CppUnitTest 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.