Spreadsheet processing method and apparatus, electronic device, and storage medium

Abstract

The present application relates to a kind of processing method, device, electronic equipment and storage medium of electronic form, the method comprises: for the first cell in electronic form, receive the first instruction of first cell, wherein each next level cell of first cell is adjacent with first cell, and located in the first set direction of cell;According to first instruction, obtain the cell response area associated with first cell;Receive the second instruction of any target cell in cell response area;According to second instruction, the linkage processing is carried out to target cell and each level cell under the jurisdiction of target cell, to adjust the data display of the electronic form.This embodiment is based on the up-down level relationship between cell, the linkage processing is carried out to target cell and each level cell under the jurisdiction of target cell, can provide convenience for the modification of data in electronic form for user, improve user experience.

Description

TECHNICAL FIELD

[0001] Embodiments of the present application relate to the technical field of data processing, and more particularly, to a processing method and device of a spreadsheet, an electronic device, and a storage medium. BACKGROUND

[0002] In daily work and life, users are used to recording data by using a spreadsheet. For the data recorded in the spreadsheet, the user can modify it as needed. In the related art, the modification of the data mainly includes manually deleting, adding, and other modification operations on each piece of data to be modified. Taking the deletion of part of the cells in the spreadsheet as an example, after the part of the cells is deleted, the framework of the data of the spreadsheet can be changed, so that the user needs to adjust the data obtained after the deletion.

[0003] It can be seen that the current modification of the data in the spreadsheet is time-consuming and laborious, and the operation is redundant, and the user experience is poor. SUMMARY

[0004] Embodiments of the present application provide a processing method and device of a spreadsheet, an electronic device, and a storage medium, which can provide convenience for the user to modify the data in the spreadsheet and improve the user experience.

[0005] According to a first aspect of the present application, a processing method of a spreadsheet is provided, including: receiving a first instruction for a first cell in the spreadsheet, wherein each next level cell of the first cell is adjacent to the first cell and located in a first set direction of the first cell; obtaining a cell response area associated with the first cell according to the first instruction; receiving a second instruction for any target cell in the cell response area; and performing linkage processing on the target cell and each level cell subordinate to the target cell according to the second instruction to adjust the data display of the spreadsheet.

[0006] Optionally, the linkage processing on the target cell and each level cell subordinate to the target cell according to the second instruction to adjust the data display of the spreadsheet includes: determining a cell relationship framework of the spreadsheet, obtaining an architecture node of the target cell and all architecture sub-nodes subordinate to the architecture node according to the cell relationship framework; synchronously adjusting a child cell corresponding to each architecture sub-node and the target cell according to the second instruction; and updating a display interface of the data of the spreadsheet by synchronously adjusting the child cell and the target cell.

[0007] Optionally, the determining the cell relationship framework of the electronic table comprises: determining attribute information of data of the first cell and an identifier corresponding to the first cell; dividing data of cells with same path and belonging to same origin data into a same-origin framework node set according to the attribute information of data of the first cell and the identifier; dividing adjacent framework nodes in the same-origin framework node set into a same-group framework node set; determining a subordinate relationship between a framework node and a framework sub-node in the same-group framework node set according to the identifier of the first cell; and determining the cell relationship framework of the electronic table according to the same-origin framework node set, the same-group framework node set, and the subordinate relationship.

[0008] Optionally, the determining the subordinate relationship between the framework node and the framework sub-node in the same-group framework node set according to the identifier of the first cell comprises: determining a serial number of the first cell in the first set direction according to the identifier of the first cell; determining a node level of the first cell according to the serial number of the first cell in the first set direction, wherein the node level of the first cell is lower than a node level of an upper-level cell of the first cell; sorting and storing the framework node corresponding to the first cell according to the node level of the first cell; and determining the subordinate relationship between the framework node and the framework sub-node in the same-group framework node set according to the sorting and storing result.

[0009] Optionally, after the determining the cell relationship framework of the electronic table, the method further comprises: displaying the cell relationship framework in response to a display instruction of the cell relationship framework; adjusting the cell relationship framework by performing linkage adjustment on a third cell and each level cell subordinate to the third cell in response to an adjustment instruction of the third cell in the cell relationship framework; and adjusting data display of the electronic table according to the adjusted cell relationship framework.

[0010] Optionally, the acquiring the cell response region associated with the first cell according to the first instruction comprises: acquiring an instruction type of the first instruction; and acquiring the cell response region associated with the first cell according to the instruction type.

[0011] Optionally, the acquiring the cell response region associated with the first cell according to the instruction type comprises: in a case where the instruction type is a first set type, acquiring a next-level cell of the first cell; and acquiring the cell response region associated with the first cell according to the next-level cell of the first cell, wherein the cell response region comprises the next-level cell of the first cell.

[0012] Optionally, before the acquiring the cell response area associated with the first cell, the method further comprises: for a cell set consisting of each lower level cell of the first cell, detecting whether the cell set is aligned with the first cell in a second set direction, the second set direction being perpendicular to the first set direction; and in the case that the cell set is aligned with the first cell in the second set direction, performing the step of acquiring the cell response area associated with the first cell.

[0013] Optionally, the method further comprises: in the case that the cell set is not aligned with the first cell in the second set direction, performing a first operation to align the cell set with the first cell in the second set direction; and after the first operation is performed, performing the step of acquiring the cell response area associated with the first cell.

[0014] Optionally, the acquiring the cell response area associated with the first cell according to the instruction type comprises: in the case that the instruction type is a second set type, acquiring a second cell, wherein the second cell is a higher level cell of the first cell, and the second cell has no upper level cell; and taking the second cell as the cell response area associated with the first cell.

[0015] Optionally, the second instruction comprises any one of the following instructions: an instruction of adjusting the order of the target cell and each level cell subordinate to the target cell, an instruction of adding a same level cell of the target cell, an instruction of adding a lower level cell of the target cell, and an instruction of deleting the target cell and each level cell subordinate to the target cell.

[0016] According to a second aspect of the present application, there is further provided a processing device of an electronic table, comprising: a first receiving module configured to receive a first instruction for a first cell in the electronic table, wherein each lower level cell of the first cell is adjacent to the first cell and located in a first set direction of the first cell; an acquiring module configured to acquire a cell response area associated with the first cell according to the first instruction; a second receiving module configured to receive a second instruction for any target cell in the cell response area; and a processing module configured to perform a linkage processing on the target cell and each level cell subordinate to the target cell according to the second instruction, so as to adjust the data display of the electronic table.

[0017] According to a third aspect of the present application, there is also provided an electronic device comprising a memory for storing a computer program; and a processor for executing the computer program to implement the method according to the first aspect of the present application.

[0018] According to a fourth aspect of the present application, there is also provided a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the method according to the first aspect of the present application.

[0019] According to an embodiment of the present application, for a first cell in an electronic spreadsheet, a first instruction to the first cell is received, wherein each next level cell of the first cell is adjacent to the first cell and is in a first set direction of the cells; a cell response area associated with the first cell is obtained according to the first instruction; a second instruction to any target cell in the cell response area is received; and the target cell and each level cell subordinate to the target cell are processed in linkage according to the second instruction to adjust the data display of the electronic spreadsheet. This embodiment processes the target cell and each level cell subordinate to the target cell in linkage based on the superior-inferior relationship between the cells, so that the target cell and each level cell subordinate to the target cell can be deleted, adjusted, etc. in synchronization at one time, thereby increasing the convenience of the user in adjusting the data in the electronic spreadsheet, providing convenience for the user in modifying the data in the electronic spreadsheet, and improving the user experience.

