https://bugs.documentfoundation.org/show_bug.cgi?id=167126
Bug ID: 167126
Summary: Setting a macro to "Error Alert" in a cell validation,
you will not be able to key in
Product: LibreOffice
Version: 25.8.0.0 alpha0+
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Setting a macro to "Error Alert" in a cell validation, you will not be able to
key in.
Steps to Reproduce:
1. Open new Calc.
2. Select Cell [A1].
3. Insert Cell Validity. ( Menu - Data > Validity )
4. Criteria Tab :
Allow : List
Entities : a (for example)
5. Error Alert Tab :
Action : Macro
This bug does not affect whether the correct macro is set or not.
You do not need to configure specific macros.
6. Close. ( Push OK Button )
7. In Cell [A1], "a" is displayed in the drop-down, and you can confirm that
you can select correctly.
8. Insert "b" for Cell [A1].
9. Of course, the macro of the cell is not set, so the warning is displayed and
the input is also rejected.
10. Move the cursor to Cell [A2] and try to enter some text in the cell.
Actual Results:
11. The cell is empty.
You may be able to input using "Input line", but even if you confirm the
input, it is not reflected in the cell.
Expected Results:
11. The cell should be fillable.
Reproducible: Always
User Profile Reset: No
Additional Info:
Not reproduced 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
Version: 25.8.0.0.beta1 (X86_64) / LibreOffice Community
Build ID: 1b25e37a63c5a6f16bdcb365ed3da80ac419e6e4
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
[2025-06-20]
Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 024053c0c140e1d167a0276f1885a21a160b45ac
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
--
You are receiving this mail because:
You are the assignee for the bug.