Description: The cell range cannot be selected using the validity. And no longer be able to close Calc. Steps to Reproduce: 1. Open new Calc. 2. Menu - Data > Validity.. 3. Criteria tab > Allow > select [ Cell range] 4. Source > Push [Shrink] button. 5. Select Cell Range. No data is required. Select the appropriate range. Actual Results: 6. The selected range of cells will not be posted in the dialog window. Give up and exit the dialog. You will then be unable to exit Calc. Expected Results: 6. The dialog displays the selected range of cells. And you can exit Calc. Reproducible: Always User Profile Reset: No Additional Info: Not reproducible with [2025-01-08] Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 6700b311310a94e0de8123b307275cd553bb0d9b CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Vulkan; VCL: win Locale: en-US (ja_JP); UI: en-US Calc: CL threaded Reproducible with [2025-05-09] Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 9bc5b89c149497a83117edfadc3fb0b96d2f9899 CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Vulkan; VCL: win Locale: en-US (ja_JP); UI: en-US Calc: CL threaded
Reproducible Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 9bc5b89c149497a83117edfadc3fb0b96d2f9899 CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-GB Calc: CL threaded
author Pranam Lashkari <lpranam@collabora.com> 2025-01-24 18:06:18 +0530 commit 63b26e8e20f6a4eeb3117925b7a727f565e3a2dc sc: convert data validity dialog async Change-Id: Ifef985c15a58c1c081f9a011e174e3b2547f3ea2 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/179402
Reproducible with [2025-05-23] Version: 25.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 3158b14e0b26875300a8098bc117a5e69b76f48f CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: en-US (ja_JP); UI: en-US Calc: CL threaded
Reproducible with Version: 25.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 98e6dae9f7fc9d9bfb646aed278d65be34aad92b CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: en-US (ja_JP); UI: en-US Calc: CL threaded
Reproduced. Version: 25.8.0.1.0+ (X86_64) / LibreOffice Community Build ID: 256737875d23442cb14c34d5168779e525c5f5e3 CPU threads: 8; OS: Windows 11 X86_64 (build 26100); UI render: default; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: threaded Version: 25.8.0.1.0+ (X86_64) / LibreOffice Community Build ID: 256737875d23442cb14c34d5168779e525c5f5e3 CPU threads: 8; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL threaded Jumbo --- I'm not sure if the following observations will help identify the cause of the issue, or if they indicate a separate bug, but I'm sharing them just in case. 1. When using the "Shrink" button to select a cell range for the validity source, the drop-down list appears not on the intended input cell (e.g. A1), but on the selected source range (e.g. D1:D5). This seems to suggest that the rule is being applied to the wrong location. 2. Even if I avoid using the Shrink button entirely, and instead paste a valid range string such as "$Sheet1.$D$1:$D$5" directly into the "Source" field, the drop-down is correctly created on the intended cell (e.g. A1). However, Calc still cannot be closed afterwards, just like when using the Shrink button. These behaviors might be related, or separate, but both happen consistently in the affected version.
Still reproducible in 26.2. In Normal mode. Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: e9632c5d3ab90a75d3615147e6ecec682f7bc15c CPU threads: 8; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL threaded Jumbo In Safe mode. Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: e9632c5d3ab90a75d3615147e6ecec682f7bc15c CPU threads: 8; OS: Windows 11 X86_64 (build 26100); UI render: default; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: threaded
Further observations reveal the following: - New files that contain Validity settings (from Data -> Validity -> Criteria tab -> Allow -> select Cell range) can be saved, but the bug occurs upon exiting. - When editing an existing Validity setting, the application can be closed without triggering the bug. - The bug occurs on exit if a newly created Validity setting is present, regardless of whether the file itself is new or pre-existing. - Even if the creation of the Validity setting is interrupted—for example, by clicking the close button on the Shrink window immediately after pressing the [Shrink] button for the source field—the bug still occurs upon exit. This indicates that completing the cell range selection is not required to trigger this issue. This strongly suggests that the issue specifically arises when a new Validity setting is created with a cell range as its source, even if the creation process is not completed. Tested with: Version: 25.8.1.0.0+ (X86_64) / LibreOffice Community Build ID: cf39db5b97e665c47271a5679518a2fa9941be74 CPU threads: 8; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL threaded Jumbo
*** Bug 167866 has been marked as a duplicate of this bug. ***
This bug is still reproducible in 25.8.0 RC3. Tested with: Version: 25.8.0.3 (X86_64) Build ID: ab0112984cb0c13cf3d4edd063593d096a42a1aa CPU threads: 8; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL threaded Jumbo