[0020] Other features of the embodiments of the present application, and their advantages, will become apparent from the following detailed description of exemplary embodiments of the present application, with reference to the drawings. BRIEF DESCRIPTION OF DRAWINGS

[0021] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments of the application and, together with the description, serve to explain the principles of the embodiments of the application.

[0022] Figure 1 is a flowchart of a processing method of an electronic spreadsheet according to an embodiment;

[0023] Figure 2 is a schematic diagram of an electronic spreadsheet according to an embodiment;

[0024] Figure 3 is a schematic diagram of another electronic spreadsheet according to an embodiment;

[0025] Figure 4 is a flowchart of a processing method of another electronic spreadsheet according to an embodiment;

[0026] Figure 5is a schematic diagram of still another electronic table according to an embodiment;

[0027] Figure 6 is a flowchart of a processing method of an electronic table according to an embodiment;

[0028] Figure 7 is a block schematic diagram of a processing apparatus of an electronic table according to an embodiment;

[0029] Figure 8 is a schematic diagram of a hardware structure of an electronic device according to an embodiment. DETAILED DESCRIPTION

[0030] Various exemplary embodiments of the present application will now be described in detail with reference to the accompanying drawings. It should be noted that the relative arrangement of the components and steps set forth in the embodiments, numerical expressions, and numerical values set forth in the embodiments are not limiting of the scope of the present application unless otherwise specifically stated.

[0031] The following description of at least one exemplary embodiment is merely exemplary in nature and is in no way intended to limit the scope of the application its application or uses.

[0032] Techniques, methods, and apparatus known to those of ordinary skill in the relevant art can not be discussed in detail herein. However, where appropriate, such techniques, methods, and apparatus can be considered as part of the description of the present application.

[0033] In all of the examples shown and discussed herein, any specific values should be interpreted as merely exemplary and not as a limitation. Thus, other examples of the exemplary embodiments can have different values.

[0034] It should be noted that like reference numerals and letters in the various figures indicate similar items, and thus, once an item is defined in one figure, it is not necessary to discuss it further in subsequent figures.

[0035] Hereinafter, various embodiments and examples according to the present application will be described with reference to the accompanying drawings.

[0036] <Method Embodiment>

[0037] Figure 1 is a flowchart of a processing method of an electronic table according to an embodiment.

[0038] As Figure 1 shown, the processing method of the electronic table of the present embodiment can include the following steps S110-S140:

[0039] In step S110, a first instruction for a first cell in the electronic table is received, wherein each next-level cell of the first cell is adjacent to the first cell and located in a first set direction of the first cell.

[0040] The electronic table in the embodiment can be an electronic table on a PC (Personal Computer) or an electronic table on the Web (World Wide Web). The electronic table can be an electronic table in an electronic table software or an electronic table in a word processor application.

[0041] The first cell in the embodiment is any cell in the electronic table in which data is input. The cell can be an independent cell or a merged cell formed by merging at least two independent cells. Any cell in this paragraph and throughout the entire specification.

[0042] In the embodiment, the first cell has at least one next-level cell. The first cell and the next-level cell of the first cell have a relationship that the first cell is a parent cell (a high-level cell) and the next-level cell of the first cell is a child cell (a low-level cell). The next-level cells of the first cell have a relationship that they are sibling cells (peer cells). Each next-level cell of the first cell is adjacent to the first cell and located in a first set direction of the first cell.

[0043] In an embodiment of the disclosure, the first set direction can be any direction based on the first cell corresponding to left, right, up, or down. In this way, in the electronic table, the next-level cell of the first cell can be located on the left side, right side, upper side, or lower side of the first cell.

[0044] It should be noted that, based on pointing left from the first cell, the spreadsheet displayed on the client's screen is viewed horizontally from the first cell towards the left edge of the client device, assuming the display is recognizable to the naked eye at eye level and displays data correctly and accurately. Similarly, pointing right from the first cell, the spreadsheet is viewed horizontally from the first cell towards the right edge of the client device, assuming the display is recognizable to the naked eye at eye level and displays data correctly and accurately. Pointing upwards from the first cell, the spreadsheet is viewed horizontally from the first cell towards the top edge of the client device, assuming the display is recognizable to the naked eye at eye level and displays data correctly and accurately. Pointing downwards from the first cell, the spreadsheet is viewed horizontally from the first cell towards the bottom edge of the client device, assuming the display is recognizable to the naked eye at eye level and displays data correctly and accurately.

[0045] Preferably, the first set direction is the rightward direction corresponding to the first cell.

[0046] Taking the first set direction as the rightward direction corresponding to the first cell as an example, such as Figure 2 As shown, Figure 2 This shows a portion of a spreadsheet (primarily the portion of the spreadsheet containing non-empty cells). Specifically, a cell is considered non-empty if it contains content, such as visible characters or a formula.

[0047] like Figure 3 As shown, this embodiment also provides a feasible specific example of a spreadsheet. For example... Figure 2 As shown, the next level cell after the first cell is adjacent to the first cell and located to the right of the first cell. Please refer to this example. Figure 2 For example, the cell with data "a" is a merged cell. This cell can be the first cell, and there are three cells below it: the merged cell with data "a1", the merged cell with data "a2", and the merged cell with data "a3". These three cells are the next level cells of the cell with data "a".

[0048] Two adjacent cells can be defined as cells sharing a common cell edge, which can be the top, bottom, left, or right side of the cell.

[0049] For example, the cell with data "b11" is a merged cell, and the next level cells of the cell with data "b11" are two, which are a cell with data "b111" and a cell with data "b112".

[0050] As shown in Figure 3 the cell with data "East China" is a merged cell, and the next level cells of the cell with data "East China" are three, which are a cell with data "Jiangxi", a cell with data "Shanghai" and a cell with data "Jiangsu".

[0051] For example, the cell with data "Jiangsu" is a merged cell, and the next level cells of the cell with data "Jiangsu" are two, which are a cell with data "Office supplies-10001876" and a cell with data "Furniture-chair-10004416".

[0052] As shown in Figure 2 and Figure 3 It can be seen that based on the row label and the column label of the cell, the superior-inferior relationship between the cells in the spreadsheet can be determined, which will not be described one by one in this embodiment.

[0053] In detail, for the spreadsheet displayed on the device with a touch screen, the user can realize the triggering operation on any cell by the way of touch.

[0054] In detail, for the spreadsheet displayed on the device without a touch screen, the user can realize the triggering operation on any cell by the way of controlling the mouse.

[0055] In this embodiment, when the user performs a triggering operation such as clicking on the first cell, the device can correspondingly receive a first instruction for the first cell. After receiving the first instruction, the following step S120 can be performed. The first instruction is an instruction for obtaining a cell response region, which is externally input by the user.

[0056] Step S120: obtaining a cell response region associated with the first cell according to the first instruction.

[0057] In this step, the device obtains a cell response region associated with the first cell triggered by the user in response to the received first instruction. The cell response region includes at least one cell. The cell response region can be a collection of cells associated with the first cell triggered by the user.

[0058] In detail, the device can detect the data organization mode beside the first cell according to the first instruction, such as detecting the next level cells of the first cell, and obtaining the corresponding cell response region based on the detection result.

[0059] In one embodiment of the present disclosure, referring to Figure 4 At step S120, according to the first instruction, the cell response region associated with the first cell is obtained, which can include the following steps S1201-S1202:

[0060] At step S1201, the instruction type of the first instruction is obtained.

[0061] In detail, the instruction type of the first instruction can be distinguished by different triggering modes. Different instruction types can correspond to different determination modes of the cell response region.

