Information Processing Method, Apparatus, Terminal, and Storage Medium

Abstract

The present disclosure provides an information processing method and apparatus, a terminal, and a storage medium. The information processing method includes: receiving a first condition in an input box of a filter function of a spreadsheet, where the first condition corresponds to a corresponding column of the spreadsheet; obtaining data of each cell of the column corresponding to the first condition, and filtering the data based on the first condition to obtain a filtering result of the data; and outputting result data based on the filter function and the filtering result of the data. By using the filter function of the spreadsheet, multi-condition data filtering and statistics can be achieved, and the statistical requirements of users for table data can be met.

Description

Technical Field

[0001] The present disclosure relates to the field of information technology, and particularly to an information processing method and apparatus, a terminal, and a storage medium. Background Art

[0002] When a user uses a multi-dimensional table construction application, the user's demand for flexible statistical analysis of data is increasing. Currently, for a spreadsheet (e.g., an online table), capabilities such as multi-condition filtering are not provided. The statistical requirements of the user's table data are currently not met. Summary of the Invention

[0003] To solve the existing problems, the present disclosure provides an information processing method and apparatus, a terminal, and a storage medium.

[0004] The present disclosure adopts the following technical solutions.

[0005] An embodiment of the present disclosure provides an information processing method, the information processing method including: receiving a first condition in an input box of a filter function of a spreadsheet, where the first condition corresponds to a corresponding column of the spreadsheet; obtaining data of each cell of the column corresponding to the first condition, and filtering the data based on the first condition to obtain a filtered result of the data; outputting result data based on the filter function and the filtered result of the data.

[0006] Another embodiment of the present disclosure provides an information processing apparatus, the information processing apparatus including: a condition receiving module configured to receive a first condition in an input box of a filter function of a spreadsheet, where the first condition corresponds to a corresponding column of the spreadsheet; a data filtering module configured to obtain data of each cell of the column corresponding to the first condition, and filter the data based on the first condition to obtain a filtered result of the data; a result output module configured to output result data based on the filter function and the filtered result of the data.

[0007] In some embodiments, the present disclosure provides a terminal, including: at least one memory and at least one processor; wherein, the memory is used for storing program code, and the processor is used for calling the program code stored in the memory to execute the above information processing method.

[0008] In some embodiments, the present disclosure provides a storage medium, the storage medium being used for storing program code, and the program code being used for executing the above information processing method.

[0009] By adopting the filter function of the spreadsheet, the embodiment of the present disclosure can implement multi-condition data filtering and statistics, and can meet the statistical requirements of the user's table data. Brief Description of the Drawings

[0010] In conjunction with the accompanying drawings and with reference to the following specific embodiments, the above and other features, advantages, and aspects of the various embodiments of the present disclosure will become more apparent. Throughout the drawings, the same or similar reference numerals denote the same or similar elements. It should be understood that the drawings are schematic, and the elements and elements are not necessarily drawn to scale.

[0011] Figure 1 is a flowchart of an information processing method according to an embodiment of the present disclosure.

[0012] Figure 2 shows a schematic diagram of a spreadsheet according to some embodiments.

[0013] Figure 3 shows a schematic diagram of an input box of a filter function according to some embodiments.

[0014] Figure 4 shows a schematic diagram of a calculation process of a filter function according to some embodiments.

[0015] Figure 5 shows a schematic diagram of result data output by a filter function according to some embodiments.

[0016] Figure 6 shows a schematic diagram of result data output by a filter function according to some embodiments.

[0017] Figure 7 is a partial module of an information processing device according to some embodiments of the present disclosure.

[0018] Figure 8 is a schematic structural diagram of an electronic device according to an embodiment of the present disclosure. Specific Embodiments

[0019] The embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although some embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure can be implemented in various forms and should not be construed as limited to the embodiments set forth herein. On the contrary, these embodiments are provided to more thoroughly and completely understand the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are only for exemplary purposes and are not used to limit the protection scope of the present disclosure.

[0020] It should be understood that the various steps recited in the method embodiments of the present disclosure can be executed sequentially and / or in parallel. In addition, the method embodiments may include additional steps and / or omit the steps shown. The scope of the present disclosure is not limited in this regard.

