Description: In version 25.2, The list of Validation is always displayed in ascending order. Steps to Reproduce: 1. Open New Calc. 2. Insert Cell validity in [A1], and set some list [3,2,1]. Don't check "Sort enttries ascending" 3. Displays a drop-down list. [ Alt + Down ] Actual Results: 4. Listing [1,2,3]. Expected Results: 4. Listing [3,2,1]. Reproducible: Always User Profile Reset: No Additional Info: Not Reproduced with Version: 24.8.0.3 (X86_64) / LibreOffice Community Build ID: 0bdf1299c94fe897b119f97f3c613e9dca6be583 CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 10240); UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: threaded Reproducible with Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 6c640ee2662318f32a22d8293ad7498109681933 CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 10240); UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: threaded
Reproducible Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 2fec61240fed71923e5e2172e8536438df2a2432 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded No reproducible Version: 24.8.0.3 (X86_64) / LibreOffice Community Build ID: 0bdf1299c94fe897b119f97f3c613e9dca6be583 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
> 2. Insert Cell validity in [A1], and set some list [3,2,1]. > Don't check "Sort enttries ascending" Correction of mistakes 2. Insert Cell validity in [A1], and set list [3,2,1]. Don't check "Sort entries ascending"
This seems to have begun at the below commit in bibisect repository/OS linux-64-25.2$. Adding Cc: to Noel Grandin ; Could you possibly take a look at this one? Thanks 9cb0bc9a683a2b913a3bfab077683520d05f10a9 is the first bad commit commit 9cb0bc9a683a2b913a3bfab077683520d05f10a9 Author: Jenkins Build User <tdf@maggie.tdf> Date: Thu Aug 1 21:10:13 2024 +0200 source 639a1f39dd45a6ff71eec2c073a84a9f181e350f 171378: optimise GetDataEntries a little | https://gerrit.libreoffice.org/c/core/+/171378
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/ce2a5f6bc80a7a206051d7a81fcc6e87f1fab972 tdf#162459 Validation list is always displayed in ascending order It will be available in 25.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.