Table operation method and device

Abstract

The invention discloses a table operation method and device, and belongs to the technical field of communication. The method comprises the steps that under the condition that a to-be-processed table and an operation area of the to-be-processed table are displayed, first input of a user for table cell identifiers in the operation area of the to-be-processed table is received, the to-be-processed table comprises N rows and M columns of table cells, N and M are positive integers, and N is a positive integer; the cell identifier is used for indicating a to-be-processed cell in a to-be-processed table; and in response to the first input, executing a target operation on the to-be-processed cell, the target operation including at least one of a display operation and a target editing operation.

Description

Technical Field

[0001] This application belongs to the field of communication technology, specifically relating to a table operation method and apparatus. Background Technology

[0002] With the development of communication technology, mobile electronic devices such as smartphones and tablets have been deeply integrated into the office environment. Users can quickly browse or edit spreadsheets during business trips or leisure time by using the spreadsheet engine built into the operating system (OS) of these electronic devices, thus meeting the needs of mobile office work.

[0003] However, mobile electronic devices often have small screen sizes, resulting in fewer cells that can be displayed and a smaller display area for each cell. Especially when the number of rows and columns in a table is large, users need to perform multiple zooming and swiping operations to locate the target cell. This process is cumbersome and prone to accidental touches, thus making electronic devices less efficient at operating tables. Summary of the Invention

[0004] The purpose of this application is to provide a table operation method and apparatus that can improve the efficiency of electronic devices in operating tables.

[0005] In a first aspect, embodiments of this application provide a table operation method, the method comprising: when displaying a table to be processed and an operation area of ​​the table to be processed, receiving a first input from a user on a cell identifier in the operation area of ​​the table to be processed, wherein the table to be processed comprises N rows and M columns of cells, wherein N and M are both positive integers, and the cell identifier is used to indicate the cell to be processed in the table to be processed; in response to the first input, performing a target operation on the cell to be processed, the target operation including at least one of the following: a display operation and a target editing operation.

[0006] Secondly, embodiments of this application provide a table manipulation device, comprising a receiving module and an execution module. The receiving module is configured to receive a first input from a user regarding cell identifiers in the operation area of ​​the table to be processed, while displaying a table to be processed and an operation area of ​​the table to be processed. The table to be processed comprises N rows and M columns of cells, where N and M are both positive integers, and the cell identifiers indicate the cells to be processed in the table. The execution module is configured to perform a target operation on the cells to be processed in response to the first input received by the receiving module. The target operation includes at least one of the following: a display operation and a target editing operation.

[0007] Thirdly, embodiments of this application provide an electronic device including a processor and a memory, wherein the memory stores programs or instructions executable on the processor, and the programs or instructions, when executed by the processor, implement the steps of the method described in the first aspect.

[0008] Fourthly, embodiments of this application provide a readable storage medium on which a program or instructions are stored, which, when executed by a processor, implement the steps of the method described in the first aspect.

[0009] Fifthly, embodiments of this application provide a chip, the chip including a processor and a communication interface, the communication interface being coupled to the processor, the processor being used to run programs or instructions to implement the method as described in the first aspect.

[0010] In a sixth aspect, embodiments of this application provide a computer program product stored in a storage medium, which is executed by at least one processor to implement the method described in the first aspect.

[0011] In this embodiment, the electronic device can receive a first input from a user regarding a cell identifier in the operation area of ​​the table to be processed, while displaying a table to be processed and the operation area of ​​the table to be processed. The table to be processed comprises N rows and M columns of cells, and the cell identifier indicates the cell to be processed within the table. In response to the first input, a target operation is performed on the cell to be processed. This target operation includes at least one of the following: a display operation and a target editing operation. In this solution, since the electronic device can receive user input regarding the cell identifier, and the cell identifier indicates the cell to be processed within the table to be processed, the electronic device can directly display the cell to be processed through the cell identifier and directly perform the target editing operation on the cell to be processed. This eliminates the need for multiple complex operations such as zooming and scrolling, shortens the operation time for locating the cell, and reduces the probability of accidental touches, thereby improving the efficiency of the electronic device in processing tables. Attached Figure Description

[0012] Figure 1 This is one of the flowcharts of the table operation method provided in the embodiments of this application;

[0013] Figure 2 This is one of the schematic diagrams of the operating area provided in the embodiments of this application;

[0014] Figure 3 This is a second schematic diagram of the operating area provided in the embodiments of this application;

[0015] Figure 4 This is the third schematic diagram of the operating area provided in the embodiments of this application;

[0016] Figure 5 This is the second flowchart of the table operation method provided in the embodiments of this application;

[0017] Figure 6 This is the fourth schematic diagram of the operating area provided in the embodiments of this application;

[0018] Figure 7 This is the fifth schematic diagram of the operating area provided in the embodiments of this application;

[0019] Figure 8 This is the sixth schematic diagram of the operating area provided in the embodiments of this application;

[0020] Figure 9 This is the third flowchart of the table operation method provided in the embodiments of this application;

[0021] Figure 10 This is the fourth flowchart of the table operation method provided in the embodiments of this application;

[0022] Figure 11 This is one of the schematic diagrams of the table control provided in the embodiments of this application;

[0023] Figure 12 This is the seventh schematic diagram of the operating area provided in the embodiments of this application;

[0024] Figure 13 This is a second schematic diagram of the table control provided in the embodiments of this application;

[0025] Figure 14 This is the eighth schematic diagram of the operating area provided in the embodiments of this application;

[0026] Figure 15 This is the ninth schematic diagram of the operating area provided in the embodiments of this application;

[0027] Figure 16 This is the tenth schematic diagram of the operating area provided in the embodiments of this application;

[0028] Figure 17 This is eleventh of the schematic diagrams of the operating area provided in the embodiments of this application;

[0029] Figure 18 This is a schematic diagram of the table operation device provided in the embodiments of this application;

[0030] Figure 19 This is a schematic diagram of the structure of the electronic device provided in the embodiments of this application;

[0031] Figure 20 This is a schematic diagram of the hardware structure of the electronic device provided in the embodiments of this application. Detailed Implementation

[0032] The technical solutions of the embodiments of this application will be clearly described below with reference to the accompanying drawings. Obviously, the described embodiments are only some, not all, of the embodiments of this application. All other embodiments obtained by those skilled in the art based on the embodiments of this application are within the scope of protection of this application.

[0033] The terms "first," "second," etc., used in the specification and claims of this application are used to distinguish similar objects and not to describe a specific order or sequence. It should be understood that such use of data can be interchanged where appropriate so that embodiments of this application can be implemented in orders other than those illustrated or described herein, and the objects distinguished by "first," "second," etc., are generally of the same class and the number of objects is not limited; for example, a first object can be one or more. Furthermore, in the specification and claims, "and / or" indicates at least one of the connected objects, and the character " / " generally indicates that the preceding and following objects are in an "or" relationship.