[0021] As used herein, the term "including" and its variations are open-ended, i.e., "including but not limited to". The term "based on" means "at least partially based on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments". The relevant definitions of other terms will be given in the following description.

[0022] It should be noted that the concepts such as "first", "second", etc. mentioned in this disclosure are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.

[0023] It should be noted that the modification of "one" mentioned in this disclosure is illustrative rather than restrictive. Those skilled in the art should understand that, unless otherwise clearly specified in the context, it should be understood as "one or more".

[0024] The names of the messages or information exchanged between multiple devices in the embodiments of this disclosure are only for illustrative purposes and are not used to limit the scope of these messages or information.

[0025] Figure 1 A flowchart of the information processing method of the embodiments of this disclosure is provided. The information processing method of this disclosure may include step 101 of receiving a first condition in the input box of the filter function of a spreadsheet, where the first condition corresponds to a corresponding column of the spreadsheet. In some embodiments, the spreadsheet may include an online spreadsheet. In some embodiments, as Figure 2 shown, the input box of the filter function may be temporarily hidden, and in response to the triggering of a preset control (for example, Figure 2 the "filter" control in Figure 3 ), the input box of the filter function is displayed (the input box as shown by the arrow in

[0026] ). In some embodiments, when performing multi-condition filtering, a first condition and a second condition are received in the input box of the filter function of the spreadsheet, where the first condition and the second condition respectively correspond to corresponding columns of the spreadsheet. Figure 2 As shown, if it is necessary to filter out boys with a height greater than 170, the first condition may correspond to the column of gender, the gender is male, and the second condition may correspond to the column of height, and the height is greater than 170.

[0027] In some embodiments, the method of the present disclosure may further include step 102 of obtaining data of each cell of the column corresponding to the first condition and filtering the data based on the first condition to obtain a filtered result of the data. In some embodiments, in the case of multi-condition filtering, data of each cell of the columns corresponding to the first condition and the second condition are obtained, and the data are filtered based on the first condition and the second condition to obtain a filtered result of the data. Similarly, taking the example of filtering boys with a height greater than 170, the first condition and the second condition may respectively correspond to the columns of gender and height. Therefore, data of each cell of these two columns of gender and height are obtained, and the data are filtered based on the first condition (male gender) and the second condition (height greater than 170) to obtain a filtered result of the data, so that the data satisfying the first condition and the second condition can be filtered out. It should be understood that although one or two conditions (the first condition and the second condition) are used as examples in the present disclosure for illustration, this is only exemplary, and filtering can also be performed using three or more conditions.

[0028] In some embodiments, the method of the present disclosure may further include step 103 of outputting result data based on the filter function and the filtered result of the data. In some embodiments, after filtering the data according to the corresponding conditions, the corresponding result data can be output according to the filter function and the filtered result of the data.

[0029] In this way, by using the filter function of the spreadsheet, multi-condition data filtering and statistics can be achieved, which can meet the statistical requirements of users for table data. In addition, by inputting the corresponding function (i.e., receiving the corresponding filtering conditions) in the input box of the filter function of the spreadsheet, the required results can be obtained, greatly facilitating the data statistics of users.

[0030] In some embodiments, the filter function includes a preset keyword and a preset identifier located after the preset keyword. In some embodiments, the preset keyword may include CurrentValue, and this preset keyword can represent the element being filtered. In some embodiments, the preset identifier may include “.”. In some embodiments, through the preset identifier, the preset keyword refers to the column corresponding to the theme after the preset identifier, that is, through the. operator, CurrentValue can refer to the column corresponding to the theme after the.. For example, for boys with a height greater than 170, the filter function can be expressed as: [Information Table].FILTER(CurrentValue.[Gender] = “Boys” && CurrentValue.[Height] > 170).Name, where FILTER refers to the filtering or screening of data. By defining the preset keyword and the preset identifier, the present disclosure realizes the input of the filter function, and thus can realize the filtering of data.

[0031] In some embodiments, data of each cell in the column corresponding to the first condition is obtained through a preset calculation rule. In some embodiments, data of each cell in the column corresponding to the first condition and the second condition is obtained through a preset calculation rule. In some embodiments, the preset calculation rule may include a Mappable rule. In some embodiments, obtaining data of each cell in the column corresponding to the first condition through a preset calculation rule includes: taking the intersection of each row record with the column corresponding to the first condition to obtain data of each cell in the column corresponding to the first condition. In some embodiments, obtaining data of each cell in the column corresponding to the first condition and the second condition through a preset calculation rule includes: taking the intersection of each row record with the column corresponding to the first condition and the second condition to obtain data of each cell in the column corresponding to the first condition and the second condition.

