https://bugs.documentfoundation.org/show_bug.cgi?id=88002
Katie Chan <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|WORKSFORME |--- --- Comment #19 from Katie Chan <[email protected]> --- It was still open because the regression in behaviour going from 4.2.8 to 4.3.5 remains. Using the attachment from comment #2, previously if you sort A10 to D20 by "Column B", Calc does not decide to only worry about A10:C20 because it doesn't think there's any content in D10:D20. On the basis of consistency in behaviour, sort should not return differently if you select A1:D20 compared to a the fewer rows but same columns A10:D20. Formatting such as colour is data. The program is optimising where it shouldn't. "Include formats" does not solve this issue. Selected, Sort is moving the formating (such as colour) with the rest of the content of the cell, but that's after it has reduced what it is sorting (and hence moving) from A10:D20 to A10:C20 because it think there's no content including any formatting despite the colour. -- You are receiving this mail because: You are the assignee for the bug.
