Description: Normally when using "List" Cell Validity, we can still input manual data or value other than written in the Entries box (when List is selected); LibreCalc will allow that manually input data to be showed and saved in the cells ONLY IF we uncheck "Show error message when invalid values are entered" box in Error Alert tab. In this case after selecting OK and we try to input manual value, the cell will still display the last value as if nothing happens. But turns out we suddenly CANNOT INPUT to all the cells in the same document/file. Other sheet in the same file also affected. Closing and reopening the file again seems to reset the Bug. And other opened window while the error happened will not be affected by this. Only deleting the value of the cells, will not trigger the bug. Already tried using different Action rather than default Stop, but resulting same output. Already tried using Safe Mode but resulting same output. Steps to Reproduce: 1.Open new Calc document 2.Select cell A1 then open Data -> Validity... 3.In Criteria, select List; only "Allow empty cells" and "Show selection list" boxes are selected 4.Write : "a" then enter, "b" then enter, and "c" 5.Go to Error Aler tab and uncheck "Show error message when invalid values are entered" 6.Click OK -- Validity window closes. 7.On cell A1 write "D" and press enter Bug should be triggered, and we cannot input to all the other cells in the same document. Actual Results: cell A1 still display last value. Error triggered : cannot input to all the other cells in the same document (also affecting other sheet in same document) Expected Results: cell A1 should display "D" and listed option are still available. Other cells should not be affected. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 25.8.0.4 (X86_64) Build ID: 48f00303701489684e67c38c28aff00cd5929e67 CPU threads: 8; OS: Windows 11 X86_64 (build 22621); UI render: Skia/Vulkan; VCL: win Locale: en-GB (en_GB); UI: en-US Calc: threaded
Reproduced. Version: 25.8.2.0.0+ (X86_64) / LibreOffice Community Build ID: afc5873df922a9f72bb615fdeb38de22311b9651 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 Not reproduced. Version: 25.2.6.2 (X86_64) / LibreOffice Community Build ID: 729c5bfe710f5eb71ed3bbde9e06a6065e9c6c5d CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL threaded Jumbo
Reproduced. Version: 25.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: b852ed9fc8b43cdc335c14aeb71c581daa7d98a7 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 Note: This version is the oldest in the 25.8 series I have.
bibisected with linux-64-25.8 commit 72bbb0dd4a368dab2b1bd99917cd07d23a92a3f0 author Pranam Lashkari <lpranam@collabora.com> Mon Dec 30 02:20:22 2024 +0530 sc: make data validy error dialog async (invalid value error) Change-Id: Icd077776b26e21b226b4dee5beb1a5ff6dcf301a Reviewed-on: https://gerrit.libreoffice.org/c/core/+/179509 Tested-by: Jenkins CollaboraOffice <jenkinscollaboraoffice@gmail.com> Reviewed-by: Caolán McNamara <caolan.mcnamara@collabora.com> (cherry picked from commit 495be2dcb34d22af59a2028d3a686a0d48774166) Reviewed-on: https://gerrit.libreoffice.org/c/core/+/180286 adding CC: Pranam Lashkari
This occurred not only for "List" but also in all validities except "All values". Tested with: Version: 25.8.2.0.0+ (X86_64) / LibreOffice Community Build ID: 641a0e3d9a668f38651831f2a99db02edd50f21e 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 think it's a dup of tdf#160096.
I think this is different from Bug 160096. This bug is about "cannot input to all the other cells in the same document". I'm not good at English, and I read reports after translating them with Google Translate, so I might be misunderstanding. However, if my understanding is correct, I think there are the following differences: - Bug 168261: Unable to input values into cells that do NOT have Validity settings - Bug 160096: Unable to input values into cells that do have Validity settings
(In reply to Takenori Yasuda from comment #6) ... > - Bug 168261: Unable to input values into cells that do NOT have Validity > settings > ... Reading steps on the descriptions, A1 has validity settings. Indeed the author indicates having set a validity list ("a", "b", "c") then try to type "d" in the cell A1. Moreover, title talks about "validity" so how could this bugtracker be "unable to input values into cells that do NOT have validity settings" ?
(In reply to Julien Nabet from comment #7) > how could this bugtracker be "unable to input values into cells > that do NOT have validity settings" ? I summarized it that way from "Title" and "Actual Results". Among all cells, some have validation rules set while others do not. It is self-evident and normal that cells with validation rules cannot accept invalid values. For cells without validation rules, there should be no restrictions on input, meaning all values should be acceptable. However, the author states in various places that they "cannot input in/to all (other) cells". In other words, the author reports that "I cannot input any values into cells that do not have validity settings" and is troubled by it. This is why I wrote "Unable to input values into cells that do NOT have Validity settings" in Comment 6. From my perspective, the explanation ended up this way because I focused on the result, but if I focus on the cause, it would be an issue with the Validity.
Here's something I noticed. If you enter D in cell A1, D will remain displayed in the formula bar. It will return to normal when you print preview. --- I may be off the mark, but perhaps bforget is still set to true?