[0032] In some embodiments, obtaining data of each cell in the column corresponding to the first condition and filtering the data based on the first condition to obtain a filtered result of the data includes: determining the data of the spreadsheet according to the first field of the first condition, and encapsulating the data of the spreadsheet into an object of the first rule; according to the first identifier and the second field of the first condition, executing the first rule to divide the data of the spreadsheet into multiple data combinations, where the data combination is a combination of the row record data of the spreadsheet and the second field; determining the filtered result from the data combination according to the second identifier and the third field. In some embodiments, the first field may be the above-mentioned preset keyword, for example, CurrentValue. In some embodiments, the first rule may be the above-mentioned preset calculation rule, for example, a Mappable rule. In some embodiments, the first identifier may be the above-mentioned preset identifier, that is, the "." symbol. In some embodiments, the second field may include the subject of the column of the spreadsheet. In some embodiments, the multiple data combinations include a set of data in the intersection of each row record and the column corresponding to the second field. In some embodiments, the second identifier may include the "=" operator. In some embodiments, the third field may include the subject of a column of the spreadsheet different from the second field. By adopting the above method, the filtered result of the data can be obtained conveniently and accurately.

[0033] In some embodiments, based on the filter function and the filtering result of the data, result data is output, including: the data of the spreadsheet and the filtering result of the data received by the filter function; performing the operation of the filter function to output the result data. In some embodiments, the data of the spreadsheet and the filtering result of the data are equivalent to the input parameters of the filter function. Thus, the filter function receives the data of the spreadsheet and the filtering result of the data (for example, an array including true values and false values), and then performs filtering through a one-to-one correspondence relationship. After that, the operation of the filter function is performed to output the result data. For example, if the operation result of the filter function is to obtain data that meets the corresponding conditions (for example, boys with a height of 170), the names of the boys can be output; if the operation result of the filter function is to obtain the number of data that meet the corresponding conditions, the number of boys who meet the corresponding conditions can be output, for example.

[0034] The following combines Figure 4 to illustrate the Mappable rule. When the operation executes CurrentValue.[Gender], CurrentValue will find the first element that can be substituted, that is, [Information Table], and encapsulate it into a Mappable object: (MappableVar - [Information Table]). Then the dot operator (i.e.,. ) is executed, (MappableVar - [Information Table]).[Gender]. Since the dot operator does not accept Mappable parameters and the left node is a Mappable object, at this time it will execute Mappable, splitting the information table or data table into individual sub-elements, that is, [Row Record 1, Row Record 2, Row Record 3...].[Gender]. The execution result of the dot operator is: MappableVar - [Cell 1, Cell 2, Cell 3...]. Then the = operator is executed, (MappableVar - [Cell 1, Cell 2, Cell 3]) = "male". Since the = operator does not accept Mappable parameters and the left node is a Mappable object, at this time it will execute Mappable, splitting it into individual cells for comparison. The execution result of the = operator is: MappableVar - [true, false, true...], that is, an array including true values and false values, where meeting the condition is true and not meeting the condition is false. Additionally, the greater than (>) operator and the && operator are the same. Finally, it comes to the Filter function. The input parameters of the Filter function at this time are: [Information Table] and Mappable - [true, false, true...]. Since the Filter function accepts Mappable parameters and the right node is a Mappable object, at this time MappableVar will be directly passed to the Filter function. The Filter function receives a set and an array of true and false values, and performs filtering through a one-to-one correspondence relationship.

[0035] In some embodiments, as described above, the screening result of the data includes an array containing true and false values. For the data of each cell in the column corresponding to the condition, if the condition is met, it is true; if the condition is not met, it is false.

[0036] In some embodiments, when a preset identifier is received in the input box of the spreadsheet filtering function, the themes of the columns of the spreadsheet are provided for the user to select at a preset area. As Figure 3 shown, when a preset identifier is received in the input box of the filtering function, the themes of the columns (i.e., name, gender, height, weight) are provided for the user to select at the lower left corner of the input box. In this way, intelligent input prompts can be given to the user, which is convenient for the user to input conditions and improves the user experience. In some embodiments, the preset area may include any area around the input box or other suitable areas. Displaying the themes of the columns for the user to select after recognizing the preset identifier also improves the efficiency of the user inputting the corresponding filtering conditions.

