https://bugs.documentfoundation.org/show_bug.cgi?id=88002
Katie Chan <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |UNCONFIRMED Assignee|[email protected] |[email protected] |desktop.org | Ever confirmed|1 |0 --- Comment #21 from Katie Chan <[email protected]> --- Created attachment 178177 --> https://bugs.documentfoundation.org/attachment.cgi?id=178177&action=edit LibreOffice Calc Sort Behaviour comparison When a subset of cells are sorted by the same criteria, a user should expect to see the same result in the user selected subset of cells compared to the result of having the superset of cells sorted. If the sort range include at least one cell with user entered characters in a column when "Include formats" is selected in the Options, everything in that row are moved by the sort including any formatting such as cell colour in an otherwise empty cell. This was the behaviour in 4.2.8 and earlier. And in fact, this is also the behaviour where the formatting only row is NOT the left-most or right-most column selected. Where the formatting only row is left most or right most, that left-most or right-most column with formatting only is not sorted along with the rest of the selected range. -- You are receiving this mail because: You are the assignee for the bug.