[0062] Feasibly, the instruction type of the first instruction can have two types. For example, when the user clicks the first cell, the instruction type of the first instruction is a first set type, and when the user clicks the first cell and continues for a set duration (such as 1s, 2s, etc.) or more, the instruction type of the first instruction is a second set type.

[0063] At step S1202, the cell response region associated with the first cell is obtained according to the instruction type.

[0064] In this step, after the instruction type is determined, the cell response region of the first cell is obtained according to the instruction type.

[0065] Considering that the first cell usually has both upper and lower cells, the cell response region of the first cell can be determined according to the lower cell, or the cell response region of the first cell can be determined according to the upper cell.

[0066] Based on this, in order to illustrate a possible implementation mode of determining the cell response region according to the lower cell, at step S1202, the cell response region associated with the first cell is obtained according to the instruction type, which can include the following steps:

[0067] In the case where the instruction type is the first set type, the next level cell of the first cell is obtained; and the cell response region associated with the first cell is obtained according to the next level cell of the first cell, wherein the cell response region includes the next level cell of the first cell.

[0068] In this embodiment, if the instruction type is the first set type, the next level cell of the first cell can be obtained. Further, the cell response region including the obtained next level cell can be obtained.

[0069] In one embodiment of the present disclosure, if the instruction type is the first set type, the cell response region associated with the first cell can be composed of the next level cell of the first cell.

[0070] For example, referring toFigure 2 For example, if the user clicks the merged cell with data "a", the cell response region of the merged cell with data "a" can be composed of the three merged cells with data "a1", "a2", and "a3" respectively.

[0071] For example, if the user clicks the merged cell with data "a2", the cell response region of the merged cell with data "a2" can be composed of the two merged cells with data "a21" and "a22" respectively. In addition, if the user clicks the merged cell with data "b1", the cell response region of the merged cell with data "b1" can be composed of the merged cell with data "b11".

[0072] For example, if the user clicks the merged cell with data "East China", the cell response region of the merged cell with data "East China" can be composed of the three merged cells with data "Jiangxi", "Shanghai", and "Jiangsu" respectively. Figure 3

[0073] In addition, if the user clicks the merged cell with data "Jiangsu", the cell response region of the merged cell with data "Jiangsu" can be composed of the two independent cells with data "Office supplies-10001876" and "Furniture-chair-10004416" respectively.

[0074] In the embodiment, the user triggers the first cell, and the next level cell of the first cell can be used as the cell response region, so that the user can subsequently process any next level cell of the first cell and the cells at all levels subordinate to the next level cell.

[0075] In addition, in other embodiments of the present disclosure, when the instruction type is the first set type, the cell response region of the first cell can include each level cell subordinate to the first cell in addition to the next level cell of the first cell, so that the user can subsequently process any cell subordinate to the first cell and the cells at all levels subordinate to the cell.

[0076] Generally, a cell can have only one upper level cell, so that when the cell is operated, the cells at all levels subordinate to the cell can be accurately operated and will not affect other cells.

[0077] The first set type is to set the cell response region to be located in the subordinate region of the first cell.

[0078] Based on this, in an embodiment of the present disclosure, before the cell response region associated with the first cell is obtained, the method can further include the following steps:​

[0079] For the cell set composed of each lower-level cell of the first cell, it is detected whether the cell set is aligned with the first cell in a second set direction, the second set direction being perpendicular to the first set direction; in the case that the cell set is aligned with the first cell in the second set direction, the step of obtaining the cell response area associated with the first cell is performed.

[0080] In the case that the cell set is aligned with the first cell in the second set direction, each cell in the cell set can have the same row index or column index.

[0081] In the case that the two directions are perpendicular, the included angle between the two directions is a right angle.

[0082] It should be noted that, in the embodiment, the first set direction and the second set direction are adopted, wherein the first set direction can be rightward based on the first cell in the horizontal direction, and the corresponding second set direction can be upward or downward based on the first cell in the vertical direction; or the first set direction can be downward based on the first cell in the vertical direction, and the corresponding second direction can be leftward or rightward based on the first cell in the horizontal direction. The horizontal direction refers to the direction of the data displayed on the display interface of the client, and the horizontal direction is parallel to the horizontal ground based on the display interface that can be recognized by the naked eye when the user looks straight and the normal and accurate display of the data. The vertical direction refers to the direction of the data displayed on the display interface of the client, and the vertical direction is perpendicular to the vertical ground based on the display interface that can be recognized by the naked eye when the user looks straight and the normal and accurate display of the data.

[0083] In the embodiment, it is required that the first cell and the lower-level cell thereof generally have a normal corresponding effect. For example, in the case that the first cell is located on the left side of the lower-level cell thereof, the number of rows corresponding to the first cell includes the number of rows corresponding to the lower-level cell thereof.

[0084] Please refer to Figure 3 , Figure 3 A schematic diagram of a spreadsheet is shown, and the first set direction is the direction corresponding to the right of the first cell. If the user clicks the merged cell with the data "East China", the row index corresponding to the merged cell is 2-7, that is, the number of rows corresponding to the merged cell is the 2nd row to the 7th row, and the lower-level cell of the merged cell is the three merged cells with the data "Jiangxi", "Shanghai" and "Jiangsu". The row index corresponding to the three merged cells is also 2-7, that is, the number of rows corresponding to the three merged cells is also the 2nd row to the 7th row. In this way, it can be considered that the merged cell with the data "East China" and the lower-level cell thereof are aligned in the second set direction.

[0085] It can be seen that the first cell corresponds to the same row label as the entire set of lower-level cells of the first cell, and thus has a standard cell row alignment effect.

[0086] Please refer to Figure 5 If the user clicks the merged cell with data "m", the row label corresponding to the merged cell with data "m" is 2-10, and the lower-level cells include the merged cell with data "m1" and the merged cell with data "m6". However, the row label corresponding to the merged cell with data "m1" is 1-2, and the merged cell with data "m" does not correspond to row label 1. In this way, the two are not aligned in the second set direction. In addition, the row label corresponding to the merged cell with data "m6" is 9-11, and the merged cell with data "m" does not correspond to row label 11. In this way, the two are also not aligned in the second set direction.

[0087] It can be seen that the first cell corresponds to the same row label as the entire set of lower-level cells of the first cell, and thus has a standard cell row alignment effect.

[0088] In this embodiment, in the case where the first cell and its lower-level cells (i.e. the cell set) are not aligned in the second set direction, the subsequent step of obtaining the cell response area can not be performed, and a warning can be given, such as displaying corresponding reminder information on the user interface of the device, so that the user can quickly and accurately understand the abnormality and solve the abnormality.

[0089] Based on this alignment detection operation, the corresponding relationship between the cell currently operated by the user and its lower-level cells can be detected to avoid subsequent operation of the cell that is not aligned with the upper-level cell, resulting in unsuccessful operation or disorder of associated data in the electronic form.

[0090] For example, please refer to Figure 5 If the user clicks the merged cell with data "m", the row label corresponding to the merged cell with data "m" is 2-10, and the lower-level cells include the merged cell with data "m1" and the merged cell with data "m6". However, the row label corresponding to the merged cell with data "m1" is 1-2, and the merged cell with data "m" does not correspond to row label 1. In this way, the two are not aligned in the second set direction. In addition, the row label corresponding to the merged cell with data "m6" is 9-11, and the merged cell with data "m" does not correspond to row label 11. In this way, the two are also not aligned in the second set direction.

[0091] Based on the above, in another embodiment of the present disclosure, the method further comprises: in the case that the cell set is not aligned with the first cell in the second set direction, performing a first operation to align the cell set with the first cell in the second set direction; after the first operation is completed, performing the step of obtaining the cell response area associated with the first cell.