[0034] The terms "at least one," "at least one," etc., in this application refer to any one, any two, or a combination of two or more of the included objects. For example, at least one of a, b, and c can mean: "a," "b," "c," "a and b," "a and c," "b and c," and "a, b, and c," where a, b, and c can be single or multiple. Similarly, "at least two" refers to two or more, and its meaning is similar to that of "at least one."

[0035] The table operation method and apparatus provided in this application will be described in detail below with reference to the accompanying drawings, through specific embodiments and application scenarios.

[0036] The embodiments of this application can be applied to scenarios where tables are manipulated via electronic devices.

[0037] The table operation method provided in this application will be illustrated below using some specific scenarios as examples.

[0038] Scenario 1: A user is on a business trip and receives a report file containing dozens of lines of project data from a colleague. The user needs to quickly check and adjust the order of the data in the cramped seating space.

[0039] Scenario 2: A user is resting at home and using their smartphone to check their work progress when they receive a notification from their supervisor that they must immediately insert several new columns into the existing spreadsheet to supplement the indicator fields and complete the merging of cells across rows and columns.

[0040] Scenario 3: A user is using a tablet computer to present a project analysis table in a meeting room. Attendees raise project adjustment requests on the spot, and the user needs to efficiently modify specific cells.

[0041] It should be noted that scenarios 1 to 3 above are merely exemplary examples of some scenarios that may be applied to the embodiments of this application. In actual implementation, the embodiments of this application can also be applied to any possible scenario of demand table operations, and the embodiments of this application are not limited here.

[0042] This application provides a table operation method and apparatus. Since the electronic device can receive user input of cell identifiers, and the cell identifiers indicate the cells to be processed in the table, the electronic device can directly display the cells to be processed through the cell identifiers and directly perform target editing operations on the cells to be processed. This can save complex operations such as multiple zooming and sliding, shorten the operation time for locating cells and reduce the probability of accidental touches, thereby improving the efficiency of the electronic device in processing tables.

[0043] The execution subject of the table operation method provided in this application embodiment can be a table operation device, which can be an electronic device, or a functional module or functional entity in an electronic device. The following uses an electronic device as an example to illustrate the technical solution provided in this application embodiment.

[0044] Figure 1 A flowchart of a table manipulation method provided in an embodiment of this application is shown, such as... Figure 1 As shown, the table operation method provided in this application embodiment may include the following steps 101 and 102.

[0045] Step 101: With the table to be processed and the operation area of ​​the table to be processed displayed, receive the user's first input of the cell identifiers in the operation area of ​​the table to be processed.

[0046] In some embodiments of this application, the aforementioned table to be processed refers to a table that the user needs to edit or manipulate. This table may contain multiple cells, organizing data in rows and columns.

[0047] In some embodiments of this application, the table to be processed includes N rows and M columns of cells, where N and M are both positive integers.

[0048] In some embodiments of this application, the aforementioned operating area is a dedicated area on the screen of an electronic device used to receive user input commands. Within this area, the user can manipulate the table by inputting commands containing cell identifiers.

[0049] In some embodiments of this application, the aforementioned operation area can be a semi-transparent floating keyboard, which includes input controls and input boxes for inputting commands. Specifically, the input controls on the floating keyboard can include keys representing row and column numbers, such as number keys and letter keys. Users can input cell identifiers by clicking these keys, for example, entering "B3" to locate the cell in the 2nd column and 3rd row. Furthermore, the floating keyboard can also have editing controls, such as "Insert," "Delete," and "Merge," allowing users to directly perform target operations on selected cells or regions using these buttons.

[0050] In some embodiments of this application, the aforementioned operation area can also be the area where the input method interface is located, including input boxes for inputting commands, and commands can be input through the input controls built into the input method interface. Specifically, the top of the input method interface can display editing controls and input boxes similar to a floating keyboard, while the input controls on the keyboard, such as letter and number keys, can be mapped and associated with the columns and rows of the table, respectively. Users can input cell identifiers or operation commands through the input method interface to complete the editing operation of the table.

[0051] In some embodiments of this application, after a user opens a spreadsheet file, the electronic device can display the spreadsheet on the screen and display an operation area, allowing the user to perform operations on the spreadsheet by inputting information into the operation area.

[0052] In some embodiments of this application, the cell identifier is used to indicate the cell to be processed in the table to be processed.

[0053] In some embodiments of this application, the aforementioned cell identifier is a character combination used to uniquely identify a cell in a table. It can consist of a column identifier and a row identifier, such as using letters to represent column identifiers and numbers to represent row identifiers. For example, "A1" can represent the cell in the first row of the first column, and "B3" can represent the cell in the third row of the second column.

[0054] In some embodiments of this application, the cell to be processed refers to a specific cell in the table specified by a cell identifier entered by the user. The cell to be processed can be a single cell, or two or more cells. For example, "A1" represents the cell in the first row of the first column, "B" represents the cell in the second column, and "B3:C5" represents the cell range from the third row of the second column to the fifth row of the third column.

[0055] In some embodiments of this application, the first input is used to perform an operation on the cell to be processed indicated by the cell identifier. Specifically, after the user inputs an instruction containing the cell identifier through the operation area, the electronic device can perform an operation on the cell indicated by the cell identifier based on the instruction, such as insertion, deletion, merging, format adjustment, etc.

[0056] In some embodiments of this application, the aforementioned first input includes, but is not limited to: touch input by the user on the operation area using a touch device such as a finger or stylus, or a voice command input by the user, or a specific gesture input by the user, or other feasible inputs. The specific input can be determined according to actual usage needs, and this application embodiment does not impose limitations.

[0057] In some embodiments of this application, after an instruction containing a cell identifier is entered in the operation area, the electronic device can also display a confirmation control in the operation area, which is used to execute the instruction entered by the user.

[0058] In some embodiments of this application, the first input can be a click input to an input control in the operation area.

[0059] In some embodiments of this application, when a user needs to fill in and update information in a certain row or column of a table in an outdoor or non-office environment, if the table content is large and the user cannot quickly locate the information, the user can enter the row and column number of the cell. This allows the electronic device to automatically locate the cell containing that row and column in the table and display the text content therein in the operation area in the middle of the keyboard. The user can then directly and easily update the text content to complete the update, thereby achieving fast and convenient table editing.

[0060] For example, in some embodiments of this application, a mobile phone is used as an example electronic device. Figure 2 As shown, the phone displays Table 10, which includes the phone's display operation area 12. For example, if a user needs to view cell "B13", they can enter "B", "1", or "3" in the input box 15 of operation area 12, representing the cell in column B, row 13. Figure 3 As shown, this triggers the electronic device to display cell "B13" 16 and displays the information in cell "B13" 16 in the input box 15.

[0061] Step 102: The electronic device responds to the first input and performs the target operation on the cell to be processed.