[0037] In some embodiments, the result data includes the data or data set of the cells where the rows where the cells meeting the first condition intersect with the columns corresponding to the themes determined by the filtering function; and / or the quantity of the data. In some embodiments, the result data includes the data or data set of the cells where the rows where the cells meeting the first condition and the second condition intersect with the columns corresponding to the themes determined by the filtering function; and / or the quantity of the data. As Figure 5 shown, after the parentheses of the filtering function, the name is followed by a dot, which indicates that the result expected to be output by this filtering function is the name of the boys with a height greater than 170. For example, user A meets the first condition and the second condition, that is, he is a boy and his height is also greater than 170. Therefore, the result data includes the data "user A" of the cell where this row intersects with the column corresponding to the theme name determined by the filtering function. When the result data includes multiple data, the result data includes a data set. As Figure 6 shown, the filtering function COUNTIF represents counting the results that meet the conditions. At this time, the output result data is the quantity of the data that meets the corresponding conditions. For example, when 4 users meet the corresponding conditions, the output result data is 4. Therefore, the present disclosure can output data or a data set, and can also output the quantity as a statistical result, which can meet the multiple statistical needs of users.

[0038] Embodiments of the present disclosure also provide an information processing apparatus 600. The information processing apparatus 600 includes a condition receiving module 601, a data screening module 602, and a result output module 603. In some embodiments, the condition receiving module 601 is configured to receive a first condition in the input box of a filter function of a spreadsheet, where the first condition corresponds to a respective column of the spreadsheet. In some embodiments, the data screening module 602 is configured to obtain data of each cell of the column corresponding to the first condition, and screen the data based on the first condition to obtain a screening result of the data. In some embodiments, the result output module 603 is configured to output result data based on the filter function and the screening result of the data.

[0039] It should be understood that the content described with respect to the information processing method also applies to the information processing apparatus 600 here. For simplicity, it will not be described in detail herein.

[0040] In some embodiments, the filter function includes a preset keyword and a preset identifier located after the preset keyword. Through the preset identifier, the preset keyword refers to the column corresponding to the subject after the preset identifier. In some embodiments, the data of each cell of the column corresponding to the first condition is obtained through a preset calculation rule. In some embodiments, obtaining the data of each cell of the column corresponding to the first condition through a preset calculation rule includes: taking the intersection of each row record with the column corresponding to the first condition to obtain the data of each cell of the column corresponding to the first condition. In some embodiments, the screening result of the data includes an array containing true / false values. In some embodiments, when a preset identifier is received in the input box of the filter function of the spreadsheet, the subjects of the respective columns of the spreadsheet are provided for the user to select at a preset area. In some embodiments, the result data includes the data or data set of the cells where the cells satisfying the first condition intersect with the column corresponding to the subject determined by the filter function; and / or the quantity of the data. In some embodiments, obtaining the data of each cell of the column corresponding to the first condition and screening the data based on the first condition to obtain a screening result of the data includes: determining the data of the spreadsheet according to the first field of the first condition, and encapsulating the data of the spreadsheet into an object of the first rule; according to the first identifier and the second field of the first condition, executing the first rule to divide the data of the spreadsheet into multiple data combinations, where the data combination is the combination of the row record data of the spreadsheet and the second field; determining the screening result from the data combination according to the second identifier and the third field. In some embodiments, outputting the result data based on the filter function and the screening result of the data includes: receiving the data of the spreadsheet and the screening result of the data by the filter function; performing the operation of the filter function and outputting the result data.

[0041] In addition, the present disclosure also provides a terminal, including: at least one memory and at least one processor; wherein, the memory is used for storing program codes, and the processor is used for calling the program codes stored in the memory to execute the above information processing method.

[0042] In addition, the present disclosure also provides a computer storage medium, which stores program codes for executing the above information processing method.

[0043] As described above, the information processing method and apparatus of the present disclosure are illustrated based on the embodiments and application examples. In addition, the present disclosure also provides a terminal and a storage medium, and the following describes these terminal and storage medium.

