Method, device, computer storage medium and terminal for adjusting cell function

Abstract

A method, device, computer storage medium and terminal for adjusting cell functions. After determining difference information between a first function and a second function, the embodiment of the present invention automatically adjusts the parameters of the second function according to the determined parameter difference information, thereby obtaining the first function filled into the first cell, simplifying the cell function adjustment process and improving the efficiency of data sorting based on electronic spreadsheets by users.

Description

Technical Field

[0001] The present invention relates to but is not limited to office application technology, and in particular to a method, device, computer storage medium and terminal for adjusting cell functions. Background Art

[0002] Spreadsheets are a major tool for users to organize data, for example: fill a column or row in a first spreadsheet into a specified column or row in a second spreadsheet; or: perform the same operation on a column or row in multiple first spreadsheets, and fill the operation result in a specified position in a second spreadsheet. In order to achieve the above table filling, users need to configure a series of functions to implement it.

[0003] Figure 1 A screenshot of the student achievement statistics table (Table 1) in the related technology, such as Figure 2 As shown, in order to Figure 1 In the student performance statistics table shown in the figure, Wang's scores in each subject are filled in Figure 2 The specified row of Table 2 shown in the figure generally includes: first, input a function in cell B4 of Table 2, the content of the input function is: fill the Chinese score of Wang in Table 1 into cell B4 of Table 2; then, select cell B4, and drag the fill operation to the right cell of the fourth row to fill the function of cell B4 into cells C4~F4, at this time, the function of cells C4~F4 is to fill Wang's Chinese score into the cell; then, manually modify the function in the filled cells C4~F4, so that the modified function can fill Wang's mathematics, English and science in Table 1 into cells C4~F4 of Table 2 respectively. By comparison, the mathematics score and the Chinese score in Table 1 are in the same row, and the number of columns of the mathematics score is 1 more than the number of columns of the Chinese score. Therefore, the user only needs to manually modify the column parameters in the fill function, that is, change the column parameters (the third parameter displayed by underline) of the formula of cell C4:F4 in Table 2 to 3, 4, 5 and 6 respectively. In the related art, the process of achieving data sorting by manual modification is cumbersome and inefficient, which greatly reduces the efficiency of data sorting. Summary of the invention

[0004] 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.

[0005] The embodiments of the present invention provide a method, device, computer storage medium and terminal for adjusting cell functions, which can improve data sorting efficiency.

[0006] An embodiment of the present invention provides a method for adjusting a cell function, comprising:

[0007] Determining parameter difference information between the first function and the second function;

[0008] Adjusting the parameters of the second function according to the determined parameter difference information to obtain the first function;

[0009] Among them, the first function includes more than one, which is used to represent the operation performed when the source data is filled into the first cell; the second function includes the one that has been written into the second cell, which is used to represent the operation performed when the source data is filled into the second cell.

[0010] On the other hand, an embodiment of the present invention further provides a computer storage medium, in which a computer program is stored. When the computer program is executed by a processor, the method for adjusting a cell function is implemented.

[0011] In another aspect, an embodiment of the present invention further provides a terminal, comprising: a memory and a processor, wherein the memory stores a computer program; wherein:

[0012] The processor is configured to execute the computer program in the memory;

[0013] When the computer program is executed by the processor, the method for adjusting the cell function as described above is implemented.

[0014] In another aspect, an embodiment of the present invention further provides a device for adjusting a cell function, comprising: a determining unit and an adjusting unit; wherein:

[0015] The determination unit is used to: determine parameter difference information between the first function and the second function;

[0016] The adjustment unit is used to: adjust the parameters of the second function according to the determined parameter difference information to obtain the first function;

[0017] Among them, the first function includes more than one, which is used to represent the operation performed when the source data is filled into the first cell; the second function includes the one that has been written into the second cell, which is used to represent the operation performed when the source data is filled into the second cell.

[0018] The present application includes: determining parameter difference information between a first function and a second function; adjusting parameters of the second function according to the determined parameter difference information to obtain the first function; wherein the first function includes more than one, used to represent the operation performed when the source data is filled into the first cell; the second function includes a function that has been written into the second cell, used to represent the operation performed when the source data is filled into the second cell. After the embodiment of the present invention determines the difference information between the first function and the second function, the parameters of the second function are automatically adjusted according to the determined parameter difference information, and the first function filled into the first cell is obtained, which simplifies the adjustment process of the cell function and improves the efficiency of the user in sorting data based on the spreadsheet.

