https://bugs.freedesktop.org/show_bug.cgi?id=81633
--- Comment #9 from Jean-Baptiste Faure <jbf.fa...@sud-ouest.org> --- Created attachment 104016 --> https://bugs.freedesktop.org/attachment.cgi?id=104016&action=edit another example of inconsistency in sorting This attachment is the same as the previous except I have added a column with a formula using the OFFSET() function. This formula in column E gives the same result as the formula in column D. It is an attempt to keep the reference to the cell just above the current one. If you select the range A2:E14 and sort ascending, you get several errors 523 in column E. Clearly it is not what is expected. If you do the same thing in LO 4.1.6 both columns still give the same result. What is more inconsistent is that the sorting does not treat the part (Cn-Bn) in both columns the same way. It is updated in column D while it is not in column E. As the change introduced by the fix for bug 81309 is big, I think it shouldn't be done in bugfix versions like 4.2.7 and 4.3.1. In other words, it is not a fix for a bug, it is a paradigmatic change. Best regards. JBF -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