[0044] Next, refer to Figure 8 , which shows a schematic structural diagram of an electronic device (such as a terminal device or a server) 700 suitable for implementing the embodiments of the present disclosure. The terminal device in the embodiments of the present disclosure may include, but is not limited to, mobile terminals such as mobile phones, laptop computers, digital broadcast receivers, PDAs (Personal Digital Assistants), PADs (Tablet Computers), PMPs (Portable Multimedia Players), in-vehicle terminals (such as in-vehicle navigation terminals), etc., and fixed terminals such as digital TVs, desktop computers, etc. Figure 8 The electronic device shown is only an example and should not impose any limitations on the functions and usage scope of the embodiments of the present disclosure.

[0045] As Figure 8 shown, the electronic device 700 may include a processing device (such as a central processing unit, a graphics processing unit, etc.) 701, which may perform various appropriate actions and processes according to the programs stored in the read-only memory (ROM) 702 or the programs loaded from the storage device 708 into the random access memory (RAM) 703. In the RAM 703, various programs and data required for the operation of the electronic device 700 are also stored. The processing device 701, the ROM 702, and the RAM 703 are connected to each other through a bus 704. The input / output (I / O) interface 705 is also connected to the bus 704.

[0046] Generally, the following devices may be connected to the I / O interface 705: an input device 706 including, for example, a touch screen, a touchpad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; an output device 707 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; a storage device 708 including, for example, a magnetic tape, a hard disk, etc.; and a communication device 709. The communication device 709 may allow the electronic device 700 to communicate with other devices wirelessly or wirelesly to exchange data. Although Figure 8An electronic device 700 is shown with various devices, but it should be understood that it is not required to implement or have all the shown devices. Instead, more or fewer devices may be implemented or had.

[0047] Specifically, according to an embodiment of the present disclosure, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, an embodiment of the present disclosure includes a computer program product that includes a computer program carried on a computer-readable medium, and the computer program contains program codes for performing the methods shown in the flowcharts. In such an embodiment, the computer program can be downloaded and installed from a network via a communication device 709, or installed from a storage device 708, or installed from a ROM 702. When the computer program is executed by a processing device 701, the above-mentioned functions defined in the methods of the embodiments of the present disclosure are performed.

[0048] It should be noted that the above-mentioned computer-readable medium in the present disclosure can be a computer-readable signal medium or a computer-readable storage medium or any combination of the two. The computer-readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the above. More specific examples of the computer-readable storage medium can include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present disclosure, the computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. And in the present disclosure, the computer-readable signal medium can include a data signal propagated in a baseband or as part of a carrier wave, in which the computer-readable program code is carried. Such a propagated data signal can take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. The computer-readable signal medium can also be any computer-readable medium other than the computer-readable storage medium, and the computer-readable signal medium can send, propagate, or transmit a program for use by or in conjunction with an instruction execution system, apparatus, or device. The program code contained on the computer-readable medium can be transmitted by any appropriate medium, including but not limited to: wires, optical cables, RF (radio frequency), etc., or any suitable combination of the above.

[0049] In some embodiments, the client and the server can communicate using any currently known or future-developed network protocol such as HTTP (HyperText Transfer Protocol), and can be interconnected with digital data communication in any form or medium (e.g., a communication network). Examples of communication networks include local area networks ("LAN"), wide area networks ("WAN"), the Internet (e.g., the Internet), and end-to-end networks (e.g., ad hoc end-to-end networks), as well as any currently known or future-developed networks.

[0050] The computer-readable medium described above can be included in the above-mentioned electronic device; it can also exist separately without being assembled into the electronic device.

[0051] The computer-readable medium bears one or more programs, and when the one or more programs are executed by the electronic device, the electronic device is caused to execute the method of the present disclosure described above.

[0052] Computer program code for performing the operations of the present disclosure can be written in one or more programming languages or combinations thereof. The programming languages include object-oriented programming languages such as Java, Smalltalk, C++, and also include conventional procedural programming languages such as the "C" language or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, executed as a stand-alone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer can be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or can be connected to an external computer (e.g., by using an Internet service provider to connect through the Internet).

