CN109726380A

CN109726380A - Table edit method and device

Info

Publication number: CN109726380A
Application number: CN201811634978.8A
Authority: CN
Inventors: 徐煜; 唐卓
Original assignee: Tianjin ByteDance Technology Co Ltd
Current assignee: Tianjin ByteDance Technology Co Ltd
Priority date: 2018-12-29
Filing date: 2018-12-29
Publication date: 2019-05-07

Abstract

The disclosure proposes a kind of Table edit method and device, belongs to computer application technology.Wherein, which comprises obtain list data input request, include the location information of first unit lattice in request；According to the location information of first unit lattice, generates and show the first input interface corresponding with first unit lattice；According to the content that user inputs in the first input interface, the content of first unit lattice is determined.As a result, by this Table edit method, allow user in biggish input interface, the content of input unit lattice not only increases the accuracy to cell positioning, and improves the efficiency to cell editor, improves user experience.

Description

Table editing method and device

Technical Field

The present disclosure relates to the field of computer application technologies, and in particular, to a method and an apparatus for editing a table.

Background

With the continuous development of science and technology, the functions of the application programs in the mobile terminal are more and more, so as to adapt to the diversified use requirements of people. The application of document editing, online documents and the like in the mobile terminal can meet the requirements of people on learning and processing work anytime and anywhere, and brings great convenience to people.

However, since the display screen of the mobile terminal is small, the document editing application in the mobile terminal cannot completely display the entire document, and the display font of the document content is small. For example, when an Excel form is edited, only narrow cells can be edited, which is not only easy to make mistakes, but also low in efficiency, and affects user experience.

Disclosure of Invention

The form editing method, the form editing device, the electronic equipment and the storage medium are used for solving the problems that in the related art, a document editing application in a mobile terminal cannot completely display a whole document, and the display font of document content is small, so that errors are easy to occur, the efficiency is low and the user experience is influenced when the document content is edited.

The form editing method provided by the embodiment of the one aspect of the disclosure includes: acquiring a form data input request, wherein the request comprises the position information of a first cell; generating and displaying a first input interface corresponding to the first cell according to the position information of the first cell; and determining the content of the first cell according to the content input in the first input interface by the user.

Another embodiment of the present disclosure provides a table editing apparatus, including: the acquisition module is used for acquiring a table data input request, wherein the request comprises the position information of a first cell; the generating module is used for generating and displaying a first input interface corresponding to the first cell according to the position information of the first cell; and the determining module is used for determining the content of the first cell according to the content input in the first input interface by the user.

An embodiment of another aspect of the present disclosure provides an electronic device, which includes: a processor and a memory; wherein the processor executes a program corresponding to the executable program code by reading the executable program code stored in the memory, for implementing the table editing method as described above.

A further aspect of the present disclosure provides a non-transitory computer readable storage medium, on which a computer program is stored, wherein the program, when executed by a processor, implements the table editing method as described above.

A further aspect of the present disclosure provides a computer program, which when executed by a processor implements the table editing method as described above.

According to the form editing method, the form editing device, the electronic device, the computer readable storage medium and the computer program provided by the embodiments of the present disclosure, when the form data input request is obtained, the first input interface corresponding to the first cell may be generated and displayed according to the position information of the first cell included in the data input request, and then the content of the first cell may be determined according to the content input by the user in the first input interface. Therefore, the first input interface corresponding to the first cell needing to input data is generated, so that a user can input the content of the cell in a larger input interface, the accuracy of cell positioning is improved, the cell editing efficiency is improved, and the user experience is improved.

Additional aspects and advantages of the disclosure will be set forth in part in the description which follows and, in part, will be obvious from the description, or may be learned by practice of the disclosure.

Drawings

The foregoing and/or additional aspects and advantages of the present disclosure will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings of which:

fig. 1 is a schematic flowchart of a table editing method according to an embodiment of the disclosure;

FIG. 2-1 is a schematic diagram of a first input interface provided by an embodiment of the present disclosure;

2-2 are schematic diagrams of another first input interface provided by embodiments of the present disclosure;

FIG. 3 is a flowchart illustrating another table editing method according to an embodiment of the disclosure;

FIG. 4-1 is a schematic view of another first input interface provided by embodiments of the present disclosure;

FIG. 4-2 is a schematic diagram of a second input interface provided by an embodiment of the present disclosure;

FIG. 5 is a flowchart illustrating another table editing method according to an embodiment of the disclosure;

FIG. 6-1 is a schematic diagram of an editing interface provided by an embodiment of the present disclosure;

6-2 are schematic diagrams of another editing interface provided by embodiments of the present disclosure;

FIG. 6-3 is a schematic diagram of entering an editing interface by clicking a header before and after a left-slide operation is performed on a table display interface;

fig. 7 is a schematic structural diagram of a table editing apparatus according to an embodiment of the present disclosure;

fig. 8 is a schematic structural diagram of an electronic device provided in the disclosed embodiments;

fig. 9 is a schematic structural diagram of a non-transitory computer-readable storage medium according to an embodiment of the present disclosure.

Detailed Description

Reference will now be made in detail to the embodiments of the present disclosure, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the like or similar elements throughout. The embodiments described below with reference to the drawings are exemplary and intended to be illustrative of the present disclosure, and should not be construed as limiting the present disclosure.