[0062] In some embodiments of this application, the target operation described above includes at least one of the following: display operation and target editing operation.

[0063] In some embodiments of this application, the above-mentioned display operation refers to displaying a cell in a table, for example, directly locating the cell and highlighting it.

[0064] In some embodiments of this application, the above-mentioned editing operations refer to operations that directly modify cells in a table, such as inserting, deleting, merging cells, and modifying cell content.

[0065] In some embodiments of this application, the aforementioned target editing operation refers to a specific editing operation selected by the user.

[0066] In some embodiments of this application, the aforementioned target operation refers to a specific operation performed on a cell. Specifically, when the user-input instruction only contains a cell identifier and not an operation on the cell (i.e., the user only inputs the cell identifier through the input control and does not input an operation on the cell through the editing control), the electronic device can display the cell to be processed indicated by the cell identifier. Conversely, when the user-input instruction contains both a cell identifier and an operation on the cell (i.e., the user inputs the cell identifier through the input control and inputs an operation on the cell through the editing control), the electronic device can display the cell to be processed indicated by the cell identifier and perform the corresponding operation on the cell to be processed.

[0067] In some embodiments of this application, after receiving the user's first input, the electronic device can parse the input cell identifier and related instructions. If the user does not input any operation on the cell, the electronic device can confirm that the user's instruction is to display that cell. For example, if the user inputs "B3" and the instruction "insert row", the electronic device can identify the cell position corresponding to "B3" and understand that the user wants to perform the operation of inserting a row at that position.

[0068] In some embodiments of this application, after parsing the cell identifier and related instructions, the electronic device can locate a specific cell or cell range in the table and perform a target operation on the located cell according to the instructions input by the user.

[0069] For example, assuming the user-input cell identifier indicates a cell in the third row, then:

[0070] If the instruction is "insert", the electronic device can insert a line below the third line.

[0071] If the instruction is "merge", the electronic device can merge the selected cell range, i.e., the third row, into one cell.

[0072] If no other instructions are entered, the electronic device can scroll the selected cell into the visible area and highlight it.

[0073] Furthermore, by way of example, in combination Figure 3 ,like Figure 4 As shown, if a user needs to change the information in cell "B13" from 420 to 425, they can directly edit the information in cell "B13" in input box 15. After editing, the phone can directly display the updated information in cell "B13" and display the prompt message "Update content: Completed" in input box 15.

[0074] This application provides a method for quickly and conveniently accessing table information on a mobile terminal. The application scenario is when operating on a table with a large number of rows and columns. The electronic device can provide numbers and letters corresponding to rows and columns on a floating keyboard, and provide shortcut operations on the keyboard, thereby significantly reducing the cost of table operation.

[0075] This application provides a table operation method. Since the electronic device can receive user input of cell identifiers, and the cell identifiers indicate the cells to be processed in the table, the electronic device can directly display the cells to be processed through the cell identifiers and directly perform target editing operations on the cells to be processed. This can save complex operations such as multiple zooming and sliding, shorten the operation time for locating cells and reduce the probability of accidental touches, thereby improving the efficiency of the electronic device in processing tables.

[0076] In some embodiments of this application, the aforementioned operation area includes at least one editing control, each editing control being used to perform an editing operation. (Combined with...) Figure 1 ,like Figure 5 As shown, prior to step 101 above, the table operation method provided in this application embodiment further includes the following steps 201 and 202.

[0077] Step 201: The electronic device receives a second input from the user to a target edit control in at least one edit control.

[0078] In some embodiments of this application, the target editing control is a specific editing control selected by the user, that is, the editing control corresponding to the editing operation that the user needs to perform.

[0079] In some embodiments of this application, the second input is used to trigger the electronic device to perform the editing operation corresponding to the target editing control.

[0080] In some embodiments of this application, the second input includes, but is not limited to: touch input by the user using a touch device such as a finger or stylus to the target editing control, or voice commands input by the user, or specific gestures input by the user, or other feasible inputs. The specific input can be determined according to actual usage needs, and this application does not limit it.

[0081] In some embodiments of this application, the second input described above may be a user's click input on the target editing control.

[0082] Step 202: The electronic device responds to the second input and performs a target editing operation.

[0083] In some embodiments of this application, the above-mentioned target editing operation is the editing operation corresponding to the target editing control selected by the user, that is, the editing operation that the user needs to perform.

[0084] In some embodiments of this application, upon receiving a second input, the electronic device can perform a target editing operation corresponding to the target editing control selected by the user on the cell corresponding to the cell identifier.

[0085] In some embodiments of this application, the user can first click an operation option on the floating keyboard, such as "Insert", and then click the row number or column number to add a new row or column after that row or column. Similarly, for example, by clicking the "Merge" operation, the user can select the rows to be merged in sequence, and the selected row numbers will also be displayed in the operation area. Finally, the user can click the confirmation button on the keyboard to complete the table operation.

[0086] For example, combined Figure 2 ,like Figure 6 As shown, if a user wants to insert a new row, they can click the insert control 17 in the operation area 12, and then enter the row to be inserted in the input box 15. For example, if the user enters "7", it means inserting a row after the 7th row, and the phone can then insert a new row after the 7th row.

[0087] In this way, electronic devices can display clear editing controls for users to choose from, reducing the time users spend searching for functions in complex table menus and significantly improving operational efficiency.

[0088] In some embodiments of this application, before "performing the target operation on the cell to be processed" in step 102 above, the table operation method provided in this application embodiment further includes the following step 301, and the "performing the target operation on the cell to be processed" in step 102 above can be implemented by the following step 102a. It should be noted that the above steps 301 and 102a are not shown in the accompanying drawings.

[0089] Step 301: When cell identifiers are displayed in the operation area, the electronic device receives a third input from the user to the operation identifier in the operation area.

[0090] In some embodiments of this application, after the user enters a cell identifier, the electronic device can display the cell identifier in the operating area. In this way, the electronic device can allow the user to visually confirm whether the input is correct by displaying the cell identifier. If the user enters an incorrect identifier, it can be corrected promptly.

[0091] In some embodiments of this application, after a user inputs a cell identifier, the electronic device can locate the cell corresponding to that cell identifier and highlight those cells, thereby allowing the user to further confirm whether the input cell identifier is correct.

[0092] In some embodiments of this application, the above-mentioned operation identifier is used to indicate the target editing operation.

[0093] In some embodiments of this application, the operation identifiers mentioned above are symbols or instructions input by the user to specify the specific editing operation to be performed on the table. For example, "+" can represent an insertion operation, "-" can represent a deletion operation, "=" can represent a merge operation, and "()" can represent a multi-selection operation, etc. Each operation identifier corresponds to a specific target editing operation.

