CN111783406A

CN111783406A - Table data operation method and device

Info

Publication number: CN111783406A
Application number: CN201910967360.1A
Authority: CN
Inventors: 李玥; 袁宇航; 杨苇苇; 周洪涛; 马远超
Original assignee: Beijing Jingdong Century Trading Co Ltd; Beijing Wodong Tianjun Information Technology Co Ltd
Current assignee: Beijing Jingdong Tuoxian Technology Co Ltd
Priority date: 2019-10-12
Filing date: 2019-10-12
Publication date: 2020-10-16

Abstract

The table data operation method and device provided by the embodiment of the disclosure firstly present a splitting control in a quantity type cell of a table, then present a splitting dialog box including initial splitting data in response to receiving a selection operation of the splitting control, the initial splitting data is a splitting result corresponding to data in the quantity type cell, then split the quantity type cell according to the quantity of the initial splitting data when receiving a determination operation of a user on the initial splitting data, split the initial splitting data into the split quantity type cell, present data in the split quantity type cell and the split quantity type cell in the table after the final splitting operation is completed, split the data in the quantity type cell through an interactive operation with the splitting control without re-inputting the data by the user, the error probability of user input is reduced, the data is rapidly split, and the data processing efficiency is improved.

Description

Table data operation method and device

Technical Field

The embodiment of the disclosure relates to the technical field of computers, the technical field of internet and the field of data processing, in particular to a table data operation method and device.

Background

The ERP system is an operation mode of modern enterprise management, is a highly integrated system applied in the whole company range, covers management work of clients, projects, inventory and purchasing, supply, production and the like, and achieves the maximum resource benefit by optimizing enterprise resources. The ERP system provides a large number of data reports, and users need to process the reports according to different conditions.

Sometimes, the data contents in the tables are mostly consistent, but the contents of some cells are different, when operations such as splitting or merging of data of a certain cell in the tables are required, the existing method generally rebuilds a row or a column, processes the data in the cell to be operated, re-inputs the processed data into the cell, re-inputs the data in other cells as original values, and keeps the contents of other cells in a new row or a new column unchanged after the operations.

Disclosure of Invention

The embodiment of the disclosure provides a table data operation method and device.

In a first aspect, an embodiment of the present disclosure provides a table data operation method, where the method includes: presenting a split control within a numeric cell of a table; in response to receiving a selection operation of a splitting control, presenting a splitting dialog box, wherein the splitting dialog box comprises initial splitting data; in response to receiving the determination operation on the initial split data, splitting the number type cells according to the number of the initial split data, and splitting the initial split data into the split number type cells respectively; the split number cells and the data in the split number cells are presented in a table.

In some embodiments, the split dialog box further comprises: an adjustment option to the initial split data; the method further comprises the following steps: in response to receiving an adjustment operation for an adjustment option of the initial split data, presenting the adjusted split data; and in response to receiving the determined operation on the adjusted split data, splitting the quantity type cells according to the number of the adjusted split data, and splitting the adjusted split data into the split quantity type cells respectively.

In some embodiments, the adjustment option for the initial split data is to present an input box for the initial split data; and in response to receiving an adjustment operation to an adjustment option of the initial split data, presenting the adjusted split data comprises: in response to receiving an adjustment operation on initial split data in an input box, judging whether the adjusted split data accords with a first check rule; and presenting the adjusted split data in response to determining that the adjusted split data conforms to the first check rule.

In some embodiments, in response to receiving an adjustment operation on preset split data, presenting the adjusted split data, further includes: and in response to determining that the adjusted split data does not conform to the first check rule, controlling the input box to present a preset color and presenting error prompt information.

In some embodiments, the adjustment option for the initial split data is an adjust button for the initial split data; and in response to receiving an adjustment operation to an adjustment option of the initial split data, presenting the adjusted split data comprises: and in response to receiving the clicking operation of the adjusting button, presenting the determined splitting data after the adjusting button is clicked.

In some embodiments, the adjustment option for the initial split data is to present an adjustment slider for the initial split data; and in response to receiving an adjustment operation to an adjustment option of the initial split data, presenting the adjusted split data comprises: in response to receiving a dragging operation on the adjusting slider, displaying split data determined by the dragged slider; and the dragging operation of the slider accords with a second check rule.

In some embodiments, the split dialog box further comprises: determining options and closing options; the determining operation includes: clicking the determined option and/or clicking an area outside the splitting dialog box; and the method further comprises: and closing the splitting dialog box in response to receiving the click operation on the closing option.

In some embodiments, the split control is a line split control; in response to receiving a determination operation on the initial split data, splitting the quantitative cells according to the quantity of the initial split data, and splitting the initial split data into the split quantitative cells respectively comprises: in response to receiving a determination operation on initial split data, splitting a row where the quantity type cells are located according to the quantity of the initial split data to obtain split rows, splitting the initial split data into the split quantity type cells in each split row respectively, and copying data in other cells except the quantity type cells in the row where the quantity type cells are located into the split other cells in each split row; and presenting the split number cells and the data of the split number cells in a table includes: data in split rows that include the split number cells and split rows that include data in the split number cells are presented in a table.

In some embodiments, the split control is a column split control; in response to receiving a determination operation on the initial split data, splitting the quantitative cells according to the quantity of the initial split data, and splitting the initial split data into the split quantitative cells respectively comprises: in response to receiving a determination operation on initial split data, splitting columns of the quantity type cells according to the quantity of the initial split data to obtain split columns, splitting the initial split data into the split quantity type cells in each split column respectively, and copying data in other cells except the quantity type cells in the columns of the quantity type cells to the split other cells in each split row; presenting the split number cells and the data in the split number cells in a table includes: data in split columns including the split number cells and split columns including data in the split number cells are presented in a table.

In a second aspect, an embodiment of the present disclosure provides a table data operation method, including: presenting a merge control within the table; responding to the received selection operation of more than two rows or columns and the click operation of the merging control, and judging whether the data in the selected rows or columns meet merging conditions or not, wherein the merging conditions are as follows: the selected row or column at least has a column or row of unit cells which are quantity type unit cells, and the data in other columns or rows with the same number except the column or row where the quantity type unit cells are located in the selected row or column are the same; in response to determining that the data in the selected row or column satisfies the merge condition, merging the selected row or column using: merging the selected rows or columns to obtain merged parallel or merged columns; merging the sum of data in the columns or the number type cells of the rows with the same number in each row or column into merged number type cells of columns or rows with the same number in a merged row or merged column; copying data in other cells of the columns or rows with the same numbers except the digital cells in each row or column to the merged other cells of the columns or rows with the same numbers in the merged row or merged column; presenting in the table a merged row or merged column comprising the merged number cells and presenting in the table the data in the merged row or merged column comprising the data in the merged number cells.