The embodiment of the disclosure provides a form editing method aiming at the problems that in the related art, a document editing application in a mobile terminal cannot completely display a whole document, and the display font of document content is small, so that when the document content is edited, errors are easy to occur, the efficiency is low, and the user experience is influenced.

According to the form editing method provided by the embodiment of the disclosure, when the form data input request is acquired, the first input interface corresponding to the first cell can be generated and displayed according to the position information of the first cell included in the data input request, and then the content of the first cell is determined according to the content input in the first input interface by the user. Therefore, the first input interface corresponding to the first cell needing to input data is generated, so that a user can input the content of the cell in a larger input interface, the accuracy of cell positioning is improved, the cell editing efficiency is improved, and the user experience is improved.

The form editing method, apparatus, electronic device, storage medium, and computer program provided by the present disclosure are described in detail below with reference to the accompanying drawings.

Fig. 1 is a flowchart illustrating a table editing method according to an embodiment of the disclosure.

As shown in fig. 1, the table editing method includes the following steps:

step 101, a form data input request is obtained, wherein the request comprises position information of a first cell.

The data input request may be input by a user through an input device (a mouse, a keyboard, a touch screen, or the like) of the electronic device, and the data input request may be obtained by detecting operations such as clicking, double-clicking, long-pressing, sliding, and the like on a cell in the table. The first cell is a cell to which contents are currently required to be input. The position information of the first cell refers to the row number and the column number information corresponding to the first cell.

It should be noted that, in the embodiment of the present disclosure, an operation for triggering a data input request may be preset, and when the preset operation is detected, an occurrence position of the operation is obtained, and a row serial number and a column serial number corresponding to the occurrence position of the operation are determined as the position information corresponding to the first cell. When the operations of the tokens triggering the data input requests are different, the rules for determining the first cell location information may also be different.

Specifically, if the operation of the preset trigger data input request is a click operation, it may be first determined whether an occurrence position of the click operation is a focus position, and if so, a row number and a column number corresponding to the occurrence position of the click operation of the operation may be obtained and determined as position information corresponding to the first cell; if the occurrence position of the click operation is not the focus position, it can be determined that the click operation is an operation for moving the focus, and the data input request is not triggered. If the preset operation for triggering the data input request is a double-click operation, the occurrence position of the double-click operation can be directly obtained when the occurrence of the double-click operation is detected, and the row serial number and the column serial number corresponding to the occurrence position of the double-click operation are determined as the position information corresponding to the first cell. If the preset operation for triggering the data input request is a long-press operation, when it is detected that the occurrence duration of the click operation exceeds a preset duration threshold, it may be determined that the current occurrence operation is the long-press operation, and the row sequence number and the column sequence number corresponding to the occurrence position of the long-press operation are determined as the position information corresponding to the first cell. If the preset operation for triggering the data input request is a sliding operation, when the sliding operation is detected to occur, the initial position where the sliding operation occurs may be obtained, and the row serial number and the column serial number corresponding to the initial position where the sliding operation occurs are determined as the position information of the first cell.

When the preset operation for triggering the data input request is a long press operation, a threshold value for determining the length of the long press operation needs to be preset, for example, the threshold value may be preset to 0.5 second, that is, when it is detected that the length of the click operation is greater than 0.5 second, it may be determined that the long press operation is currently performed. In practical use, the time length threshold for judging the long press operation can be preset according to actual needs, and the embodiment of the disclosure does not limit the time length threshold.

It should be noted that the operation of triggering the data input request may include, but is not limited to, the above-listed situations. In actual use, the operation of triggering the data input request may be preset according to actual needs, which is not limited in the embodiment of the present disclosure.

In one possible implementation form of the embodiment of the present disclosure, the row number and the column number corresponding to a cell in the table may be represented by a numeral or an english letter. For example, the row number of the cell may be represented by a number, and the column number of the cell may be represented by an english alphabet, so that the first cell with the position information of "1C" refers to the cell located in the 1 st row, the C th column (the 3 rd column) in the table.

It should be noted that, in actual use, a method for representing the location information of the cells may be preset according to actual needs, which is not limited in the embodiment of the present disclosure.

And 102, generating and displaying a first input interface corresponding to the first cell according to the position information of the first cell.

In the embodiment of the present disclosure, after the form data input request is obtained, the first input interface corresponding to the first cell may be generated and displayed according to the location information of the first cell included in the data request. The first input interface can include a name of the first input interface, position information of the first cell, a cell content input box, and controls such as "determine", "cancel", and "close".

Fig. 2-1 is a schematic diagram of a first input interface provided in an embodiment of the present disclosure. In the first input interface shown in fig. 2-1, the center at the top of the interface is the name "cell content input interface" of the first input interface, the position information "1C" of the first cell, the cell content input box, "determine" and "cancel" controls are sequentially arranged below the interface, and the "close" control is arranged at the upper right corner of the interface.

Fig. 2-2 are schematic diagrams of another first input interface provided in an embodiment of the present disclosure. In the first input interface shown in fig. 2-2, the center at the top of the interface is the name "cell content input interface" of the first input interface, the position information "1C" of the first cell, the cell content input box, "determination" control are sequentially arranged below the interface, and the upper right corner of the interface is the "close" control.

It should be noted that, the first input interface corresponding to the first cell may include, but is not limited to, the above listed situations. In actual use, the content and the function control which need to be displayed in the first input interface can be preset according to actual needs, which is not limited in the embodiment of the disclosure.

Step 103, determining the content of the first cell according to the content input by the user in the first input interface.