[0053] The flowcharts and block diagrams in the accompanying drawings illustrate the possible architectures, functions, and operations of systems, methods, and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagram may represent a module, a segment of a program, or a portion of code that contains one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions noted in the blocks may occur in a different order than that noted in the accompanying drawings. For example, two consecutive blocks shown may actually be executed substantially in parallel, or they may sometimes be executed in the reverse order, depending on the functions involved. It should also be noted that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, can be implemented by a dedicated hardware-based system that performs the specified functions or operations, or by a combination of dedicated hardware and computer instructions.

[0054] The units involved in the embodiments described in the present disclosure can be implemented in software or in hardware. In some cases, the name of the unit does not constitute a limitation on the unit itself.

[0055] The functions described above herein can be performed, at least in part, by one or more hardware logic components. By way of example, and without limitation, the types of hardware logic components that may be used include: field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), system on a chip (SOCs), complex programmable logic devices (CPLDs), and the like.

[0056] In the context of the present disclosure, a machine-readable medium may be a tangible medium that can contain or store a program for use by or in connection with an instruction execution system, apparatus, or device. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or Flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0057] According to one or more embodiments of the present disclosure, an information processing method is provided. The information processing method includes: receiving a first condition in an input box of a filter function of a spreadsheet, where the first condition corresponds to a respective column of the spreadsheet; obtaining data of each cell of the column corresponding to the first condition, and filtering the data based on the first condition to obtain a filtered result of the data; and outputting result data based on the filter function and the filtered result of the data.

[0058] According to one or more embodiments of the present disclosure, the filter function includes a preset keyword and a preset identifier located after the preset keyword. Through the preset identifier, the preset keyword references the column corresponding to the theme after the preset identifier.

[0059] According to one or more embodiments of the present disclosure, data of each cell of the column corresponding to the first condition is obtained through a preset calculation rule.

[0060] According to one or more embodiments of the present disclosure, obtaining data of each cell of the column corresponding to the first condition through a preset calculation rule includes: taking the intersection of each row record with the column corresponding to the first condition to obtain data of each cell of the column corresponding to the first condition.

[0061] According to one or more embodiments of the present disclosure, the filtered result of the data includes an array containing true / false values.

[0062] According to one or more embodiments of the present disclosure, when the preset identifier is received in the input box of the filter function of the spreadsheet, the themes of the respective columns of the spreadsheet are provided for the user to select at a preset area.

[0063] According to one or more embodiments of the present disclosure, the result data includes data or a data set of cells where the rows where the cells satisfying the first condition intersect with the column corresponding to the theme determined by the filter function; and / or the quantity of the data.

[0064] According to one or more embodiments of the present disclosure, obtaining data of each cell of the column corresponding to the first condition, and filtering the data based on the first condition to obtain a filtered result of the data, includes: determining the data of the spreadsheet according to the first field of the first condition, and encapsulating the data of the spreadsheet into an object of a first rule; according to the first identifier and the second field of the first condition, executing the first rule to divide the data of the spreadsheet into multiple data combinations, where the data combination is a combination of the row record data of the spreadsheet and the second field; and determining the filtered result from the data combination according to the second identifier and the third field.

[0065] According to one or more embodiments of the present disclosure, outputting result data based on the filtering result of the filter function and the data includes: receiving, by the filter function, the data of the spreadsheet and the filtering result of the data; performing an operation of the filter function to output the result data.

[0066] According to one or more embodiments of the present disclosure, an information processing apparatus is provided, including: a condition receiving module configured to receive a first condition in an input box of a filter function of a spreadsheet, where the first condition corresponds to a respective column of the spreadsheet; a data filtering module configured to obtain data of each cell of a column corresponding to the first condition and filter the data based on the first condition to obtain a filtering result of the data; and a result output module configured to output result data based on the filter function and the filtering result of the data.

[0067] According to one or more embodiments of the present disclosure, a terminal is provided, including: at least one memory and at least one processor; wherein the at least one memory is configured to store program code, and the at least one processor is configured to call the program code stored in the at least one memory to execute the method according to any one of the above.

[0068] According to one or more embodiments of the present disclosure, a storage medium is provided, and the storage medium is configured to store program code, and the program code is configured to execute the method according to the above.