[0094] In some embodiments of this application, users can use the numeric and alphanumeric operations on the keyboard to quickly manipulate tables. Specifically: if the table has a large number of rows and columns and a lot of information, the mathematical operations of the numeric and alphanumeric keys on the keyboard can be cleverly used to represent the operations of the corresponding rows and columns, replacing the operation options on the keyboard. For example, symbols such as "+", "-", and "()" can be used to represent operations. For example, "+" represents insertion or merging. If it is "100+", it means adding one row after the 100th row. If it is "7+8", it means merging the 7th and 8th rows. "-" represents deleting a row or column. "()" is used to select multiple cells, rows, and columns.

[0095] In some embodiments of this application, the third input is used to perform a target editing operation on the cell corresponding to the cell identifier.

[0096] In some embodiments of this application, the aforementioned third input includes, but is not limited to: touch input by the user on the operating area using a touch device such as a finger or stylus, or voice commands input by the user, or specific gestures input by the user, or other feasible inputs. The specific input can be determined according to actual usage needs, and this application does not impose limitations.

[0097] In some embodiments of this application, the third input can be a user's click input on the target editing control.

[0098] Step 102a: The electronic device responds to the third input and performs a target editing operation on the cell to be processed.

[0099] In some embodiments of this application, after the electronic device receives a third input from the user, it can determine the corresponding cell to be processed based on the cell identifier entered by the user, determine the corresponding target editing operation through the operation identifier entered by the user, and then perform the target editing operation on the cell to be processed.

[0100] In some embodiments of this application, operation identifiers can be directly mapped to specific editing operations using simple symbols or characters. Users do not need to remember complex menu paths or function button locations; they can complete the operation simply by entering a simple identifier. This simplicity significantly reduces the learning cost, enabling users to quickly get started and efficiently complete table editing tasks.

[0101] It should be noted that the primary operation method for current mobile electronic devices is touch screen operation. Due to the characteristics of touch screen operation, only one row or column can be touched at a time. Therefore, mobile electronic devices can usually only select one row or column at a time, and cannot select multiple rows or columns simultaneously or sequentially for operations such as deletion or screenshotting. In this embodiment, the above-mentioned "()" symbols can solve this problem. For example, inputting (10, 20, 30) can represent that rows 10, 20, and 30 are selected simultaneously. Adding "+" at the end can represent inserting a row after rows 10, 20, and 30, and adding "-" at the end can represent deleting a row after rows 10, 20, and 30.

[0102] For example, such as Figure 7 As shown, assuming the phone displays Table 10, which includes an operation area 12, the phone displays an input box 15, a "+" operation identifier 18, a "-" operation identifier 19, and a "()" operation identifier 20 within the operation area 12. If the user needs to insert a row after row 7 and row 8 respectively, they can enter "(7, 8) +" in input box 15. Figure 7 ,like Figure 8 As shown, this triggers the phone to insert a line after the 7th and 8th lines respectively.

[0103] In some embodiments of this application, the use of operation identifiers allows electronic devices to flexibly adjust operation logic based on user input. Users can perform more complex operations by combining identifiers or inputting specific formats. For example, (10, 20, 30) represents that rows 10, 20, and 30 are selected simultaneously, and "(10, 20, 30)+" indicates that a row is inserted after rows 10, 20, and 30. This flexibility enables the system to adapt to various complex table editing needs, while also facilitating future functional expansion. If further functional expansion is required, simply adding new operation identifiers will perfectly adapt to the existing operation logic.

[0104] In this way, electronic devices can quickly locate the corresponding cell to be processed by entering the cell identifier in the operation area, and accurately perform the target editing operation on the cell to be processed by the operation identifier, reducing the steps for users in complex operations and improving the efficiency and accuracy of table operations.

[0105] In some embodiments of this application, combined with Figure 1 ,like Figure 9 As shown, prior to step 101 above, the table operation method provided in this application embodiment further includes the following steps 401 and 402.

[0106] Step 401: When the table to be processed is displayed, the electronic device determines whether the table to be processed meets the first condition.

[0107] In some embodiments of this application, the first condition includes at least one of the following: the number of rows N of the table to be processed is greater than or equal to the number of rows threshold, and the number of columns M of the table to be processed is greater than or equal to the number of columns threshold.

[0108] In some embodiments of this application, the above-mentioned row number threshold is a threshold used to determine whether the number of rows in a table affects the user's browsing and operation.

[0109] In some embodiments of this application, the aforementioned row count threshold can be the default value of the electronic device or a value preset by the user. For example, the aforementioned row count threshold can be 10, 15, 20, etc. The specific threshold can be determined according to actual usage requirements, and this application embodiment does not impose any limitations.

[0110] In some embodiments of this application, the above column number threshold is a threshold used to determine whether the number of rows in a table affects the user's browsing and operation.

[0111] In some embodiments of this application, the above-mentioned column number threshold can be the default value of the electronic device or a value preset by the user. For example, the above-mentioned row number threshold can be 10, 15, 20, etc. The specific threshold can be determined according to actual usage requirements, and this application embodiment does not impose any limitations.

[0112] In some embodiments of this application, the electronic device can set row number thresholds and column number thresholds according to the screen size. For example, if the table scaling factor is 1, and the number of rows is greater than or equal to 10, it will exceed the display range of the screen, then the row number threshold can be set to 10; if the number of columns is greater than or equal to 8, it will exceed the display range of the screen, then the column number threshold can be set to 8.

[0113] In some embodiments of this application, after a user opens a spreadsheet file, the electronic device can display the spreadsheet to be processed on the screen, and the electronic device can obtain the number of rows N and columns M of the spreadsheet to be processed. This information can be obtained from the metadata of the spreadsheet file, or it can be directly calculated from the structure of the spreadsheet to be processed.

[0114] In some embodiments of this application, after the electronic device obtains the number of rows N and the number of columns M of the table to be processed, it can compare the number of rows N with a preset row count threshold, and simultaneously compare the number of columns M with a preset column count threshold, to determine whether the table to be processed meets the first condition. The specific determination logic is as follows:

[0115] If the number of rows N is greater than or equal to the number of rows threshold, or the number of columns M is greater than or equal to the number of columns threshold, the electronic device determines that the table to be processed meets the first condition;

[0116] If the number of rows N is less than the number of rows threshold and the number of columns M is less than the number of columns threshold, the electronic device can determine that the table to be processed does not meet the first condition.

[0117] Step 402: If the table to be processed meets the first condition, the electronic device displays the operation area.

[0118] In some embodiments of this application, if the table to be processed meets the first condition, it means that the table is complex enough and requires an additional operating area to assist the user in performing efficient operations. Therefore, the electronic device can display the operating area to assist the user in performing operations.