In the embodiment of the disclosure, after the first input interface corresponding to the first cell is generated and displayed, the user may call the input method installed in the electronic device by clicking the area corresponding to the "cell content input box" in the first input interface, and input the corresponding content by using the input method, so that the content input by the user in the "cell content input box" through the input method may be determined as the content of the first cell.

In a possible implementation form of the embodiment of the present disclosure, if the first input interface corresponding to the first cell is the interface shown in fig. 2-1, when it is detected that the "determine" control in the first input interface is clicked, the content input by the user in the "cell content input box" may be determined as the content of the first cell, and the first input interface is closed; and when detecting that a 'cancel' control or a 'close' control in the first input interface is clicked, clearing the content input in the 'cell content input box' by the user, namely considering that the user does not input the content in the first input interface, and closing the first input interface.

In another possible implementation form of the embodiment of the present disclosure, if the first input interface corresponding to the first cell is the interface shown in fig. 2-2, when it is detected that the "confirm" control in the first input interface is clicked, the content input by the user in the "cell content input box" may be determined as the content of the first cell, and the first input interface is closed; and when the 'closing' control in the first input interface is detected to be clicked, clearing the content input in the 'cell content input box' by the user, namely considering that the user does not input the content in the first input interface, and closing the first input interface.

In a possible implementation form of the embodiment of the disclosure, the first input interface may be further closed by an operation of sliding upwards from the bottom of the first input interface.

In a possible implementation form of the present disclosure, attribute fields corresponding to each row or each column in the table may be preset according to data content to be recorded in the table, a first attribute field corresponding to the first cell is determined according to the location information of the first cell, and the first attribute field is displayed in a first input interface corresponding to the first cell, so as to improve friendliness and interchangeability of the interface.

The table editing method provided by the embodiment of the present disclosure is further described below with reference to fig. 3.

Fig. 3 is a flowchart illustrating another table editing method according to an embodiment of the disclosure.

As shown in fig. 3, the table editing method includes the following steps:

step 301, a form data input request is obtained, where the request includes location information of a first cell.

The detailed implementation process and principle of step 301 may refer to the detailed description of the above embodiments, and are not described herein again.

Step 302, determining the position of each attribute field in the form according to the type of the form in which the first cell is located.

The types of the tables can include horizontal tables and vertical tables; the horizontal table means that each row of the table is used for recording one record; vertical tables, which means that each column of the table is used to record one record.

It should be noted that each attribute field in the table is related to the data content recorded in the table. In actual use, each attribute field in the table may be preset according to the content recorded in actual need, which is not limited in the embodiment of the present disclosure. For example, the content to be recorded is department staff information, and each attribute field in the table may be name, gender, age, native place, position, and the like.

It will be appreciated that, when a form is built, the attribute fields within the form are typically recorded at the very front of the form, and therefore the location of the attribute fields within the form is related to the type of form. Specifically, if the type of the table is a horizontal table, the position of each attribute field in the table is the first row of the table, that is, each attribute field is sequentially recorded in one or more cells corresponding to the first row of the table; if the type of the table is a vertical table, the position of each attribute field in the table is the first column of the table, that is, each attribute field is sequentially recorded in one or more cells corresponding to the first column of the table. Therefore, in a possible implementation form of the embodiment of the present disclosure, the position of each attribute field in the table may be determined according to the type of the table in which the first cell is located.

Step 303, obtaining a first attribute field corresponding to the first cell according to the location information of the first cell.

In the embodiment of the present disclosure, after the position of each attribute field in the form where the first cell is located is determined, according to the position information of the first cell, the attribute field corresponding to the position information of the first cell, that is, the first attribute field corresponding to the first cell, may be obtained from each attribute field in the form.

Specifically, if the position of each attribute field in the table is the first row of the table, that is, the table where the first cell is located is the horizontal table, the attribute field recorded in the cell in the first row in the table, which is the same as the column number of the first cell, may be determined as the first attribute field according to the column number in the position information of the first cell; if the position of each attribute field in the table is the first column of the table, that is, the table where the first cell is located is the vertical table, the attribute field recorded in the cell with the same row sequence number as the first cell in the first column of the table may be determined as the first attribute field according to the row sequence number in the position information of the first cell.

For example, the location information of the first cell is "MN", that is, the first cell is located in the mth row and nth column in the table, that is, the row number of the first cell is M, and the column number is N; the table in which the first cell is located is a horizontal table, that is, the position of each attribute field in the table is the first row of the table, and then the first attribute field corresponding to the first cell is the attribute field recorded in the cell located in the 1 st row and the N th column in the table. For example, if the attribute fields in the table are "name, gender, and age" and are recorded in the cells corresponding to row 1, column a, row 1, column B, and row 1, column C of the table, the first attribute field corresponding to the first cell having the location information of "2A" is "name".

Furthermore, the attribute fields can be added or modified in the cells corresponding to the positions of the attribute fields in the table according to actual needs. That is, in a possible implementation form of the embodiment of the present disclosure, before the step 303, the method may further include:

acquiring a form data input request, wherein the request comprises the position information of a second cell;

and if the position information of the second cell is matched with the position of the attribute field in the table, determining the attribute field corresponding to the row or the column where the second cell is located according to the acquired input data.

The second cell is a cell in a row or a column where each attribute field in the table is located. For example, if the table is a horizontal table, the second cell refers to all cells in the first row of the table; if the table is a vertical table, the second cell refers to all cells in the first column of the table.

