Description: If a calc file is opened and a column is hidden by menu, the column is hidden, but extra column breaks and row breaks are in the sheet. Steps to Reproduce: 1. Create a new calc file and save it, close it and reopen it 2. Hide a column Actual Results: Extra column breaks and row breaks are in the sheet, before there was none. Expected Results: If before none of these breaks are in the sheet, they should not be inserted by hiding a column. Reproducible: Always User Profile Reset: No Additional Info:
Hello, Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document. (Please note that the attachment will be public, remove any sensitive information before attaching it.) How can I eliminate confidential data from a sample document? https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F Thank you I cannot reproduce in Version: 6.3.0.0.alpha0+ Build ID: 83abdf803a023067ebc207fd82dde987df233754 CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win;
Created attachment 151146 [details] An empty calc document
Just open the attached empty document. Then hide the first column. Result: Periodical column breaks between "H" and "I", "O" and "P", "V" and "W", and so on. Periodical row breaks between "51" and "52", "102" and "103", "153" and "154" and so on.
Created attachment 152591 [details] Picture shows two column breaks after hiding first column
Self confirming according to https://wiki.documentfoundation.org/QA/Guidelines_for_public_and_private_sector_deployments. Issue has originally been reported by another user in our internal issue tracker.
Hello Ilhan, I think the problem is that the page break are not displayed by default. You see the same problem if you go to print preview and back to normal view ( bug 120009 ) I guess both bugs have the same root cause ?
I remember that I've seen this effect also in my tests, so it should be the same reason. I've a solution already: https://gerrit.libreoffice.org/#/c/75355/ but wait that the reviewers accept it.
Ilhan Yesil committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/caeb7b141280a65e60525f11a7e6514b76e12e11 tdf#124983 In calc make printable page borders also initially visible It will be available in 6.4.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.
This is fixed by the commit from comment 8.
*** Bug 120009 has been marked as a duplicate of this bug. ***
Verified in Version: 6.4.0.0.alpha0+ Build ID: 52cda5c5ae426761ccbdb4f20419098eab195303 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 Nice!!! @Ilhan Yesil, thanks for fixing this issue!!
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/c4281cb41e6b76cabd5fe42fc707877e864dfb82 tdf#130640: Revert "tdf#124983 In calc make printable page... It will be available in 7.0.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.
Commit was reverted
Xisco Fauli committed a patch related to this issue. It has been pushed to "libreoffice-6-4": https://git.libreoffice.org/core/commit/b3e302b98dd7b992b7aa5a7f6756980d3edafc83 tdf#130640: Revert "tdf#124983 In calc make printable page... It will be available in 6.4.2. 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.
Xisco Fauli committed a patch related to this issue. It has been pushed to "libreoffice-6-4-1": https://git.libreoffice.org/core/commit/668cb9794ffb2cab5bad9ea0174c03adc7f88f8b tdf#130640: Revert "tdf#124983 In calc make printable page... It will be available in 6.4.1. 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.
As the first solution caused a lot of problems, I've changed my solution a bit. In my tests, it looks much better and faster. https://gerrit.libreoffice.org/c/core/+/90101
(In reply to Ilhan Yesil from comment #16) > As the first solution caused a lot of problems, I've changed my solution a > bit. In my tests, it looks much better and faster. > > https://gerrit.libreoffice.org/c/core/+/90101 patch restored
Dear Ilhan Yesil, This bug has been in ASSIGNED status for more than 3 months without any activity. Resetting it to NEW. Please assign it back to yourself if you're still working on this.
Ilhan Yesil committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/86e300df241312f6152da1cfa3cb2b8c668d1df5 tdf#124983 In calc make printable page borders initially visible It will be available in 7.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.
Ilhan Yesil committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/ff3f749cd08851ee4eb0991eabee0327ca081a45 tdf#124983 In calc make printable page borders initially visible It will be available in 7.2.0.0.beta2. 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.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/0be41797787622ebb5320acb6ec6cb65a7c8cdd4 Revert "tdf#124983 In calc make printable page borders initially visible" It will be available in 7.2.0.0.beta2. 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.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/6e88f3c8eb8d07bfdf8ade18230de7114c5ab362 Revert "Revert "tdf#124983 In calc make printable page borders initially visible"" It will be available in 7.2.0.0.beta2. 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.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/3d7007ef8784e92bb56a91c40e7bdff812251677 maShowPageBreaksTimer.Stop() in ScGridWindow::dispose(), tdf#124983 follow-up It will be available in 7.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.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/293f70b39602231198041812fededcc21d89f145 maShowPageBreaksTimer.Stop() in ScGridWindow::dispose(), tdf#124983 follow-up It will be available in 7.2.0.0.beta2. 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 137661 has been marked as a duplicate of this bug. ***
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/f58f35b2c8ca1efbacec642a8f3de5b0c499bc6b Do not count pages for initial page breaks, tdf#124983 follow-up It will be available in 7.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.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/3044912f5b1dba19c59e91901da0551c161f5fb4 Do not count pages for initial page breaks, tdf#124983 follow-up It will be available in 7.2.1. 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.