[0119] In some embodiments of this application, users can configure the spreadsheet program so that when the number of rows or columns in the spreadsheet opened on the electronic device is large—for example, by setting a first threshold for the number of rows and a second threshold for the number of columns—if the number of rows exceeds the first threshold or the number of columns exceeds the second threshold, the electronic device can determine that the spreadsheet cannot be fully displayed, and thus automatically display a floating keyboard for spreadsheet operations. After setting this, when users open the spreadsheet, they do not need to manually click the "Quick Edit" option to display the floating keyboard, further reducing the user's spreadsheet operation costs.

[0120] In this way, electronic devices can automatically identify whether the user needs additional operational assistance by determining whether the table to be processed meets the first condition. This not only avoids unnecessary display of operation areas in simple table scenarios, saving screen space and system resources, but also ensures that the operation area is automatically displayed in complex table scenarios, saving the user the steps of triggering the operation area display. Thus, electronic devices can flexibly adapt to table operation needs of varying complexity, improving the flexibility of electronic devices in operating tables.

[0121] In some embodiments of this application, combined with Figure 1 ,like Figure 10 As shown, before step 101 above, the table operation method provided in this application embodiment further includes steps 501 to 504 as described below.

[0122] Step 501: When the table to be processed is displayed, the electronic device receives a fourth input from the user to the table control.

[0123] In some embodiments of this application, the aforementioned table control refers to a functional control used to display the operation area.

[0124] In some embodiments of this application, the above-mentioned table control can be displayed in the table to be processed, for example, at the top of the table to be processed.

[0125] In some embodiments of this application, the electronic device may display a "Quick Edit" option, i.e., a table control, at the top of the table to be processed. If the user has a large number of rows and columns in the opened table and needs to edit the content in more detail, they can click this option. After the user clicks this option, the table program analyzes the number of rows and columns, and then a semi-transparent table keyboard appears floating on the table page. The keyboard contains numbers representing the number of rows, letters representing the number of columns, and basic operation options such as "Insert," "Cut," and "Merge."

[0126] For example, such as Figure 11 As shown, the user opens a table 10. At the top of table 10 is a "Quick Edit" option 11, which is the table control. If the table has many rows and columns and the user wants to display the operating area, they can click the "Quick Edit" option 11. Figure 11 ,like Figure 12 As shown, this triggers the phone to display the operation area 12.

[0127] In some embodiments of this application, the floating keyboard is designed to reduce obstruction of table content while providing clear operation guidance. Users can also adjust the size and position of the floating keyboard through gestures to optimize the operating experience.

[0128] In some embodiments of this application, the above-mentioned table control can be displayed in the input method interface, such as at the top of the input method interface.

[0129] In some embodiments of this application, the input method interface described above is an interface for inputting text, which can automatically pop up when the user needs to input text. In embodiments of this application, the input method interface can display a table control to switch to table mode and display an operation area to facilitate user operation of the table.

[0130] In some embodiments of this application, electronic devices can leverage the feature that the system's built-in input method keyboard appears when a user edits table content. A "table mode" option, i.e., a table control, can be added to the system's built-in input method keyboard. Users can click on "table mode" to edit tables on the input method keyboard. The advantage of this is that it does not affect the table area occupancy, and the input method keyboard itself appears when the table content is edited without adding extra jump costs. In addition, table editing itself is a system capability, and the input method is also a built-in system capability, so there is no need to add third-party adaptation costs, which has high system scenario application value.

[0131] For example, such as Figure 13 As shown, the phone displays table 10. When the user triggers the phone to display the system input method interface 13 on table 10, the phone detects that the current screen is a table, and then adds a "Table Mode" option 14, i.e., a table control, to the input method interface 13. Combined with... Figure 13 ,like Figure 14 As shown, after the user clicks the "Table Mode" option 14, table operation options such as "Merge," "Copy," and "Insert" will appear at the top of the input method keyboard. The letters on the input method keyboard are mapped one-to-one with the column letters in the table. Clicking the "Number" control on the input method keyboard switches to a numeric input keyboard, where the numeric keypad is mapped one-to-one with the table row numbers. To edit table rows and columns, the user can click the table operation options at the top of the input method keyboard and then click a letter or number on the keyboard to select the row or column. Figure 14 ,like Figure 15 As shown, if the user needs to make in-depth adjustments to the table, the operation area, i.e., the input box 15, can also be displayed at the top of the input method keyboard. If the user needs to exit the table editing mode and return to the input method keyboard input mode, they can click the "Table Mode" option 14 again to trigger the electronic device to exit table mode editing.

[0132] In some embodiments of this application, the electronic device can combine the system input method keyboard that appears when editing table content, integrating table operations with the system's built-in input method keyboard to enhance the convenience of editing office documents.

[0133] In some embodiments of this application, the design of adding a table mode to the input method interface makes full use of the layout and functions of the system's built-in input method keyboard, without taking up additional screen space, and avoids frequent switching between different operation interfaces, thereby improving the continuity and efficiency of operation.

[0134] In some embodiments of this application, the fourth input described above is used to trigger the electronic device to display the operation area.

[0135] In some embodiments of this application, the aforementioned fourth input includes, but is not limited to: touch input of the table control by the user using a touch device such as a finger or stylus, or voice commands input by the user, or specific gestures input by the user, or other feasible inputs. The specific input can be determined according to actual usage needs, and this application does not limit it.

[0136] In some embodiments of this application, the above-mentioned touch input can be single-click input, double-click input, or any number of clicks, or it can be long-press input or short-press input.

[0137] In some embodiments of this application, the specific gesture mentioned above can be any one of a single-click gesture, a swipe gesture, a drag gesture, a pressure recognition gesture, a long-press gesture, an area change gesture, a double-press gesture, or a double-tap gesture.

[0138] In some embodiments of this application, the fourth input can be a user's click input on the table control.

[0139] Step 502: The electronic device responds to the fourth input and displays the operation area.

[0140] In some embodiments of this application, the electronic device may display an operating area upon receiving a fourth input from the user to the table control.

[0141] In some embodiments of this application, if a table control is displayed in the input method interface, the electronic device can display an operation area at the top of the input method interface, and the user can directly input cell identifiers or perform table operations through the input controls in the input method interface.

[0142] In some embodiments of this application, if the table control is displayed directly in the table to be processed, the electronic device can display the operation area in the form of a floating keyboard, and the user can directly input cell identifiers or perform table operations through the input controls in the floating keyboard.

[0143] In this way, when users need to perform table operations, they only need to click on the table control to trigger the electronic device to display the operation area. This allows the operation area to be displayed promptly when users need to use its functions to quickly operate on the table, thus improving the flexibility of the operation area display.

[0144] Step 503: The electronic device receives the user's fifth input to the operation area.

[0145] In some embodiments of this application, the fifth input is used to adjust the display parameters of the operation area.

[0146] In some embodiments of this application, the above-mentioned display parameters refer to the display characteristics of the operating area, such as size and position.

[0147] In some embodiments of this application, the aforementioned fifth input includes, but is not limited to: touch input by the user on the operating area using a touch device such as a finger or stylus, or voice commands input by the user, or specific gestures input by the user, or other feasible inputs. The specific input can be determined according to actual usage needs, and this application does not impose limitations.