In a third aspect, an embodiment of the present disclosure provides a table data operation apparatus, including: a first display unit configured to present a split control within a numeric cell of a table; in response to receiving a selection operation of a splitting control, presenting a splitting dialog box, wherein the splitting dialog box comprises initial splitting data; a splitting unit configured to split the number cells according to the number of the initial split data and split the initial split data into the split number cells, respectively, in response to receiving a determination operation on the initial split data; the first display unit is further configured to present the split number type cell and the data in the split number type cell in a table.

In some embodiments, the split dialog box further comprises: an adjustment option to the initial split data; a first display unit, further configured to present adjusted splitting data in response to receiving an adjustment operation of an adjustment option for the initial splitting data; the splitting unit is further configured to split the quantity type cells according to the quantity of the adjusted split data and split the adjusted split data into the split quantity type cells respectively in response to receiving the determined operation of the adjusted split data.

In some embodiments, the split control is a line split control; a splitting unit further configured to: in response to receiving a determination operation on initial split data, splitting a row where the quantity type cells are located according to the quantity of the initial split data to obtain split rows, splitting the initial split data into the split quantity type cells in each split row respectively, and copying data in other cells except the quantity type cells in the row where the quantity type cells are located into the split other cells in each split row; and a first display unit further configured to: data in split rows that include the split number cells and split rows that include data in the split number cells are presented in a table.

In some embodiments, the split control is a column split control; a splitting unit further configured to: in response to receiving a determination operation on initial split data, splitting columns of the quantity type cells according to the quantity of the initial split data to obtain split columns, splitting the initial split data into the split quantity type cells in each split column respectively, and copying data in other cells except the quantity type cells in the columns of the quantity type cells to the split other cells in each split row; a first display unit further configured to: data in split columns including the split number cells and split columns including data in the split number cells are presented in a table.

In a fourth aspect, an embodiment of the present disclosure provides a table data manipulation apparatus, including: a second display unit configured to present a merge control within the table; the judging unit is configured to respond to the received selection operation on more than two rows or columns and the click operation on the merging control, and judge whether the data in the selected rows or columns meet merging conditions, wherein the merging conditions are as follows: the selected row or column at least has a column or row of unit cells which are quantity type unit cells, and the data in other columns or rows with the same number except the column or row where the quantity type unit cells are located in the selected row or column are the same; a merging unit configured to merge the selected row or column in response to determining that the data in the selected row or column satisfies a merging condition, with the following steps: merging the selected rows or columns to obtain merged parallel or merged columns; merging the sum of data in the columns or the number type cells of the rows with the same number in each row or column into merged number type cells of columns or rows with the same number in a merged row or merged column; copying data in other cells of the columns or rows with the same numbers except the digital cells in each row or column to the merged other cells of the columns or rows with the same numbers in the merged row or merged column; a second display unit configured to present in the table merged rows or merged columns including the merged number cells and present in the table merged rows or merged columns including the data in the merged number cells.

In a fifth aspect, an embodiment of the present disclosure provides an electronic device, including: one or more processors; a storage device having one or more programs stored thereon; when the one or more programs are executed by the one or more processors, the one or more processors are caused to implement the table data manipulation method as described in any of the embodiments of the first aspect or the second aspect.

In a sixth aspect, embodiments of the present disclosure provide a computer-readable medium on which a computer program is stored, the computer program, when executed by a processor, implementing a method of table data manipulation as described in any of the embodiments of the first or second aspect.

In some embodiments, the validity of the data submitted to the system by the user is judged by judging whether the adjusted split data meets the inspection rule, so that the validity of the data input by the user is ensured, illegal data is prevented from being submitted, and the accuracy and efficiency of data processing are improved.

Drawings

Other features, objects and advantages of the disclosure will become more apparent upon reading of the following detailed description of non-limiting embodiments thereof, made with reference to the accompanying drawings in which:

FIG. 1 is an exemplary system architecture diagram in which one embodiment of the present disclosure may be applied;

FIG. 2 is a flow diagram of one embodiment of a method of table data manipulation according to an embodiment of the present disclosure;

FIG. 3 is a schematic diagram of one application scenario of a table data manipulation method according to an embodiment of the present disclosure;

FIG. 4 is one specific example of an adjustment option for initial split data according to an embodiment of the present disclosure;

FIG. 5 is one specific example of an adjustment option for initial split data according to an embodiment of the present disclosure;

FIG. 6 is one specific example of an adjustment option for initial split data according to an embodiment of the present disclosure;

FIG. 7 is one specific example of an adjustment option for initial split data according to an embodiment of the present disclosure;

FIG. 8 is a flow diagram of yet another embodiment of a table data manipulation method according to an embodiment of the present disclosure;

FIG. 9 is a schematic diagram of the row split result shown in FIG. 8, according to an embodiment of the present disclosure;

FIG. 10 is a flow diagram of yet another embodiment of a method of table data manipulation according to an embodiment of the present disclosure;

FIG. 11 is a flow diagram of yet another embodiment of a method of table data manipulation according to an embodiment of the present disclosure;

FIG. 12 is a graphical illustration of the merged results shown in FIG. 11 according to an embodiment of the present disclosure;

FIG. 13 is a schematic diagram of an embodiment of a table data manipulation apparatus, according to an embodiment of the present disclosure;

FIG. 14 is a schematic structural diagram of an electronic device suitable for use in implementing embodiments of the present disclosure.

Detailed Description

The present disclosure is described in further detail below with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the relevant disclosure and are not limiting of the disclosure. It should be noted that, for the convenience of description, only the parts relevant to the related disclosure are shown in the drawings.

It should be noted that, in the present disclosure, the embodiments and features of the embodiments may be combined with each other without conflict. The present disclosure will be described in detail below with reference to the accompanying drawings in conjunction with embodiments.

Fig. 1 illustrates an exemplary system architecture 100 of a table data manipulation method or table data manipulation apparatus to which embodiments of the present disclosure may be applied.

As shown in fig. 1, the system architecture 100 may include

terminal devices

104, 105, 106, a network 107,

servers

101, 102, 103 belonging to the same server cluster. The network 107 is used to provide a medium for communication links between the

terminal devices

104, 105, 106 and the

servers

101, 102, 103 belonging to the same server cluster. The network 107 may include various connection types, such as wired, wireless communication links, or fiber optic cables, among others.

A user may interact with

servers

101, 102, 103 belonging to the same server cluster via a network 107 via

terminal devices

104, 105, 106 to receive or transmit information or the like. The

end devices

104, 105, 106 may have various applications installed thereon, such as data processing applications, data analysis applications, instant messaging tools, social platform software, search-type applications, shopping-type applications, browser-type applications, and the like.

The

terminal devices

