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.

Reply via email to