https://bugs.freedesktop.org/show_bug.cgi?id=86304
--- Comment #6 from Jean-Baptiste Faure <[email protected]> --- (In reply to Luke from comment #4) > Jean-Baptiste Faure, > The Legacy behavior is the correct one, because that is the industry > standard. Open this file in Google Sheets, Excel, or OpenOffice Calc and > try to sort it. They all produce the same, correct results. Ok, but for me it means that the behavior to be chosen is arbitrary and because we have a well established behavior, we choose this one. It does not mean that the legacy behavior is correct according to its own quality. That said I agree that for now it is the best we have. > > This document does a nice job of explaining how relative and absolute > references should be handed in a sorting routine: > http://support2.microsoft.com/kb/40401 Sorry, I am not convinced. I do not understand why this article says that the column C is correctly sorted. If we consider only the values, the order in column C is wrong after sort because the column C should be kept in the reverse order of the column A. Does that mean the column C is correctly sorted because it is not sorted at all due to absolute references? The problem with this kind of very simplified example, is that they are not self explaining why the expected behavior is the correct one. It is why I am still waiting for use-cases from the real life. Best regards. JBF -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