104, 105, 106 may be hardware or software. When the terminal device is hardware, it may be various electronic devices having a display screen and supporting communication with the server, including but not limited to a smart phone, a tablet computer, a laptop portable computer, a desktop computer, and the like. When the terminal device is software, the terminal device can be installed in the electronic devices listed above. It may be implemented as multiple pieces of software or software modules, or as a single piece of software or software module. And is not particularly limited herein.

The

servers

101, 102, 103 belong to the same server cluster, and may be servers providing various services, such as a background server receiving a request sent by a terminal device establishing a communication connection with the server. The background server can receive and analyze the request sent by the terminal device, and generate a processing result.

The server may be hardware or software. When the server is hardware, it may be various electronic devices that provide various services to the terminal device. When the server is software, it may be implemented as a plurality of software or software modules for providing various services to the terminal device, or may be implemented as a single software or software module for providing various services to the terminal device. And is not particularly limited herein.

It should be noted that the table data operation method provided by the embodiments of the present disclosure may be executed by the

terminal devices

104, 105, and 106. Accordingly, table data manipulation means are provided in the

terminal devices

104, 105, 106.

It should be understood that the number of terminal devices, networks, and servers in fig. 1 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.

With continued reference to FIG. 2, a flow 200 of one embodiment of a table data manipulation method according to the present disclosure is shown. The table data operation method is applied to any terminal equipment and comprises the following steps:

at step 210, a split control is presented within a numeric cell of a table.

The quantity type cell refers to a cell in which data in the cell can be split as required, and the data in the quantity type cell can be split as required to obtain a split result.

In this embodiment, the execution agent may display table data in a table, and display a split control in a number cell in the table. For example, the execution subject may display the split control in the quantity cell, may display the split control on the right side of the data of the quantity cell, and may also display the split control on the left side of the data, which is not specifically limited in this application.

In response to receiving the selection operation of the split control, a split dialog box is presented, step 220.

The splitting dialog box includes initial splitting data corresponding to data in the quantity type cell, the initial splitting data indicates a splitting result after the data in the quantity type cell is split, the initial splitting data may be splitting data preset by a user, and may be set to be half of the data in the quantity type cell, for example, the data in the quantity type cell is 10, and the initial splitting data may be set to be 5 and 5, which is not specifically limited in this application.

In this embodiment, the execution main body displays the split control to the user in the quantity type cell in the table, and the user performs a selection operation on the displayed split control, for example, the user may click the split control through a mouse, may perform a touch click operation on the split control through a touch screen, and may perform a long-time press operation on the split control, and after receiving the selection operation on the split control by the user, the execution main body may display the split dialog box in a lower right corner of the split control, where the split dialog box includes initial split data corresponding to data in the quantity type cell, for example, the data in the quantity type cell is 10, and then the initial split data may be displayed to the user through the split dialog box as 5 and 5.

Step 230, in response to receiving the determination operation on the initial split data, splitting the quantitative cells according to the quantity of the initial split data, and splitting the initial split data into the split quantitative cells respectively.

In this step, the execution subject displays initial split data corresponding to the data of the quantity type cells to a user through a split dialog box, when a determination operation of the user on the initial split data is received, the execution subject determines the quantity of the initial split data, performs a split operation on the quantity type cells according to the quantity of the initial split data, and simultaneously splits the initial split data into the split quantity type cells respectively.

As a specific example, if the data in the quantity type cell is 10, the initial split data displayed through the split dialog box may be 5 and 5, the user performs a determination operation on the

initial split data

5 and 5, after the execution subject receives the determination operation of the user, the execution subject determines that the number of the initial split data is two, splits the quantity type cell according to the number of the initial split data, splits the quantity type cell into two, and splits the

initial split data

5 and 5 into the two split quantity type cells respectively.

At step 240, the split number cells and the data in the split number cells are presented in a table.

In this step, the executing agent performs a splitting operation on the number cells and the data in the number cells, and when the splitting operation is completed, the executing agent may present the data in the split number cells and the split number cells in the table, where the number of the split number cells is the same as the number corresponding to the initial splitting data.

As a specific example, the data in the quantity type cell is 10, the initial split data displayed through the split dialog box may be 5 and 5, the execution subject splits the quantity type cell to obtain two split quantity type cells, the execution subject presents the two split quantity type cells to the user in the table, and presents the data in the two split quantity type cells to the user as 5 and 5, respectively.

With continuing reference to fig. 3, fig. 3 is a schematic diagram of an application scenario of the table data manipulation method according to the present embodiment. In the application scenario of fig. 3, a user can see the splitting control 310 in the number type cell in the table, the terminal device receives a selection operation of the user on the splitting control 310, presents a splitting dialog box including initial splitting data to the user, splits the number type cell according to the initial splitting data and splits the initial splitting data into the split number type cells respectively in response to receiving a determination operation of the user on the initial splitting data, the terminal device displays the data in the split number type cell and the split number type cell to the user in the table after the splitting operation is completed, for example, the data in the number type cell is 10, the initial splitting data is 5 and 5, and presents the data in the two split number type cells and the split number type cell to the user in the table after the splitting operation is completed, that is, the two resulting quantity cells and the data in each split quantity cell are respectively 5, which are presented to the user in the table.

The table data operation method provided by the embodiment of the disclosure includes firstly presenting a splitting control in a quantity type cell of a table, then presenting a splitting dialog box including initial splitting data in response to receiving a selection operation of the splitting control, splitting the quantity type cell according to the quantity of the initial splitting data when a determination operation of a user on the initial splitting data is received, splitting the initial splitting data into the split quantity type cell, and finally presenting the split quantity type cell and the data in the split quantity type cell in the table after the splitting operation is completed, splitting the data in the quantity type cell through an interactive operation with the splitting control without re-inputting the data by the user, the error probability of user input is reduced, the data is rapidly split, and the data processing efficiency is improved.

In some optional implementation manners of this embodiment, the splitting dialog box may further include an adjustment option for the initial splitting data, where the adjustment option is used to receive an adjustment operation of the initial splitting data by a user, the adjustment operation for the initial splitting data may be implemented by performing an adjustment operation on the adjustment option, and the user may complete an increase or decrease of the split data in the initial splitting data by operating the adjustment option.

The table data operation method may further include the steps of:

in the first step, in response to receiving an adjustment operation for an adjustment option of the initial splitting data, the adjusted splitting data is presented.

In this step, the execution subject displays an adjustment option for the initial split data to the user through the split dialog box, the user may operate the adjustment option as needed to adjust the initial split data, and when the execution subject receives an adjustment operation for the adjustment option from the user, the execution subject displays an adjusted split data corresponding to the adjustment operation to the user according to the received adjustment operation.

And secondly, in response to the received determination operation on the adjusted split data, splitting the number type cells according to the number of the adjusted split data, and splitting the adjusted split data into the split number type cells respectively.