In the table including the attribute fields, before contents are input to other cells in the table, each attribute field may be input to a cell corresponding to a position of each attribute field in the table. Therefore, when it is determined that the position information of the second cell included in the data input request matches the position of the attribute field in the table, a data input interface corresponding to the second cell may be generated and displayed, and when data input by the user on the data input interface is acquired, the acquired input data is determined as the attribute field corresponding to the row or column where the second cell is located, and the acquired input data is recorded in the second cell.

Specifically, if the form is a horizontal form, the acquired input data is determined as an attribute field corresponding to the column where the second cell is located; and if the form is a vertical form, determining the acquired input data as the attribute field corresponding to the row of the second cell.

For example, the form is a horizontal form, that is, the position of each attribute field in the form is the first row of the form, the position information of the second cell is "1B", that is, the second cell is located in the 1 st row and the B th column in the form, so that a data input interface corresponding to the second cell is generated and displayed, and when data input by a user on the data input interface is acquired, the acquired input data is recorded in the second cell, and the acquired input data is determined as the attribute field corresponding to the B th column in the form. For example, if the acquired input data is "gender", the "gender" may be recorded in the second cell, and the "gender" may be determined as the attribute field corresponding to the B-th column of the table.

Step 304, according to the first attribute field corresponding to the first cell, generating and displaying a first input interface corresponding to the first cell, wherein the first input interface includes the first attribute field corresponding to the first cell.

In the embodiment of the disclosure, after the first attribute field corresponding to the first cell is determined, a first input interface corresponding to the first cell may be generated and displayed, and the first attribute field corresponding to the first cell is displayed in the first input interface, so as to remind a user to input the content of the first cell at a corresponding position.

Fig. 4-1 is a schematic diagram of another first input interface provided in an embodiment of the present disclosure. In the first input interface shown in fig. 4-1, the center of the uppermost portion of the interface is the name "cell content input interface" of the first input interface, the first attribute field "name" corresponding to the first cell, the cell content input box, "determination" control, and the upper right corner of the interface is the "close" control.

Further, when a data input request is obtained, that is, when it is determined that a user requests to input the content of the first cell, the attribute fields corresponding to all cells in the row or the column where the first cell is located may be simultaneously displayed in the input interface, so that the user may simultaneously input a plurality of fields of the same record. That is, in a possible implementation form of the embodiment of the present disclosure, the step 304 may further include:

acquiring attribute fields corresponding to the cells in the form according to the type of the form in which the first cell is located;

generating and displaying a second input interface corresponding to the row or the column of the first cell according to the attribute field corresponding to each cell;

the second input interface comprises a first attribute field corresponding to the first cell and second attribute fields corresponding to other cells which are the same as the first cell in the row or the column.

It should be noted that in a possible implementation form of the embodiment of the present disclosure, when a form data input request is obtained, attribute fields corresponding to all cells in a row or a column where a first cell is located may be simultaneously displayed in a first input interface, so that a user may simultaneously input multiple fields of the same record, and the editing efficiency of the form is improved. Therefore, the position of each attribute field in the table can be determined according to the type of the table in which the first cell is located, and then the attribute field corresponding to each cell in the table can be determined according to the position of each attribute field.

Specifically, if the type of the table is a horizontal table, that is, the position of each attribute field in the table is the first row of the table, the attribute field corresponding to each column of cells in the table is the attribute field recorded in the cells in the first row of the column; if the type of the table is a vertical table, that is, the position of each attribute field in the table is the first column of the table, the attribute field corresponding to each row of cells in the table is the attribute field recorded in the cells in the first column of the row.

For example, the type of the table is a horizontal table, and the attribute fields recorded in the cells corresponding to the row 1, column a, row 1, column B, and column 1, column C of the table are "name", "gender", and "age", respectively, so the attribute field corresponding to the cell in the column a in the table is "name", the attribute field corresponding to the cell in the column B is "gender", and the attribute field corresponding to the cell in the column C is "age".

In the embodiment of the present disclosure, after the attribute field corresponding to each cell in the table is determined, a second input interface corresponding to the row or the column where the first cell is located may be generated and displayed according to the attribute field corresponding to the cell in the row or the column where the first cell is located, and the attribute field of each cell in the row or the column where the first cell is located is displayed in the second input interface.

Specifically, if the form type is a horizontal form, a second input interface corresponding to the row where the first cell is located is generated and displayed; and if the table type is a vertical table, generating and displaying a second input interface corresponding to the column of the first cell.

For example, the table type is a horizontal table, the attribute fields recorded in the cells corresponding to the row 1, column a, row 1, column B, and column C of the table are "name", "gender", and "age", respectively, the location information of the first cell is "2A", that is, the corresponding first attribute field is "name". Fig. 4-2 is a schematic diagram of a second input interface provided in an embodiment of the disclosure. In the second input interface shown in fig. 4-2, the name "record information input interface" of the second input interface is located in the center of the uppermost position of the interface, the first attribute field "name" and the corresponding cell content input box corresponding to the first cell, the attribute field "gender" and the corresponding cell content input box corresponding to the cell in row 2, column B, the attribute field "age" and the corresponding cell content input box corresponding to the cell in row 2, column C, the "ok" control, and the "close" control are located in the upper right corner of the interface.

Step 305, determining the content of the first cell according to the content input in the first input interface by the user.

