阅读说明：本技术 调整单元格函数的方法、装置、计算机存储介质及终端 (Method and device for adjusting cell function, computer storage medium and terminal ) 是由 陈波 项林建 覃欢 于 2020-06-01 设计创作，主要内容包括：一种调整单元格函数的方法、装置、计算机存储介质及终端,本发明实施例确定第一函数和第二函数的差异信息后,对第二函数通过确定的参数差异信息进行参数的自动调整后,获得填充至第一单元格的第一函数,简化了单元格函数的调整过程,提升了用户基于电子表格进行数据整理的效率。(After the difference information of a first function and a second function is determined, the parameters of the second function are automatically adjusted through the determined parameter difference information, and the first function filled in the first cell is obtained, so that the adjustment process of the cell function is simplified, and the efficiency of data arrangement of a user based on an electronic form is improved.)

1. A method of adjusting a cell function, comprising:

determining parameter difference information of the first function and the second function;

adjusting parameters of the second function according to the determined parameter difference information to obtain a first function;

the first function comprises more than one function and is used for representing the operation performed when the source data is filled into the first cell; the second function includes an operation written to the second cell to represent the source data as it fills the second cell.

2. The method of claim 1, wherein the parameter difference information comprises one or any combination of the following:

the serial number of the table where the source data of the function operation is located, the row number of the data row where the source data of the function operation is located, and the column number and the constant of the data column where the source data of the function operation is located.

3. The method of claim 1 or 2, wherein determining parameter difference information between the first function and the second function comprises:

acquiring a difference item and a difference value of the position information of the source data of the first function and the second function;

and determining the parameter difference information according to the difference item and the difference value of the acquired position information of the source data of the first function and the second function.

4. The method of claim 1 or 2, wherein determining parameter difference information between the first function and the second function comprises:

for two or more second functions, determining parameter difference information among the second functions and position difference information among second cells written by the second functions;

establishing a corresponding relation between the obtained parameter difference information between the second functions and the position difference information between the second cells written in by the second functions;

respectively determining the position difference information of a first cell to be written in by the first function and any selected second cell;

and acquiring the parameter difference information of the first function and the second function according to the established corresponding relation and the position difference information of the first cell to be written in by the first function and any selected second cell.

5. The method of claims 1 to 2, wherein after obtaining the first function, the method further comprises:

and filling the obtained first functions into corresponding first cells respectively.

6. A computer storage medium having stored thereon a computer program which, when executed by a processor, implements a method of adjusting a cell function as claimed in any one of claims 1 to 5.

7. A terminal, comprising: a memory and a processor, the memory having a computer program stored therein; wherein the content of the first and second substances,

the processor is configured to execute the computer program in the memory;

the computer program, when executed by the processor, implements a method of adjusting a cell function as claimed in any of claims 1 to 5.

8. An apparatus for adjusting a cell function, comprising: a determining unit and an adjusting unit; wherein the content of the first and second substances,

the determination unit is used for: determining parameter difference information of the first function and the second function;

the adjusting unit is used for: adjusting parameters of the second function according to the determined parameter difference information to obtain a first function;

the first function comprises more than one function and is used for representing the operation performed when the source data is filled into the first cell; the second function includes an operation written to the second cell to represent the source data as it fills the second cell.

9. The apparatus of claim 8, wherein the determining unit comprises a first determining module and a second determining module; wherein the content of the first and second substances,

the first determining module is to: acquiring a difference item and a difference value of the position information of the source data of the first function and the second function; determining the parameter difference information according to the difference item and the difference value of the acquired position information of the source data of the first function and the second function;

the second determination module is to: for two or more second functions, determining parameter difference information among the second functions and position difference information among second cells written by the second functions; establishing a corresponding relation between the obtained parameter difference information between the second functions and the position difference information between the second cells written in by the second functions; respectively determining the position difference information of a first cell to be written in by the first function and any selected second cell; and acquiring the parameter difference information of the first function and the second function according to the established corresponding relation and the position difference information of the first cell to be written in by the first function and any selected second cell.

10. The apparatus according to claims 8 to 9, further comprising a filling unit for: and filling the obtained first functions into corresponding first cells respectively.

Technical Field

The present disclosure relates to, but not limited to, office application technologies, and more particularly, to a method, an apparatus, a computer storage medium, and a terminal for adjusting a cell function.