In this step, the executing agent presents the adjusted split data corresponding to the adjustment operation to the user, then receives a determination operation of the user on the adjusted split data, the executing agent determines the number of the adjusted split data, and finally splits the number of the number cells according to the number of the adjusted split data, the obtained number of the split number cells is the same as the number of the adjusted split data, and the adjusted split data is split into the split number cells respectively, at this time, the data in each split number cell is the adjusted split data respectively.

In the implementation mode, the adjustment options of the initial splitting data are presented to the user, and the user can adjust the initial splitting data according to needs, so that the control of the splitting result of the data in the quantity type cells is more flexible.

In some optional implementations of the present implementation, the adjustment option for the initial split data may be an input box presenting the initial split data. As a specific example, as shown in FIG. 4, the initial split data may be displayed via two input boxes.

Wherein, in response to receiving an adjustment operation for an adjustment option of the initial split data, presenting the adjusted split data may be implemented by:

the method comprises the first step of responding to received adjustment operation of initial split data in an input box, and judging whether the adjusted split data accords with a first check rule.

When the initial split data is displayed through the input box, the first verification rule may include: the split data must be greater than 0, the sum of the split data must be equal to the data in the number cells, and a single split data cannot be greater than or equal to the data in the number cells.

In this step, the execution main body may display the initial splitting data through the two input boxes, please continue to refer to fig. 4, at this time, the user may perform an adjustment operation on the pre-initial splitting data displayed in the input boxes, that is, the user may re-input new splitting data in the input boxes, and take the splitting data re-input by the user as the adjusted splitting data. After receiving the split data re-input by the user in the input box, the execution main body judges whether the re-input split data conforms to a first check rule.

And secondly, in response to determining that the adjusted split data conforms to the first check rule, presenting the adjusted split data.

In this step, after receiving the split data re-input by the user in the input box, the execution subject determines the re-input split data, and displays the adjusted split data to the user when it is determined that the adjusted split data, that is, the re-input split data, meets the first verification rule.

When it is determined that the adjusted split data, i.e. the re-input split data, does not comply with the first check rule, the following steps may be further performed: and in response to the fact that the adjusted splitting data does not accord with the first check rule, controlling the input frame to present a preset color and presenting error prompt information.

In this step, the execution subject determines that the adjusted split value does not conform to the first check rule, at this time, the execution subject controls the input box where the adjusted split value is located to display a preset color, which may be set by itself, for example, red, etc., which is not specifically limited in this application, and at the same time, the execution subject displays an error prompt message in the split dialog box to prompt the user that the re-input split data does not conform to the first check rule. For example, when the adjusted split value input by the user is greater than the data in the number cell, the execution subject may control the input box in which the adjusted split data is located to display red, and display the red in the split dialog box as "error: error indication that the numerical value cannot be larger than the original value ".

In the implementation mode, the split data is displayed to the user in the input box form, and the split data in the input box is judged, so that the legality of the data submitted to the system by the user is ensured, illegal data are prevented from being submitted, and the accuracy and the efficiency of data processing are improved.

In some optional implementations of this implementation, the adjustment option of the initial splitting data may also be an adjustment button of the initial splitting data, and the adjustment button may be disposed around the initial splitting data, such as on the right or left of the initial splitting data, or disposed in the input box, or disposed outside the input box. As yet another specific example, as shown in FIG. 5, the adjustment button may be disposed in the input box and to the right of the initial split data.

Wherein, in response to receiving an adjustment operation for an adjustment option of the initial split data, presenting the adjusted split data may be implemented by: and in response to receiving the clicking operation of the adjusting button, presenting the determined splitting data after the adjusting button is clicked.

The split data corresponding to the adjusted adjustment button can be the data in the number type cell minus 1 to the maximum, and can be 1 to the minimum.

The execution main body can display the adjusting button around the initial splitting data and can also be arranged in the input box to display, the user can realize the adjustment of the initial splitting data by clicking the adjusting button, the adjusting button can comprise an increase button and a decrease button, the user can click the increase button to increase the initial splitting data, and the user can click the decrease button to decrease the initial splitting data. For example, with continued reference to fig. 5, the adjustment button may be set in the lower input box, the adjustment button may be displayed together with the input box, or may be displayed by focusing a mouse in the input box, when the mouse focuses in the input box, the increase button and the decrease button are displayed, the user may click the increase button or the decrease button to adjust the initial splitting data, and the determined splitting data after the adjustment button is clicked is displayed in the input box.

In the implementation mode, the split data is displayed to the user in the form of the adjusting button, so that the flexibility of adjusting the split data is improved.

In some optional implementations of the present implementation, the adjustment option for the initial split data may also be an adjustment slider that presents the initial split data. As another specific example, as shown in fig. 6, the initial splitting data is displayed by the position of an adjustment slider.

Wherein, in response to receiving an adjustment operation for an adjustment option of the initial split data, presenting the adjusted split data can be further achieved by: and in response to receiving the dragging operation of the adjusting slider, presenting the split data determined by the dragged slider.

For example, please continue to refer to fig. 6, the position of the adjustment slider may display initial split data, the execution main body may receive a dragging operation of the adjustment slider by a user, and may display the split data corresponding to the position of the adjustment slider on the left side of the adjustment slider in the dragging process. The executing body receives a dragging operation of a user on the adjusting slider, determines split data corresponding to the dragged slider, and presents the split data to the user, wherein the dragging operation conforms to a second check rule, and the second check rule may include: adjusting the numerical range corresponding to the dragging position of the sliding block: the minimum is 1 and the maximum is 1 minus the data in the number cells.

In the implementation mode, the split data is displayed to the user in the form of the adjusting slider, the flexibility of adjusting the split data is improved, the user changes the split data by dragging the slider, the legality of the data submitted to the system by the user is guaranteed, illegal data are prevented from being submitted, and the accuracy and the efficiency of data processing are improved.

In some optional implementations of the present implementation, as shown in fig. 7, the adjustment option of the initial split data may also be an input box and an adjustment slider that present the initial split data.

Wherein, in response to receiving an adjustment operation for an adjustment option of the initial split data, presenting the adjusted split data can be further achieved by: and in response to receiving the dragging operation of the adjusting slider, displaying the split data determined by the dragged slider, or in response to receiving the adjusting operation of the initial split data in the input box, determining that the adjusted split data accords with a first verification rule, and displaying the adjusted split data.

At this time, the user can adjust the split data by dragging the adjustment slider, and can also input new split data in the input box. When the adjusting slider is dragged, the split data in the input box changes along with the change of the split data determined by the adjusting slider; when the user adjusts the split data of the input box, the position of the adjusting slider is changed along with the change of the split data in the input box.

In the implementation mode, the split data is displayed to the user in various forms, so that the flexibility of adjusting the split data is improved, the legality of the data submitted to the system by the user is ensured, illegal data are prevented from being submitted, and the accuracy and the efficiency of data processing are improved.

