Beijing Kingsoft Office Software, Inc.

Zhuhai Kingsoft Office Software Co., Ltd.

Guangzhou Kingsoft Mobile Technology Co., Ltd.

Zelin Ai

Bo Chen

Qingyuan Zhang

Xialin Pi

Linjian Xiang

Embodiments of a method and an apparatus for providing a prompt of a function parameter in a spreadsheet and of an electronic device are provided. The method includes: obtaining a first function parameter of a function in the spreadsheet; determining whether the first function parameter is associated with a dynamic constraint rule, wherein the dynamic constraint rule is that there is a dynamic constraint that associates the first function parameter with another function parameters in a function to which the first function parameter belongs; if the first function parameter is associated with a dynamic constraint rule, calculating a value range of the first function parameter based on the dynamic constraint rule; and presenting a prompt for the first function parameter based on the value range. By applying the embodiments provided in the present application, a user can input correct content for a parameter quickly and accurately. An inappropriate input for a parameter and thus erroneous calculation of the related formula are avoided.

Growing community of inventors

Zhuhai, China

Zelin Ai