Invention Grant
- Patent Title: Method and apparatus for displaying function parameter in spreadsheet, and electronic device
-
Application No.: US16619413Application Date: 2018-05-14
-
Publication No.: US11238213B2Publication Date: 2022-02-01
- Inventor: Bo Chen , Xialin Pi , Zelin Ai , Linjian Xiang , Qingyuan Zhang
- Applicant: BEIJING KINGSOFT OFFICE SOFTWARE, INC. , ZHUHAI KINGSOFT OFFICE SOFTWARE CO., LTD. , GUANGZHOU KINGSOFT MOBILE TECHNOLOGY CO., LTD.
- Applicant Address: CN Beijing; CN Guangdong; CN Guangzhou
- Assignee: BEIJING KINGSOFT OFFICE SOFTWARE, INC.,ZHUHAI KINGSOFT OFFICE SOFTWARE CO., LTD.,GUANGZHOU KINGSOFT MOBILE TECHNOLOGY CO., LTD.
- Current Assignee: BEIJING KINGSOFT OFFICE SOFTWARE, INC.,ZHUHAI KINGSOFT OFFICE SOFTWARE CO., LTD.,GUANGZHOU KINGSOFT MOBILE TECHNOLOGY CO., LTD.
- Current Assignee Address: CN Beijing; CN Guangdong; CN Guangzhou
- Priority: CN201710418474.1 20170606
- International Application: PCT/CN2018/086665 WO 20180514
- International Announcement: WO2018/223813 WO 20181213
- Main IPC: G06F40/174
- IPC: G06F40/174 ; G06F9/451 ; G06F40/18 ; G06F3/0482 ; G06F9/54

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.
Public/Granted literature
- US20200184147A1 METHOD AND APPARATUS FOR DISPLAYING FUNCTION PARAMETER IN SPREADSHEET, AND ELECTRONIC DEVICE Public/Granted day:2020-06-11
Information query