[0019] Other features and advantages of the present invention will be described in the following description, and partly become apparent from the description, or understood by practicing the present invention. The purpose and other advantages of the present invention can be realized and obtained by the structures particularly pointed out in the description, claims and drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] The accompanying drawings are used to provide a further understanding of the technical solution of the present invention and constitute a part of the specification. Together with the embodiments of the present application, they are used to explain the technical solution of the present invention and do not constitute a limitation on the technical solution of the present invention.

[0021] Figure 1 This is a screenshot of the student performance statistics table in the related technology;

[0022] Figure 2 A screenshot of the statistics table that fills Wang's grades in each subject into the specified rows of Table 2;

[0023] Figure 3 A flow chart of a method for adjusting a cell function according to an embodiment of the present invention;

[0024] Figure 4 is a schematic diagram of an interactive window according to an embodiment of the present invention;

[0025] Figure 5 A structural block diagram of an apparatus for adjusting cell function according to an embodiment of the present invention. DETAILED DESCRIPTION

[0026] In order to make the purpose, technical solution and advantages of the present invention more clear, the embodiments of the present invention will be described in detail with reference to the accompanying drawings. It should be noted that the embodiments and features in the embodiments of the present application can be combined with each other arbitrarily without conflict.

[0027] The steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions. Also, although a logical sequence is shown in the flowchart, in some cases, the steps shown or described can be performed in a sequence different from that shown here.

[0028] Figure 3 Flow chart of the method for adjusting the cell function according to an embodiment of the present invention, such as Figure 3 As shown, including:

[0029] Step 301: Determine parameter difference information between the first function and the second function;

[0030] Among them, the first function includes more than one, which is used to represent the operation performed when the source data is filled into the first cell; the second function includes the one that has been written into the second cell, which is used to represent the operation performed when the source data is filled into the second cell.

[0031] It should be noted that the source data in the embodiment of the present invention refers to the original data obtained when filling the first cell and the second cell; for example, in the first row cell B1 of the first electronic table, the data in the first row cell B1 of the second electronic table is filled, and the data in the first row cell B1 of the second electronic table is the above-mentioned source data; in the first row cell B1 of the first electronic table, the sum of all the data in the data column B1 of the second electronic table is filled, and all the data in the data column B1 of the second electronic table is the above-mentioned source data.

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

[0033] The table number where the source data for the function operation is located, the row number where the source data for the function operation is located, the column number where the source data for the function operation is located, and the constant.

[0034] In an exemplary instance, constants may include: text constants, numeric constants, and date constants, etc.; taking a spreadsheet that counts class grades as an example, Class 1, Class 2, Class 3, ... Class N in the spreadsheet are text constants; taking a spreadsheet for compound operations as an example, when the data in a specified cell in the spreadsheet is multiplied by 1, 3, 5, ..., and 2N+1, respectively, then 1, 3, 5, ..., 2N+1 are numeric constants.

[0035] In an exemplary embodiment, the difference in constants, the difference in serial numbers, the difference in row numbers, and the difference in column numbers may include differences that conform to any of the following categories: a difference in arithmetic progressions, a difference in geometric sequences, and a difference in custom sequences.

[0036] In an exemplary embodiment, determining parameter difference information between a first function and a second function includes:

[0037] Obtaining a difference item and a difference value of position information of source data of the first function and the second function;

[0038] Parameter difference information is determined according to the difference item and difference value of the acquired position information of the source data of the first function and the second function.

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

[0040] In an exemplary embodiment, obtaining the parameters in which the first function and the second function differ and the difference values ​​of the parameters can be achieved through a preset interactive window; for example: through Figure 4 The interactive window shown determines that the parameter difference information of the first function and the second function is: the column numbers of the data columns where the source data of the first function and the second function are located are different, and the specific difference is that the column number difference conforms to an arithmetic progression, and the step value of the arithmetic progression is 1; Figure 4 In the figure, the triangle button is used to determine the parameters with differences, the types of differences and the specific difference values ​​of each type of differences; the button for adding parameter difference information is used to add new difference parameter information when multiple parameter difference information are included.

[0041] In an exemplary embodiment, determining parameter difference information between a first function and a second function includes:

[0042] For two or more second functions, determining parameter difference information between the second functions and position difference information between the second cells written by the second functions;

[0043] Establishing a correspondence between the obtained parameter difference information between the second functions and the position difference information between the second cells written by the second functions;

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

