https://bugs.documentfoundation.org/show_bug.cgi?id=88402
--- Comment #39 from Aprax <[email protected]> --- @ Laurent: Great summary Laurent, thank you. In order to help a coder who wishes to work on this I'd like to re-state the issue. When a user defines a range of cells to be sorted and clicks through Data > Sort, the program performs a test of the contents of each cell in the first row of the Range. Note: "first row of the Range' need not be Row 1 although in most cases it will be. 1) If one or more numeric values are found, the program assumes that the first row does *not* contain column Labels and should be sorted with the other rows and it un-ticks the box for "Range contains column labels". 2) If no numeric values are found, the program assumes that the values are column Labels and ticks the box for "Range contains column labels". This may be helpful upon the *very first sort* of the Range. However the user may realize that the auto-setting for the box for "Range contains column labels" is wrong for his/her purposes and changes the setting, runs the sort and Saves the sheet with the 'correct' setting expecting the setting to be saved for future sorts. The issue is that the program performs the test *every* time that the sort process is run, not just the first time it's run, regardless of a saved user setting.. The best and probably easiest 'fix' would be to remove the test and leave it up to the user to choose. But, if we *must* have the first row test, it should be restricted to the *first* time that the range is sorted, then: 1) If the auto-setting is correct, the user need do nothing or 2) If it's wrong, the user can change it. The setting should be saved and left "as is" for all subsequent sorts or until the user changes it. ====================================================== Scenarios where the program *assumption* is incorrect: 1) I define a range which contains only text, all rows are names and descriptions, there is no row containing Labels or numbers. The program assumes *incorrectly* that the first row must be a Label row. 2) I define a range which contains a number in the first row, e.g. in C$15 (an exchange rate to be used in calculations in the remaining rows). The program assumes *incorrectly* that the first row should be sorted with all other rows. -- 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
