https://bugs.freedesktop.org/show_bug.cgi?id=79140
--- Comment #3 from pierre-yves samyn <[email protected]> --- Hi (In reply to comment #2) > Can you explain that workaround a bit more - I want to add that info to the > wiki :) The "top 10" filter works only on values. You can insert a column in which the CODE function is used to get a numeric code for the first character in a text string. First, to ignore the difference between uppercase and lowercase, the cell is converted (LOWER function) Codes corresponding to the aphabet are growing. They are multiplied by -1 so that A is before B. This workaround is limited because it only takes into account the first letter of the cell. I made this proposal without testing but it seems that however it may give a good result (see attached example) Go further: in the example calculations in column B are masked by the use of a custom cell style. That said, the numbers are always displayed when selecting the filter so it may not be necessary Regards Pierre-Yves -- 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