[0092] In the embodiment, in the case that the first cell and its next level cell are not aligned in the second set direction, the cell set is considered to be irregular, and therefore, an irregular conversion process can be performed first to automatically convert the irregular cell into a regular one to meet the alignment requirement, and then subsequent operations are performed. As shown in FIG. 6, since the merged cell with data “m1” is irregular, an automatic splitting process can be performed on the cell to split the cell into two cells arranged in an up-down manner, and the data of the two cells is “m1”. The cell split out on the lower side can belong to a separate cell with data “m1”, and the cell split out on the upper side can belong to another separate cell. Figure 5

[0093] The first operation refers to adjusting the irregular cell to align the cell set with the first cell in the second set direction, for example, performing a splitting process on the irregular cell.

[0094] Generally, a next level cell of a cell can have at least one, and when there are multiple next level cells, the multiple next level cells are arranged in the first set direction. In this way, when any next level cell is operated, the cells under it can be accurately operated together.

[0095] Based on this, in one embodiment of the present disclosure, before obtaining the cell response area associated with the first cell, the method can further comprise the following steps:

[0096] For the cell set composed of the next level cells of the first cell, it is detected whether the cell set is arranged in the first set direction; in the case that the cell set is arranged in the first set direction, the step of obtaining the cell response area associated with the first cell is performed.

[0097] In the embodiment, the next level cells of the first cell generally have a standard corresponding effect. For example, in the case that the first cell is located on the left side of its next level cells, the column numbers corresponding to the next level cells of the first cell are the same.

[0098] Please refer to Figure 2 , Figure 2 ​A schematic diagram of an electronic table is shown, and the first set direction is a right direction corresponding to the first cell. If a user clicks a merged cell with data "a", the next level cell thereof is three cells with data "a1", "a2" and "a3" respectively, and the column labels of the three cells are all "B", i.e. the column numbers corresponding to the three cells are all the Bth column. In this way, the merged cell with data "a" and the next level cell thereof are aligned in the first set direction.

[0099] It can be seen that, since the column labels corresponding to the next level cells of the first cell are the same, the cell column alignment effect is standard.

[0100] Please refer to Figure 5 If a user clicks a merged cell with data "m", the next level cell thereof is six cells with data "m1" to "m6" respectively. However, among the six cells, the cell with data "m4" has column labels "B" and "C", i.e. corresponds to the Bth column and the Cth column, while the column labels of the other five cells are all "B", i.e. all correspond to the Bth column, and none correspond to the Cth column. In this way, the next level cells of the merged cell with data "m4" are not aligned in the first set direction.

[0101] It can be seen that, since the column labels corresponding to the next level cells of the first cell are not the same, the corresponding effect is not standard.

[0102] In this embodiment, in the case where the next level cells of the first cell are not aligned in the first set direction, the subsequent step of obtaining a cell response area can not be performed, and a warning can be given, such as displaying corresponding warning information on the user interface of the device, so that the user can quickly and accurately understand the abnormality and solve the abnormality.

[0103] Based on this alignment detection operation, the corresponding relationship between the next level cells of the cell currently operated by the user can be detected, so as to avoid the user's subsequent operation on a cell that is not aligned with a sibling cell, which leads to unsuccessful operation or disorder of associated data in the electronic table.

[0104] For example, if a user clicks the cell with data "m4", without the above alignment detection operation, the cell with row label 6 and column label B (denoted as cell B6) can be used as the cell response area of the cell with data "m4". If the user subsequently triggers the cell B6 and issues a request to move the cell B6 to a sibling cell (such as a cell with data "m3") of the cell with data "m4", the system will either determine that the cell B6 cannot be moved, or the cell B6 will be moved to cause disorder of associated data, such as a change in the correspondence between the cell B6 and the column number, which will not conform to the original correspondence defined by the electronic table.

[0105] Furthermore, to illustrate a possible implementation of determining the cell response area based on the subordinate cell, step S1202, obtaining the cell response area associated with the first cell according to the instruction type, may include the following steps:

[0106] When the instruction type is the second set type, the second cell is obtained, wherein the second cell is the parent cell of the first cell and the second cell has no parent cell; the second cell is used as the cell response area associated with the first cell.

[0107] In detail, the instruction type can be attribute information of the instruction, used to distinguish the purpose of the instruction, etc. In this embodiment, there can be two instruction types, such as the two preset instruction types referred to as the first setting type and the second setting type. The second setting type sets the cell response area to be located in the parent area of ​​the first cell.

[0108] In this embodiment, if the instruction type is the second preset type, the top-level cell of the first cell can be obtained. Then, the cell response area including the top-level cell can be obtained.

[0109] like Figure 2 The spreadsheet shown contains three top-level cells with data "a", "b", and "c" respectively. For example, if the first cell is any cell under the cell with data "a", then the second cell mentioned above is the cell with data "a".

[0110] In one embodiment of this disclosure, if the instruction type is a second set type, the cell response area associated with the first cell can be composed of the second cell corresponding to the first cell.

[0111] In this embodiment, when a user triggers the first cell, the topmost cell of the first cell can be used as the cell response area. That is, no matter which cell under the topmost cell the user triggers, the system can quickly locate the topmost cell, so that the user can process the topmost cell and all the cells under the topmost cell together.

[0112] Furthermore, in other embodiments of this disclosure, when the instruction type is the second set type, the cell response area of ​​the first cell may include not only the top-level cell of the first cell, but also each level of cells under the top-level cell, so that the user can subsequently process any cell under the top-level cell and all levels of cells under that cell together.

[0113] In addition, in order to facilitate the user to perform on-demand operation on any cell in the cell response area, the cell response area can be highlighted.

[0114] Thus, in one embodiment of the present disclosure, after the cell response area associated with the first cell is acquired, the method can further include highlighting the cell response area in the spreadsheet.

[0115] For example, referring to Figure 2 , if the user clicks the cell with data "a", it can be determined that the corresponding cell response area can be composed of three cells adjacent to the right of the cell with data "a" in the vertical direction, and thus the three cells can be highlighted by setting the background color, or the border line of the cell response area is highlighted by setting the color, or the data in the above three cells is displayed in bold, or the data in the above three cells is displayed in italics, or the data in the above three cells is displayed in flashing, or the above various display modes are combined for display, etc. As shown in Figure 2 , the border line of the cell response area is highlighted (which can also be displayed by setting the color, such as red).

[0116] By highlighting the cell response area, the user can quickly locate the cell to be operated, and quickly and accurately perform on-demand operation on the cell in the cell response area, which provides a good user experience.

[0117] In addition to highlighting the cell response area, the operable data range can also be highlighted. Based on this, in one embodiment of the present disclosure, after the cell response area associated with the first cell is acquired, the method can further include:

[0118] Acquiring each non-empty cell subordinate to each cell in the cell response area; determining data boundary indication information corresponding to the cell response area according to each non-empty cell; and displaying the data boundary indication information.

[0119] In this embodiment, when any cell in the cell response area is processed, the subordinate cells at all levels of the cell are also processed, and the user can only perceive the processing of the non-empty cells. Therefore, in order to facilitate the user to quickly know the data range involved, each non-empty cell subordinate to any cell in the cell response area can be acquired, and the specific data boundary of the data range can be determined accordingly.

[0120] For example, referring to Figure 2As shown in the spreadsheet, the first setting direction is a direction corresponding to the right of the first cell, and thus the right boundary of the data range can be determined to obtain the corresponding data boundary indication information. For example, the data boundary indication information can include the rows from the 2nd row to the 8th row and the right of the E column.