Further, after a second input interface corresponding to the row or the column where the first cell is located is generated and displayed, the content of each cell in the row or the column where the first cell is located can be determined according to the obtained content input by the user in the corresponding "cell content input box".

According to the form editing method provided by the embodiment of the disclosure, when a form data input request is obtained, a first attribute field corresponding to a first cell can be obtained according to position information of the first cell included in the data input request and a type of a form where the first cell is located, and then a first input interface corresponding to the first cell is generated and displayed according to the first attribute field corresponding to the first cell, wherein the first input interface includes the first attribute field corresponding to the first cell, and further, the content of the first cell is determined according to the content input by a user in the first input interface. Therefore, by generating a larger first input interface corresponding to the first cell needing to input data and displaying the first attribute field corresponding to the first cell in the first input interface, the efficiency of editing the cells is improved, the friendliness and the interchangeability of the interface are improved, and the user experience is further improved.

In one possible implementation form of the present disclosure, the content of the cell may also be edited, such as modified, deleted, and the like, according to the operation of the user on the cell.

The table editing method provided by the embodiment of the present disclosure is further described below with reference to fig. 5.

Fig. 5 is a flowchart illustrating another table editing method according to an embodiment of the disclosure.

As shown in fig. 5, the table editing method includes the following steps:

step 501, if an editing request for the first cell is acquired, an editing interface containing the content of the first cell is generated and displayed.

After the content of the cell is input, the content of the cell may be edited, for example, the content of the cell is modified or deleted, or a cell in a certain row or a certain column in the table is deleted. Therefore, in one possible implementation form of the present disclosure, an editing interface corresponding to the first cell may be generated and displayed according to the obtained editing request of the first cell, and the content of the first cell is displayed in the editing interface, so that a user may modify the content of the first cell.

Further, a corresponding operation for triggering the editing request may be preset, and when the preset operation is detected, the editing request for the cell may be acquired. That is, in a possible implementation form of the embodiment of the present disclosure, the step 501 may include:

if the sliding operation of the user on the first cell is detected, determining to acquire an editing request on the first cell; or,

and if the fact that the user carries out clicking operation on the list head of the row or the column where the first cell is located is detected, determining to acquire the editing request of the first cell.

It should be noted that, if the preset operation for triggering the editing request is a sliding operation on the cell, when the sliding operation on the first cell by the user is detected, it may be determined that the editing request on the first cell is acquired, and according to the starting position where the sliding operation occurs, the row number and the column number where the editing request is located are determined as the position information of the first cell, and then according to the position information of the first cell, the first attribute field corresponding to the first cell and the content of the first cell are determined, and then the first attribute field corresponding to the first cell and the content of the first cell are displayed in the editing interface. The display area corresponding to the content of the first cell can receive input operation of a user to edit the content of the first cell, and the obtained input data is determined as the edited content of the first cell.

As shown in fig. 6-1, an embodiment of the present disclosure provides a schematic diagram of an editing interface. In the editing interface shown in fig. 6-1, the name "cell detail" of the editing interface is set at the center of the uppermost part of the interface, controls of a first attribute field "name", cell contents "open three", and "delete contents" corresponding to the first cell are sequentially set below the interface, and a control of "close" is set at the upper right corner of the interface. The content of the first cell can be edited by clicking the display area corresponding to the content of the cell, the content of the first cell can be deleted by clicking the 'delete content' control, the editing interface can be closed by clicking the 'close' control or by 'sliding up' operation, and the editing of the content of the first cell is saved.

It should be noted that, in actual use, the operation of triggering the editing request may be preset according to actual needs, for example, the operation may be a click operation on a cell, a double click operation on a cell, a long press operation, and the like, which is not limited in this embodiment of the application.

In another possible implementation form of the embodiment of the present disclosure, the preset operation of triggering the editing request may also be a click operation performed on a header of a row or a column where the cell is located. The header refers to the first cell in the row or the first cell in the column of the cell. Therefore, when it is detected that a user clicks on a header of a row or a column where the first cell is located, it may be determined that an editing request for the first cell is obtained, and an editing interface corresponding to the row or the column where the clicked header is located is generated and displayed according to the type of the table, where the editing interface includes attribute fields corresponding to the cells in the row or the column where the clicked header is located and contents of the cells, so that the user may edit multiple fields in one record at the same time.

Specifically, if the type of the table is a horizontal table, an editing interface corresponding to the row where the clicked header is located is generated and displayed, and the attribute fields corresponding to the cells in the row where the clicked header is located and the content of the cells are displayed in the editing interface; and if the type of the table is a vertical table, generating and displaying an editing interface corresponding to the column where the clicked header is located, and displaying the attribute fields corresponding to the cells in the column where the clicked header is located and the content of the cells in the editing interface.

For example, the type of the table is a horizontal table, the attribute fields recorded in the cells corresponding to the row 1, column a, row 1, column B, and column 1, column C of the table are "name", "gender", and "age", respectively, when it is detected that the user clicks the header of the second row of the table, the editing interface corresponding to the second row generated and displayed is as shown in fig. 6-2, the middle position at the top of the interface is the name "recording details" of the editing interface, the attribute field "name" and the corresponding cell content "zhangsan" corresponding to the cell in the row 2, column a are sequentially located below the interface, the attribute field "name" and the corresponding cell content "zhangsan" corresponding to the cell in the row 2, column B of the interface, the attribute field "age" and the corresponding cell content "25" and "delete" control corresponding to the cell content "male gender", the cell in the row 2, column C of the interface, the upper right hand corner of the interface is the "close" control. The record of the row can be deleted by clicking the record deleting control, the editing interface can be closed by clicking the closing control or by the sliding operation, and the editing of the contents of all the cells of the row is saved.