In some optional implementations of the present implementation, the split dialog box may further include a determine option and a close option.

The user can click the determination option in the splitting dialog box to determine the initial splitting data or the adjusted splitting data. And the execution main body receives the click operation of the user on the determination option and indicates that the user performs the determination operation on the initial split data or the adjusted split data.

The user can click the region outside the splitting dialog box to determine the initial splitting data or the adjusted splitting data. And the execution main body receives the clicking operation of the user on the region outside the splitting dialog box, and indicates that the user determines the operation on the initial splitting data or the adjusted splitting data.

When the user adjusts the initial split data by performing the up-and-down dragging operation on the adjusting slider, the executing main body can also determine the adjusted split data by detecting that the user stops dragging the adjusting slider. The execution subject detects that the user stops dragging operation, and indicates that the user performs determination operation on the adjusted split data.

The user can cancel the splitting operation by clicking a closing option in the splitting dialog box. And the execution main body receives the click operation of the user on the closing option, closes the splitting dialog box and terminates the splitting operation.

In the implementation mode, the user can confirm the split numerical value in various modes, and meanwhile, a closing option for canceling the operation is provided, so that the flexibility of the user operation is improved.

With further reference to fig. 8, the split control is a row split control that the execution principal displays within a numeric cell, and fig. 8 illustrates a flow 800 of yet another embodiment of a table data manipulation method. The process 800 of the table data operation method may further include the following steps:

at step 810, a row split control is presented within a numeric cell of a table.

The line splitting control is used for receiving selection operation of a user and indicating that splitting operation is performed on a line where the quantity type cells are located.

In this step, the execution body may display table data in a table, and display a row splitting control in a number cell in the table. For example, the execution subject may display the line splitting control in a number type cell, may display the line splitting control on the right side of data of the number type cell, and may also display the line splitting control on the left side of the data, which is not specifically limited in this application.

At step 820, in response to receiving a selection operation of the row split control, a split dialog box is presented.

In this step, the execution subject displays a line splitting control to a user in a quantity type cell in the table, the user performs a selection operation on the displayed line splitting control, for example, the user may click the line splitting control through a mouse, may perform a touch click operation on the line splitting control through a touch screen, and may perform a long-time pressing operation on the line splitting control, after receiving the selection operation on the line splitting control by the user, the execution subject may display the splitting dialog box in a lower right corner of the line splitting control, at this time, the splitting dialog box includes initial splitting data corresponding to data in the quantity type cell, for example, the data in the quantity type cell is 10, and then the initial splitting data may be displayed to the user through the splitting dialog box as 5 and 5.

Step 830, in response to receiving the determination operation on the initial split data, splitting the row where the number type cell is located according to the number of the initial split data to obtain split rows, splitting the initial split data into the split number type cells in each split row, and copying data in other cells except the number type cell in the row where the number type cell is located to the split other cells in each split row.

In this step, the execution subject displays initial split data corresponding to the data of the quantity type cells to a user through a split dialog box, when a determination operation of the user on the initial split data is received, the execution subject determines a line where the quantity type cells are located as a line to be split, the line where the quantity type cells are located is split according to the quantity of the initial split data to obtain split lines, the quantity of the obtained split lines is the same as that of the initial split data, and each split line comprises the split quantity type cells and other split cells. Meanwhile, the execution main body splits the initial split data determined by the user into the corresponding split quantitative cells respectively, and copies the data in other cells into the split other cells. At this time, the data in the split number type cell in each split row obtained after splitting is the initial split data, and the data in the other split cells are kept unchanged.

At step 840, the data in each split row that includes the split number cell and each split row that includes the data in the split number cell is presented in a table.

In this step, the execution body presents, in the table, the split rows including the split number cells and the split rows including the data in the split number cells. The execution main body splits a line where the quantity type cell is located into a plurality of split lines, each split line comprises the split quantity type cell and other split cells, data in each split line comprises data in the split quantity type cell and data in the split other cells, and the execution main body displays each split line to a user after the split of the line where the quantity type cell is located is completed.

As a specific example, as shown in fig. 9, if the data in the quantity type cell is 10, the initial split data displayed by the split dialog box may be 5 and 5, the user performs a determination operation on the

initial split data

5 and 5, the execution subject determines that the number of the initial split data is two, splits the row of the quantity type cell to obtain two split rows, and the execution subject splits the initial split data into the split quantity type cells respectively and copies the data in the other cells into the split other cells in each split row. When the splitting operation is completed, two split rows are displayed in the table, the data in the split number type cells are 5 and 5, and the data in the other split cells are not changed.

In the embodiment, the row of the quantity type cell is split by selecting the row splitting control to obtain the split row, the user does not need to re-input the data in other cells in the split row, the error probability of user input is reduced, the quick splitting of the row of the quantity type cell in the table is realized, and the efficiency of table data processing is improved.

With further reference to fig. 10, the split control is a column split control, and the execution subject displays the column split control in a numeric cell, fig. 10 shows a flow 1000 of yet another embodiment of a table data manipulation method. The process 1000 of the table data operation method may further include the following steps:

at step 1010, a column split control is presented within a numeric cell of a table.

The column splitting control is used for receiving selection operation of a user and indicating that splitting operation is carried out on the column where the quantity type cell is located.

In this step, the execution body may display table data in a table, and display a column splitting control in a number cell in the table. For example, the execution subject may display the column of splitting control in the number-type cell, may display the column of splitting control on the right side of the data of the number-type cell, and may also display the column of splitting control on the left side of the data, which is not specifically limited in this application.

Step 1020, in response to receiving a selection operation of the column split control, presenting a split dialog box.

In this step, the execution subject displays a column splitting control to a user in a quantity type cell in the table, the user performs a selection operation on the displayed column splitting control, for example, the user may click the column splitting control through a mouse, may perform a touch click operation on the column splitting control through a touch screen, and may perform a long-time pressing operation on the column splitting control, after receiving the selection operation on the column splitting control by the user, the execution subject may display the splitting dialog box in a lower right corner of the column splitting control, at this time, the splitting dialog box includes initial splitting data corresponding to data in the quantity type cell, for example, the data in the quantity type cell is 10, and then the initial splitting data may be displayed to the user through the splitting dialog box as 5 and 5.

Step 1030, in response to receiving the determination operation on the initial split data, splitting the column where the quantity type cell is located according to the quantity of the initial split data to obtain split columns, splitting the initial split data into the split quantity type cells in each split column, and copying data in other cells except the quantity type cell in the column where the quantity type cell is located to the split other cells in each split column.