[0045] Parameter difference information between the first function and the second function is obtained according to the established corresponding relationship and the position difference information between the first cell to be written by the first function and any selected second cell.

[0046] The embodiment of the present invention automatically determines the parameter difference between the first function and the second function of the first cell to be filled by comparing the parameter difference between the functions written into the cells, thereby providing data support for obtaining the first function written into each first cell.

[0047] Step 302: adjusting the parameters of the second function according to the determined parameter difference information to obtain the first function;

[0048] After the embodiment of the present invention determines the difference information between the first function and the second function, the parameters of the second function are automatically adjusted according to the determined parameter difference information, and the first function filled into the first cell is obtained, which simplifies the adjustment process of the cell function and improves the efficiency of the user in organizing data based on the spreadsheet.

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

[0050] Fill the obtained first functions into the corresponding first cells respectively.

[0051] In an exemplary instance, parameter adjustment and filling of the first function can be designed and implemented with reference to the existing drag-fill function in the application; for example: when a drag-fill operation is received, a parameter adjustment instruction is generated according to the determined parameter difference; the second function is adjusted according to the generated parameter adjustment instruction to obtain the first function; and the obtained first function is written into the first cell.

[0052] An embodiment of the present invention further provides a computer storage medium, in which a computer program is stored. When the computer program is executed by a processor, the method for adjusting a cell function is implemented.

[0053] The embodiment of the present invention further provides a terminal, comprising: a memory and a processor, wherein a computer program is stored in the memory; wherein:

[0054] The processor is configured to execute the computer program in the memory;

[0055] When the computer program is executed by a processor, the method for adjusting the cell function as described above is implemented.

[0056] Figure 5 The structural block diagram of the device for adjusting the cell function according to the embodiment of the present invention is as follows: Figure 5 As shown, it includes: a determination unit and an adjustment unit; wherein,

[0057] The determination unit is used to: determine parameter difference information between the first function and the second function;

[0058] The adjustment unit is used to: adjust the parameters of the second function according to the determined parameter difference information to obtain the first function;

[0059] Among them, the first function includes more than one, which is used to represent the operation performed when the source data is filled into the first cell; the second function includes the one that has been written into the second cell, which is used to represent the operation performed when the source data is filled into the second cell.

[0060] After the embodiment of the present invention determines the difference information between the first function and the second function, the parameters of the second function are automatically adjusted according to the determined parameter difference information, and the first function filled into the first cell is obtained, which simplifies the adjustment process of the cell function and improves the efficiency of the user in organizing data based on the spreadsheet.

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

[0062] The table number where the source data for the function operation is located, the row number where the source data for the function operation is located, the column number where the source data for the function operation is located, and the constant.

[0063] In an exemplary embodiment, the difference in serial number, row number, and column number may include a difference that conforms to any of the following categories: a difference in an arithmetic sequence, a difference in a geometric sequence, and a difference in a custom sequence.

[0064] In an exemplary embodiment, the determining unit includes a first determining module and a second determining module; wherein,

[0065] The first determination module is used to: obtain the difference item and difference value of the position information of the source data of the first function and the second function; determine the parameter difference information according to the difference item and difference value of the position information of the source data of the first function and the second function;

[0066] The second determination module is used to: determine the parameter difference information between the second functions and the position difference information between the second cells written by the second functions for two or more second functions; establish a correspondence between the obtained parameter difference information between the second functions and the position difference information between the second cells written by the second functions; respectively determine the position difference information between the first cell to be written by the first function and any selected second cell; obtain the parameter difference information between the first function and the second function based on the established correspondence and the position difference information between the first cell to be written by the first function and any selected second cell. The embodiment of the present invention automatically determines the parameter difference information between the first function to be written to the first cell and the second function by comparing the parameter differences between the functions written to the cells, thereby providing data support for obtaining the first function written to each first cell.

[0067] In an exemplary embodiment, the apparatus of the embodiment of the present invention further includes a filling unit, which is used to fill the obtained first functions into corresponding first cells respectively.