[0148] In some embodiments of this application, when the above-mentioned display parameter is size, the above-mentioned fifth input can be a two-finger swipe input by the user on the operation area.

[0149] For example, if the user wants to reduce the size of the operating area, the fifth input can be a two-finger touch on the operating area and a swipe input that moves towards the middle of the two fingers.

[0150] For example, if the user wants to enlarge the size of the operating area, the fifth input can be a swipe input that involves touching the operating area with two fingers and extending outwards from the two fingers.

[0151] In some embodiments of this application, when the displayed parameter is a position, the fifth input can be a single-finger swipe input by the user on the operation area. The user can long-press the operation area and swipe it to the desired position until the operation area moves to that position.

[0152] Step 504: The electronic device responds to the fifth input and adjusts the display parameters of the operation area according to the input parameters of the fifth input.

[0153] In some embodiments of this application, the input parameters of the fifth input mentioned above refer to specific parameters input by the user, such as the type, direction, and amplitude of the gesture. These parameters determine how the user wishes to adjust the display of the operation area.

[0154] In some embodiments of this application, after receiving a fifth input from the user, the electronic device can adjust the display parameters of the operating area according to the input parameters of the fifth input.

[0155] For example, when a user adjusts the size of the operating area using a two-finger zoom gesture, the electronic device can dynamically change the size of the operating area, making it larger or smaller.

[0156] For example, if a user adjusts the position of the operating area by dragging with a single finger, the electronic device can move the operating area to the user-specified location, such as the top, bottom, or side of the screen.

[0157] In some embodiments of this application, users can adjust the size or position of the floating keyboard area by performing gesture input on the floating keyboard area.

[0158] In some embodiments of this application, a user can press and hold the floating keyboard with two fingers, and then move the two fingers left and right or up and down to increase the distance between them. After the system detects the user's gesture, it dynamically adjusts the size of the floating keyboard according to the distance the two fingers drag.

[0159] For example, combined Figure 12 ,like Figure 16 As shown, users can long-press the operation area 12 with two fingers and then slide to input data outwards from the two fingers, such as... Figure 17 As shown, this triggers the phone to zoom in on the display area 12.

[0160] In some embodiments of this application, users can long-press the floating keyboard with a single finger and then drag it to the desired position to prevent the floating keyboard from obscuring the table content that the user needs to view.

[0161] In this way, users can directly adjust the size and position of the operation area according to their needs and screen space through simple gestures or commands, avoiding the operation area from obscuring the table content and keeping the operation area in the most comfortable and efficient position, thus improving the flexibility of the operation area display.

[0162] The purpose of this application is to provide a method for quickly editing table information on a mobile terminal, which is suitable for scenarios with a significantly large number of rows and columns in the table. This solution has obvious advantages, and the specific improvements are as follows:

[0163] 1. A semi-transparent floating keyboard appears on the table page, with numbers and letters that correspond to the rows and columns of the table, forming a correspondence that facilitates the selection and positioning of the table later.

[0164] 2. The floating keyboard provides operation options, which can be combined with numbers and letters to quickly perform operations on the table.

[0165] 3. The floating keyboard provides an operation display area, which can perform mathematical operations on the numbers and letters representing the table to replace the table operations, making it more in line with the user's operating habits.

[0166] The embodiments of this application enable rapid updates to table content and operations on table cells via a floating keyboard in scenarios with a large number of rows and columns. Table cells and content can also be quickly edited using numerical and alphanumeric operations, demonstrating high innovation and application value.

[0167] Each of the above-described method embodiments, or various possible implementations of each method embodiment, can be executed individually or in combination of any two or more. The specific implementation can be determined according to actual usage requirements, and this application does not impose any restrictions on this.

[0168] The table manipulation method provided in this application can be executed by a table manipulation device. This application uses a table manipulation device executing the table manipulation method as an example to illustrate the table manipulation device provided in this application.

[0169] Figure 18 A schematic diagram of a possible structure of a table manipulation device involved in some embodiments of this application is shown. For example... Figure 18 As shown, the table operation device 70 may include a receiving module 71 and an execution module 72.

[0170] The receiving module 71 described above is used to receive a first input from a user on a cell identifier in the operation area of ​​the table to be processed when the table to be processed and the operation area of ​​the table to be processed are displayed. The table to be processed includes N rows and M columns of cells, where N and M are both positive integers. The cell identifier is used to indicate the cell to be processed in the table to be processed.

[0171] The execution module 72 is used to perform a target operation on the cell to be processed in response to the first input received by the receiving module 71. The target operation includes at least one of the following: display operation and target editing operation.

[0172] In one possible implementation, the aforementioned operation area includes at least one editing control, each editing control being used to perform an editing operation. The receiving module 71 is further configured to receive a second input from the user onto a target editing control within the at least one editing control before receiving the user's first input onto a cell identifier in the operation area of ​​the table to be processed. The execution module is configured to execute the target editing operation in response to the second input received by the receiving module 71.

[0173] In one possible implementation, the receiving module 71 is further configured to receive a third input from the user to an input operation identifier in the operation area, provided that the cell identifier is displayed in the operation area before the execution module 72 performs the target operation on the cell to be processed. This operation identifier is used to indicate the target editing operation. Specifically, the execution module 72 is configured to perform the target editing operation on the cell to be processed in response to the third input received by the receiving module 71.

[0174] In one possible implementation, the table manipulation device provided in this application embodiment further includes a determining module and a display module. The determining module is configured to, before receiving a first input from a user regarding cell identifiers in the operation area of ​​the table to be processed, determine whether the table to be processed satisfies a first condition, wherein the first condition includes at least one of the following: the number of rows N of the table to be processed is greater than or equal to a row count threshold, and the number of columns M of the table to be processed is greater than or equal to a column count threshold. The display module is configured to display the operation area if the table to be processed satisfies the first condition.

[0175] In one possible implementation, the table operation device provided in this application embodiment further includes a display module. The receiving module 71 is further configured to receive a fourth input from the user to the table controls, while the table to be processed is displayed, before receiving a first input from the user to the cell identifiers in the operation area of ​​the table to be processed. The display module is configured to display the operation area in response to the fourth input. The receiving module 71 is further configured to receive a fifth input from the user to the operation area. The execution module 72 is further configured to adjust the display parameters of the operation area according to the input parameters of the fifth input, in response to the fifth input received by the receiving module.

[0176] This application provides a table operation device. Since the table operation device can receive user input of cell identifiers, and the cell identifiers indicate the cells to be processed in the table, the table operation device can directly display the cells to be processed through the cell identifiers and directly perform target editing operations on the cells to be processed. This can save multiple complex operations such as scaling and sliding, shorten the operation time for locating cells and reduce the probability of accidental touches, thereby improving the efficiency of the table operation device in processing tables.