In this step, the execution subject displays initial split data corresponding to the data of the quantity type cells to a user through a split dialog box, when a determination operation of the user on the initial split data is received, the execution subject determines the column where the quantity type cells are located as a column to be split, the column where the quantity type cells are located is split according to the quantity of the initial split data to obtain split columns, the quantity of the obtained split columns is the same as that of the initial split data, and each split column comprises the split quantity type cells and other split cells. Meanwhile, the execution main body splits the initial split data determined by the user into the corresponding split quantitative cells respectively, and copies the data in other cells into the split other cells. At this time, the data in the split number type cell in each split column obtained after splitting is the initial split data, and the data in the other split cells are kept unchanged.

Step 1040, presenting the split columns including the split number cells and the data in the split columns including the data in the split number cells in the table.

In this step, the execution body presents, in the table, the split columns including the split number cells and the data in the split columns including the data in the split number cells. The execution main body splits the column of the quantity type cell into a plurality of split columns, each split column comprises the split quantity type cell and other split cells, data in each split column comprises data in the split quantity type cell and data in other split cells, and the execution main body displays each split column to a user after splitting the column of the quantity type cell.

In the embodiment, the column in which the quantity type cell is located is split through the selection operation of the column splitting control to obtain the split column, the user does not need to re-input the data in other cells in the split column, the error probability of user entry is reduced, the rapid splitting of the column in which the quantity type cell is located in the table is realized, and the efficiency of table data processing is improved.

With further reference to FIG. 11, a flow 1100 of yet another embodiment of a table data manipulation method according to the present disclosure is shown. The table data operation method is applied to any terminal equipment and comprises the following steps:

at step 1110, a merge control is presented within the form.

In this step, the execution body may display the table data in the table, and display the merge control at a certain position in the table. For example, the execution body may display the merge control at the upper right corner of the whole table, may also display the merge control at the upper left corner of the whole table, and the like, which is not specifically limited in this application.

Step 1120, in response to receiving the selection operation on more than two rows or columns and the click operation on the merge control, determining whether the data in the selected rows or columns meet the merge condition.

The merging condition is that the selected cells with at least one column or row in each row or column are number cells, and the data in other columns or rows with the same number except the column or row where the number cells are located in each selected row or column are the same. The selected row comprises at least one column of quantity type cells which can be subjected to merging operation, and other cells in the selected row need to meet the condition that the data in the cells with the same column number are the same. The selected column comprises at least one row of quantity type cells which can carry out merging operation, and other cells in the selected column need to meet the condition that the data in the cells with the same row number are the same.

In this step, the execution main body receives a selection operation of a user on at least two rows or at least two columns in the table, at this time, the selected row or column is in a selected state, and presents the row or column in the selected state to the user, and then the execution main body receives a click operation of the user on the merge control, judges the selected row or column, and judges whether data in the selected row or column meets the merge condition. For example, a user selects two rows of cells in the table, the two rows of cells selected by the user are controlled to be in a selected state at the moment, then the user clicks the merge control, the execution main body judges data in the two rows of cells selected, it is determined that one row of quantitative cells is included in the two rows of cells selected for merging, and data in cells with the same row number in each group are respectively correspondingly the same, it is determined that the two rows of cells selected meet the merge condition.

It should be noted that the method for controlling the selected data to be in the selected state is a well-known technology widely studied and applied at present, and is not described herein again.

In response to determining that the data in the selected row or column meets the merge condition, step 1130 merges the selected row or column using the following steps: merging the selected rows or columns to obtain merged parallel or merged columns; merging the sum of data in the columns or the number type cells of the rows with the same number in each row or column into merged number type cells of columns or rows with the same number in a merged row or merged column; and copying the data in other cells of the columns or rows with the same numbers except the numerical cells in each row or column to the merged other cells of the columns or rows with the same numbers in the merged row or the merged column.

In this step, after determining that the data in the selected row or column meets the merge condition, the execution body performs a merge operation on the selected row or column.

The merging operation of the selected rows is realized based on the following steps:

in the first step, selected rows are merged to obtain a merged row.

In this step, the execution body merges the selected rows into one row, and a merged row is obtained.

And a second step of merging the sum of the data in the number type cells of the columns with the same number in each row into the merged number type cells of the columns with the same number in the merged row.

In this step, the execution body adds the data in the number cells of the columns having the same number in each selected row to obtain the sum of the data, and merges the obtained sum of the data into the merged number cells of the columns having the same number in the merged row.

And thirdly, copying data in other cells with columns with the same number except the numerical cells in each row to other merged cells with columns with the same number in the merged row.

In this step, the execution body copies the data in the other cells to the other cells merged in the merged row, that is, the data in the merged other cells with the same column number in the merged row is the same as the data in the other cells with the same column number before merging and remains unchanged.

in the first step, selected columns are merged to obtain a merged column.

In this step, the execution body merges the selected columns into one column, and a merged column is obtained.

And a second step of merging the sum of the data in the number type cells of the rows with the same number in each column into the merged number type cells of the rows with the same number in the merged column.

In this step, the execution body adds the data in the number cells of the row with the same number in each selected column to obtain the sum of the data, and merges the obtained sum of the data into the merged number cell with the same row number in the merged column.

And thirdly, copying the data in other cells with the same number of rows except the numerical cells in each column to the merged other cells with the same number of rows in the merged column.

In this step, the execution body copies the data in the other cells to the other cells merged in the merged row, that is, the data in the merged other cells with the same row number in the merged column is the same as the data in the other cells with the same row number before merging and remains unchanged.

At step 1140, a merged row or merged column comprising the merged number cells is presented in a table and data in a merged row or merged row comprising data in the merged number cells is presented in a table.

In this step, the merged row or merged column includes the merged number cell and the other merged cells, and the data in the merged row or merged row includes the data in the merged number cell and the data in the other merged cells. And after the execution main body carries out merging operation on the selected row or column, presenting the merged parallel or merged column obtained by the merging operation to a user in the table.

For example, as shown in fig. 12, a user selects two rows of cells in a table, the data in the "number" columns in the two rows of cells are different and can be merged, and the data in the other cells are respectively the same, at this time, the execution body controls the two rows of cells to be in a selected state, after the user clicks the merge control, the execution body performs a merge operation on the two rows of cells, adds the data in the "number" column in the first row and the data in the "number" column in the second row to obtain merged data, the data in the other cells are kept unchanged, the two rows of cells are merged into one row of cells, and the merged rows and the data in the merged rows are presented to the user.

In the embodiment, the merging operation of the selected row or column is completed through the interactive operation with the merging control, so that the table data is quickly merged, the entry errors of the user are reduced, and the data processing efficiency is improved.

It should be noted that, in the embodiment, the data merging method may operate on table data that meets the merging condition, or may operate on the table data obtained after the splitting. Therefore, the merging method for data in this embodiment may be executed after the splitting operation is performed, or may be executed separately, which is not specifically limited in this application.

