Description: The sort by color in Autofilter context menu shows different results on each application. Steps to Reproduce: 1.Open file in link in either Calc and Excel 365 2. Sort by color "yellow" 3. Inspect results in both software Actual Results: Sorting order is different on each application Expected Results: Same results in both applications Reproducible: Always User Profile Reset: No Additional Info: related to bug#95520 and bug#163714, this last one is for documenting purposes. The Sort by color in Excel has a dialog for more accurate color sorting.
Created attachment 202435 [details] Test file
for me is the same like in the image. Version: 25.2.5.2 (X86_64) / LibreOffice Community Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022 CPU threads: 16; OS: Linux 6.14; UI render: default; VCL: gtk3 Locale: ro-RO (en_US.UTF-8); UI: en-US Calc: threaded Also with Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 6204dfeb53aefbc4de1c82a6bfc2f6903565f5c1 CPU threads: 16; OS: Linux 6.14; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Both sort the selected color to the start. But then Excel sorts according the position of the color in the color scale of the conditional cell formatting, whereas LibreOffice sorts by the color value, that is, #rrggbb interpreted as unsigned integer. Tested in Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d60ff8c8bd4e3ebf8f84f53448ead3c838332ea9 CPU threads: 32; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: de-DE (de_DE); UI: en-US Calc: threaded