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.

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.

Abstract: The embodiments of the present application provide a method, an apparatus, an electronic equipment and a storage medium for performing screening and statistical operation on data. The method includes: obtaining a data region on which screening and statistical operation is to be performed in a data table; the data region may contain content in multiple rows and multiple fields, and the content may have a plurality of different types; receiving a user's screen instruction for screening a field specified by a user to view in the data region; obtaining all the content contained in the field specified by the user to view in the data region according to the user's screen instruction; classifying and summarizing said all the content to obtain a classification statistic result of various types of content, wherein the statistic result includes the various types of content and values corresponding to the various types of content; displaying the statistic result on the screening panel in a specified way.

Abstract: The embodiments of the present application provide a method, an apparatus, an electronic equipment and a storage medium for performing screening and statistical operation on data. The method includes: obtaining a data region on which screening and statistical operation is to be performed in a data table; the data region may contain content in multiple rows and multiple fields, and the content may have a plurality of different types; receiving a user's screen instruction for screening a field specified by a user to view in the data region; obtaining all the content contained in the field specified by the user to view in the data region according to the user's screen instruction; classifying and summarizing said all the content to obtain a classification statistic result of various types of content, wherein the statistic result includes the various types of content and values corresponding to the various types of content; displaying the statistic result on the screening panel in a specified way.