[0121] Further, the data boundary indication information can be displayed, such as Figure 2 As shown, the data boundary position indicated by the data boundary indication information can be highlighted by double lines (and can also be displayed by setting a color, such as red). In this way, after the user clicks the cell with the data "a", the user can see that the operable data range is the data between the cell with the data "a" and the double lines, which provides convenience for the user to view and confirm the operable data range.

[0122] After the cell response area is obtained, the following step S130 can be performed.

[0123] In step S130, a second instruction for any target cell in the cell response area is received.

[0124] The target cell is any cell in the cell response area.

[0125] The second instruction is an instruction input by an external user, for example, for linkage processing of the target cell and each level cell subordinate to the target cell.

[0126] In detail, the user can operate any cell in the cell response area, and the device can correspondingly receive the second instruction.

[0127] In an embodiment of the present disclosure, the second instruction includes any one of an instruction for adjusting the order of the target cell and each level cell subordinate to the target cell, an instruction for adding a same level cell of the target cell, an instruction for adding a next level cell of the target cell, and an instruction for deleting the target cell and each level cell subordinate to the target cell.

[0128] In detail, the user can issue the corresponding second instruction by dragging, clicking, or the like.

[0129] Based on this, in an embodiment of the present disclosure, in step S130, receiving the second instruction for any target cell in the cell response area can include receiving the second instruction input by an external drag operation on any target cell in the cell response area.

[0130] In this embodiment, the user can drag the target cell by a mouse or touch, etc. to issue the corresponding second instruction. Based on the linkage drag processing of the target cell and the cell set of each level cell under the target cell, the position exchange between the cell set and the corresponding other cell set can be realized without involving the occlusion of the data in the cell.

[0131] For example, referring to Figure 2 , the user can perform the operation of dragging the cell with data "a3" and dragging it between the cell with data "a1" and the cell with data "a2" to issue the instruction of adjusting the order of the cell with data "a3", which is specifically defined as exchanging the positions of the two sibling cells of the cell with data "a3" and the cell with data "a2", and the linkage effect of each level cell under the two cells is correspondingly generated. In this way, the label of the row number of the cell set of the cell with data "a3" and each level cell under the cell is changed from 7-8 to 4-5, and correspondingly, the label of the row number of the cell set of the cell with data "a2" and each level cell under the cell is changed from 4-6 to 6-8.

[0132] For another example, the user can also drag the cell with data "a3" and drag it between the cell with data "b1" and the cell with data "b2" to issue the instruction of adjusting the order of the cell with data "a3" in order to adjust the cell with data "a3" to the next level cell of the cell with data "b".

[0133] In addition, in one embodiment of the present disclosure, referring to Figure 6 , before receiving the second instruction on any target cell in the cell response area in step S130, the method can further include the following steps a1-a2:

[0134] Step a1, receiving a third instruction on any target cell in the cell response area.

[0135] In detail, the user can place the mouse pointer on the target cell to issue the third instruction of requesting to display the floating pop-up window. In addition, the user can also right-click the target cell to issue the third instruction of requesting to display the fixed pop-up window. Alternatively, the user can long press the target cell by touch to issue the third instruction of requesting to display the pop-up window.

[0136] Step a2, displaying the pop-up window including at least one instruction item according to the third instruction.

[0137] Based on the third instruction received in step a1, the device can correspondingly control the appearance of a floating pop-up window in the vicinity of the target cell to support the user to trigger any instruction item in the floating pop-up window, or correspondingly control the appearance of a fixed pop-up window in the vicinity of the target cell to support the user to trigger any instruction item in the fixed pop-up window.

[0138] In detail, the pop-up window can display corresponding instruction items for adjusting the order of the cells, deleting the cells, and adding new cells (such as adding a next-level cell or a sibling cell).

[0139] Based on the above, in step S130, receiving the second instruction for any target cell in the cell response area can include receiving the second instruction corresponding to any instruction item.

[0140] After the user triggers any instruction item, the device can correspondingly receive the corresponding second instruction.

[0141] Based on the above, the present embodiment supports the user to select any desired way to issue the second instruction, and supports the user to flexibly operate the cells.

[0142] After receiving the second instruction, the following step S140 can be performed.

[0143] In step S140, according to the second instruction, the target cell and each level of cell subordinate to the target cell are processed in linkage to adjust the data display of the electronic spreadsheet.

[0144] In the present embodiment, the target cell and each level of cell subordinate to the target cell are processed in linkage, that is, the target cell is processed in synchronization, and the device can simultaneously perform the same processing on each level of cell subordinate to the target cell. For example, the target cell and each level of cell subordinate to the target cell can be deleted or adjusted in synchronization at one time, so as to increase the convenience of the user to adjust the data in the electronic spreadsheet, provide convenience for the user to modify the data in the electronic spreadsheet, and improve the user experience.

[0145] The data of the electronic spreadsheet is the character content in the electronic spreadsheet for displaying to the user.

[0146] Taking deletion as an example, when the second instruction requires deleting the target cell, the target cell and each level of cell subordinate to the target cell can be deleted.

[0147] For example, Figure 2In the embodiment, when the target cell is the cell with data "a3", the cells with data "a3", "a31", "a32", "a311", "a321", and "a3211" can be deleted together, i.e., the 7th row and the 8th row cells are deleted. In this way, the next level cells of the cell with data "a" are the cell with data "a1" and the cell with data "a2". Correspondingly, the device can also control the corresponding row numbers of the cell with data "a" to change to the 2nd row to the 6th row, and the cells in the 9th row and the following rows are all correspondingly moved up by two rows.

[0148] The response area refers to a cell adjacent to the first cell and located in the first set direction of the first cell.

[0149] In an embodiment of the present disclosure, before the target cell and the cells at each level under the target cell are processed, it can be detected whether any of the cells at each level under the target cell is aligned with the target cell in the second set direction. If the cells are aligned, the processing is continued. If the cells are not aligned, the processing is not performed and the user is reminded. In this way, the processing can avoid affecting other cells.

[0150] Since the target cell and the cells at each level under the target cell are processed together, such as being dragged together and deleted, it is not necessary to detect whether any of the cells at each level under the target cell is aligned with the corresponding cell at the upper level in the second set direction. Therefore, the data processing pressure of the device can be relatively reduced, and the expected processing effect can also be achieved.

[0151] According to the embodiments of the present disclosure, for a first cell in an electronic spreadsheet, a first instruction for the first cell is received, wherein each next level cell of the first cell is adjacent to the first cell and located in a first set direction of the cell. According to the first instruction, a cell response area associated with the first cell is obtained. A second instruction for any target cell in the cell response area is received. According to the second instruction, a linkage processing is performed on the target cell and each level cell under the target cell to adjust the data display of the electronic spreadsheet. In the embodiment, based on the upper and lower level relationship between the cells, the linkage processing is performed on the target cell and each level cell under the target cell. Therefore, the target cell and each level cell under the target cell can be synchronously deleted or adjusted at one time, so as to increase the convenience of the user in adjusting the data in the electronic spreadsheet, provide convenience for the user in modifying the data in the electronic spreadsheet, and improve the user experience.

[0152] In one embodiment of the present disclosure, according to the second instruction, the target cell and each level cell subordinate to the target cell are processed in linkage to adjust the data display of the electronic spreadsheet, including: determining a cell relationship framework of the electronic spreadsheet, obtaining an architecture node of the target cell and all architecture sub-nodes subordinate to the architecture node according to the cell relationship framework; synchronously adjusting the target cell and the sub-level cell corresponding to each architecture sub-node according to the second instruction; and updating the display interface of the data of the electronic spreadsheet by synchronously adjusting the target cell and the sub-level cell.

