Description: It seems like the rows after row 72 are not being displayed and instead there is grey background. In the rows 1 up to 72 (included) were data before but I removed them in attempt to try solve the issue. Not sure what triggered this behavior. But this is what I have done before the problem arrived: - Played with sheet protection - Saved document with password encryption - Played with AutoFilter (I think this might be the last thing I did before problem arrived) I have also tried to restore the document to its original state, removed AutoFilter, protections, encryption, data in cells, formatting... Screenshot: https://i.ibb.co/31cSL2S/calc-issue.png Steps to Reproduce: could not reproduce Actual Results: In description Expected Results: normal function Reproducible: Couldn't Reproduce User Profile Reset: No Additional Info: LibreOffice version: Version: 7.6.4.1 (X86_64) / LibreOffice Community Build ID: 60(Build:1) CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: sk-SK (en_US.UTF-8); UI: en-US Ubuntu package version: 4:7.6.4-0ubuntu0.20.04.1~lo2 Calc: threaded
I think you have those rows hidden. Menu/Edit - Select All Right-click on one of the rows number and select 'Show rows' Right-click on one of the columns letter and select 'Show columns'
Yeap. My bad. I don't remember to ever hid the rows but they were hidden.