https://bugs.documentfoundation.org/show_bug.cgi?id=163636
--- Comment #6 from Andrew <[email protected]> --- I have gone back to the file that started giving me problems after the upgrade. I have extracted one sheet from the many that where there. This spread sheet originally had 55 sheets and has worked for several years. After the upgrade it stopped. In the sheet attached I Performed several steps 1. Selected the whole sheet and pressed the auto filter button twice to remove auto filters. 2. inserted several new (empty) rows after row 34 (rows 35 through 39). 3. Then selected rows 1 through 34 and applied auto filter. 4. Attempted to sort column I ascending. Received message stating range had merged cells. 5. Selected rows 1 through 39 and selected unmerge cells button. 6. Attempted to sort column I ascending. Received message stating range had merged cells (again). 7. Selected rows 40 through 60 selected unmerge cells button. 8. Attempted to sort column I ascending. Sort was performed, but incorrectly Rows 42 and 44 where included in the selection becoming rows 32 and 33. Rows 40, 41, 43, and 45 where not sorted and became rows 42 43, and 45. I have left the spreadsheet in the condition prior to step 8. If you attempt to sort row "I" ascending, you should be able to repeat the results in step 8. I attempted to correct the problem in my sheets by deleting the problematic rows and making new rows 42 and 43 after the sorting. Didn't work it grabbed the two rows again. -- You are receiving this mail because: You are the assignee for the bug.