[0153] In detail, the cell relationship framework can include architecture nodes corresponding to the cells and the connection relationship between the architecture nodes. The cell and the corresponding architecture node are in one-to-one correspondence. For an architecture sub-node in the cell relationship framework, the cell corresponding to the architecture sub-node can be considered as a subordinate cell, i.e., the cell has a higher level cell.

[0154] In detail, the adjustment operation can be a deletion operation or a position change operation.

[0155] In detail, the display interface can be a control interface contacted when the display device is adjusted.

[0156] In detail, the above linkage processing can be implemented in combination with the cell relationship framework. For example, for the cell shown in FIG. 1, the cell with data "a" has a row label of 2-8 and a column label of A, i.e., the cell corresponds to the 2nd-8th row of the A column of the electronic spreadsheet. Based on the label of the cell, the cell relationship framework of the electronic spreadsheet can be determined. Figure 2

[0157] In detail, each cell in the electronic spreadsheet corresponds to an architecture node in the cell relationship framework. The association relationship between the architecture nodes is consistent with the association relationship between the corresponding cells in the electronic spreadsheet.

[0158] For example, when the cell x is a higher level cell of the cell y, the architecture node corresponding to the cell x is the parent node of the architecture node corresponding to the cell y, and the two are in a parent-child relationship. With respect to the architecture node corresponding to the cell x, the architecture node corresponding to the cell y is the corresponding architecture sub-node.

[0159] In this way, the synchronous adjustment of the target cell and each level cell subordinate to the target cell can be implemented according to the cell relationship framework and the corresponding relationship between the architecture nodes and the cells.

[0160] In this embodiment, the corresponding display interface is displayed based on the adjusted cell relationship framework, so that the user can intuitively view the linkage adjustment effect.

[0161] ​Based on the above, in one embodiment of the present disclosure, the cell relationship framework of the electronic spreadsheet is determined, including: determining attribute information of data of a first cell and an identifier corresponding to the first cell; dividing data of cells with the same path and belonging to the same origin data into a same-origin framework node set according to the attribute information of the data of the first cell and the identifier; dividing adjacent framework nodes in the same-origin framework node set into a same-group framework node set; determining the subordinate relationship between the framework nodes and the framework sub-nodes in the same-group framework node set according to the identifier of the first cell; and determining the cell relationship framework of the electronic spreadsheet according to the same-origin framework node set, the same-group framework node set, and the subordinate relationship.

[0162] In detail, the attribute information of the data of the cell can be a title to which the cell belongs / corresponds.

[0163] In detail, the identifier of the cell can be a label of the cell, such as a row label and a column label of the cell. The label can be a character used to distinguish a cell row or a cell column.

[0164] The serial number can be a sequentially arranged numerical value.

[0165] In detail, for the same path, it can be considered that the mutually adjacent cells are on the same path along the direction formed by the multiple titles.

[0166] In detail, the origin data is data in a cell without a higher-level cell, such as data of a merged cell.

[0167] In this embodiment, the same-origin framework node set and the same-group framework node set can be divided in combination with the attribute information and the identifier of the data of the cell. Then, the relationship between the framework nodes in the same-group framework node set can be obtained according to the identifier of the cell.

[0168] For example, referring to Figure 3 , the framework node corresponding to the cell with the data of "East China" and the framework node corresponding to the cell with the data of "Jiangxi" have a parent-child relationship; the framework node corresponding to the cell with the data of "East China" and the framework node corresponding to the cell with the data of "Office Use-Label-10002541" have a parent-grandchild relationship.

[0169] In this embodiment, the division of the set can be implemented in combination with the label of the cell, so that the data of each cell belonging to the same cell is divided into a large set, and the data of any cell and its next-level cell is divided into a small set based on the superior-inferior relationship between the cells. That is, the nesting relationship of the set is consistent with the superior-inferior relationship of the corresponding cells.

[0170] For example,Figure 2 The data of the cells in the 2nd to 8th rows and the A to E columns of the illustrated spreadsheet is a large set, which in turn comprises several small sets, such as a set a with data "a", "a1", "a2", "a3", and another set a1 with data "a1", "a11", "a12". The set a further comprises the set a1.

[0171] The present embodiment embodies the superior-inferior relationship between cells through sets, and combines the nesting relationship between the sets, so that the expected linkage adjustment effect can be achieved by adjusting the sets in the cell relationship framework.

[0172] In an embodiment of the present disclosure, according to the identifier of the first cell, the subordinate relationship between the framework nodes and the framework sub-nodes in the same set of framework nodes is determined, including: for the first cell, according to the label of the first cell, determining the serial number of the first cell in the first set direction; according to the serial number of the first cell in the first set direction, determining the node level of the first cell, wherein the node level of the first cell is lower than the node level of the upper level cell of the first cell; according to the node level of the first cell, sorting and storing the framework node corresponding to the first cell; according to the sorting and storage result, determining the subordinate relationship between the framework nodes and the framework sub-nodes in the same set of framework nodes.

[0173] In detail, as Figure 2 Taking the right direction based on the first cell as an example, the serial number in the right direction is the column serial number. Taking the cell with data "a" as an example, the serial number in the right direction is A, so the node level of the cell can be the highest level, such as level one. Taking the cell with data "a1" as an example, the serial number in the right direction is B, so the node level of the cell can be level two. Taking the cell with data "a11" as an example, the serial number in the right direction is C, so the node level of the cell can be level three. The nodes corresponding to the three cells are parent node, child node and grandchild node in turn.

[0174] Based on the above, the node level of each cell in the spreadsheet can be determined. After determining the node level of each cell, the superior-inferior relationship between cells can be combined to construct a cell relationship framework, and the relationship framework is used to reflect the superior-inferior relationship between the corresponding cells. In this way, by adjusting the node position in the cell relationship framework, the linkage adjustment of the corresponding cells can be realized.

[0175] In one embodiment of the present disclosure, after determining the cell relationship framework of the spreadsheet, the method further comprises: in response to a display instruction of the cell relationship framework, displaying the cell relationship framework; in response to an adjustment instruction of a third cell in the cell relationship framework, adjusting the cell relationship framework by performing linkage adjustment on the third cell and each level cell subordinate to the third cell; and adjusting the data display of the spreadsheet according to the adjusted cell relationship framework.

[0176] In the present embodiment, the user can request to display the cell relationship framework, such as displaying the cell relationship framework in a new interface (such as a pop-up window) so that the user can directly adjust the cell relationship framework. The display interface of the spreadsheet is updated based on the adjusted cell relationship framework, which also achieves the linkage adjustment purpose of the corresponding cells.

[0177] <Device Embodiment>

[0178] Figure 7 is a principle block diagram of a processing apparatus 700 of a spreadsheet according to one embodiment. As shown in Figure 7 the processing apparatus 700 of the spreadsheet can include a first receiving module 710, an obtaining module 720, a second receiving module 730, and a processing module 740.

[0179] The first receiving module 710 is configured to receive a first instruction for a first cell in a spreadsheet, wherein each next level cell of the first cell is adjacent to the first cell and located in a first set direction of the first cell. The obtaining module 720 is configured to obtain a cell response area associated with the first cell according to the first instruction. The second receiving module 730 is configured to receive a second instruction for any target cell in the cell response area. The processing module 740 is configured to perform linkage processing on the target cell and each level cell subordinate to the target cell according to the second instruction, so as to adjust the data display of the spreadsheet.

[0180] According to the embodiments of the present application, a first instruction for a first cell in a spreadsheet is received, wherein each next level cell of the first cell is adjacent to the first cell and located in a first set direction of the first cell. A cell response area associated with the first cell is obtained according to the first instruction. A second instruction for any target cell in the cell response area is received. Linkage processing is performed on the target cell and each level cell subordinate to the target cell according to the second instruction, so as to adjust the data display of the spreadsheet. In the present embodiment, the target cell and each level cell subordinate to the target cell are processed in linkage based on the superior-inferior relationship between the cells, which provides convenience for the user to modify the data in the spreadsheet and improves the user experience.