It should be noted that, in actual use, when an edit request is triggered by performing corresponding operation on the header, the operation on the header may be preset according to actual needs, for example, the header may be subjected to double-click operation, long-press operation, and the like, which is not limited in this embodiment of the application.

In one possible implementation form of the embodiment of the disclosure, due to the limited size of the display screen of the electronic device, the content of the table may not be fully displayed, and therefore, other content in the table which is not displayed may be viewed through a sliding operation. For example, the content not displayed below the table can be viewed through the sliding operation; and through the left-sliding operation, the content which is not displayed on the right of the table is checked. Therefore, after the table is subjected to the sliding operation, the head can still be operated to enter the editing interface corresponding to the row or the column where the head is located, and when the sliding operation on the table is detected, each cell of the row or the column where the head is located can be reduced into a small square, and the head is always displayed in the display screen of the electronic device.

For example, if the type of the table is a horizontal table, the cell corresponding to the head of the table is the first column of the table, and if a left-sliding operation on the table is detected, each cell in the first column of the table may be reduced to a small square and always displayed in the display screen of the electronic device. After left-sliding the table, the corresponding editing interface can still be entered by clicking the header, as shown in fig. 6-3.

Step 502, determining a third cell to be displayed by the editing interface according to the direction of the sliding operation executed by the user on the editing interface.

Step 503, displaying the content of the third cell on the editing interface.

In a possible implementation form of the embodiment of the present disclosure, when the editing interface corresponding to the first cell is displayed, the content of a third cell adjacent to the first cell may be displayed in the editing interface through a corresponding sliding operation. Therefore, the position information of the third cell to be displayed on the editing interface can be determined according to the direction of the sliding operation executed by the user on the editing interface, the content of the third cell and the attribute field corresponding to the third cell are determined according to the position information of the third cell, and the attribute field corresponding to the third cell and the content of the third cell are displayed on the editing interface.

Specifically, if the sliding operation direction executed by the user on the editing interface is from bottom to top, namely, the user slides up, it may be determined that the third cell is the cell located below the first cell; if the sliding operation direction executed by the user on the editing interface is from top to bottom, namely the sliding operation, the third cell can be determined to be the cell positioned above the first cell; if the sliding operation direction executed by the user on the editing interface is from left to right, namely the sliding operation is performed on the right side, the third cell can be determined to be the cell positioned on the left side of the first cell; if the sliding operation direction executed by the user on the editing interface is from right to left, namely left sliding operation, the third cell can be determined to be the cell positioned on the right side of the first cell.

Furthermore, if the content in the editing interface is the content of a cell in a certain row or a certain column in the table, the content of a cell in an adjacent row or an adjacent column can be displayed in the editing interface through a sliding operation. Specifically, if the type of the table is a horizontal table, when the direction of the sliding operation performed by the user on the editing interface is from left to right, that is, the sliding operation is performed on the right, the content of each cell in the previous row can be displayed in the editing interface; when the sliding operation direction executed by the user on the editing interface is from right to left, namely left sliding operation, the content of each cell in the next row can be displayed on the editing interface; if the type of the table is a vertical table, when the sliding operation direction executed by the user on the editing interface is from left to right, namely right sliding operation, the content of each cell in the previous column can be displayed in the editing interface; when the direction of the sliding operation performed by the user on the editing interface is from right to left, namely, the sliding operation is performed on the left, the content of each cell in the next column can be displayed in the editing interface.

It should be noted that the above-mentioned switching rules between the direction of the sliding operation and the display content of the editing interface are merely exemplary, and should not be considered as limiting the disclosure. In actual use, the display content in the editing interface is switched through the sliding operation, and the direction of the sliding operation and the relationship between the direction of the sliding operation and the third cell to be displayed can be preset according to actual needs, which is not limited by the embodiment of the disclosure.

According to the table editing method provided by the embodiment of the disclosure, when the editing request for the first cell is acquired, the editing interface containing the content of the first cell can be generated and displayed, the third cell to be displayed on the editing interface is determined according to the direction of the sliding operation executed by the user on the editing interface, and then the content of the third cell is displayed on the editing interface. Therefore, when the cell content is edited, a larger editing interface corresponding to the cell is generated, and the content displayed in the editing interface can be switched through sliding operation, so that a user can edit the content of the cell in the larger editing interface, the accuracy of cell positioning and the editing efficiency are improved, the content of the table can be conveniently checked, and the user experience is further improved.

In order to implement the above embodiments, the present disclosure further provides a table editing apparatus.

Fig. 7 is a schematic structural diagram of a table editing apparatus according to an embodiment of the present disclosure.

As shown in fig. 7, the table editing apparatus 70 includes:

a first obtaining module 71, configured to obtain a table data input request, where the request includes location information of a first cell;

the first generating module 72 is configured to generate and display a first input interface corresponding to the first cell according to the position information of the first cell;

the first determining module 73 is configured to determine the content of the first cell according to the content input in the first input interface by the user.

In practical use, the form editing apparatus provided by the embodiment of the present disclosure may be configured in any electronic device to execute the foregoing form editing method.

