Description: When rows 15 to the last row are hidden, the last row(s) becomes unhidden when deleting row(s). The last row(s) should be sticky and remain hidden if the last row is hidden when deleting row(s). Steps to Reproduce: 1. Select rows from 15 to last row 2. Hide the rows 3. Delete row 6 and the last row is shown; or Select rows 9 and 10 and delete them and the last 2 rows are shown. Actual Results: Hidden last row(s) show when row(s) above are deleted Expected Results: Hidden last row(s) should remain hidden when row(s) above are deleted Reproducible: Always User Profile Reset: No Additional Info: Attaching file soon. Thank you
Created attachment 181582 [details] Hidden last row(s) show when deleting row(s) above
Repro Version: 6.4.7.2 (x64) Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: GL; VCL: win; Locale: es-ES (es_ES); UI-Language: en-US Calc: CL Version: 7.4.0.2 (x64) / LibreOffice Community Build ID: 1512ce97d7ed39dce3121f7e15651fd8895f950e CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 20cc897dddb8ae7cee3c6d66e9cebba9da543c3a CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL
(In reply to Óvári from comment #0) > Expected Results: > Hidden last row(s) should remain hidden when row(s) above are deleted After you delete some rows, the same number of rows remains hidden. So, what do you see are not the last row(s) hidden, but new rows that are added to the spreadsheet. Rows number is 1048576 although you add or delete some rows. To test, type some text in A1048576, then delete some rows. You will see that the added text now are not in row 1048576, but 1048575 or up. I think that expected behavior is that _same number_ of rows remain hidden. For me, not-a-bug.
(In reply to LeroyG from comment #3) > (In reply to Óvári from comment #0) > > Expected Results: > > Hidden last row(s) should remain hidden when row(s) above are deleted > > After you delete some rows, the same number of rows remains hidden. So, what > do you see are not the last row(s) hidden, but new rows that are added to > the spreadsheet. > > Rows number is 1048576 although you add or delete some rows. > > To test, type some text in A1048576, then delete some rows. You will see > that the added text now are not in row 1048576, but 1048575 or up. > > I think that expected behavior is that _same number_ of rows remain hidden. > For me, not-a-bug. Does the current behavior provides a poor UX? Any data added to, say, row 1048576 would mean the spreadsheet would be sparse. Would this: a) reduce the performance of the spreadsheet? b) stop new rows being added as the last row has data? If a row is to be added, should it be added at the end of the last visible row, i.e. show row 15? Perhaps someone with other spreadsheet programs can provide information on what they do? Thank you
MSO: If rows 15-last are empty, deleting some rows <15 doesn't show additional rows. If A1048576 is not empty, deleting rows 9-10 shows additional rows A1048575-A1048576. I don't see why the behavior is different.
WPS goes a ster further and doesn't add new row regardless is empty or not. Seems that it makes sense and LO should do the same. Low priority.
(In reply to Timur from comment #5) > I don't see why the behavior is different. Perhaps it has to do with the last row/column being "sticky"? Thank you for setting this issue status as NEW.
On a second thought, this doesn't look like a bug, it does literally what's told, but line an enhancement, to get what users expects.
We discussed the topic in the design meeting. While rows are "added" in MSO, it does not happen for columns - "deleting" a column reduces the total number (actually the number remain but with zero width). We "add" rows and columns if one is deleted. So the recommendation is to keep "added" rows and columns hidden if the last row/column is not visible.
Wonder if this is an interesting easy hack.