[0181] In an embodiment of the present disclosure, the processing module 740 is configured to determine a cell relationship framework of the electronic form, acquire a framework node of a target cell according to the cell relationship framework, and acquire all framework sub-nodes belonging to the framework node; synchronize and adjust the target cell and a sub-level cell corresponding to each framework sub-node according to the second instruction; and update a display interface of data of the electronic form by synchronously adjusting the target cell and the sub-level cell.

[0182] In an embodiment of the present disclosure, the processing module 740 is configured to determine attribute information of data of a first cell and an identifier corresponding to each first cell; divide data of cells with the same path and belonging to the same origin data into a same-origin framework node set according to the attribute information of data of the first cell and the identifier; divide adjacent framework nodes in the same-origin framework node set into a same-group framework node set; determine a subordination relationship between a framework node and a framework sub-node in the same-group framework node set according to the identifier of the first cell; and determine a cell relationship framework of the electronic form according to the same-origin framework node set, the same-group framework node set, and the subordination relationship.

[0183] In an embodiment of the present disclosure, the processing module 740 is configured to, for a first cell, determine a serial number of the first cell in a first set direction according to a label of the first cell; determine a node level of the first cell according to the serial number of the first cell in the first set direction, wherein the node level of the first cell is lower than a node level of an upper-level cell of the first cell; sort and store a framework node corresponding to the first cell according to the node level of the first cell; and determine a subordination relationship between the framework node and a framework sub-node in the same-group framework node set according to a sorting storage result.

[0184] In an embodiment of the present disclosure, the apparatus further includes a response module. The response module is configured to display the cell relationship framework in response to a display instruction of the cell relationship framework. The processing module 740 is configured to, in response to an adjustment instruction of a third cell in the cell relationship framework, adjust the cell relationship framework by performing linkage adjustment on the third cell and each level cell belonging to the third cell; and adjust a data display of the electronic form according to the adjusted cell relationship framework.

[0185] In an embodiment of the present disclosure, the acquisition module 720 is configured to acquire an instruction type of the first instruction; and acquire a cell response area associated with the first cell according to the instruction type.

[0186] In an embodiment of the present disclosure, the acquisition module 720 is configured to, in a case where the instruction type is the first set type, acquire a next-level cell of the first cell; and acquire a cell response region associated with the first cell according to the next-level cell of the first cell, wherein the cell response region comprises the next-level cell of the first cell.

[0187] In an embodiment of the present disclosure, the acquisition module 720 is configured to, for a cell set composed of each next-level cell of the first cell, detect whether the cell set is aligned with the first cell in a second set direction, the second set direction being perpendicular to the first set direction; and in a case where the cell set is aligned with the first cell in the second set direction, perform the step of acquiring the cell response region associated with the first cell.

[0188] In an embodiment of the present disclosure, the acquisition module 720 is configured to, in a case where the cell set is not aligned with the first cell in the second set direction, perform a first operation to align the cell set with the first cell in the second set direction; and after the first operation is completed, perform the step of acquiring the cell response region associated with the first cell.

[0189] In an embodiment of the present disclosure, the acquisition module 720 is configured to, in a case where the instruction type is the second set type, acquire a second cell, wherein the second cell is a super-level cell of the first cell, and the second cell has no next-level cell; and take the second cell as the cell response region associated with the first cell.

[0190] In an embodiment of the present disclosure, the second instruction comprises any one of the following instructions: an instruction for adjusting the order of the target cell and each level cell subordinate to the target cell, an instruction for adding a same-level cell of the target cell, an instruction for adding a next-level cell of the target cell, and an instruction for deleting the target cell and each level cell subordinate to the target cell.

[0191] Figure 8 is a hardware structure schematic diagram of an electronic device according to another embodiment.

[0192] As shown in Figure 8 , the electronic device 800 comprises a processor 810 and a memory 820 for storing an executable computer program, and the processor 810 is configured to execute the method of any method embodiment as described above according to the control of the computer program.

[0193] The electronic device 800 can be a personal computer (Personal Computer, English abbreviation: PC).

[0194] The modules of the electronic device 800 above can be implemented by the processor 810 executing computer programs stored in the memory 820 in the embodiment, or can be implemented by other circuit structures, which are not limited here.

[0195] The present application can be a system, a method, and / or a computer program product. The computer program product can include a computer readable storage medium (or media) having computer readable program instructions thereon for causing a processor to carry out aspects of the present application.

[0196] The computer readable storage medium can be a tangible device that can retain and store instructions for use by an instruction execution device. The computer readable storage medium can be, for example, but is not limited to, an electronic storage device, a magnetic storage device, an optical storage device, an electromagnetic storage device, a semiconductor storage device, or any suitable combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium include the following: 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), a static random access memory (SRAM), a portable compact disc read-only memory (CD-ROM), a digital versatile disk (DVD), a memory stick, a floppy disk, a mechanically encoded device such as punch-cards or punched tape, a magnetically encoded device such as magnetic strip cards, an optically encoded device such as a compact disc (CD) or DVD, and / or any suitable combination of the foregoing. A computer readable storage medium, as used herein, is not to be construed as being transitory signals per se, such as radio waves or other freely propagating electromagnetic waves, electromagnetic waves propagating through a waveguide or other transmission media (e.g., light pulses passing through a fiber-optic cable), or electrical signals transmitted through a wire.

[0197] Computer readable program instructions described herein can be downloaded to respective computing / processing devices from a computer readable storage medium or to an external computer or external storage device via a network, for example, the Internet, a local area network, a wide area network and / or a wireless network. The network can comprise copper transmission cables, optical transmission fibers, wireless transmission, routers, firewalls, switches, gateway computers and / or edge servers. A network adapter card or network interface in each computing / processing device receives computer readable program instructions from the network and forwards the computer readable program instructions for storage in a computer readable storage medium within the respective computing / processing device.

[0198] Computer readable program instructions for carrying out operations of the present application can be assembler instructions, instruction-set-architecture (ISA) instructions, machine instructions, machine dependent instructions, microcode, firmware instructions, state-setting data, or either source code or object code written in any combination of one or more programming languages, including an object oriented programming language such as Smalltalk, C++ or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The computer readable program instructions can execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the latter scenario, 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 the connection can be made to an external computer (for example, through the Internet using an Internet Service Provider). In some embodiments, electronic circuitry including, for example, programmable logic circuitry, field-programmable gate array (FPGA), or programmable logic array (PLA) can execute the computer readable program instructions by utilizing state information of the computer readable program instructions to personalize the electronic circuitry, in order to perform aspects of the present application.

[0199] The computer readable program instructions can also be loaded onto a computer, other programmable data processing apparatus, or other device to cause a series of operational steps to be performed on the computer, other programmable apparatus or other device to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide processes for implementing the functions / acts specified in the flowchart and / or block diagram block or blocks.

[0200] These computer readable program instructions can be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions / acts specified in the flowchart and / or block diagram block or blocks. These computer readable program instructions can also be stored in a computer readable storage medium that can include random access memory (RAM), read only memory (ROM), electrically erasable programmable read only memory (EEPROM), flash memory or other data storage device. When the computer readable program instructions are loaded into the computer and other programmable data processing apparatus, a series of operational steps are implemented that provide processes such that the computer or other programmable apparatus provide processes for implementing the functions / acts specified in the flowchart and / or block diagram block or blocks.