Background

Spreadsheets are a major tool for users to perform data consolidation, such as: populating a column and a row in the first spreadsheet into a specified column or row in the second spreadsheet; the following steps are repeated: and after the same operation is carried out on the data of a certain column or a certain row in the plurality of first electronic forms, filling the operation result in the specified position of the second electronic form. In order to implement the above table filling, a user is required to configure a series of functions to implement the table filling.

Fig. 1 is a screenshot of a student performance statistics table (table 1) in the related art, and as shown in fig. 2, in order to fill the performance of each department of the king classmate in the student performance statistics table shown in fig. 1 into a designated row in the table 2 shown in fig. 2, the screenshot roughly includes: first, the function is entered in cell B4 of table 2, the contents of which are: filling the Chinese achievement of the king classmate in table 1 into cell B4 of table 2; then, selecting the cell B4, dragging and filling the cell B4 to the right cell of the fourth row, and filling the cell C4-F4 with the function of the cell B4, wherein the function of the cell C4-F4 is to fill the Wang classmate language achievement into the cell; then, the functions in the filled cells C4-F4 are manually modified so that the modified functions achieve the filling of the mathematics, english, and science of the wang classmates in table 1 into the cells C4-F4 of table 2, respectively. By comparison, the mathematical achievement and the Chinese achievement in table 1 are located in the same row, and the number of columns of the mathematical achievement is 1 more than that of the Chinese achievement, so that the user only needs to manually modify the parameters of the columns in the fill function, that is, the parameters (the 3 rd parameter shown by underline) about the columns of the unit cell C4: F4 formula in table 2 are respectively changed into 3, 4, 5 and 6. In the related art, the process of realizing data sorting through manual modification is complex in operation and low in efficiency, and the efficiency of data sorting is greatly reduced.

Disclosure of Invention

The following is a summary of the subject matter described in detail herein. This summary is not intended to limit the scope of the claims.

The embodiment of the invention provides a method and a device for adjusting a cell function, a computer storage medium and a terminal, which can improve the data sorting efficiency.

The embodiment of the invention provides a method for adjusting a cell function, which comprises the following steps:

determining parameter difference information of the first function and the second function;

adjusting parameters of the second function according to the determined parameter difference information to obtain a first function;

the first function comprises more than one function and is used for representing the operation performed when the source data is filled into the first cell; the second function includes an operation written to the second cell to represent the source data as it fills the second cell.

On the other hand, an embodiment of the present invention further provides a computer storage medium, where a computer program is stored, and when the computer program is executed by a processor, the method for adjusting a cell function is implemented.

In another aspect, an embodiment of the present invention further provides a terminal, including: a memory and a processor, the memory having a computer program stored therein; wherein the content of the first and second substances,

the processor is configured to execute the computer program in the memory;

the computer program, when executed by the processor, implements a method of adjusting a cell function as described above.

In another aspect, an embodiment of the present invention further provides an apparatus for adjusting a cell function, where the apparatus includes: a determining unit and an adjusting unit; wherein the content of the first and second substances,

the determination unit is used for: determining parameter difference information of the first function and the second function;

the adjusting unit is used for: adjusting parameters of the second function according to the determined parameter difference information to obtain a first function;

the first function comprises more than one function and is used for representing the operation performed when the source data is filled into the first cell; the second function includes an operation written to the second cell to represent the source data as it fills the second cell.

The application includes: determining parameter difference information of the first function and the second function; adjusting parameters of the second function according to the determined parameter difference information to obtain a first function; the first function comprises more than one function and is used for representing the operation performed when the source data are filled into the first cell; the second function includes an operation written to the second cell to represent the source data as it fills the second cell. After the difference information of the first function and the second function is determined, the parameters of the second function are automatically adjusted through the determined parameter difference information, and the first function filled in the first cell is obtained, so that the adjustment process of the cell function is simplified, and the efficiency of data arrangement of a user based on an electronic form is improved.

Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.

Drawings

The accompanying drawings are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the example serve to explain the principles of the invention and not to limit the invention.

FIG. 1 is a screenshot of a student achievement statistics table in the related art;

FIG. 2 is a screenshot of a statistics table populating the assigned row of Table 2 with the scores of each department of the congruence of the King university;

FIG. 3 is a flowchart of a method for adjusting a cell function according to an embodiment of the present invention;