[0177] The form operation device in this application embodiment can be an electronic device or a component within an electronic device, such as an integrated circuit or a chip. The electronic device can be a terminal or other devices besides a terminal. For example, the electronic device can be a mobile phone, tablet computer, laptop computer, PDA, in-vehicle electronic device, mobile internet device (MID), augmented reality (AR) / virtual reality (VR) device, robot, wearable device, ultra-mobile personal computer (UMPC), netbook, or personal digital assistant (PDA), etc. It can also be a server, network attached storage (NAS), personal computer (PC), television (TV), ATM, or self-service machine, etc. This application embodiment does not specifically limit the specific device.

[0178] The table operation device in this application embodiment can be a device with an operating system. This operating system can be Android, iOS, or other possible operating systems; this application embodiment does not specifically limit the specific operating system used.

[0179] The table operation device provided in this application embodiment can implement the various processes implemented in the above method embodiments, and will not be described again here to avoid repetition.

[0180] Optionally, such as Figure 19 As shown, this application embodiment also provides an electronic device 1000, including a processor 1001 and a memory 1002. The memory 1002 stores a program or instructions that can run on the processor 1001. When the program or instructions are executed by the processor 1001, they implement the various steps of the above-described table operation method embodiment and can achieve the same technical effect. To avoid repetition, they will not be described again here.

[0181] It should be noted that the electronic devices in the embodiments of this application include the mobile electronic devices and non-mobile electronic devices described above.

[0182] Figure 20 A schematic diagram of the hardware structure of an electronic device to implement an embodiment of this application.

[0183] The electronic device 100 includes, but is not limited to, components such as: radio frequency unit 101, network module 102, audio output unit 103, input unit 104, sensor 105, display unit 106, user input unit 107, interface unit 108, memory 109, and processor 110.

[0184] Those skilled in the art will understand that the electronic device 100 may also include a power supply (such as a battery) for supplying power to various components. The power supply may be logically connected to the processor 110 through a power management system, thereby enabling functions such as managing charging, discharging, and power consumption through the power management system. Figure 20 The electronic device structure shown does not constitute a limitation on the electronic device. The electronic device may include more or fewer components than shown, or combine certain components, or have different component arrangements, which will not be elaborated here.

[0185] The user input unit 107 is used to receive a first input from the user on the cell identifier in the operation area of ​​the table to be processed when the table to be processed and the operation area of ​​the table to be processed are displayed. The table to be processed includes N rows and M columns of cells, where N and M are both positive integers. The cell identifier is used to indicate the cell to be processed in the table to be processed.

[0186] The processor 110 described above is configured to perform a target operation on the cell to be processed in response to a first input, the target operation including at least one of the following: a display operation and a target editing operation.

[0187] Optionally, the aforementioned operation area includes at least one editing control, each editing control being used to perform an editing operation. The user input unit 107 is further configured to receive a second input from the user to a target editing control among the at least one editing controls before receiving a first input from the user to a cell identifier in the operation area of ​​the table to be processed. The execution module is further configured to, in response to the second input, determine the editing operation corresponding to the target editing control as the target editing operation.

[0188] Optionally, the user input unit 107 is further configured to receive a third input from the user regarding an input operation identifier in the operation area, provided that a cell identifier is displayed in the operation area before performing a target operation on the cell to be processed. This operation identifier is used to indicate the target editing operation. Specifically, the processor 110 is configured to perform the target editing operation on the cell to be processed in response to the third input.

[0189] Optionally, the processor 110 is further configured to, when displaying a table to be processed, determine whether the table to be processed meets a first condition, the first condition including at least one of the following: the number of rows N of the table to be processed is greater than or equal to a row number threshold, and the number of columns M of the table to be processed is greater than or equal to a column number threshold. The display unit 106 is further configured to display an operation area when the table to be processed meets the first condition.

[0190] Optionally, the user input unit 107 is further configured to receive a fourth input from the user to the table control before receiving the first input from the user to the cell identifier in the operation area of ​​the table to be processed, while the table to be processed is displayed. The display unit 106 is configured to display the operation area in response to the fourth input. The user input unit 107 is further configured to receive a fifth input from the user to the operation area after displaying the table to be processed and the operation area. The processor 110 is further configured to adjust the display parameters of the operation area according to the input parameters of the fifth input in response to the fifth input.

[0191] This application provides an electronic device that can receive user input of cell identifiers, and the cell identifiers indicate the cells to be processed in the table to be processed. Therefore, the electronic device can directly display the cells to be processed through the cell identifiers and directly perform target editing operations on the cells to be processed. This can save complex operations such as multiple zooming and sliding, shorten the operation time for locating cells and reduce the probability of accidental touches, thereby improving the efficiency of the electronic device in processing tables.

[0192] The electronic device provided in this application embodiment can implement all the processes implemented in the above method embodiments and achieve the same technical effects. To avoid repetition, it will not be described again here. The beneficial effects of the various implementation methods in this embodiment can be found in the beneficial effects of the corresponding implementation methods in the above method embodiments. To avoid repetition, it will not be described again here.

[0193] It should be understood that, in this embodiment, the input unit 104 may include a graphics processing unit (GPU) 1041 and a microphone 1042. The GPU 1041 processes image data of still images or videos obtained by an image capture device (such as a camera) in video capture mode or image capture mode. The display unit 106 may include a display panel 1061, which may be configured in the form of a liquid crystal display, an organic light-emitting diode, or the like. The user input unit 107 includes at least one of a touch panel 1071 and other input devices 1072. The touch panel 1071 is also called a touch screen. The touch panel 1071 may include a touch detection device and a touch controller. Other input devices 1072 may include, but are not limited to, physical keyboards, function keys (such as volume control buttons, power buttons, etc.), trackballs, mice, and joysticks, which will not be described in detail here.

[0194] The memory 109 can be used to store software programs and various data. The memory 109 may primarily include a first storage area for storing programs or instructions and a second storage area for storing data. The first storage area may store the operating system, application programs or instructions required for at least one function (such as sound playback, image playback, etc.). Furthermore, the memory 109 may include volatile memory or non-volatile memory, or both. The non-volatile memory may be read-only memory (ROM), programmable read-only memory (PROM), erasable programmable read-only memory (EPROM), electrically erasable programmable read-only memory (EEPROM), or flash memory. Volatile memory can be random access memory (RAM), static random access memory (SRAM), dynamic random access memory (DRAM), synchronous dynamic random access memory (SDRAM), double data rate synchronous dynamic random access memory (DDRSDRAM), enhanced synchronous dynamic random access memory (ESDRAM), synchronous link dynamic random access memory (SLDRAM), and direct memory bus RAM (DRRAM). The memory 109 in the embodiments of this application includes, but is not limited to, these and any other suitable types of memory.

