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
This bug is still reproducible in 25.8.0.4 Tested with: Version: 25.8.0.4 (X86_64) Build ID: 48f00303701489684e67c38c28aff00cd5929e67 CPU threads: 8; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: threaded
(In reply to Peter from comment #10) > This bug is still reproducible in 25.8.1.1 > > Tested with: > >Version: 25.8.1.1 (X86_64) >Build ID: 54047653041915e595ad4e45cccea684809c77b5 >CPU threads: 8; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: >win >Locale: de-DE (de_DE); UI: de-DE >Calc: threaded
*** Bug 168206 has been marked as a duplicate of this bug. ***
Can reproduce with 25.8.0.4 (X86_64). Version: 25.8.0.4 (X86_64) / LibreOffice Community Build ID: 580(Build:4) CPU threads: 8; OS: Linux 6.15; UI render: default; VCL: gtk3 Calc: threaded Apart from not being able to close the particular Calc window, in documents that have more than one sheet I can no longer switch between the sheets by clicking on the tab. I am still able to switch using Sheet > Navigate > Go to sheet... as well as using keyboard shortcuts (Ctrl+Tab, Ctrl+Shift+Tab). Also, noticed that for the issue to be triggered it is enough to just edit the `Source` field in the `Validity` dialogue.
Reproduced the behavior described in Comment 13. Tested with: Version: 25.8.2.0.0+ (X86_64) / LibreOffice Community Build ID: 3db9979c937d510d27db2fe7408c8407079d5527 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 Additional Info: - None of the normal exit operations (e.g. Ctrl+Q, File > Exit LibreOffice) work. - Help > Restart in Safe Mode does not work either. - The only way to terminate Calc in this state is via Task Manager.
Calc - LibreOffice 25.8.1 - Validità dati > Intervallo celle … Sorgente ingestibile https://ask.libreoffice.org/t/calc-libreoffice-25-8-1-validita-dati-intervallo-celle-sorgente-ingestibile/126125
There was also a report here. Meniul Date-Validitate https://ask.libreoffice.org/t/meniul-date-validitate/125967/3
always reproducible. recently updated to newest stable version, and also noticed this bug. frustating because I happen to use the "cell range" cell validity alot. hope it get fixed soon. Using: Version: 25.8.0.4 (X86_64) Build ID: 48f00303701489684e67c38c28aff00cd5929e67 CPU threads: 8; OS: Windows 11 X86_64 (build 22621); UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-US Calc: threaded
*** Bug 168353 has been marked as a duplicate of this bug. ***
It seems that the minimal trigger condition might be moving the focus to the Source input field in the Validity dialog.
(In reply to Takenori Yasuda from comment #19) > It seems that the minimal trigger condition might be moving the focus to the > Source input field in the Validity dialog. I can confirm the same, minimal steps to reproduce: 1) open a new blank Calc Spreadsheet 2) open Data > Validity ... > Allow: Cell Range 3) move focus to the Source input field Note, if the 'Validity' dialogue is closed (OK or Cancel) after step 2, the issue doesn't trigger. But as soon as the 'Source' field gets focus it instantly triggers the condition, with the 'Validity' window still open. Also noticed that the moment the condition is triggered (step 3 above), all elements/buttons/dropdowns in the 'Properties' sidebar change to a disabled status. In my case, the transition to a disabled (ghosted) state is not instantaneous; instead, the elements are ghosted out one by one, with a noticeable delay. LO version as per my comment #13.
*** Bug 168397 has been marked as a duplicate of this bug. ***
This should be fixed with tdf#156263. I will close, but anyone is welcome to test with LO master 26.2+. *** This bug has been marked as a duplicate of bug 156263 ***
I can confirm it is solved in Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: ed45cdaef3d2807d0b9d6a4c08da375fc72024a6 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: lv-LV (en_US.UTF-8); UI: en-US Calc: CL threaded
*** Bug 168492 has been marked as a duplicate of this bug. ***
*** Bug 168570 has been marked as a duplicate of this bug. ***
The bug still exists. [2025-09-30]] Version: 25.8.3.0.0+ (X86_64) / LibreOffice Community Build ID: bd61271f10181fe6540264273753551779d4ac8a CPU threads: 4; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: en-US (ja_JP); UI: en-US Calc: CL threaded
*** Bug 168618 has been marked as a duplicate of this bug. ***
@nobu the fix has been advertised as implemented in upcoming release 26.2, which is absolutely ridiculous that we must wait that long for a bug this profound, but there it is.
(In reply to xordevoreaux from comment #28) > @nobu the fix has been advertised as implemented in upcoming release 26.2, > which is absolutely ridiculous that we must wait that long for a bug this > profound, but there it is. It will be available in 25.8.3 Week 46 , Nov 10, 2025 - Nov 16, 2025. And maybe even earlier... (see details i https://bugs.documentfoundation.org/show_bug.cgi?id=156263)
(In reply to nobu from comment #26) > The bug still exists. > [2025-09-30]] > Version: 25.8.3.0.0+ (X86_64) / LibreOffice Community > Build ID: bd61271f10181fe6540264273753551779d4ac8a The backport was merged a few hours later than your comment, please try with tomorrow's build: https://bugs.documentfoundation.org/show_bug.cgi?id=156263#c10
I confirmed this bug was fixed in the following version. Version: 25.8.3.0.0+ (X86_64) / LibreOffice Community Build ID: 58f7ecbcf486672bc5c1dddd25cd0097113a8d51 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 Additional Info: Bug 156263 might not be the same bug as Bug 166527 (cf. Bug 156263, Comment 19; Bug 156263, Comment 20).
I confirmed this bug was fixed in the following RC version. Version: 25.8.2.2 (X86_64) Build ID: d401f2107ccab8f924a8e2df40f573aab7605b6f 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