FIG. 4 is a diagram illustrating an interactive window according to an embodiment of the present invention;

FIG. 5 is a block diagram of an apparatus for adjusting a cell function according to an embodiment of the present invention.

Detailed Description

In order to make the objects, technical solutions and advantages of the present invention more apparent, embodiments of the present invention will be described in detail below with reference to the accompanying drawings. It should be noted that the embodiments and features of the embodiments in the present application may be arbitrarily combined with each other without conflict.

The steps illustrated in the flow charts of the figures may be performed in a computer system such as a set of computer-executable instructions. Also, while a logical order is shown in the flow diagrams, in some cases, the steps shown or described may be performed in an order different than here.

Fig. 3 is a flowchart of a method for adjusting a cell function according to an embodiment of the present invention, as shown in fig. 3, including:

step 301, determining parameter difference information of a first function and a second function;

the first function comprises more than one function and is used for representing the operation performed when the source data are filled into the first cell; the second function includes an operation written to the second cell to represent the source data as it fills the second cell.

It should be noted that, the source data in the embodiment of the present invention refers to original data obtained when the first cell and the second cell are filled; for example, in the first row of cell B1 in the first spreadsheet, the data in the first row of cell B1 in the second spreadsheet is filled, and the data in the first row of cell B1 in the second spreadsheet is the source data; in the first row of cell B1 of the first spreadsheet, the sum of all the data in column B1 of the second spreadsheet is filled, and all the data in column B1 of the second spreadsheet is the source data.

In an exemplary embodiment, the parameter difference information includes one or any combination of the following:

the serial number of the table where the source data of the function operation is located, the row number of the data row where the source data of the function operation is located, and the column number and the constant of the data column where the source data of the function operation is located.

In one illustrative example, the constants may include: text constants, numeric constants, date constants, and the like; taking the spreadsheet for counting the class scores as an example, … … N classes of 1, 2 and 3 in the spreadsheet are text constants; taking a spreadsheet with a complex operation as an example, when the operations of multiplying 1 by 3, multiplying 5 by 5 … … by 2N +1 are sequentially performed on the data of the designated cells in the spreadsheet, 1, 3, 5, … … 2N +1 are digital constants.

In an illustrative example, the difference in constants, the difference in numbering, the difference in row numbers, and the difference in column numbers may include differences that conform to any of the following categories: differences in arithmetic series, differences in geometric sequences, and differences in custom sequences.

In one illustrative example, determining parameter difference information for the first function and the second function comprises:

acquiring a difference item and a difference value of the position information of the source data of the first function and the second function;

and determining parameter difference information according to the difference item and the difference value of the acquired position information of the source data of the first function and the second function.

It should be noted that the location information may include one or any combination of the following items: the table number, the row number of the data row, and the column number of the data column.

In an exemplary embodiment, obtaining the parameter having the difference between the first function and the second function and the difference value of each parameter may be implemented by a preset interactive window; for example: determining the parameter difference information of the first function and the second function through the interaction window shown in fig. 4 as follows: the column numbers of the data columns where the source data operated by the first function and the second function are located are different, wherein the specific difference is that the column number difference accords with an arithmetic progression, and the step value of the arithmetic progression is 1; in fig. 4, the triangular key is used to determine the parameters with differences, the types of differences, and the specific difference values of the differences; the key for adding parameter difference information is used for adding new difference parameter information when a plurality of items of parameter difference information are contained.

In one illustrative example, determining parameter difference information for the first function and the second function comprises:

for two or more second functions, determining parameter difference information between the second functions and position difference information between second cells written by the second functions;

establishing a corresponding relation between the obtained parameter difference information between the second functions and the position difference information between the second cells written in by the second functions;

respectively determining the position difference information of a first cell to be written in by the first function and any selected second cell;

and acquiring parameter difference information of the first function and the second function according to the established corresponding relation and the position difference information of the first cell to be written in by the first function and any selected second cell.

The embodiment of the invention automatically determines the parameter difference between the first function and the second function of the first cell to be filled through the parameter difference between the functions written into the cells, and provides data support for obtaining the first function written into each first cell.

Step 302, adjusting parameters of the second function according to the determined parameter difference information to obtain a first function;

after the difference information of the first function and the second function is determined, the parameters of the second function are automatically adjusted through the determined parameter difference information, and the first function filled in the first cell is obtained, so that the adjustment process of the cell function is simplified, and the efficiency of data arrangement of a user based on an electronic form is improved.