With further reference to FIG. 13, the present disclosure provides one embodiment of a table data manipulation device as an implementation of the methods illustrated in the above figures. The embodiment of the apparatus corresponds to the embodiment of the method shown in fig. 2, and the apparatus may be specifically applied to any electronic device in a server cluster.

As shown in fig. 13, the table data operation apparatus 1300 of the present embodiment may include: a first display unit 1310 configured to present a split control within a numeric cell of a table; in response to receiving a selection operation of a splitting control, presenting a splitting dialog box, wherein the splitting dialog box comprises initial splitting data; a splitting unit 1320 configured to, in response to receiving a determination operation on the initial split data, split the quantitative cells according to the number of the initial split data, and split the initial split data into the split quantitative cells, respectively; the first display unit 1310 is further configured to present the split number cells and the data in the split number cells in a table.

In some optional implementations of this implementation, the split dialog box further includes: an adjustment option to the initial split data; a first display unit 1310 further configured to present the adjusted split data in response to receiving an adjustment operation for an adjustment option of the initial split data; the splitting unit 1320, further configured to, in response to receiving the determination operation on the adjusted split data, split the quantitative cells according to the number of the adjusted split data, and split the adjusted split data into the split quantitative cells respectively.

In some optional implementations of this implementation, the split control is a row split control; a splitting unit 1320, further configured to: in response to receiving a determination operation on initial split data, splitting a row where the quantity type cells are located according to the quantity of the initial split data to obtain split rows, splitting the initial split data into the split quantity type cells in each split row respectively, and copying data in other cells except the quantity type cells in the row where the quantity type cells are located into the split other cells in each split row; and a first display unit 1310, further configured to: data in split rows that include the split number cells and split rows that include data in the split number cells are presented in a table.

In some optional implementations of this implementation, the split control is a column split control; a splitting unit 1320, further configured to: in response to receiving a determination operation on initial split data, splitting columns of the quantity type cells according to the quantity of the initial split data to obtain split columns, splitting the initial split data into the split quantity type cells in each split column respectively, and copying data in other cells except the quantity type cells in the columns of the quantity type cells to the split other cells in each split row; a first display unit 1310, further configured to: data in split columns including the split number cells and split columns including data in the split number cells are presented in a table.

In some optional implementations of this implementation, the apparatus includes: a second display unit configured to present a merge control within the table; the judging unit is configured to respond to the received selection operation on more than two rows or columns and the click operation on the merging control, and judge whether the data in the selected rows or columns meet merging conditions, wherein the merging conditions are as follows: the selected row or column at least has a column or row of unit cells which are quantity type unit cells, and the data in other columns or rows with the same number except the column or row where the quantity type unit cells are located in the selected row or column are the same; a merging unit configured to merge the selected row or column in response to determining that the data in the selected row or column satisfies a merging condition, with the following steps: merging the selected rows or columns to obtain merged parallel or merged columns; merging the sum of data in the columns or the number type cells of the rows with the same number in each row or column into merged number type cells of columns or rows with the same number in a merged row or merged column; copying data in other cells of the columns or rows with the same numbers except the digital cells in each row or column to the merged other cells of the columns or rows with the same numbers in the merged row or merged column; a second display unit configured to present a merged row or merged column including the merged number type cell in the table, and present data in a merged row or merged row including the data in the merged number type cell in the table

The apparatus provided in the foregoing embodiment of the present disclosure presents the split control in the number type cell of the table, then presents the split dialog box including the initial split data in response to receiving the selection operation of the split control, then when receiving the determination operation of the user on the initial split data, splits the initial split data into the split number type cells according to the number of the initial split data, and finally presents the split number type cells and the data in the split number type cells in the table after the completion of the splitting operation, and splits the data in the number type cells through the interactive operation with the split control without the user re-inputting the data, the error probability of user input is reduced, the data is rapidly split, and the data processing efficiency is improved.

Referring now to fig. 14, shown is a schematic diagram of an electronic device (e.g., terminal device in fig. 1) 1400 suitable for use in implementing embodiments of the present disclosure. The terminal device in the embodiments of the present disclosure may include, but is not limited to, a mobile terminal such as a mobile phone, a notebook computer, a PAD (tablet computer), a PMP (portable multimedia player), a car terminal (e.g., car navigation terminal), and the like, and a fixed terminal such as a digital TV, a desktop computer, and the like. The terminal device shown in fig. 14 is only an example, and should not bring any limitation to the functions and the range of use of the embodiments of the present disclosure.

As shown in fig. 14, electronic device 1400 may include a processing means (e.g., central processing unit, graphics processor, etc.) 1401 that may perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)1402 or a program loaded from storage device 1408 into a Random Access Memory (RAM) 1403. In the RAM 1403, various programs and data necessary for the operation of the electronic device 1400 are also stored. The processing device 1401, the ROM 1402, and the RAM 1403 are connected to each other by a bus 1404. An input/output (I/O) interface 1405 is also connected to bus 1404.

Generally, the following devices may be connected to the I/O interface 1405: input devices 1406 including, for example, a touch screen, touch pad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; an output device 1407 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, or the like; storage devices 1408 including, for example, magnetic tape, hard disk, etc.; and a communication device 1409. The communication means 1409 may allow the electronic device 1400 to communicate wirelessly or by wire with other devices to exchange data. While fig. 14 illustrates an electronic device 1400 having various means, it is to be understood that not all illustrated means are required to be implemented or provided. More or fewer devices may alternatively be implemented or provided. Each block shown in fig. 14 may represent one device or may represent a plurality of devices as necessary.

In particular, according to an embodiment of the present disclosure, the processes described above with reference to the flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network via the communication device 1409, or installed from the storage device 1408, or installed from the ROM 1402. The computer program, when executed by the processing apparatus 1401, performs the above-described functions defined in the methods of the embodiments of the present disclosure. It should be noted that the computer readable medium of the embodiments of the present disclosure may be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In embodiments of the disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In embodiments of the present disclosure, however, a computer readable signal medium may comprise a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, optical cables, RF (radio frequency), etc., or any suitable combination of the foregoing.

The computer readable medium may be embodied in the electronic device; or may exist separately without being assembled into the electronic device. The computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to: monitoring the authorization state of the system authority, wherein the authorization state is used for indicating the range of the system authority which permits the application program in the system to be used; in response to monitoring the authorization permission of the application program for obtaining the system permission, obtaining an authorization timestamp of the application program for obtaining the authorization permission; monitoring the current use state of the system authority in real time based on the authorization timestamp; and in response to monitoring that the current use state of the system authority is the in-use state, sending a use notice that the application program is using the system authority to the user.

Computer program code for carrying out operations for embodiments of the present disclosure may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + +, and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may 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 case of a remote computer, the remote computer may 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 may be made to an external computer (for example, through the Internet using an Internet service provider).

The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