[0195] Processor 110 may include one or more processing units; optionally, processor 110 integrates an application processor and a modem processor, wherein the application processor mainly handles operations involving the operating system, user interface, and applications, and the modem processor mainly handles wireless communication signals, such as a baseband processor. It is understood that the aforementioned modem processor may also not be integrated into processor 110.

[0196] This application also provides a readable storage medium storing a program or instructions. When the program or instructions are executed by a processor, they implement the various processes of the above-described table operation method embodiments and achieve the same technical effect. To avoid repetition, they will not be described again here.

[0197] The processor is the processor in the electronic device described in the above embodiments. The readable storage medium includes computer-readable storage media, such as computer read-only memory (ROM), random access memory (RAM), magnetic disk, or optical disk.

[0198] This application embodiment also provides a chip, which includes a processor and a communication interface. The communication interface is coupled to the processor. The processor is used to run programs or instructions to implement the various processes of the above table operation method embodiment and can achieve the same technical effect. To avoid repetition, it will not be described again here.

[0199] It should be understood that the chip mentioned in the embodiments of this application may also be referred to as a system-on-a-chip, system chip, chip system, or system-on-a-chip, etc.

[0200] This application provides a computer program product, which is stored in a storage medium and executed by at least one processor to implement the various processes of the above-described table operation method embodiments, and can achieve the same technical effect. To avoid repetition, it will not be described again here.

[0201] It should be noted that, in this document, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or apparatus. Without further limitations, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes that element. Furthermore, it should be noted that the scope of the methods and apparatuses in the embodiments of this application is not limited to performing functions in the order shown or discussed, but may also include performing functions substantially simultaneously or in the reverse order, depending on the functions involved. For example, the described methods may be performed in a different order than described, and various steps may be added, omitted, or combined. Additionally, features described with reference to certain examples may be combined in other examples.

[0202] Through the above description of the embodiments, those skilled in the art can clearly understand that the methods of the above embodiments can be implemented by means of software plus necessary general-purpose hardware platforms. Of course, they can also be implemented by hardware, but in many cases the former is a better implementation method. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, can be embodied in the form of a computer software product. This computer software product is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk) and includes several instructions to cause a terminal (which may be a mobile phone, computer, server, or network device, etc.) to execute the methods described in the various embodiments of this application.

[0203] The embodiments of this application have been described above with reference to the accompanying drawings. However, this application is not limited to the specific embodiments described above. The specific embodiments described above are merely illustrative and not restrictive. Those skilled in the art can make many other forms under the guidance of this application without departing from the spirit and scope of the claims, and all of these forms are within the protection scope of this application.

Claims

1. A table manipulation method, characterized in that, include: When displaying the table to be processed and the operation area of ​​the table to be processed, the user's first input on the cell identifier in the operation area of ​​the table to be processed is received, wherein the table to be processed includes N rows and M columns of cells, where N and M are both positive integers, and the cell identifier is used to indicate the cell to be processed in the table to be processed; In response to the first input, a target operation is performed on the cell to be processed, the target operation including at least one of the following: display operation, target editing operation.

2. The method according to claim 1, characterized in that, The operation area includes at least one editing control, and each editing control is used to perform an editing operation; Prior to receiving the user's first input regarding cell identifiers in the operation area of ​​the table to be processed, the method further includes: Receive a second input from the user to a target edit control in the at least one edit control; The target editing operation is performed in response to the second input.

3. The method according to claim 1, characterized in that, Before performing the target operation on the cell to be processed, the method further includes: When the cell identifier is displayed in the operation area. Receive a third input from the user regarding an operation identifier in the operation area, the operation identifier being used to indicate the target editing operation; The step of performing the target operation on the cell to be processed includes: In response to the third input, the target editing operation is performed on the cell to be processed.

4. The method according to claim 1, characterized in that, Before receiving the user's first input on the cell identifiers in the operation area of ​​the table to be processed, the method further includes: When the table to be processed is displayed, it is determined whether the table to be processed meets a first condition, the first condition including at least one of the following: The number of rows N of the table to be processed is greater than or equal to the number of rows threshold, and the number of columns M of the table to be processed is greater than or equal to the number of columns threshold; If the table to be processed meets the first condition, the operation area is displayed.

5. The method according to claim 1, characterized in that, Before receiving the user's first input on the cell identifiers in the operation area of ​​the table to be processed, the method further includes: While the table to be processed is displayed, a fourth input from the user is received; In response to the fourth input, the operation area is displayed; Receive the user's fifth input to the operation area; In response to the fifth input, the display parameters of the operation area are adjusted according to the input parameters of the fifth input.

6. A table operation device, characterized in that, include: Receive module and execution module; The receiving module is configured to receive a first input from a user on a cell identifier in the operation area of ​​the table to be processed when the table to be processed and the operation area of ​​the table to be processed are displayed. The table to be processed includes N rows and M columns of cells, where N and M are both positive integers. The cell identifier is used to indicate the cell to be processed in the table to be processed. The execution module is configured to perform a target operation on the cell to be processed in response to the first input received by the receiving module. The target operation includes at least one of the following: a display operation and a target editing operation.

7. The apparatus according to claim 6, characterized in that, The operation area includes at least one editing control, and each editing control is used to perform an editing operation; The receiving module is further configured to receive a second input from the user to a target editing control in the at least one editing control before receiving a first input from the user to a cell identifier in the operation area of ​​the table to be processed; The execution module is further configured to perform the target editing operation in response to the second input received by the receiving module.

8. The apparatus according to claim 6, characterized in that, The receiving module is further configured to receive a third input from the user on the operation identifier in the operation area before the execution module performs the target operation on the cell to be processed, when the cell identifier is displayed in the operation area, wherein the operation identifier is used to indicate the target editing operation; The execution module is specifically used to perform the target editing operation on the cell to be processed in response to the third input received by the receiving module.

9. The apparatus according to claim 6, characterized in that, The device further includes: a determining module and a display module; The determining module is configured to, before receiving a first input from the user regarding cell identifiers in the operation area of ​​the table to be processed, determine whether the table to be processed satisfies a first condition when the table to be processed is displayed. The first condition includes at least one of the following: the number of rows N of the table to be processed is greater than or equal to a row count threshold; the number of columns M of the table to be processed is greater than or equal to a column count threshold; and... The display module is used to display the operation area when the table to be processed meets the first condition.

10. The apparatus according to claim 6, characterized in that, The device further includes: a display module; The receiving module is further configured to receive a fourth input from the user to the table control before receiving the first input from the user to the cell identifier in the operation area of ​​the table to be processed, while the table to be processed is displayed; The display module is used to display the operation area in response to the fourth input; The receiving module is also used to receive a fifth input from the user to the operation area; The execution module is further configured to, in response to the fifth input received by the receiving module, adjust the display parameters of the operation area according to the input parameters of the fifth input.

Images