[0201] The computer readable program instructions can also be loaded onto a computer, other programmable data processing apparatus, or other device to cause a series of operational steps to be performed on the computer, other programmable data processing apparatus or other device to produce a computer implemented process such that the instructions which execute on the computer, other programmable data processing apparatus, or other device implement the functions / acts specified in the flowchart and / or block diagram block or blocks.

[0202] The flow diagrams and the block diagrams in the drawings are meant as possible implementations of a system, method, or computer program product according to the application. It should be noted that each block of the flow diagrams and / or block diagrams and combinations thereof can be implemented by hardware that performs the specified functions or acts, or combinations of hardware and computer program product(s). For instance, the functions can be performed by one or more operatively activated processors (e.g., CPUs, ASICs, FPGAs, etc.). Each block can also represent a portion of a computer program product that includes one or more computer program instructions (e.g., a logical expression) that embody some or all of the described functionality, or a portion thereof. The computer program instructions can be written in any of various languages, scripting languages, or programming languages, including C, C++, Java, Visual Basic, etc. The computer program instructions can be compiled or interpreted as desired. Each block can also represent a logical expression, a logical expression, or a portion thereof.

[0203] Embodiments of the application have been described above, and the description is intended to be illustrative of the embodiments of the application and not exhaustive. Numerous modifications and adaptations thereof will be apparent to those skilled in the art without departing from the scope and spirit of the described embodiments. The scope of the application is defined by the appended claims.

Claims

1. A processing method of an electronic spreadsheet, characterized by, The application relates to a method for adjusting data display of an electronic table. The method comprises the following steps: For a first cell in the electronic table, a first instruction for the first cell is received, wherein each next-level cell of the first cell is adjacent to the first cell and is located in a first set direction of the first cell; the next-level cell of the first cell is a cell adjacent to the first cell and located in the first set direction of the first cell; wherein two cells are adjacent if the two cells have a common cell edge; According to the first instruction, a cell response area associated with the first cell is obtained; A second instruction for any target cell in the cell response area is received; According to the second instruction, the same kind of linkage processing is performed on the target cell and each level cell subordinate to the target cell to adjust the data display of the electronic table; The second instruction comprises an instruction for adjusting the order of the target cell and each level cell subordinate to the target cell; or an instruction for deleting the target cell and each level cell subordinate to the target cell; 2. The method of claim 1, wherein, According to the first instruction, the cell response area associated with the first cell is obtained, which comprises the following steps: obtaining the instruction type of the first instruction; according to the instruction type, the cell response area associated with the first cell is obtained, wherein the instruction type comprises at least one of a first set type and a second set type, the first set type is to set the cell response area in the subordinate area of the first cell, and the second set type is to set the cell response area in the superior area of the first cell. According to the second instruction, the same kind of linkage processing is performed on the target cell and each level cell subordinate to the target cell to adjust the data display of the electronic table, which comprises the following steps: The cell relationship architecture of the electronic table is determined, the architecture node of the target cell and all architecture sub-nodes subordinate to the architecture node are obtained according to the cell relationship architecture; According to the second instruction, the sub-level cell corresponding to each architecture sub-node and the target cell are synchronously adjusted; 3. The method of claim 2, wherein, Through synchronous adjustment of the sub-level cell and the target cell, the display interface of the data of the electronic table is updated. The cell relationship architecture of the electronic table is determined, which comprises the following steps: The attribute information of the data of the first cell and the identifier corresponding to the first cell are determined; According to the attribute information of the data of the first cell and the identifier, the data of the cells with the same path and subordinate to the same original data are divided into a same-origin architecture node set; The adjacent architecture nodes in the same-origin architecture node set are divided into a same-group architecture node set; According to the identifier of the first cell, the subordinate relationship between the architecture nodes and the architecture sub-nodes in the same-group architecture node set is determined; 4. The method of claim 3, wherein, According to the same-origin architecture node set, the same-group architecture node set and the subordinate relationship, the cell relationship architecture of the electronic table is determined. According to the identifier of the first cell, the subordinate relationship between the architecture nodes and the architecture sub-nodes in the same-group architecture node set is determined, which comprises the following steps: For the first cell, the serial number of the first cell in the first set direction is determined according to the label of the first cell; determine a node level of the first cell according to a serial number of the first cell in the first set direction, wherein the node level of the first cell is lower than a node level of a parent cell of the first cell; store the framework nodes corresponding to the first cell in sequence according to the node level of the first cell; determine a subordination relationship between the framework nodes and the framework sub-nodes in the same group of framework node set according to the storage result.

5. The method of claim 2, wherein, After the cell relationship framework of the electronic spreadsheet is determined, the method further comprises: display the cell relationship framework in response to a display instruction of the cell relationship framework; adjust the cell relationship framework by linkage adjustment on the third cell and each level cell subordinate to the third cell in response to an adjustment instruction of the third cell in the cell relationship framework; and adjust the data display of the electronic spreadsheet according to the adjusted cell relationship framework.

6. The method of claim 1, wherein, The method further comprises: in a case where the instruction type is the first set type, obtain a next level cell of the first cell; obtain the cell response area associated with the first cell according to the next level cell of the first cell, wherein the cell response area comprises the next level cell of the first cell.

7. The method of claim 1, wherein, Before the cell response area associated with the first cell is obtained, the method further comprises: for a cell set composed of the next level cells of the first cell, detect whether the cell set is aligned with the first cell in a second set direction, wherein the second set direction is perpendicular to the first set direction; in a case where the cell set is aligned with the first cell in the second set direction, perform the step of obtaining the cell response area associated with the first cell.

8. The method of claim 7, wherein, The method further comprises: in a case where the cell set is not aligned with the first cell in the second set direction, perform a first operation to align the cell set with the first cell in the second set direction; after the first operation is completed, perform the step of obtaining the cell response area associated with the first cell.

9. The method of claim 1, wherein, The method further comprises: in a case where the instruction type is the second set type, obtain a second cell, wherein the second cell is a parent cell of the first cell and has no next level cell; and take the second cell as the cell response area associated with the first cell.

10. An electronic spreadsheet processing device, characterized by The method further comprises: a first receiving module configured to, for a first cell in an electronic spreadsheet, receive a first instruction for the first cell, wherein each next level cell of the first cell is adjacent to the first cell and located in a first set direction of the first cell; the next level cell of the first cell is a cell adjacent to the first cell and located in the first set direction of the first cell; and two cells are adjacent if they have a common cell edge; an obtaining module configured to, according to the first instruction, obtain a cell response area associated with the first cell; and a displaying module configured to display the cell response area associated with the first cell. The second receiving module is configured to receive a second instruction for any target cell in the cell response area; The processing module is configured to perform the same linkage processing on the target cell and each level cell subordinate to the target cell according to the second instruction, so as to adjust the data display of the electronic form; wherein the second instruction comprises: an instruction for adjusting the order of the target cell and each level cell subordinate to the target cell; or an instruction for deleting the target cell and each level cell subordinate to the target cell. According to the first instruction, the cell response area associated with the first cell is obtained, comprising: obtaining the instruction type of the first instruction; and according to the instruction type, obtaining the cell response area associated with the first cell, wherein the instruction type comprises at least one of a first setting type and a second setting type, the first setting type is to set the cell response area to be located in the subordinate area of the first cell, and the second setting type is to set the cell response area to be located in the superior area of the first cell.

11. An electronic device comprising a memory and a processor, the memory for storing a computer program, characterized in that, The processor is configured to execute the computer program to implement the method according to any one of claims 1-9.

12. A computer-readable storage medium having stored thereon a computer program, characterized in that The computer program, when executed by the processor, implements the method according to any one of claims 1-9.

Images