https://bugs.documentfoundation.org/show_bug.cgi?id=168261
Bug ID: 168261
Summary: Cannot input in all cells; after input manual
data/value in cell with "List" validity
Product: LibreOffice
Version: 25.8.0.4 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