When the form data input request is obtained, the form editing device provided by the embodiment of the disclosure can generate and display the first input interface corresponding to the first cell according to the position information of the first cell included in the data input request, and further determine the content of the first cell according to the content input by the user in the first input interface. Therefore, the first input interface corresponding to the first cell needing to input data is generated, so that a user can input the content of the cell in a larger input interface, the accuracy of cell positioning is improved, the cell editing efficiency is improved, and the user experience is improved.

In a possible implementation form of the present disclosure, the first generating module 72 is specifically configured to:

determining the position of each attribute field in the form according to the type of the form in which the first cell is located;

acquiring a first attribute field corresponding to the first cell according to the position information of the first cell;

and generating and displaying a first input interface corresponding to the first cell according to the first attribute field corresponding to the first cell, wherein the first input interface comprises the first attribute field corresponding to the first cell.

Further, in another possible implementation form of the present disclosure, the first generating module 72 is further configured to:

In a possible implementation form of the present disclosure, the table editing apparatus 70 further includes:

the second obtaining module is used for obtaining the attribute fields corresponding to the cells in the form according to the type of the form in which the first cell is located;

the second generation module is used for generating and displaying a second input interface corresponding to the row or the column where the first cell is located according to the attribute field corresponding to each cell;

Further, in another possible implementation form of the present disclosure, the table editing apparatus 70 further includes:

and the third generation module is used for generating and displaying an editing interface containing the content of the first cell if the editing request for the first cell is acquired.

the second determining module is used for determining to acquire an editing request for the first cell if the sliding operation of the user on the first cell is detected; or,

and the third determining module is used for determining to acquire the editing request for the first cell if the fact that the user performs click operation on the head of the row or the column where the first cell is located is detected.

the fourth determining module is used for determining a third cell to be displayed on the editing interface according to the direction of the sliding operation executed on the editing interface by the user;

and the display module is used for displaying the content of the third cell on the editing interface.

It should be noted that the above explanation of the table editing method embodiments shown in fig. 1, fig. 3, and fig. 5 is also applicable to the push information presentation apparatus 70 of this embodiment, and is not repeated here.

The table editing device provided by the embodiment of the disclosure can generate and display an editing interface containing the content of the first cell when an editing request for the first cell is acquired, determine a third cell to be displayed on the editing interface according to the direction of the sliding operation executed by the user on the editing interface, and further display the content of the third cell on the editing interface. Therefore, when the cell content is edited, a larger editing interface corresponding to the cell is generated, and the content displayed in the editing interface can be switched through sliding operation, so that a user can edit the content of the cell in the larger editing interface, the accuracy of cell positioning and the editing efficiency are improved, the content of the table can be conveniently checked, and the user experience is further improved.

In order to implement the above embodiments, the present disclosure further provides an electronic device.

Fig. 8 is a schematic structural diagram of an electronic device according to an embodiment of the present disclosure.

Referring now to FIG. 8, shown is a schematic diagram of an electronic device 700 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 digital broadcast receiver, a PDA (personal digital assistant), a PAD (tablet computer), a PMP (portable multimedia player), a vehicle terminal (e.g., a car navigation terminal), and the like, and a stationary terminal such as a digital TV, a desktop computer, and the like. The electronic device shown in fig. 8 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present disclosure.

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

Generally, the following devices may be connected to the I/O interface 705: input devices 706 including, for example, a touch screen, touch pad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; an output device 707 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, and the like; storage 708 including, for example, magnetic tape, hard disk, etc.; and a communication device 709. The communication means 709 may allow the electronic device 700 to communicate wirelessly or by wire with other devices to exchange data. While fig. 8 illustrates an electronic device 700 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.

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 embodiments, the computer program may be downloaded and installed from a network via the communication means 709, or may be installed from the storage means 708, or may be installed from the ROM 702. The computer program, when executed by the processing device 701, 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 in the present disclosure can 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 the present 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 contrast, in the present disclosure, a computer readable signal medium may comprise a propagated data signal with computer readable program code embodied therein, either 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: acquiring at least two internet protocol addresses; sending a node evaluation request comprising the at least two internet protocol addresses to node evaluation equipment, wherein the node evaluation equipment selects the internet protocol addresses from the at least two internet protocol addresses and returns the internet protocol addresses; receiving an internet protocol address returned by the node evaluation equipment; wherein the obtained internet protocol address indicates an edge node in the content distribution network.

Alternatively, the computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to: receiving a node evaluation request comprising at least two internet protocol addresses; selecting an internet protocol address from the at least two internet protocol addresses; returning the selected internet protocol address; wherein the received internet protocol address indicates an edge node in the content distribution network.

Computer program code for carrying out operations for aspects 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 units described in the embodiments of the present disclosure may be implemented by software or hardware. Where the name of a unit does not in some cases constitute a limitation of the unit itself, for example, the first retrieving unit may also be described as a "unit for retrieving at least two internet protocol addresses".

It should be noted that, for the implementation process and the technical principle of the electronic device of the embodiment, reference is made to the foregoing explanation of the form editing method of the embodiment of the present disclosure, and details are not described here again.

The electronic device provided by the embodiment of the disclosure may execute the form editing method, and when a form data input request is obtained, a first input interface corresponding to a first cell may be generated and displayed according to the position information of the first cell included in the data input request, and then the content of the first cell may be determined according to the content input by the user in the first input interface. Therefore, the first input interface corresponding to the first cell needing to input data is generated, so that a user can input the content of the cell in a larger input interface, the accuracy of cell positioning is improved, the cell editing efficiency is improved, and the user experience is improved.

