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
Extra column breaks and row breaks are in the sheet, before there was none.
If before none of these breaks are in the sheet, they should not be inserted by hiding a column.
User Profile Reset: No
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?
I cannot reproduce in Version: 184.108.40.206.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.
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.
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:
but wait that the reviewers accept it.
Ilhan Yesil committed a patch related to this issue.
It has been pushed to "master":
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:
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. ***
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
@Ilhan Yesil, thanks for fixing this issue!!