The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Feb. 01, 2022
Filed:
May. 14, 2018
Beijing Kingsoft Office Software, Inc., Beijing, CN;
Zhuhai Kingsoft Office Software Co., Ltd., Guangdong, CN;
Guangzhou Kingsoft Mobile Technology Co., Ltd., Guangzhou, CN;
Bo Chen, Zhuhai, CN;
Xialin Pi, Zhuhai, CN;
Zelin Ai, Zhuhai, CN;
Linjian Xiang, Zhuhai, CN;
Qingyuan Zhang, Zhuhai, CN;
BEIJING KINGSOFT OFFICE SOFTWARE, INC., Beijing, CN;
ZHUHAI KINGSOFT OFFICE SOFTWARE CO., LTD., Guangdon, CN;
GUANGZHOU KINGSOFT MOBILE TECHNOLOGY CO., LTD., Guangzhou, CN;
Abstract
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.