In order to implement the above embodiments, the present disclosure also proposes a non-transitory computer-readable storage medium on which a computer program is stored, which when executed by a processor implements the table editing method as described in the foregoing embodiments.

Fig. 9 is a schematic diagram illustrating a computer-readable storage medium according to an embodiment of the present disclosure. As shown in fig. 9, a computer-readable storage medium 800 having non-transitory computer-readable instructions 810 stored thereon according to an embodiment of the disclosure. The non-transitory computer readable instructions 810, when executed by a processor, perform all or a portion of the steps of the form editing methods of the embodiments of the disclosure previously described.

In order to implement the foregoing embodiments, an embodiment of a further aspect of the present disclosure provides a computer program, which when executed by a processor, implements the table editing method according to the embodiment of the present disclosure.

In the description herein, references to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the present disclosure. In this specification, the schematic representations of the terms used above are not necessarily intended to refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.

Furthermore, the terms "first", "second" and "first" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In the description of the present disclosure, "a plurality" means at least two, e.g., two, three, etc., unless explicitly specifically limited otherwise.

Any process or method descriptions in flow charts or otherwise described herein may be understood as representing modules, segments, or portions of code which include one or more executable instructions for implementing steps of a custom logic function or process, and alternate implementations are included within the scope of the preferred embodiment of the present disclosure in which functions may be executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those reasonably skilled in the art of the embodiments of the present disclosure.

The logic and/or steps represented in the flowcharts or otherwise described herein, e.g., an ordered listing of executable instructions that can be considered to implement logical functions, can be embodied in any computer-readable medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, processor-containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions. For the purposes of this description, a "computer-readable medium" can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device. More specific examples (a non-exhaustive list) of the computer-readable medium would include the following: an electrical connection (electronic device) having one or more wires, a portable computer diskette (magnetic device), a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disc read-only memory (CDROM). Additionally, the computer-readable medium could even be paper or another suitable medium upon which the program is printed, as the program can be electronically captured, via for instance optical scanning of the paper or other medium, then compiled, interpreted or otherwise processed in a suitable manner if necessary, and then stored in a computer memory.

It should be understood that portions of the present disclosure may be implemented in hardware, software, firmware, or a combination thereof. In the above embodiments, the various steps or methods may be implemented in software or firmware stored in memory and executed by a suitable instruction execution system. If implemented in hardware, as in another embodiment, any one or combination of the following techniques, which are known in the art, may be used: a discrete logic circuit having a logic gate circuit for implementing a logic function on a data signal, an application specific integrated circuit having an appropriate combinational logic gate circuit, a Programmable Gate Array (PGA), a Field Programmable Gate Array (FPGA), or the like.

It will be understood by those skilled in the art that all or part of the steps carried by the method for implementing the above embodiments may be implemented by hardware related to instructions of a program, which may be stored in a computer readable storage medium, and when the program is executed, the program includes one or a combination of the steps of the method embodiments.

In addition, functional units in the embodiments of the present disclosure may be integrated into one processing module, or each unit may exist alone physically, or two or more units are integrated into one module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional module mode. The integrated module, if implemented in the form of a software functional module and sold or used as a stand-alone product, may also be stored in a computer readable storage medium.

The storage medium mentioned above may be a read-only memory, a magnetic or optical disk, etc. Although embodiments of the present disclosure have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting the present disclosure, and that changes, modifications, substitutions and alterations may be made to the above embodiments by those of ordinary skill in the art within the scope of the present disclosure.

Claims

1. A method of editing a form, comprising:

acquiring a form data input request, wherein the request comprises the position information of a first cell;

generating and displaying a first input interface corresponding to the first cell according to the position information of the first cell;

and determining the content of the first cell according to the content input in the first input interface by the user.

2. The method of claim 1, wherein the generating and presenting a first input interface corresponding to the first cell according to the location information of the first cell comprises:

3. The method of claim 2, wherein before the obtaining the first attribute field corresponding to the first cell, further comprising:

4. The method of claim 1, wherein after obtaining the form data entry request, further comprising:

5. The method of any of claims 1-4, wherein after determining the content of the first cell, further comprising:

and if the editing request for the first cell is acquired, generating and displaying an editing interface containing the content of the first cell.

6. The method of claim 5, wherein the obtaining the edit request for the first cell comprises:

7. The method of claim 5, wherein after generating and presenting the editing interface containing the content of the first cell, further comprising:

determining a third cell to be displayed by the editing interface according to the direction of the sliding operation executed by the user on the editing interface;

and displaying the content of the third cell on the editing interface.

8. A form editing apparatus, comprising:

the acquisition module is used for acquiring a table data input request, wherein the request comprises the position information of a first cell;

the generating module is used for generating and displaying a first input interface corresponding to the first cell according to the position information of the first cell;

and the determining module is used for determining the content of the first cell according to the content input in the first input interface by the user.

9. An electronic device comprising a processor and a memory;

wherein the processor executes a program corresponding to the executable program code by reading the executable program code stored in the memory for implementing the table editing method as claimed in any one of claims 1 to 7.

10. A non-transitory computer readable storage medium having stored thereon a computer program, wherein the program, when executed by a processor, implements the form editing method of any one of claims 1-7.