Problem description: I use spreadsheets where I need to repeat $1:$2 on each page for printing. I can set via edit print ranges and print but it won't save this reverting to just $2 on reopening Steps to reproduce: 1. Format > Print ranges > Edit... 2. Rows to repeat - User defined - set to $1:$2 3. Save, close & reopen. 4. 1. & 2. above showing just $2 requiring re-setting Current behavior: Won't save print range: rows to repeat format. Expected behavior: To save user defined print range: rows to repeat format Columns seems to be ok Operating System: Windows 7 Version: 4.0.1.2 release
This may be of importance, in the top two rows to repeat some of the columns are merged cells, others aren't.
Reproducibe on OS X 10.8.2 LO 4.0.2.2. Proceeding as described by bug-reporter leads to the described behavior. -> NEW
(In reply to comment #1) > This may be of importance, in the top two rows to repeat some of the columns > are merged cells, others aren't. I tested using un merged cells but 2 repeated and the same happens
I can confirm this bug in LO 4.0.1.2 and 4.0.2.2 on Windows XP and in LO 4.0.2.1 on Linux (openSUSE). => Platform: All Some more information: - The "print range - repeat row"-information is saved correctly. Opened with LO 3.5.? or AOO 3.4.1 the setting is ok. It might not be a "save" bug, but on "open" bug. - It seems that only row 1 is affected. Any other row I tried worked.
*** Bug 61436 has been marked as a duplicate of this bug. ***
A work around in the meantime should you need it: Insert row above so blank row 1. Set row height to 0. Set print range to repeat as $2:$3
I can confirm this bug in LO 4.0.3.3 Win 7
*** Bug 64373 has been marked as a duplicate of this bug. ***
*** Bug 64535 has been marked as a duplicate of this bug. ***
*** Bug 63342 has been marked as a duplicate of this bug. ***
*** Bug 64644 has been marked as a duplicate of this bug. ***
*** Bug 64642 has been marked as a duplicate of this bug. ***
*** Bug 64785 has been marked as a duplicate of this bug. ***
*** Bug 64564 has been marked as a duplicate of this bug. ***
already existing in 400alpha1
Created attachment 80146 [details] spreadsheet with various print ranges on various sheets Attached a test document. 1- opened in 400alpha1: to repeat headers in sheet 1 and 5 are changed 2- correct to repeat headers 3- save 4- open in 366: to repeat headers in sheet 1 and 5 are OK > error is on opening the file > regression from 3.6
I suppose I should look into it as Joren pointed out it might have been a commit that went through my review which introduced the regression.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3c332c935e3531ca58fafebe79f7f99cf9d16a72&h=libreoffice-4-1 the print range can start in row 0, fdo#62938 It will be available in LibreOffice 4.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e1c70f2f046ab6c5bb808666b4f5466902b9fcf8 the print range can start in row 0, fdo#62938 The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a719841d02fb93ddfc80956c5e6e417f551e8a9f add test case for fdo#62938 The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4e8d0a9efe4d549789995344c637bac5bede1893&h=libreoffice-4-1 Revert "the print range may start in row 0, fdo#62938" It will be available in LibreOffice 4.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=07e24af2801ae28a5552c4afc9ea3730aa00914c&h=libreoffice-4-1 correct fix for fdo#62938 It will be available in LibreOffice 4.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=59519242dd11ac91720a9646197b803f5ed812b7 Revert "the print range may start in row 0, fdo#62938" The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7dfb72e69c629e5897ee515f8c42b7e45610ab8e correct fix for fdo#62938 The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review for 4-0.
*** Bug 65392 has been marked as a duplicate of this bug. ***
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-4-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=2e5b6fd2d1c1b23eef3c32222bfb0efd7a27d21d&h=libreoffice-4-0 correct fix for fdo#62938 It will be available in LibreOffice 4.0.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Thanks, Markus, for the fix! It helps us a lot!
*** Bug 67262 has been marked as a duplicate of this bug. ***
*** Bug 61056 has been marked as a duplicate of this bug. ***
*** Bug 66697 has been marked as a duplicate of this bug. ***