[0069] The above description is only a preferred embodiment of the present disclosure and an explanation of the applied technical principle. Those skilled in the art should understand that the scope of disclosure involved in the present disclosure is not limited to the technical solution formed by the specific combination of the above technical features, and should also cover other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the above disclosure concept. For example, a technical solution formed by mutually replacing the above features with technical features having similar functions disclosed in the present disclosure (but not limited to).

[0070] In addition, although the operations are depicted in a particular order, this should not be construed as requiring that the operations be performed in the particular order shown or in sequential order. In certain environments, multitasking and parallel processing may be advantageous. Similarly, although several specific implementation details are included in the above discussion, these should not be construed as limiting the scope of the present disclosure. Certain features described in the context of separate embodiments may also be implemented combinatorially in a single embodiment. Conversely, various features described in the context of a single embodiment may also be implemented separately or in any suitable sub-combination in multiple embodiments.

[0071] Although the subject matter has been described in language specific to structural features and / or methodological acts, it is to be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or acts described above. On the contrary, the specific features and acts described above are merely example forms of implementing the claims.

Claims

1. An information processing method, characterized in that, Including: Receiving a first condition in an input box of a filter function of a spreadsheet, where the first condition corresponds to a corresponding column of the spreadsheet; Obtaining data of each cell in the column corresponding to the first condition, and filtering the data based on the first condition to obtain a filtered result of the data; Outputting result data based on the filter function and the filtered result of the data; Wherein, the filter function includes a preset keyword and a preset identifier located after the preset keyword, and through the preset identifier, the preset keyword references the column corresponding to the theme after the preset identifier; wherein, the filter function is applied to a column of the spreadsheet, and the result data is displayed in the cells of this column; Wherein, when the preset identifier is received in the input box of the filter function of the spreadsheet, the themes of each column of the spreadsheet are provided for the user to select at a preset area.

2. The information processing method according to claim 1, wherein Obtaining data of each cell in the column corresponding to the first condition through a preset calculation rule.

3. The information processing method according to claim 2, wherein Obtaining data of each cell in the column corresponding to the first condition through a preset calculation rule includes: Taking the intersection of each row record with the column corresponding to the first condition to obtain data of each cell in the column corresponding to the first condition.

4. The information processing method according to claim 1, wherein The filtered result of the data includes an array containing true / false values.

5. The information processing method according to claim 1, characterized in that, The result data includes data or a data set of the intersection of the rows where the cells satisfying the first condition are located and the column corresponding to the theme determined by the filter function; and / or the quantity of the data.

6. The information processing method according to claim 1, wherein Obtaining data of each cell in the column corresponding to the first condition, and filtering the data based on the first condition to obtain a filtered result of the data, includes: Determining the data of the spreadsheet according to the first field of the first condition, and encapsulating the data of the spreadsheet into an object of a first rule; Executing a first rule according to the first identifier and the second field of the first condition, and dividing the data of the spreadsheet into multiple data combinations, where the data combination is a combination of the row record data of the spreadsheet and the second field; Determining the filtered result from the data combinations according to the second identifier and the third field.

7. The information processing method according to claim 1, wherein The outputting result data based on the filter function and the filtered result of the data includes: Receiving the data of the spreadsheet and the filtered result of the data by the filter function; Executing the operation of the filter function and outputting the result data.

8. An information processing apparatus, characterized in that, Including: A condition receiving module configured to receive a first condition in an input box of a filter function of a spreadsheet, where the first condition corresponds to a corresponding column of the spreadsheet; A data filtering module configured to obtain data of each cell in the column corresponding to the first condition, and filter the data based on the first condition to obtain a filtered result of the data; A result output module configured to output result data based on the filter function and the filtered result of the data; Among them, the filter function includes a preset keyword and a preset identifier located after the preset keyword. Through the preset identifier, the preset keyword references the column corresponding to the theme after the preset identifier. Among them, the filter function is applied to a column of the spreadsheet, and the result data is displayed in the cell of this column. Among them, when the preset identifier is received in the input box of the filter function of the spreadsheet, the themes of the columns of the spreadsheet are provided for the user to select at the preset area.

9. A terminal, comprising: At least one memory and at least one processor; Among them, the at least one memory is used to store program code, and the at least one processor is used to call the program code stored in the at least one memory to execute the information processing method according to any one of claims 1 to 7.

10. A storage medium, the storage medium is used to store program code, and the program code is used to execute the information processing method according to any one of claims 1 to 7.

Images