[0068] “A person skilled in the art will appreciate that all or some of the steps, systems, and functional modules / units in the above disclosed methods may be implemented as software, firmware, hardware, and appropriate combinations thereof. In hardware implementations, the division between the functional modules / units mentioned in the above description does not necessarily correspond to the division of physical components; for example, a physical component may have multiple functions, or a function or step may be performed by several physical components in cooperation. Some or all components may be implemented as software executed by a processor, such as a digital signal processor or a microprocessor, or as hardware, or as an integrated circuit, such as an application specific integrated circuit. Such software may be distributed on a computer-readable medium, which may include a computer storage medium (or a non-transitory medium) and a communication medium (or a transient medium). As is known in the art, As is well known to those skilled in the art, 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. Computer storage media include, but are 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 tapes, magnetic disk storage or other magnetic storage devices, or any other medium that can be used to store the desired information and can be accessed by a computer. In addition, as is well known to those skilled in the art, communication media typically contains 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 may include any information delivery media. "

Claims

1. A method for adjusting cell functions, include: Determining parameter difference information between a first function and a second function, where the first function is a function to be obtained; Adjusting the parameters of the second function according to the determined parameter difference information to obtain the first function; The first function includes more than one, which is used to represent the operation performed when the source data is filled into the first cell; the second function includes one that has been written into the second cell, which is used to represent the operation performed when the source data is filled into the second cell; the parameter difference information includes: difference information corresponding to constants, and the constants are parameters in the second function; The method of determining the parameter difference information between the first function and the second function includes: obtaining the difference items and difference values ​​of the position information of the source data of the first function and the second function through a preset interaction window, wherein the preset interaction window is used to add new parameter difference information when multiple parameter difference information are included; and determining the parameter difference information based on the obtained difference items and difference values ​​of the position information of the source data of the first function and the second function.

2. The method according to claim 1, It is characterized in that The parameter difference information also includes one or any combination of the following: The difference information corresponding to the number of the table where the source data of the function operation is located, the difference information corresponding to the row number of the data row where the source data of the function operation is located, and the difference information corresponding to the column number of the data column where the source data of the function operation is located.

3. The method according to claim 1 or 2, It is characterized in that The determining of parameter difference information between the first function and the second function includes: For two or more of the second functions, determining parameter difference information between the second functions and position difference information between the second cells written by the second functions; Establishing a correspondence between the obtained parameter difference information between the second functions and the position difference information between the second cells written by the second functions; respectively determining position difference information of a first cell to be written by the first function and any selected second cell; The parameter difference information between the first function and the second function is obtained according to the established corresponding relationship and the position difference information between the first cell to be written by the first function and any selected second cell.

4. The method according to claim 1 or 2, It is characterized in that After obtaining the first function, the method further includes: The first functions obtained are filled into corresponding first cells respectively.

5. A computer storage medium, wherein a computer program is stored in the computer storage medium, and when the computer program is executed by a processor, the method for adjusting a cell function as described in any one of claims 1 to 4 is implemented.

6. A terminal, include: A memory and a processor, wherein the memory stores a computer program; wherein, The processor is configured to execute the computer program in the memory; When the computer program is executed by the processor, the method for adjusting a cell function as described in any one of claims 1 to 4 is implemented.

7. A device for adjusting the function of a cell, include: Determine the unit and adjust the unit; where, The determining unit is used to: determine parameter difference information between a first function and a second function, where the first function is a function to be obtained; The adjustment unit is used to: adjust the parameters of the second function according to the determined parameter difference information to obtain the first function; The first function includes more than one, which is used to represent the operation performed when the source data is filled into the first cell; the second function includes one that has been written into the second cell, which is used to represent the operation performed when the source data is filled into the second cell; the parameter difference information includes: difference information corresponding to constants, and the constants are parameters in the second function; The determination unit includes a first determination module, which is used to: obtain difference items and difference values ​​of location information of source data of the first function and the second function through a preset interaction window, and the preset interaction window is used to add new parameter difference information when multiple parameter difference information are included; determine the parameter difference information based on the obtained difference items and difference values ​​of location information of source data of the first function and the second function.

8. The device according to claim 7, It is characterized in that The determination unit further includes a second determination module; wherein, The second determination module is used to: for two or more of the second functions, determine the parameter difference information between the second functions and the position difference information between the second cells written by the second functions; establish a correspondence between the obtained parameter difference information between the second functions and the position difference information between the second cells written by the second functions; respectively determine the position difference information between the first cell to be written by the first function and any selected second cell; and obtain the parameter difference information between the first function and the second function based on the established correspondence and the position difference information between the first cell to be written by the first function and any selected second cell.

9. The device according to claim 7 or 8, It is characterized in that The device also includes a filling unit, which is used to fill the obtained first functions into corresponding first cells respectively.

Images