The foregoing description is only exemplary of the preferred embodiments of the disclosure and is illustrative of the principles of the technology employed. It will be appreciated by those skilled in the art that the scope of the invention in the embodiments of the present disclosure is not limited to the specific combination of the above-mentioned features, but also encompasses other embodiments in which any combination of the above-mentioned features or their equivalents is made without departing from the inventive concept as defined above. For example, the above features and (but not limited to) technical features with similar functions disclosed in the embodiments of the present disclosure are mutually replaced to form the technical solution.

Claims

1. A method of table data manipulation, comprising:

presenting a split control within a numeric cell of a table;

in response to receiving a selection operation of the splitting control, presenting a splitting dialog box, wherein the splitting dialog box comprises initial splitting data;

in response to receiving a determination operation on the initial splitting data, splitting the quantitative cells according to the quantity of the initial splitting data, and splitting the initial splitting data into the split quantitative cells respectively;

presenting the split number cells and the data in the split number cells in the table.

2. The method of claim 1, wherein the split dialog box further comprises: an adjustment option to the initial split data;

the method further comprises the following steps: in response to receiving an adjustment operation on an adjustment option of the initial splitting data, presenting the adjusted splitting data; and in response to receiving the determined operation of the adjusted split data, splitting the quantitative cells according to the number of the adjusted split data, and splitting the adjusted split data into the split quantitative cells respectively.

3. The method of claim 2, wherein the adjustment option for the initial split data is to present an input box for the initial split data; and

the presenting the adjusted split data in response to receiving an adjustment operation to an adjustment option of the initial split data comprises: in response to receiving an adjustment operation on the initial splitting data in the input box, judging whether the adjusted splitting data accords with a first check rule; in response to determining that the adjusted split data complies with the first verification rule, presenting the adjusted split data.

4. The method of claim 3, wherein the presenting the adjusted split data in response to receiving the adjustment operation on the preset split data further comprises: and in response to determining that the adjusted split data does not conform to the first check rule, controlling the input box to present a preset color and presenting error prompt information.

5. The method of claim 2, wherein the adjustment option for the initial split data is an adjustment button for the initial split data; and

the presenting the adjusted split data in response to receiving an adjustment operation to an adjustment option of the initial split data comprises: in response to receiving a click operation on the adjusting button, the determined splitting data after the adjusting button is clicked is presented.

6. The method of claim 2 or 5, wherein the adjustment option for the initial split data is to present an adjustment slider for the initial split data; and

the presenting the adjusted split data in response to receiving an adjustment operation to an adjustment option of the initial split data comprises: in response to receiving the dragging operation of the adjusting slider, displaying the split data determined by the dragged slider;

wherein the drag operation of the slider conforms to a second check rule.

7. The method of claim 1 or 2, wherein the split dialog box further comprises: determining options and closing options;

the determining operation includes: clicking the determined option and/or clicking an area outside the splitting dialog box;

and the method further comprises: and closing the splitting dialog box in response to receiving the click operation on the closing option.

8. The method of claim 1 or 2, wherein the split control is a row split control;

the splitting the quantitative cell according to the amount of the initial split data and splitting the initial split data into the split quantitative cells respectively in response to receiving the determination operation on the initial split data comprises:

in response to receiving a determination operation on the initial split data, splitting the row of the number type cell according to the number of the initial split data to obtain split rows, splitting the initial split data into the split number type cells in each split row respectively, and copying data in other cells except the number type cells in the row of the number type cell to the split other cells in each split row; and

the presenting the split number cells and the split number cells data in the table includes:

presenting, in the table, split rows that include the split numeric cells and split rows that include data in the split numeric cells.

9. The method of claim 1, wherein the split control is a column split control;

in response to receiving a determination operation on the initial split data, splitting the column where the number type cell is located according to the number of the initial split data to obtain split columns, splitting the initial split data into the split number type cells in each split column respectively, and copying data in other cells except the number type cells in the column where the number type cells are located into other split cells in each split row;

the presenting the split number cells and the data in the split number cells in the table includes:

presenting, in the table, split columns including the split numeric cells and data in the split columns including data in the split numeric cells.

10. A method of table data manipulation, comprising:

presenting a merge control within the table;

responding to the received selection operation of more than two rows or columns and the click operation of the merging control, and judging whether the data in the selected rows or columns meet merging conditions, wherein the merging conditions are as follows: the selected row or column at least has a column or row of unit cells which are quantity type unit cells, and the data in other columns or rows with the same number except the column or row of the quantity type unit cells in the selected row or column are the same;

in response to determining that the data in the selected row or column satisfies the merge condition, merging the selected row or column with: merging the selected rows or columns to obtain merged parallel or merged columns; merging the sum of data in the column or row number type unit cells with the same number in each row or column into the merged number type unit cells of the column or row with the same number in the merged parallel or merged column; copying data in other cells of columns or rows with the same number in each row or column except the number cells to other merged cells of columns or rows with the same number in the merged parallel or merged column;

presenting the merged row or merged column in the table that includes the merged numeric cell, and presenting the data in the merged row or merged column in the table that includes the data in the merged numeric cell.

11. A table data manipulation device, comprising:

a first display unit configured to present a split control within a numeric cell of a table; in response to receiving a selection operation of the splitting control, presenting a splitting dialog box, wherein the splitting dialog box comprises initial splitting data;

the splitting unit is configured to split the number type cells according to the number of the initial splitting data and split the initial splitting data into the split number type cells respectively in response to receiving the determination operation of the initial splitting data;

the first display unit is further configured to present the split number cells and the data in the split number cells in the table.

12. A table data manipulation device, comprising:

a second display unit configured to present a merge control within the table;

the judging unit is configured to respond to the received selection operation on more than two rows or columns and the click operation on the merging control, and judge whether the data in the selected rows or columns meet merging conditions, wherein the merging conditions are as follows: the selected row or column at least has a column or row of unit cells which are quantity type unit cells, and the data in other columns or rows with the same number except the column or row of the quantity type unit cells in the selected row or column are the same;

a merging unit configured to merge the selected row or column in response to determining that the data in the selected row or column satisfies the merging condition, with: merging the selected rows or columns to obtain merged parallel or merged columns; merging the sum of data in the column or row number type unit cells with the same number in each row or column into the merged number type unit cells of the column or row with the same number in the merged parallel or merged column; copying data in other cells of columns or rows with the same number in each row or column except the number cells to other merged cells of columns or rows with the same number in the merged parallel or merged column;

the second display unit is configured to present the merged row or merged column including the merged number cell in the table, and present data in the merged row or merged column including data in the merged number cell in the table.

13. An electronic device, comprising:

one or more processors;

a storage device for storing one or more programs,

the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method of any of claims 1-10.

14. A computer-readable medium, on which a computer program is stored which, when being executed by a processor, carries out the method according to any one of claims 1-10.