In an exemplary embodiment, after obtaining the first function, the method of the embodiment of the present invention further includes:

and filling the obtained first functions into corresponding first cells respectively.

In an exemplary embodiment, the parameter adjustment and the filling of the first function may be implemented by designing with reference to an existing drag filling function in the application program; for example: when the operation of dragging and filling is received, generating a parameter adjusting instruction according to the determined parameter difference; performing parameter adjustment on the second function according to the generated parameter adjustment instruction to obtain a first function; the obtained first function is written into the first cell.

The embodiment of the invention also provides a computer storage medium, wherein a computer program is stored in the computer storage medium, and when being executed by a processor, the computer program realizes the method for adjusting the cell function.

An embodiment of the present invention further provides a terminal, including: a memory and a processor, the memory having stored therein a computer program; wherein the content of the first and second substances,

the processor is configured to execute the computer program in the memory;

the computer program, when executed by a processor, implements a method of adjusting a cell function as described above.

Fig. 5 is a block diagram of an apparatus for adjusting a cell function according to an embodiment of the present invention, as shown in fig. 5, including: a determining unit and an adjusting unit; wherein the content of the first and second substances,

the determination unit is used for: determining parameter difference information of the first function and the second function;

the adjusting unit is used for: adjusting parameters of the second function according to the determined parameter difference information to obtain a first function;

the first function comprises more than one function and is used for representing the operation performed when the source data are filled into the first cell; the second function includes an operation written to the second cell to represent the source data as it fills the second cell.

After the difference information of the first function and the second function is determined, the parameters of the second function are automatically adjusted through the determined parameter difference information, and the first function filled in the first cell is obtained, so that the adjustment process of the cell function is simplified, and the efficiency of data arrangement of a user based on an electronic form is improved.

In an exemplary embodiment, the parameter difference information includes one or any combination of the following:

the serial number of the table where the source data of the function operation is located, the row number of the data row where the source data of the function operation is located, and the column number and the constant of the data column where the source data of the function operation is located.

In an illustrative example, the difference in numbering, the difference in row number, and the difference in column number may include differences that conform to any of the following categories: differences in arithmetic series, differences in geometric sequences, and differences in custom sequences.

In an exemplary instance, the determining unit includes a first determining module and a second determining module; wherein the content of the first and second substances,

the first determining module is to: acquiring a difference item and a difference value of the position information of the source data of the first function and the second function; determining parameter difference information according to the difference item and the difference value of the acquired position information of the source data of the first function and the second function;

the second determination module is to: for two or more second functions, determining parameter difference information between the second functions and position difference information between second cells written by the second functions; establishing a corresponding relation between the obtained parameter difference information between the second functions and the position difference information between the second cells written in by the second functions; respectively determining the position difference information of a first cell to be written in by the first function and any selected second cell; and acquiring parameter difference information of the first function and the second function according to the established corresponding relation and the position difference information of the first cell to be written in by the first function and any selected second cell. The embodiment of the invention automatically determines the parameter difference information of the first function and the second function to be written into the first cell by comparing the parameter difference between the functions written into the cells, and provides data support for obtaining the first function written into each first cell.

In an exemplary embodiment, the apparatus of the present invention further includes a filling unit, configured to: and filling the obtained first functions into corresponding first cells respectively.

"one of ordinary skill in the art will appreciate that all or some of the steps of the methods, systems, functional modules/units in the devices disclosed above may be implemented as software, firmware, hardware, and suitable combinations thereof. In a hardware implementation, the division between functional modules/units mentioned in the above description does not necessarily correspond to the division of physical components; for example, one physical component may have multiple functions, or one function or step may be performed by several physical components in cooperation. Some or all of the components may be implemented as software executed by a processor, such as a digital signal processor or microprocessor, or as hardware, or as an integrated circuit, such as an application specific integrated circuit. Such software may be distributed on computer readable media, which may include computer storage media (or non-transitory media) and communication media (or transitory media). The term computer storage media includes volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data, as is well known to those of ordinary skill in the art. Computer storage media includes, but is not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, Digital Versatile Disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can accessed by a computer. In addition, communication media typically embodies computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism and includes any information delivery media "as is well known to those of ordinary skill in the art.