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?
After this bug occurred, it seems that only the Validity using a dropdown list allows input in any cell. However, this is limited to input via the list; direct input is not possible, just like in other cells. Tested with: Version: 25.8.3.0.0+ (X86_64) / LibreOffice Community Build ID: 8b83439dc0cc270a1eb517d3efb652293f1fbce8 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
Created attachment 202989 [details] Test file You can test with this attached file. 1. Open the file with Calc 2. Select the whole column C 3. Select "Data" - " Validity" - Allow: "Cell range" 4. Click the button after the Source: field 5. Try selecting Sheet 2 (but you can not select it now) 6. At this point, Calc couldn't be closed either. I had to kill its process instead.
(In reply to Franklin Weng from comment #11) > Created attachment 202989 [details] > Test file > > You can test with this attached file. > > 1. Open the file with Calc > 2. Select the whole column C > 3. Select "Data" - " Validity" - Allow: "Cell range" > 4. Click the button after the Source: field > 5. Try selecting Sheet 2 (but you can not select it now) > 6. At this point, Calc couldn't be closed either. I had to kill its process > instead. Sorry, wrong issue. I should post this in tdf#168482. But it's related to this issue too.
It looks like a duplicated of bug 156263 *** This bug has been marked as a duplicate of bug 156263 ***
Xisco, unless you tested otherwise, this does not seem resolved. As Comment 10 clarifies, criteria here is that we should be able to type in other cells.
(In reply to Timur from comment #14) > Xisco, unless you tested otherwise, this does not seem resolved. > As Comment 10 clarifies, criteria here is that we should be able to type in > other cells. you are right. My bad. I can reproduce it in Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 81321560f2151ee12be26135aed65968287d1c94 CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: es-ES (es_ES.UTF-8); UI: en-US Calc: threaded
Actually it was already reported in bug 167126 *** This bug has been marked as a duplicate of bug 167126 ***
Turned out that fixes for this and other one are different commits. https://gerrit.libreoffice.org/c/core/+/193141
Since Bug 167126 is no longer marked as a duplicate, I'm posting the following comment here as well (see Bug 167126, Comment 5). The behavior has been confirmed in both bugs. --- Regarding invalid input: Entering a cell reference (e.g., =A2) does not commit the input when the Enter key is pressed. Instead, the reference shifts to A3, A4, and so on. There appears to be no way to commit the input. Tested with: Version: 25.8.3.1 (X86_64) Build ID: 52ad9dd1c984050a9fb6932dbfb16e86a49e9758 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
Pranam Lashkari committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/65ca233db9a39fd251ffac46608bb2714949e894 tdf#168261: resume ScInputHandler even if error not displayed It will be available in 26.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.
Pranam Lashkari committed a patch related to this issue. It has been pushed to "libreoffice-25-8": https://git.libreoffice.org/core/commit/f60a4baee3852184da95c2947c910b485225d5fb tdf#168261: resume ScInputHandler even if error not displayed It will be available in 25.8.4. 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.
Pranam Lashkari committed a patch related to this issue. It has been pushed to "libreoffice-25-8-3": https://git.libreoffice.org/core/commit/9c89b1991e2cccf35a0a53ee5e3580f14e221388 tdf#168261: resume ScInputHandler even if error not displayed It will be available in 25.8.3. 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.