Excel 中输入不完整公式后按 F1 打开帮助窗口时，帮助窗口无法交互，并弹出“该公式缺少左括号或右括号”提示

问题描述

在 Excel 单元格中输入公式且尚未填充公式参数时，按 F1 打开帮助窗口后，无法在帮助窗口内进行点击。例如输入 =SUM( 后按 F1，帮助窗口会弹出，但无法点击或框选帮助窗口中的任何内容；尝试操作帮助窗口时会弹出“该公式缺少左括号或右括号”提示；但可以拖动帮助窗口并调整大小。该提示内容与输入 =SUM( 后直接按 Enter 时出现的提示相同。

期望结果

按 F1 打开帮助窗口后，应能够正常点击、框选和操作帮助窗口内容，不应因单元格中公式未完成而弹出“该公式缺少左括号或右括号”等提示或阻止帮助窗口交互。

可复现情况（按F1后帮助窗口不可操作）：

1. =SUM(
2. =SUM()（此情况下弹出的是“此公式有问题……”对话框）

不可复现（按F1后帮助窗口可正常操作）：

1. =SUM(1)
2. =SUM(A)（点击帮助窗口后公式返回 #NAME?）
3. =SUM（点击帮助窗口后公式返回 #NAME?）
4. 输入 =SUM( → 按 F1 弹出帮助窗口 → 按 Esc 清除单元格内容后，可正常操作帮助窗口

环境信息

• Excel版本：2024MSO (版本 2610 Build 16.0.20527.20088) 64 位
• 操作系统：Windows 11 家庭版 中文版 24H2
• 语言/区域：zh-CN
• 加载项：Visual Studio Tools for Office Design-Time Adaptor for Excel、规划求解加载项
• 空白工作簿可复现

希望确认的问题

Microsoft 是否已知晓此问题？

是否有修复计划？

除了问题中列出的可正常操作帮助窗口的情况外，是否还有其他可正常操作帮助窗口的方法？

English version, translated with AI

Issue Description

In an Excel cell, when a formula has been entered but its arguments have not yet been filled in, pressing F1 to open the Help window results in the Help window being unclickable. For example, after entering =SUM( and pressing F1, the Help window pops up, but it is impossible to click or select any content in the Help window; when attempting to interact with the Help window, the prompt “The formula is missing an opening or closing parenthesis” appears; however, the Help window can be dragged and resized. This prompt is the same as the one that appears when pressing Enter directly after entering =SUM(.

Expected Result

After pressing F1 to open the Help window, it should be possible to normally click, select, and interact with the contents of the Help window. The incomplete formula in the cell should not cause prompts such as “The formula is missing an opening or closing parenthesis” to appear or prevent interaction with the Help window.

Reproducible cases (Help window is not operable after pressing F1):

=SUM(

=SUM() (in this case, the “There's a problem with this formula...” dialog appears)

Not reproducible (Help window is normally operable after pressing F1):

=SUM(1)

=SUM(A) (after clicking the Help window, the formula returns #NAME?)

=SUM (after clicking the Help window, the formula returns #NAME?)

Enter =SUM( → press F1 to open the Help window → press Esc to clear the cell contents, after which the Help window can be operated normally

Environment Information

Excel version: 2024 MSO (Version 2610 Build 16.0.20527.20088) 64-bit

Operating system: Windows 11 Home Chinese edition 24H2

Language/region: zh-CN

Add-ins: Visual Studio Tools for Office Design-Time Adaptor for Excel, Solver Add-in

Reproducible in a blank workbook

Questions to Confirm

Is Microsoft aware of this issue?

Is there a fix plan?

Besides the cases listed in the issue where the Help window can be operated normally, are there any other methods to make the Help window operable normally?