Table display method, device and medium

Abstract

The embodiment of the application discloses a table display method and device and medium, and belongs to the technical field of computers. The method comprises the following steps: in a table display interface, a target formula input in a target cell is displayed; in response to a first preset operation on a target sub-formula, an output value of the target sub-formula is acquired; and in the table display interface, the output value of the target sub-formula is displayed. The method can display the output value of the sub-formula in the formula, and is not limited to displaying the final value of the formula, thereby increasing the amount of information, enabling the user to know the output value of any sub-formula in the formula, expanding the function of the table, and improving the operation efficiency.

Description

Technical Field

[0001] This application relates to the field of computer technology, and in particular to a table display method, apparatus and medium. Background Technology

[0002] With the development of computer technology, spreadsheets have become a commonly used data processing tool, frequently used by users for data statistics. To improve the efficiency of data statistics, formulas can be entered into any cell to automatically calculate the value, eliminating the need for manual calculation. However, spreadsheets can only display the final value calculated by the formula, offering limited information and thus having functional limitations. Summary of the Invention

[0003] This application provides a table display method, apparatus, and medium, which expands the table display functionality. The technical solution is as follows:

[0004] On the one hand, a table display method is provided, the method including:

[0005] The table display interface shows the target formula entered in the target cell, where the target cell is the currently selected cell, and the target formula includes at least one function.

[0006] In response to a first preset operation on the target sub-formula, the output value of the target sub-formula is obtained, wherein the target sub-formula is a formula that is any part of the target formula;

[0007] The output value of the target sub-formula is displayed in the table display interface.

[0008] Optionally, the method further includes:

[0009] In response to a first preset operation on the target sub-formula, detailed information of the target sub-formula is displayed, the detailed information including at least a description of the target sub-formula.

[0010] Optionally, the target sub-formula is a target function, and the details information further includes at least one of the following: each element in the target function, the description information of each element, the example function corresponding to the target function, or the value currently referred to by each element.

[0011] Optionally, before displaying the target formula entered in the target cell in the table display interface, the method further includes:

[0012] In response to the selection operation of the target cell, the text data entered in the target cell is obtained;

[0013] The text data is converted into the target formula.

[0014] Optionally, converting the text data into the target formula includes:

[0015] The text data is subjected to function recognition to obtain multiple functions in the text data and the reference relationships between the multiple functions. The reference relationship between any two functions indicates that the output value of the referenced function is used as an element in the referenced function.

[0016] The target formula is determined based on the multiple functions and the reference relationships.

[0017] Optionally, the target formula includes multiple functions, each function including at least one cell identifier. After converting the text data into the target formula, the method further includes:

[0018] Obtain the value entered in the cell corresponding to the at least one cell identifier;

[0019] Based on the reference relationships between the multiple functions and at least one obtained value, the multiple functions are calculated sequentially to obtain the output value of each function.

[0020] On the other hand, a table display method apparatus is provided, the apparatus comprising:

[0021] The formula display module is used to display the target formula entered in the target cell in the table display interface. The target cell is the currently selected cell, and the target formula includes at least one function.

[0022] The output value acquisition module is used to acquire the output value of the target sub-formula in response to a first preset operation on the target sub-formula, wherein the target sub-formula is any part of the target formula;

[0023] The output value display module is used to display the output value of the target sub-formula in the table display interface.

[0024] Optionally, the output value display module is used for:

[0025] The output value is displayed in the display area corresponding to the target sub-formula in the table display interface; or...

[0026] The output value and an indicator mark pointing to the output value from the target sub-formula are displayed in any display area of ​​the table display interface.

[0027] Optionally, the output value display module is used to display the target formula in the formula display area of ​​the table display interface; or,

[0028] The target formula is displayed in the display area where the target cell is located.

[0029] Optionally, the output value acquisition module is used to acquire the output value of the target sub-formula in the region in response to the selection operation of any region in the target formula.

[0030] Optionally, the target sub-formula is an objective function, and the output value acquisition module is used for:

[0031] In response to the mouse pointer hovering over the display area of ​​the target function, the output value of the target function is obtained; or,

[0032] In response to the cursor position being within the objective function, obtain the output value of the objective function; or...

[0033] When the cursor is located in another function, in response to the operation of hovering the mouse pointer over the display area of ​​the target function, the output value of the target function is obtained.

[0034] Optionally, the target sub-formula is a target function, the target function includes a target function identifier, and the output value acquisition module is used for:

[0035] In response to the mouse pointer hovering over the display area of ​​the target function identifier, the output value of the target function is obtained; or,

[0036] If the cursor position is within another function, in response to the operation of hovering the mouse pointer over the display area identified by the target function, the output value of the target function is obtained.

[0037] Optionally, the device further includes:

[0038] The details display module is used to display detailed information of the target sub-formula in response to a first preset operation on the target sub-formula, wherein the detailed information includes at least a description of the target sub-formula.

[0039] Optionally, the target sub-formula is a target function, and the details information further includes at least one of the following: each element in the target function, the description information of each element, the example function corresponding to the target function, or the value currently referred to by each element.

[0040] Optionally, the device further includes:

[0041] The input value acquisition module is used to acquire the value entered in the cell corresponding to any cell identifier in the target formula when the mouse pointer hovers over the display area of ​​the cell identifier.

[0042] The input value display module is used to display the value entered in the cell in the table display interface.

[0043] Optionally, the device further includes:

[0044] The cell highlighting module is used to highlight the cell corresponding to any cell identifier in the target formula when the mouse pointer hovers over the cell in the display area.

[0045] Optionally, the formula display module is also used to display the cell identifier corresponding to the target cell in the table display interface;

[0046] The output value acquisition module is further configured to acquire the output value of the target formula in response to a second preset operation on the cell identifier;

[0047] The output value display module is also used to display the output value of the target formula in the table display interface.

[0048] Optionally, the output value acquisition module is further configured to acquire the output value of the target formula in response to a third preset operation on the target formula;

[0049] The output value display module is also used to display the output value of the target formula in the table display interface.

[0050] Optionally, the output value acquisition module is further configured to, in response to a fourth preset operation on the target formula, acquire the output value of the target formula and the output value of each function in the target formula;

[0051] The output value display module is also used to display the output value of the target formula and the output value of each function in the table display interface.

[0052] Optionally, the device further includes:

[0053] The cell movement module is used to obtain the identifier of the first cell after the cell has been moved in response to a movement operation on any cell.

[0054] The identifier replacement module is used to replace the second cell identifier in the target formula with the first cell identifier, wherein the second cell identifier is the cell identifier before the cell was moved.

[0055] Optionally, the device further includes:

[0056] The cell determination module is used to determine the first selected cell among the multiple cells as the target cell in response to a selection operation of multiple cells.

[0057] Optionally, the device further includes:

[0058] The text data acquisition module is used to acquire the text data entered in the target cell in response to the selection operation of the target cell;

[0059] A conversion module is used to convert the text data into the target formula.

[0060] Optionally, the conversion module is used to:

[0061] The text data is subjected to function recognition to obtain multiple functions in the text data and the reference relationships between the multiple functions. The reference relationship between any two functions indicates that the output value of the referenced function is used as an element in the referenced function.

[0062] The target formula is determined based on the multiple functions and the reference relationships.

[0063] Optionally, the device further includes:

[0064] An input value acquisition module is used to acquire the value entered in the cell corresponding to the at least one cell identifier;

[0065] The output value acquisition module is also used to calculate the output value of each function in turn according to the reference relationship between the multiple functions and at least one acquired value.

[0066] On the other hand, a computer device is provided, the computer device including a processor and a memory, the memory storing at least one piece of program code, the at least one piece of program code being loaded and executed by the processor to perform the operations performed in the table display method as described above.

[0067] On the other hand, a computer-readable storage medium is provided that stores at least one piece of program code, which is loaded and executed by a processor to perform the operations performed in the table display method described above.

[0068] On the other hand, a computer program product or computer program is provided, the computer program product or computer program including computer program code stored in a computer-readable storage medium, wherein a processor of the computer device reads the computer program code from the computer-readable storage medium and executes the computer program code, causing the computer device to perform the operations performed in the table display method described above.

[0069] The beneficial effects of the technical solutions provided in this application include at least the following:

[0070] The method provided in this application can display the output values ​​of sub-formulas in a formula, rather than just the final value of the formula. This increases the amount of information and allows users to understand the output value of any sub-formula in the formula, expanding the functionality of the table and improving operational efficiency. Attached Figure Description

[0071] To more clearly illustrate the technical solutions in the embodiments of this application, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of the embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0072] Figure 1 This is a flowchart of a table display method provided in an embodiment of this application;

[0073] Figure 2 This is a flowchart of another table display method provided in the embodiments of this application;

[0074] Figure 3 This is a schematic diagram of a table display interface provided in an embodiment of this application;

[0075] Figure 4 This is a schematic diagram of another table display interface provided in an embodiment of this application;

[0076] Figure 5 This is a schematic diagram of another table display interface provided in an embodiment of this application;

[0077] Figure 6 This is a schematic diagram of another table display interface provided in an embodiment of this application;

[0078] Figure 7 This is a schematic diagram of another table display interface provided in an embodiment of this application;

[0079] Figure 8 This is a schematic diagram of the structure of a table display device provided in an embodiment of this application;

[0080] Figure 9 This is a schematic diagram of another table display device provided in an embodiment of this application;

[0081] Figure 10 This is a schematic diagram of the structure of a terminal provided in an embodiment of this application;

[0082] Figure 11 This is a schematic diagram of the structure of a server provided in an embodiment of this application. Detailed Implementation

[0083] To make the objectives, technical solutions, and advantages of the embodiments of this application clearer, the implementation methods of this application will be further described in detail below with reference to the accompanying drawings.

[0084] It is understood that the terms "first," "second," etc., used in this application may be used to describe various concepts herein, but unless otherwise stated, these concepts are not limited by these terms. These terms are only used to distinguish one concept from another. For example, without departing from the scope of this application, a first function may be referred to as a second function, and a second function may be referred to as a first function.

[0085] As used in this application, the terms "each," "multiple," "at least," etc., mean "multiple" to include two or more, "each" to refer to each of the corresponding multiples, and "at least" to include one or more. For example, multiple values ​​include three values, and "each value" to refer to each of the three values, and "at least one value" to refer to one, two, or three of the three values.

[0086] To facilitate understanding of the embodiments of this application, the keywords involved in the embodiments of this application will be explained first:

[0087] Cell: A cell is the intersection of rows and columns in a table. A cell is the smallest unit that makes up a table. Each table contains multiple cells, and multiple adjacent cells can be merged.

[0088] Formula: A formula is an expression used in spreadsheets for numerical calculations, and it begins with "=". Formulas include operators, functions, parameters, etc.

[0089] Nested formulas: If a formula contains multiple functions, and the output of one function is used as a parameter of another function, then the formula is called a nested formula.

[0090] The method provided in this application can be applied to a variety of scenarios.

[0091] For example, it can be used in formula checking scenarios.

[0092] If the output of a formula in a spreadsheet cell is incorrect, the user needs to check whether the entered formula is accurate. In this case, the table display method provided in this application embodiment can be used to view the output value of each sub-formula in the formula. Based on whether the output value of each sub-formula is accurate, the user can determine whether the entered sub-formula is correct, thereby checking for errors in the formula.

[0093] For example, it can be used in scenarios where you want to view part of the output of a formula.

[0094] When viewing a formula, users may want to see some of the output results. In this case, they can use the table display method provided in this application to view the output value of each sub-formula in the formula, thereby understanding some of the output results.

[0095] For example, it can be applied to formula editing scenarios.

[0096] If a user wants to view the output value of the edited part while editing a formula, they can use the table display method provided in this application to view the output value of the edited part. Based on whether the output value is accurate, the accuracy of the edited part can be determined, and any errors that occur during the editing process can be detected in time.

[0097] Figure 1 This is a flowchart illustrating a table display method provided in an embodiment of this application. The executing entity in this embodiment is a terminal, which can be of various types, such as portable, pocket-sized, or handheld terminals, including smartphones, tablets, laptops, desktop computers, smart speakers, and smartwatches.

[0098] See Figure 1 The method includes the following steps:

[0099] 101. The terminal displays the target formula entered in the target cell in the table display interface.

[0100] In this embodiment of the application, the terminal displays a table display interface, through which the user can view the cells, the values ​​entered in the cells, or the formulas entered.

[0101] In one possible implementation, the terminal has the target application installed, and the spreadsheet is displayed through the target application. Alternatively, the terminal has a browser application installed, and the spreadsheet is displayed through a webpage within the browser application.

[0102] The table display interface includes multiple cells, the number of which can be arbitrary, and users can set the number and format of cells as needed. The target cell is the currently selected cell, and users can select the target cell by clicking, double-clicking, or performing other triggering operations.

[0103] In one possible implementation, since selecting multiple cells in a spreadsheet requires starting from any cell, pressing and dragging the mouse, and releasing the mouse to select multiple cells, the terminal responds to the selection operation of multiple cells by determining the first selected cell among the multiple cells as the target cell.

[0104] Optionally, the selected cell contains the target formula; or, the selected cell contains a numerical value; or, the selected cell is a blank cell, meaning that neither a formula nor a numerical value is entered in the cell.

[0105] The target formula is the formula entered in the target cell. The target formula includes at least one function, and the function includes multiple elements, including cell identifiers and function identifiers. The cell identifier is used to indicate the position of the cell in the table, and the function identifier is used to indicate the corresponding function.

[0106] For example, cell identifiers can be represented by the column and row of the cell, such as "A1", which indicates that the cell is the intersection of column A and row 1. The function SUM(A1, B1) is identified by the function identifier "SUM".

[0107] Optionally, the target formula may also include constants, operators, etc., where constants are any numerical values ​​and operators are "+", "-", "*", etc.

[0108] For example, if the target formula is "C1=SUM(A1,B1)+1", then the target formula includes a function "SUM(A1,B1)", a constant "1" and an operator "+", and the function includes the function identifier "SUM" and the cell identifiers "A1" and "B1".

[0109] 102. The terminal responds to the first preset operation on the target sub-formula and obtains the output value of the target sub-formula.

[0110] The target sub-formula is any part of the target formula. This target sub-formula may include at least one of the following: a function, a variable (cell identifier), or a constant.

[0111] In one possible implementation, the target sub-formula is a target function, which may include at least one of the following: variables or constants. The terminal, in response to a first preset operation on the target function, obtains the output value of the target function. Here, the target function can be any function in the target formula. The first preset operation on the target function includes hovering the mouse pointer over the display area of ​​the target function or placing the cursor within the target function.

[0112] The terminal can calculate the output value of the objective function in the following situations:

[0113] The first method: After the terminal responds to the first preset operation on the target function, it calculates the target function and obtains the output value of the target function. The second method: After the terminal displays the target formula in the table display interface, it calculates the target function before responding to the first preset operation on the target function and obtains the output value of the target function. The third method: After the terminal enters the target formula in the target cell, it calculates the target function and obtains the output value of the target function.

[0114] If the terminal calculates the output value of the objective function before responding to the first preset operation on the objective function, the terminal will store the output value of the objective function and retrieve the stored output value when responding to the first preset operation on the objective function.

[0115] In another possible implementation, the target sub-formula includes at least two functions and operators. For example, the target formula is "F1 = SUM(A1, B1) - AVERAGE(A1, B1, C1) + 13 - 57 + E1", and the target sub-formula is "SUM(A1, B1) - AVERAGE(A1, B1, C1)".

[0116] In another possible implementation, the target sub-formula includes at least one function, at least one constant, and an operator. For example, the target formula is "F1 = SUM(A1, B1) - AVERAGE(A1, B1, C1) + 13 - 57 + E1", and the target sub-formula is "AVERAGE(A1, B1, C1) + 13 - 57".

[0117] In another possible implementation, the target sub-formula includes at least two constants and operators. For example, the target formula is "F1 = SUM(A1, B1) - AVERAGE(A1, B1, C1) + 13 - 57 + E1", and the target sub-formula is "13 - 57".

[0118] It should be noted that the target sub-formula can take many forms. The above-mentioned possible implementation is only used as an example for illustration. In another embodiment, the target sub-formula can also include at least one function, at least one variable (cell identifier) ​​and operator, and can also include at least one constant, at least one variable and operator, etc., which will not be elaborated here.

[0119] 103. The terminal displays the output value of the target sub-formula in the table display interface.

[0120] After obtaining the output value of the target sub-formula, the terminal displays the output value so that the user can view it.

[0121] The method provided in this application can display the output values ​​of sub-formulas in a formula, rather than just the final value of the formula. This increases the amount of information and allows users to understand the output value of any sub-formula in the formula, expanding the functionality of the table and improving operational efficiency.

[0122] Figure 2 This is a flowchart of another table display method provided in this application embodiment. The execution subject of this application embodiment is a terminal; see [link to relevant documentation]. Figure 2 The method includes the following steps:

[0123] 201. The terminal obtains the value entered in the cell corresponding to at least one cell identifier in the target formula.

[0124] In this embodiment of the application, taking the target formula as an example, before displaying the target formula, the terminal pre-calculates and stores the output value of each function in the target formula. When a preset operation on the target sub-formula is detected later, if the target sub-formula includes a function, the output value of the function can be directly obtained, and the corresponding values ​​of the function and other parts in the target sub-formula can be calculated to quickly obtain the output value of the target sub-formula.

[0125] In one possible implementation, after the user enters a value into a cell, the terminal stores the entered value along with the corresponding cell identifier. When the terminal calculates the target formula, it looks up the corresponding stored value based on the cell identifier in the target formula, thereby obtaining the value entered in the cell corresponding to each cell identifier in the target formula.

[0126] Before the terminal can calculate each function in the target formula, it needs to obtain the target formula first.

[0127] In one possible implementation, since the target formula is stored in text format in the terminal, the terminal responds to the selection of the target cell by obtaining the text data entered in the target cell; and then converts the text data into the target formula.

[0128] In one possible implementation, converting text data into a target formula includes: performing function identification on the text data to obtain multiple functions and their referencing relationships; and determining the target formula based on the functions and their referencing relationships. Here, a referencing relationship between any two functions indicates that the output value of the referenced function is used as an element in the referencing function, and the function includes cell identifiers.

[0129] Syntax recognition is performed on the text data to identify multiple functions within it. Semantic analysis is then performed on the text data to determine the reference relationships between the multiple functions, i.e., to determine the first function that needs to be calculated. The output value of the first function is used as an element in the second function that needs to be calculated, and so on, to determine the order in which the multiple functions are calculated.

[0130] In one possible implementation, the terminal uses a token parser to parse token symbols from text data, i.e., each element in the formula, and then uses a lexical parser to parse the token symbols into a recognizable formula model, i.e., combining multiple elements in the formula into a complete formula.

[0131] In another possible implementation, the terminal uses a formula conversion model to convert the text data and obtain the target formula corresponding to the text data.

[0132] 202. The terminal calculates the values ​​of multiple functions sequentially according to the reference relationships between them and at least one numerical value obtained, and obtains the output value of each function.

[0133] In this context, the reference relationship between any two functions means that the output value of the referenced function is used as an element in the referencing function.

[0134] When calculating the output value of each function, the value entered in the cell is substituted into the target formula. Then, according to the reference relationship between multiple functions, the output value of the first function is calculated first, and the output value of the first function is used as an element in the second function to calculate the output value of the second function. In this way, the output value of each function is calculated in turn.

[0135] For example, the target formula is "B3 = DATEDIF(TEXT(MID(A3, 7, 8) "#-00-00"), TODAY, "Y")". This target formula includes the first-level function "MID(A3, 7, 8)", the second-level function "TEXT(MID(A3, 7, 8) "#-00-00")", and the third-level function "DATEDIF(TEXT(MID(A3, 7, 8) "#-00-00"), TODAY, "Y")". The second-level function references the first-level function, and the third-level function references the second-level function. During calculation, the output value of the first-level function is used as an element in the second-level function, and the output value of the second-level function is used as an element in the third-level function.

[0136] In another embodiment, if the multiple functions in the target formula do not have a referencing relationship, the output values ​​of each function are calculated separately. Then, based on the operators between the functions, the output values ​​of the multiple functions are calculated to obtain the output value of the target formula. For example, if the target formula is "C3 = SUM(A3, B3) + AVERAGE(A3, B3)", and the functions "SUM(A3, B3)" and "AVERAGE(A3, B3)" do not have a referencing relationship, the output values ​​of the two functions are calculated separately, and then the two output values ​​are added together to obtain the output value of the target formula.

[0137] In another embodiment, if the target formula includes only one function and a constant, the output value of the function is calculated, and then the output value is calculated with the constant according to the operator between the function and the constant to obtain the output value of the target formula. For example, if the target formula is "C3 = SUM(A3, B3) + 1", the function "SUM(A3, B3)" is calculated to obtain the output value of the function, and then the output value is added to 1 to obtain the output value of the target formula.

[0138] In one possible implementation, after calculating the output value of each function in the target formula using the above method, the function is stored in correspondence with its output value. When retrieving the output value of a function later, it is only necessary to query the stored output value, without having to perform the calculation every time, thus reducing the amount of computation.

[0139] In one possible implementation, after storing the output value of each function, if a change is detected in the input value of the cell corresponding to the cell identifier, the latest input value is obtained, the output value of each function in the target formula is recalculated, and the latest output value of the target formula is stored to ensure that the obtained output value is an accurate value calculated using the value in the current cell.

[0140] 203. The formula display area in the table display interface of the terminal displays the target formula entered in the target cell.

[0141] This application embodiment uses the example of a target formula already entered in a target cell to illustrate the display of the target formula in the formula display area. The formula display area is located anywhere within the table display area, and it is used to display the parameters or formulas entered in the selected cell.

[0142] In one possible implementation, the table display interface also includes a cell display area comprising multiple cells. The formula display area is located above, below, to the left, to the right, or other positions within the cell display area. See, for example... Figure 3 The table display interface 300 shown has a formula display area 301 located above the cell display area 302, and the target formula is displayed in the formula display area 301.

[0143] Alternatively, in one possible implementation, the user clicks on the target cell to select it, and the target formula is displayed in the formula display area. At this time, the target cell still displays the output value of the target formula.

[0144] In another possible implementation, the user double-clicks the target cell to select it. The target formula is displayed in both the formula display area and the area containing the target cell. However, unlike the other implementation, the user can view and edit the target formula within the target cell, but cannot view its output values ​​or the output values ​​of functions within it. For example, see... Figure 3 Display the target formula in target cell 303. Figure 3 Due to the size limitation of the target cell, the complete target formula is not displayed.

[0145] In one possible implementation, when displaying the target formula in the display area of ​​the target cell, if the length of the target formula is less than the length of the cell, the target formula is displayed in the target cell; if the length of the target formula is greater than the length of the cell and the target cell cannot display the complete target formula, the target cell is expanded to increase the display area of ​​the target cell and display the complete target formula.

[0146] In one possible implementation, the formula display area includes two sub-areas. The first sub-area is used to display cell identifiers, which indicate that the currently displayed target formula is the formula entered in the cell corresponding to the cell identifier. The second sub-area is used to display the target formula, which starts with "=".

[0147] This embodiment only uses the example of entering a formula in the target cell. In another embodiment, if the selected cell contains a numerical value, the numerical value is displayed in the formula display area; if the selected cell is a blank cell, the formula display area is blank.

[0148] In one possible implementation, before the terminal displays the target formula, the user can directly select the target cell, edit the target cell, and enter the target formula in the target cell; or, after the user selects the target cell, the user can enter the target formula in the formula display area, and the formula entered in the formula display area can also be synchronized to the target cell.

[0149] In another embodiment, the table display interface also includes other areas, such as undo buttons, restore buttons, font settings buttons, format painter buttons, insert buttons, etc. Users can operate the displayed buttons to achieve the corresponding functions.

[0150] 204. The terminal responds to the first preset operation on the target sub-formula and obtains the output value of the target sub-formula.

[0151] In this embodiment, the user can preview or edit the displayed target formula, and the terminal can implement both preview and editing functions for the target formula. Previewing refers to viewing the output value of any part of the target formula, or viewing the value in the cell corresponding to each cell identifier in the target formula; editing refers to editing the target formula, and the terminal can implement both editing and preview functions simultaneously.

[0152] Before previewing or editing, you need to obtain the output value of the target sub-formula.

[0153] In one possible implementation, if the target sub-formula is a target function, and the output value of each function in the target formula has been calculated based on the above steps 201-202, then the terminal responds to the first preset operation on the target function, queries the stored output value of each function, and thus obtains the output value of the target function.

[0154] In another embodiment, steps 201-203 are not executed, meaning the terminal does not pre-calculate the output value of each function in the target formula. Then, in response to the first preset operation on the target function, the terminal obtains the value entered in the cell corresponding to at least one cell identifier in the target function; and uses the target function to calculate the output value of the target function.

[0155] In another possible implementation, when the target sub-formula includes at least two functions and there is at least one operator between the at least two functions, the terminal responds to the first preset operation on the target sub-formula by directly querying the output value of each function stored in the database, obtaining the output values ​​of the at least two functions respectively, and performing operations on the output values ​​of the at least two functions according to the operation method represented by the operator to obtain the output value of the target sub-formula.

[0156] In another possible implementation, when the target sub-formula includes at least one of cell identifiers or constants, and also includes operators but not functions, the terminal responds to the first preset operation on the target sub-formula by directly performing calculations on at least one of the values ​​corresponding to the cell identifiers or constants in the target sub-formula according to the calculation method represented by the operators, and obtains the output value of the target sub-formula.

[0157] 205. The terminal displays the output value of the target sub-formula in the table display interface.

[0158] In one possible implementation, before a user operates on a target sub-formula to display the output value, the target sub-formula needs to be determined first. The user first selects any area in the target formula, and the terminal responds to the selection operation by determining the part corresponding to the selected area as the target sub-formula.

[0159] In this embodiment of the application, the terminal acquires and displays the output value of the target sub-formula in the following situations:

[0160] The first scenario: when the user previews the output value of the target sub-formula.

[0161] In one possible implementation, the user selects any region within the target formula. The terminal responds to this selection by retrieving the output value of the target sub-formula within that region. Selecting any region means the user hovers the mouse pointer over any position within the target formula, presses and drags the mouse, and then releases it. The selected region is determined by the positions where the mouse was pressed and released, and this selected region constitutes the target sub-formula.

[0162] In another possible implementation, after selecting any region, while maintaining the selected state of that region, the terminal responds to the operation of hovering the mouse pointer over other regions outside that region in the target formula and obtains the output value of the function corresponding to the hover position.

[0163] In another possible implementation, the user moves the mouse pointer to the display area of ​​the target sub-formula. The terminal, responding to the mouse pointer hovering within this display area, acquires and displays the output value of the target sub-formula. Here, "mouse pointer hover" means moving the mouse pointer to the display area without performing any other operations within it. The display area of ​​the target sub-formula refers to the region containing the portion of the target sub-formula within the target formula.

[0164] In one possible implementation, when the target sub-formula is a target function, the terminal responds to the mouse pointer hovering position being within the display area of ​​the target function, acquiring and displaying the output value of the target function. Here, the display area of ​​the target function refers to the region that includes elements within the target function but excludes elements from other functions.

[0165] In one possible implementation, the target formula is a nested formula containing multiple functions, where the target function references other functions. The terminal responds when the mouse pointer hovers over a position within the display area of ​​the target function but not within the display area of ​​the referenced function, and then retrieves the output value of the target function. For example, in the formula "B3 = DATEDIF(TEXT(MID(A3, 7, 8), "#-00-00"), TODAY, "Y")", the target function is "TEXT(MID(A3, 7, 8), "#-00-00")", and the referenced function is "MID(A3, 7, 8)". If the mouse pointer hovers over "MID(A3, 7, 8)", the output value of the referenced function will be retrieved. If the mouse pointer hovers over a position within the target function other than "MID(A3, 7, 8)", i.e., within TEXT(·), "#-00-00"), the output value of the target function will be retrieved.

[0166] When previewing the output value of any sub-formula, users only need to hover the mouse pointer over the display area of ​​that sub-formula without having to click, simplifying the user operation.

[0167] The second scenario: when the user edits the target sub-formula.

[0168] When a user clicks on the target sub-formula, the click location becomes the cursor position. The terminal responds by recognizing the cursor position as being within the target sub-formula, and then retrieves and displays the output value of the target sub-formula.

[0169] In one possible implementation, the target sub-formula is a target function, and the terminal, in response to the cursor position being within the target function, retrieves and displays the output value of the target sub-formula. For example, see... Figure 4If the cursor is positioned in the display area of ​​the function "MID(A3, 7, 8)", then the output value of the function can be obtained.

[0170] In one possible implementation, the target formula is a nested formula containing multiple functions. If the target function references other functions, the terminal responds by retrieving the output value of the target function when the cursor is positioned within the target function but not within any of the referenced functions. For example, in the formula "B3 = DATEDIF(TEXT(MID(A3, 7, 8), "#-00-00"), TODAY, "Y")", the target function is "TEXT(MID(A3, 7, 8), "#-00-00")", and the referenced function is "MID(A3, 7, 8)". If the cursor is positioned within "MID(A3, 7, 8)", the output value of the referenced function will be retrieved. If the cursor is positioned within the target function excluding "MID(A3, 7, 8)", i.e., within TEXT(·), "#-00-00"), the output value of the target function will be retrieved.

[0171] In another possible implementation, if the user first selects any area in the target formula to define the target sub-formula, which includes the target function and other functions or constants, and then performs a preset operation in the display area of ​​the target function, it is assumed that the user wants to view the output value of the target sub-formula, and the terminal displays the output value of the target sub-formula. If the user does not select any area in the target formula but performs a preset operation directly in the display position of the target function, it is assumed that the user wants to view the output value of the target function, and the terminal displays the output value of the target function.

[0172] Even when editing any sub-formula, users can still view its output value. This allows users to identify errors in the editing process by checking the sub-formula's output value if they make a mistake.

[0173] The third scenario: when the user edits another part of the sub-formula.

[0174] When a user clicks on the display area of ​​a sub-formula in another section, the cursor is positioned within that sub-formula. The user then moves the mouse pointer to the display area of ​​the target sub-formula, and the terminal retrieves and displays the output value of the target sub-formula. In other words, when the cursor is within a sub-formula in another section, the terminal retrieves and displays the output value of the target sub-formula in response to the user hovering the mouse pointer over its display area.

[0175] In one possible implementation, the target sub-formula is a target function. When the cursor position is within another function, the terminal, in response to the operation of hovering the mouse pointer over the display area of ​​the target function, obtains and displays the output value of the target function.

[0176] When the target formula is a target function, in the above cases, a preset operation is performed on the target function to obtain and display its output value. In another possible implementation, the target function includes a target function identifier, which represents the target function. For example, the function "MID(A3, 7, 8)" has the function identifier "MID". To obtain and display the output value of the target function, the user moves the mouse pointer to the display area of ​​the target function identifier. That is, the terminal obtains and displays the output value of the target function in response to the mouse pointer hovering over the display area of ​​the target function identifier. For example, see [link to example]. Figure 3 Hover the mouse pointer over the function identifier "MID".

[0177] In another possible implementation, when the cursor is positioned within another function, the terminal, in response to hovering the mouse pointer over the display area identified by the target function, acquires and displays the output value of the target function. For example, see [link to relevant documentation]. Figure 5 The table shown in the interface 500 has the cursor positioned in the function "MID(A3, 7, 8)". Move the mouse pointer to the function identifier "TEXT" to get and display the output value of the function corresponding to "TEXT".

[0178] When a user needs to view the output value of another function, they only need to move the mouse pointer from the display area of ​​the current function to the display area of ​​the other function. No other operation is required, which realizes the function of quickly switching to view the output value of different functions and simplifies the user operation.

[0179] In another embodiment, when a user selects any region in the target formula, the terminal determines the part corresponding to the selected region as the target sub-formula, and the region includes at least one function. Then, the terminal obtains and displays the output value of the at least one function; or, it obtains and displays the output value of the at least one function and the output value of the target sub-formula.

[0180] In this embodiment of the application, after obtaining the output value of the target sub-formula, the terminal displays the output value of the target sub-formula in the display area.

[0181] In one possible implementation, the terminal displays the output value in the display area corresponding to the target sub-formula in the table display interface. For example, if the target sub-formula is an objective function, see [link to relevant documentation]. Figure 3 The table display interface 300 shown above displays the output value "19900101" when the mouse pointer is hovered over the function identifier "MID".

[0182] For example, see Figure 4 The table shown in the interface 400 has the cursor positioned in the target function "MID(A3, 7, 8)" and the output value "19900101" is displayed in the display area above the target function.

[0183] In another possible implementation, the terminal displays the output value and an indicator pointing from the target sub-formula to the output value in any display area of ​​the table display interface. Here, "any display area" refers to any area of ​​the table display interface other than the formula display area, and the indicator is an arrow or other mark. The output value pointed from the target sub-formula to the output value indicates that the output value in the display area is the output value of the target sub-formula. For example, the target sub-formula is an objective function; see [link to relevant documentation]. Figure 6 The table display interface 600 shown above displays the output value "19900101" when the mouse pointer is hovered over the function identifier "MID" in the display area 601.

[0184] Optionally, when displaying the output value in the display area, it can be displayed in the form of "="output value.

[0185] Optionally, the size of the display area is determined based on the length of the output value to be displayed. If the output value has a large number of digits and a long length, the display area is longer to ensure that the complete output value is displayed; if the output value has a small number of digits and a short length, the display area is shorter to avoid occupying too much display area in the table display interface.

[0186] It should be noted that before the first preset operation is performed on the target sub-formula, the display area corresponding to the target sub-formula or any display area is not displayed in the table display interface. In response to the first preset operation on the target sub-formula, the terminal displays the display area corresponding to the target sub-formula or any display area, and displays the output value of the target sub-formula in the display area.

[0187] Additionally, when a user previews the output value of the target sub-formula, the output value will no longer be displayed after the user moves the mouse pointer away from the display area of ​​the target sub-formula. However, when a user edits the target sub-formula, the output value will still be displayed even if the user moves the mouse pointer away from the display area of ​​the target sub-formula and does not move it to the display area of ​​any other sub-formula within the target formula.

[0188] In one possible implementation, the terminal, in response to a first preset operation on the target sub-formula, displays detailed information about the target sub-formula. This detailed information describes the target sub-formula and includes at least a descriptive description. For example, if the target sub-formula includes two functions, a constant, and an operator between them, the detailed information would describe the two functions.

[0189] Optionally, the terminal displays detailed information about the target sub-formula in response to the mouse pointer hovering over it being located in the display area of ​​the target sub-formula; or, the terminal displays detailed information about the target sub-formula in response to the cursor being located in the target sub-formula; or, if the cursor is located in another target sub-formula, the terminal displays detailed information about the target sub-formula in response to the operation of hovering the mouse pointer over the display area of ​​the target sub-formula.

[0190] Optionally, when the target sub-formula is a target function, or when the target sub-formula includes a target function, the details also include at least one of the following: each element in the target function, a description of each element, a sample function corresponding to the target function, or the current value that each element refers to. Here, elements include cell identifiers and preset parameters; the sample function is a provided example function, which allows the user to edit the target function according to its format to prevent errors in the target function's output due to inaccurate formatting; and the current value that each element refers to is the value currently entered in the cell corresponding to the cell identifier in the target function, or the current value of a constant in the target function.

[0191] For example, see Figure 4 The table display interface 400 shown performs preset operations on the target function "MID(A3, 7, 8)" and displays detailed information about the target function. This detailed information includes the description of the target function: "MID: Returns a specific number of characters from a text string starting at a specified position, which is specified by the user." The detailed information also includes each element in the target function and its description, such as "MID(string, start position, extraction length)", the example function corresponding to the target function "MID(A4, 4, 18)", and the current numerical value that each element represents, such as "string = 330203199001010101", "start position = 7", and "extraction length = 8".

[0192] In one possible implementation, the terminal displays detailed information about the target function in a function description panel. This panel can be located below the target function or anywhere else in the display interface. Optionally, the position of the function description panel for each function in the target formula can be the same or different.

[0193] Optionally, the function description panel includes an expand button. If the currently displayed function description panel is complete, the user can operate the expand button to collapse the function description panel, displaying only the description information of each element in the target function; operating the expand button again will uncollapse the panel and display the complete function description panel.

[0194] Optionally, the function description panel also includes a close button, which users can use to close the function description panel.

[0195] When viewing the output of the target function, if a user wants to view the output of another function, they simply move the mouse pointer over the target function to the display area of ​​the other function they want to view. Similarly, if they want to view the value in the cell corresponding to the cell identifier, they simply move the mouse pointer over the target function to the display area of ​​the cell identifier they want to view. This allows for quick switching between viewing the output of the target function and the value entered in the cell corresponding to the cell identifier.

[0196] In one possible implementation, while the terminal displays the output value of the target sub-formula, it also responds to a first preset operation on the target sub-formula by highlighting it, allowing the user to visually view the current target sub-formula. The methods for highlighting the target sub-formula include one or more of the following: adding an underline below the target sub-formula; setting the font color of the target sub-formula to a preset color; using a dashed outline to enclose the target sub-formula; or overlaying a background color different from the font color of the target sub-formula onto the objective function, etc.

[0197] The above embodiments illustrate the display of the output value of the target sub-formula. In another embodiment, a similar implementation can be used to display the value entered in the cell corresponding to the cell identifier. By performing a preset operation on the cell identifier, the value entered in the cell corresponding to that cell identifier can be displayed, allowing the user to directly view the value without having to search through multiple cells. This simplifies the user operation and makes it more convenient for the user to view the value corresponding to the cell identifier in the formula.

[0198] In one possible implementation, based on step 201 above, which involves storing the numerical value entered in a cell as a corresponding cell identifier, the terminal responds to the mouse pointer hovering over the display area of ​​any cell identifier in the target formula by obtaining the numerical value entered in the cell corresponding to that cell identifier.

[0199] Optionally, when the mouse hovers over the display area of ​​any cell identifier, the cell identifier is highlighted. The methods for highlighting the cell include one or more of the following: adding an underline below the cell identifier; setting the font color of the cell identifier to a preset color; using a dashed outline to enclose the cell identifier; or overlaying a background color different from the font color of the cell identifier onto the cell identifier, etc.

[0200] In one possible implementation, the terminal displays the value entered in the cell within the display area corresponding to the cell identifier in the table display interface; alternatively, the terminal displays the value entered in the cell and an indicator pointing to the value from the target cell identifier in any display area of ​​the table display interface. The display method of the value is similar to the display method of the output value of the function mentioned above, and will not be described again here.

[0201] In one possible implementation, the terminal responds to the display area of ​​any cell identifier in the target formula when the mouse pointer hovers over it, highlighting the cell corresponding to that cell identifier. The method of highlighting the cell includes one or more of the following: using a dashed outline to enclose the cell; filling the cell with a preset color; or displaying the numerical value in the cell using a preset color, etc.

[0202] For example, see Figure 7 The table display interface 700 shown shows that when the mouse pointer is hovered over the cell label "A3", the value of cell 701 corresponding to "A3" is displayed above "A3". Cell 701 corresponding to "A3" is highlighted with a dashed box.

[0203] In addition, the tables in the embodiments of this application can be either online tables or offline tables, and the embodiments of this application do not limit this.

[0204] In one possible implementation, when the table is an online table, a service worker (a background thread) can be used to accelerate the calculation process of the target formula.

[0205] It should be noted that the embodiments in this application are only described with the terminal as the executing subject. In another embodiment, the above-mentioned process of calculating and outputting values ​​can be performed by the server. The server converts the text data into a formula, uses the formula to calculate the value in the cell corresponding to the cell identifier, obtains the output value of each function, and stores the output value of each function. In response to the first preset operation on the target function, the terminal sends an output value acquisition request to the server, and the server sends the output value of the target function to the terminal.

[0206] The server can be a standalone physical server, a server cluster or distributed system consisting of multiple physical servers, or a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communication, middleware services, domain name services, security services, CDN (Content Delivery Network), and big data and artificial intelligence platforms.

[0207] Another point to note is that the embodiments in this application are only illustrated by showing the target formula. In another embodiment, the table display interface can display multiple formulas, and the display method of the output value of the sub-formula in each formula is similar to the display method of the target sub-formula described above.

[0208] The method provided in this application can display the output values ​​of sub-formulas in a formula, rather than just the final value of the formula. This increases the amount of information and allows users to understand the output value of any sub-formula in the formula, expanding the functionality of the table and improving operational efficiency.

[0209] Furthermore, when the output value of a formula is incorrect, users can view the output value of each sub-formula, quickly find the problematic sub-formula, and edit it, thus improving the efficiency of formula checking and editing.

[0210] Furthermore, when viewing the output value of any sub-formula, users only need to hover the mouse pointer over the display area of ​​the sub-formula without clicking. When users need to view the output value of another sub-formula, they only need to move the mouse pointer from the current display area of ​​the sub-formula to the display area of ​​the other sub-formula without performing any other operations. This enables users to quickly switch between viewing the output values ​​of different sub-formulas, simplifies user operations, and makes the process more convenient.

[0211] The above Figure 1 and Figure 2 In the illustrated embodiment, the display of the output value of the target sub-formula and the display of the value entered in the cell are explained. In another embodiment, the terminal can also display the output value of the target formula.

[0212] In one possible implementation, the target formula includes a cell identifier corresponding to the target cell. This cell identifier represents the target formula entered in the target cell. For example, if the target formula is "F1 = SUM(A1, B1) - AVERAGE(A1, B1, C1) + 13 - 57 + E1", the cell identifier is F1. When the user wants to view the output value of the target formula, a second preset operation is performed on the cell identifier. The terminal responds to this second preset operation, obtains the output value of the target formula, and displays the output value of the target formula in the table display interface.

[0213] Optionally, when the user hovers the mouse pointer over the display area identified by the cell, the terminal, in response to the mouse pointer hovering over the display area identified by the cell, retrieves and displays the output value of the target formula. Alternatively, if the cursor is located in another area of ​​the target formula, the terminal, in response to the operation of hovering the mouse pointer over the display area identified by the cell, retrieves and displays the output value of the target formula.

[0214] In another possible implementation, the user performs a third preset operation on the target formula, the terminal responds to the third preset operation, obtains the output value of the target formula, and displays the output value of the target formula in the table display interface.

[0215] The user performs a fourth preset operation on the target formula. The terminal responds to the fourth preset operation by obtaining the output value of the target formula and the output value of each function in the target formula. The output value of the target formula and the output value of each function are displayed in the table display interface.

[0216] Among them, the first preset operation and the second preset operation can be the same or different; the first preset operation and the third preset operation can be the same or different; the first preset operation and the fourth preset operation can be the same or different; the third preset operation and the fourth preset operation are different.

[0217] Optionally, the target formula includes an equal sign. Performing a third preset operation on the target formula includes: performing a third preset operation on the equal sign in the target formula, and the terminal responding to the third preset operation on the equal sign in the target formula by acquiring and displaying the output value of the target formula. Correspondingly, performing a fourth preset operation on the equal sign in the target formula, the terminal responding to the fourth preset operation on the equal sign by acquiring and displaying the output value of the target formula, as well as the output value of each function in the target formula.

[0218] When displaying the output value of the target formula, the output value is displayed in the display area corresponding to the target formula in the table display interface; or, the output value and an indicator mark pointing from the target formula to the output value are displayed in any display area in the table display interface.

[0219] When displaying the output values ​​of the target formula and each function within the target formula, the output value of the target formula is displayed in the display area corresponding to the target formula in the table display interface, and the output value of each function is displayed in its respective display area; or, the output value of the target formula and an indicator pointing from the target formula to the output value are displayed in any display area in the table display interface, and the output values ​​of each function and an indicator pointing from the function to the output value are displayed in any other display area; or, the output value of the target formula, the output value of each function, and an indicator pointing from the target formula to the output value are displayed in any display area in the table display interface.

[0220] In the above embodiments, while displaying the output value of the formula, it is also possible to display the output value of each function in the formula. Compared with only displaying the output value of the formula, more output values ​​are displayed, increasing the amount of information. Furthermore, by displaying the output values ​​of the functions, the functionality of the table is expanded, and users can understand the output value of each function in the formula.

[0221] In another possible implementation, the terminal, in response to a preset operation on the target formula, displays detailed information about the target formula. This detailed information includes at least one of the following: a description of each function in the target formula; an example function corresponding to each function; elements within each function; a description of each element; and the current numerical value that each element represents. The preset operation is either a first preset operation or a third preset operation.

[0222] The implementation method for obtaining the output value of the target formula is similar to the implementation method for obtaining the target sub-formula in the above embodiments, and the implementation method for displaying the output value of the target formula is also similar to the implementation method for displaying the target sub-formula in the above embodiments, and will not be repeated here.

[0223] In another embodiment, the cell identifiers in the target formula are automatically updated based on changes in the corresponding cell positions. In response to a cell movement operation, the terminal obtains the first cell identifier after the movement and replaces the second cell identifier in the target formula with this first cell identifier. The second cell identifier is the cell identifier before the movement. For example, if the target formula is "D4=SUM(A1,B2)+C3", moving the row containing cell B2 one row up changes "B2" to "A2". Simultaneously, moving the row containing cell A1 one row down changes "A1" to "B1". Replacing the original cell identifier with the moved one yields the target formula "D4=SUM(B1,A2)+C3".

[0224] The formula automatically updates the cell labels based on changes in cell position, preventing inaccurate output results caused by changes in the values ​​of the cells corresponding to the cell labels after moving cells.

[0225] Figure 8 This is a schematic diagram of the structure of a table display method apparatus provided in an embodiment of this application. See also... Figure 8 The device includes:

[0226] The formula display module 801 is used to display the target formula entered in the target cell in the table display interface. The target cell is the currently selected cell, and the target formula includes at least one function.

[0227] The output value acquisition module 802 is used to acquire the output value of the target sub-formula in response to the first preset operation on the target sub-formula, wherein the target sub-formula is any part of the target formula;

[0228] The output value display module 803 is used to display the output value of the target sub-formula in the table display interface.

[0229] The device provided in this application embodiment can display the output values ​​of sub-formulas in a formula, and is not limited to displaying the final value of the formula. This increases the amount of information and allows users to understand the output value of any sub-formula in the formula, thus expanding the functionality of the table and improving operational efficiency.

[0230] Optionally, the output value display module 803 is used for:

[0231] The output value is displayed in the area corresponding to the target sub-formula in the table display interface; or...

[0232] In any display area of ​​the table display interface, the output value and the indicator mark pointing from the target sub-formula to the output value are displayed.

[0233] Optionally, the output value display module 803 is used to display the target formula in the formula display area of ​​the table display interface; or,

[0234] Display the target formula in the display area containing the target cell.

[0235] Optionally, the output value acquisition module 802 is used to acquire the output value of the target sub-formula in the region in response to the selection operation of any region in the target formula.

[0236] Optionally, the objective sub-formula is an objective function, and the output value acquisition module 802 is used for:

[0237] In response to the mouse pointer hovering over the target function's display area, the output value of the target function is obtained; or,

[0238] In response to the cursor being located within the target function, retrieve the output value of the target function; or...

[0239] When the cursor is in another function, the output value of the target function is obtained in response to the operation of hovering the mouse pointer over the display area of ​​the target function.

[0240] Optionally, the objective function includes an objective function identifier, and the output value acquisition module 802 is used for:

[0241] In response to the mouse pointer hovering over the target function's display area, the output value of the target function is obtained; or,

[0242] When the cursor is located in another function, the output value of the target function is obtained in response to the operation of hovering the mouse pointer over the display area identified by the target function.

[0243] Optionally, see Figure 9 The device also includes:

[0244] The details display module 804 is used to display detailed information about the target sub-formula in response to a first preset operation on the target sub-formula. The detailed information includes at least a description of the target sub-formula.

[0245] Optionally, the objective sub-formula is an objective function, and the detailed information also includes at least one of the following: each element in the objective function, the description of each element, the example function corresponding to the objective function, or the value currently referred to by each element.

[0246] Optionally, see Figure 9 The device also includes:

[0247] The input value acquisition module 805 is used to acquire the value entered in the cell corresponding to any cell identifier in the target formula when the mouse pointer hovers over the display area of ​​the cell identifier.

[0248] The input value display module 806 is used to display the values ​​entered in the cells in the table display interface.

[0249] Optionally, see Figure 9 The device also includes:

[0250] The cell highlighting module 807 is used to highlight the cell corresponding to any cell identifier in the target formula when the mouse pointer hovers over the display area of ​​the cell identifier.

[0251] Optionally, the formula display module 801 is also used to display the cell identifier corresponding to the target cell in the table display interface;

[0252] The output value acquisition module 802 is also used to acquire the output value of the target formula in response to a second preset operation on the cell identifier;

[0253] The output value display module 803 is also used to display the output value of the target formula in the table display interface.

[0254] Optionally, the output value acquisition module 802 is also used to acquire the output value of the target formula in response to a third preset operation on the target formula;

[0255] The output value display module 803 is also used to display the output value of the target formula in the table display interface.

[0256] Optionally, the output value acquisition module 802 is also used to acquire the output value of the target formula and the output value of each function in the target formula in response to the fourth preset operation on the target formula;

[0257] The output value display module 803 is also used to display the output value of the target formula and the output value of each function in the table display interface.

[0258] Optionally, see Figure 9 The device also includes:

[0259] The cell movement module 808 is used to respond to a cell movement operation and obtain the identifier of the first cell after the cell movement.

[0260] The identifier replacement module 809 is used to replace the second cell identifier in the target formula with the first cell identifier, where the second cell identifier is the cell identifier before the cell was moved.

[0261] Optionally, see Figure 9 The device also includes:

[0262] Cell determination module 810 is used to determine the first selected cell among multiple cells as the target cell in response to a selection operation of multiple cells.

[0263] Optionally, see Figure 9 The device also includes:

[0264] The text data acquisition module 811 is used to acquire the text data entered in the target cell in response to the selection operation of the target cell;

[0265] The conversion module 812 is used to convert text data into target formulas.

[0266] Optionally, see Figure 9 Conversion module 812 is used for:

[0267] Function recognition is performed on text data to obtain multiple functions in the text data and the reference relationships between multiple functions. The reference relationship between any two functions means that the output value of the referenced function is used as an element in the referenced function.

[0268] The target formula is determined based on multiple functions and their referencing relationships.

[0269] Optionally, see Figure 9 The device also includes:

[0270] Input value acquisition module 806 is used to acquire the value entered in at least one cell corresponding to a cell identifier;

[0271] The output value acquisition module 802 is also used to calculate the output value of each function in turn according to the reference relationship between the multiple functions and at least one value obtained.

[0272] All of the above-mentioned optional technical solutions can be combined in any way to form the optional embodiments of this application, and will not be described in detail here.

[0273] It should be noted that the table display method and apparatus provided in the above embodiments are only illustrative examples of the division of the above functional modules when displaying tables. In practical applications, the above functions can be assigned to different functional modules as needed, that is, the internal structure of the server can be divided into different functional modules to complete all or part of the functions described above. In addition, the table display method and apparatus provided in the above embodiments belong to the same concept as the table display method embodiments, and the specific implementation process can be found in the method embodiments, which will not be repeated here.

[0274] Figure 10 A structural block diagram of a terminal 1000 provided in an exemplary embodiment of this application is shown. The terminal 1000 may be a portable mobile terminal, such as a smartphone, tablet computer, MP3 player (Moving Picture Experts Group Audio Layer III), MP4 player (Moving Picture Experts Group Audio Layer IV), laptop computer, or desktop computer. The terminal 1000 may also be referred to as a user device, portable terminal, laptop terminal, desktop terminal, or other names.

[0275] Typically, terminal 1000 includes a processor 1001 and a memory 1002.

[0276] Processor 1001 may include one or more processing cores, such as a quad-core processor, an octa-core processor, etc. Processor 1001 may be implemented using at least one hardware form selected from DSP (Digital Signal Processing), FPGA (Field-Programmable Gate Array), and PLA (Programmable Logic Array). Processor 1001 may also include a main processor and a coprocessor. The main processor, also known as a CPU (Central Processing Unit), is used to process data in the wake-up state; the coprocessor is a low-power processor used to process data in the standby state. In some embodiments, processor 1001 may integrate a GPU (Graphics Processing Unit), which is responsible for rendering and drawing the content required to be displayed on the screen. In some embodiments, processor 1001 may also include an AI (Artificial Intelligence) processor, which is used to handle computational operations related to machine learning.

[0277] The memory 1002 may include one or more computer-readable storage media, which may be non-transitory. The memory 1002 may also include high-speed random access memory and non-volatile memory, such as one or more disk storage devices or flash memory devices. In some embodiments, the non-transitory computer-readable storage media in the memory 1002 are used to store at least one program code, which is executed by the processor 1001 to implement the table display method provided in the method embodiments of this application.

[0278] In some embodiments, the terminal 1000 may also optionally include a peripheral device interface 1003 and at least one peripheral device. The processor 1001, memory 1002, and peripheral device interface 1003 can be connected via a bus or signal line. Each peripheral device can be connected to the peripheral device interface 1003 via a bus, signal line, or circuit board. Specifically, the peripheral device includes at least one of the following: a radio frequency circuit 1004, a display screen 1005, a camera assembly 1006, an audio circuit 1007, and a power supply 1008.

[0279] Peripheral device interface 1003 can be used to connect at least one I / O (Input / Output) related peripheral device to processor 1001 and memory 1002. In some embodiments, processor 1001, memory 1002 and peripheral device interface 1003 are integrated on the same chip or circuit board; in some other embodiments, any one or two of processor 1001, memory 1002 and peripheral device interface 1003 can be implemented on separate chips or circuit boards, which is not limited in this embodiment.

[0280] The radio frequency (RF) circuit 1004 is used to receive and transmit RF (Radio Frequency) signals, also known as electromagnetic signals. The RF circuit 1004 communicates with communication networks and other communication devices via electromagnetic signals. The RF circuit 1004 converts electrical signals into electromagnetic signals for transmission, or converts received electromagnetic signals back into electrical signals. Optionally, the RF circuit 1004 includes: an antenna system, an RF transceiver, one or more amplifiers, a tuner, an oscillator, a digital signal processor, a codec chipset, a user identity module card, etc. The RF circuit 1004 can communicate with other terminals via at least one wireless communication protocol. This wireless communication protocol includes, but is not limited to: the World Wide Web, metropolitan area networks, intranets, various generations of mobile communication networks (2G, 3G, 4G, and 5G), wireless local area networks, and / or WiFi (Wireless Fidelity) networks. In some embodiments, the RF circuit 1004 may also include circuitry related to NFC (Near Field Communication), which is not limited in this application.

[0281] Display screen 1005 is used to display a UI (User Interface). This UI may include graphics, text, icons, videos, and any combination thereof. When display screen 1005 is a touch display screen, it also has the ability to collect touch signals on or above its surface. These touch signals can be input as control signals to processor 1001 for processing. In this case, display screen 1005 can also be used to provide virtual buttons and / or a virtual keyboard, also known as soft buttons and / or a soft keyboard. In some embodiments, there may be one display screen 1005, disposed on the front panel of terminal 1000; in other embodiments, there may be at least two display screens, disposed on different surfaces of terminal 1000 or in a folded design; in still other embodiments, display screen 1005 may be a flexible display screen, disposed on a curved or folded surface of terminal 1000. Furthermore, display screen 1005 may be configured as a non-rectangular, irregular shape, i.e., a non-rectangular screen. The display screen 1005 can be made of materials such as LCD (Liquid Crystal Display) and OLED (Organic Light-Emitting Diode).

[0282] The camera assembly 1006 is used to acquire images or videos. Optionally, the camera assembly 1006 includes a front-facing camera and a rear-facing camera. Typically, the front-facing camera is located on the front panel of the terminal, and the rear-facing camera is located on the back of the terminal. In some embodiments, there are at least two rear-facing cameras, which are any one of a main camera, a depth-sensing camera, a wide-angle camera, and a telephoto camera, to achieve background blurring by fusion of the main camera and the depth-sensing camera, panoramic shooting by fusion of the main camera and the wide-angle camera, VR (Virtual Reality) shooting, or other fusion shooting functions. In some embodiments, the camera assembly 1006 may also include a flash. The flash can be a single-color temperature flash or a dual-color temperature flash. A dual-color temperature flash refers to a combination of a warm-light flash and a cool-light flash, which can be used for light compensation at different color temperatures.

[0283] The audio circuit 1007 may include a microphone and a speaker. The microphone is used to collect sound waves from the user and the environment, converting the sound waves into electrical signals that are input to the processor 1001 for processing, or input to the radio frequency circuit 1004 for voice communication. For stereo sound acquisition or noise reduction purposes, multiple microphones may be used, each positioned at a different location on the terminal 1000. The microphone may also be an array microphone or an omnidirectional microphone. The speaker is used to convert electrical signals from the processor 1001 or the radio frequency circuit 1004 into sound waves. The speaker may be a conventional diaphragm speaker or a piezoelectric ceramic speaker. When the speaker is a piezoelectric ceramic speaker, it can convert electrical signals not only into audible sound waves but also into inaudible sound waves for purposes such as distance measurement. In some embodiments, the audio circuit 1007 may also include a headphone jack.

[0284] The power supply 1008 is used to power the various components in the terminal 1000. The power supply 1008 can be AC ​​power, DC power, a disposable battery, or a rechargeable battery. When the power supply 1008 includes a rechargeable battery, the rechargeable battery can be a wired rechargeable battery or a wireless rechargeable battery. A wired rechargeable battery is a battery that is charged via a wired line, while a wireless rechargeable battery is a battery that is charged via a wireless coil. The rechargeable battery can also be used to support fast charging technology.

[0285] In some embodiments, the terminal 1000 further includes one or more sensors 1009. The one or more sensors 1009 include, but are not limited to: an acceleration sensor 1010, a gyroscope sensor 1011, a pressure sensor 1012, an optical sensor 1013, and a proximity sensor 1014.

[0286] Accelerometer 1010 can detect the magnitude of acceleration along the three coordinate axes of a coordinate system established by terminal 1000. For example, accelerometer 1010 can be used to detect the components of gravitational acceleration along the three coordinate axes. Processor 1001 can control display screen 1005 to display the user interface in either a landscape or portrait view based on the gravitational acceleration signal acquired by accelerometer 1010. Accelerometer 1010 can also be used for games or for acquiring user motion data.

[0287] The gyroscope sensor 1011 can detect the orientation and rotation angle of the terminal 1000. The gyroscope sensor 1011 can work in conjunction with the accelerometer sensor 1010 to collect the user's 3D movements on the terminal 1000. Based on the data collected by the gyroscope sensor 1011, the processor 1001 can perform the following functions: motion sensing (e.g., changing the UI based on the user's tilt), image stabilization during shooting, game control, and inertial navigation.

[0288] The pressure sensor 1012 can be disposed on the side bezel of the terminal 1000 and / or on the lower layer of the display screen 1005. When the pressure sensor 1012 is disposed on the side bezel of the terminal 1000, it can detect the user's grip signal on the terminal 1000, and the processor 1001 can perform left / right hand recognition or quick operation based on the grip signal collected by the pressure sensor 1012. When the pressure sensor 1012 is disposed on the lower layer of the display screen 1005, the processor 1001 can control the operable controls on the UI interface based on the user's pressure operation on the display screen 1005. The operable controls include at least one of button controls, scroll bar controls, icon controls, and menu controls.

[0289] An optical sensor 1013 is used to collect ambient light intensity. In one embodiment, the processor 1001 can control the display brightness of the display screen 1005 based on the ambient light intensity collected by the optical sensor 1013. Specifically, when the ambient light intensity is high, the display brightness of the display screen 1005 is increased; when the ambient light intensity is low, the display brightness of the display screen 1005 is decreased. In another embodiment, the processor 1001 can also dynamically adjust the shooting parameters of the camera assembly 1006 based on the ambient light intensity collected by the optical sensor 1013.

[0290] The proximity sensor 1014, also known as a distance sensor, is typically installed on the front panel of the terminal 1000. The proximity sensor 1014 is used to detect the distance between the user and the front of the terminal 1000. In one embodiment, when the proximity sensor 1014 detects that the distance between the user and the front of the terminal 1000 is gradually decreasing, the processor 1001 controls the display screen 1005 to switch from a screen-on state to a screen-off state; when the proximity sensor 1014 detects that the distance between the user and the front of the terminal 1000 is gradually increasing, the processor 1001 controls the display screen 1005 to switch from a screen-off state to a screen-on state.

[0291] Those skilled in the art will understand that Figure 10 The structure shown does not constitute a limitation on terminal 1000 and may include more or fewer components than shown, or combine certain components, or use different component arrangements.

[0292] Figure 11This is a schematic diagram of a server structure provided in an embodiment of this application. The server 1100 can vary significantly due to different configurations or performance. It may include one or more Central Processing Units (CPUs) 1101 and one or more memories 1102. The memories 1102 store at least one line of program code, which is loaded and executed by the processor 1101 to implement the methods provided in the various method embodiments described above. Of course, the server may also have wired or wireless network interfaces, a keyboard, and input / output interfaces for input and output. The server may also include other components for implementing device functions, which will not be elaborated upon here.

[0293] Server 1100 can be used to execute the steps performed by the server in the above table display method.

[0294] This application also provides a computer device, which includes a processor and a memory. The memory stores at least one piece of program code, which is loaded and executed by the processor to implement the table display method of the above embodiments.

[0295] This application also provides a computer-readable storage medium storing at least one piece of program code, which is loaded and executed by a processor to implement the table display method of the above embodiments.

[0296] This application also provides a computer program product or computer program, which includes computer program code stored in a computer-readable storage medium. The processor of a computer device reads the computer program code from the computer-readable storage medium and executes the computer program code, causing the computer device to perform the table display method of the above embodiments.

[0297] Those skilled in the art will understand that all or part of the steps of the above embodiments can be implemented by hardware or by a program instructing related hardware. The program can be stored in a computer-readable storage medium, such as a read-only memory, a disk, or an optical disk.

[0298] The above are merely optional embodiments of the present application and are not intended to limit the present application. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present application should be included within the protection scope of the present application.

Claims

1. A method for displaying tables, characterized in that, The method includes: The target formula entered in the target cell is displayed in the table display interface. The target cell is the currently selected cell. In response to a selection operation on any region in the target formula, the part corresponding to the selected region in the target formula is determined as the target sub-formula; In response to a first preset operation on the target sub-formula, the output value of the target sub-formula is obtained. The target sub-formula is a formula that is any part of the target formula. The target sub-formula includes at least one of a function, variable, constant, or operator. The output value of the target sub-formula is displayed in the table display interface. Furthermore, the target sub-formula is a target function. In response to the first preset operation on the target sub-formula, detailed information of the target sub-formula is displayed. The detailed information includes the description information of the target sub-formula, and also includes at least one of each element in the target function, the description information of each element, the example function corresponding to the target function, or the value currently referred to by each element. The target sub-formula is a target function. The step of obtaining the output value of the target sub-formula in response to a first preset operation on the target sub-formula includes: obtaining the output value of the target function in response to the mouse pointer hovering position being located in the display area of ​​the target function; or, obtaining the output value of the target function in response to the cursor position being located within the target function; or, if the cursor position is located within another function, obtaining the output value of the target function in response to the operation of hovering the mouse pointer in the display area of ​​the target function; or, if the target function includes a target function identifier, obtaining the output value of the target function in response to the mouse pointer hovering position being located in the display area of ​​the target function identifier; or, if the target function includes the target function identifier, obtaining the output value of the target function in response to the operation of hovering the mouse pointer in the display area of ​​the target function identifier when the cursor position is located within another function. The target formula also includes at least one cell identifier, and the method further includes: in response to the mouse pointer hovering over the display area of ​​any cell identifier in the target formula, obtaining the value entered in the cell corresponding to the cell identifier; displaying the value entered in the cell in the table display interface, and highlighting the cell.

2. The method according to claim 1, characterized in that, The step of displaying the output value of the target sub-formula in the table display interface includes: The output value is displayed in the display area corresponding to the target sub-formula in the table display interface; or... The output value and an indicator mark pointing to the output value from the target sub-formula are displayed in any display area of ​​the table display interface.

3. The method according to claim 1, characterized in that, The step of displaying the target formula entered in the target cell in the table display interface includes: The target formula is displayed in the formula display area of ​​the table display interface; or, The target formula is displayed in the display area where the target cell is located.

4. The method according to claim 1, characterized in that, The method further includes: The table display interface shows the cell identifier corresponding to the target cell; In response to a second preset operation on the cell identifier, the output value of the target formula is obtained; The output value of the target formula is displayed in the table display interface.

5. The method according to claim 1, characterized in that, The method further includes: In response to a third preset operation on the target formula, the output value of the target formula is obtained; The output value of the target formula is displayed in the table display interface.

6. The method according to claim 1, characterized in that, The method further includes: In response to a fourth preset operation on the target formula, the output value of the target formula and the output value of each function in the target formula are obtained; The table display interface shows the output value of the target formula and the output value of each function.

7. The method according to claim 1, characterized in that, The method further includes: In response to a move operation on any cell, obtain the identifier of the first cell after the cell has been moved; Replace the second cell identifier in the target formula with the first cell identifier, where the second cell identifier is the cell identifier before the cell was moved.

8. The method according to claim 1, characterized in that, Before displaying the target formula entered in the target cell in the table display interface, the method further includes: In response to a selection operation on multiple cells, the first selected cell among the multiple cells is determined as the target cell.

9. The method according to claim 1, characterized in that, Before displaying the target formula entered in the target cell in the table display interface, the method further includes: In response to the selection operation of the target cell, the text data entered in the target cell is obtained; The text data is converted into the target formula.

10. The method according to claim 9, characterized in that, The step of converting the text data into the target formula includes: The text data is subjected to function recognition to obtain multiple functions in the text data and the reference relationships between the multiple functions. The reference relationship between any two functions indicates that the output value of the referenced function is used as an element in the referenced function. The target formula is determined based on the multiple functions and the reference relationships.

11. The method according to claim 9, characterized in that, The target formula includes multiple functions, each function including at least one cell identifier. After converting the text data into the target formula, the method further includes: Obtain the value entered in the cell corresponding to the at least one cell identifier; Based on the reference relationships between the multiple functions and at least one obtained value, the multiple functions are calculated sequentially to obtain the output value of each function.

12. A table display device, characterized in that, The device includes: The formula display module is used to display the target formula entered in the target cell in the table display interface, wherein the target cell is the currently selected cell; The output value acquisition module is used to determine the part corresponding to the selected region in the target formula as the target sub-formula in response to the selection operation of any region in the target formula; and to acquire the output value of the target sub-formula in response to the first preset operation of the target sub-formula, wherein the target sub-formula is a formula of any part of the target formula, and the target sub-formula includes at least one of function, variable, constant or operator. The output value display module is used to display the output value of the target sub-formula in the table display interface; The target sub-formula is a target function. The details display module is used to display the details of the target sub-formula in response to the first preset operation on the target sub-formula. The details include the description information of the target sub-formula, and also include at least one of each element in the target function, the description information of each element, the example function corresponding to the target function, or the value currently referred to by each element. The target sub-formula is a target function. The output value acquisition module is further configured to acquire the output value of the target function in response to the mouse pointer hovering position being located in the display area of ​​the target function; or, in response to the cursor position being located in the target function, acquire the output value of the target function; or, if the cursor position is located in another function, acquire the output value of the target function in response to the operation of hovering the mouse pointer in the display area of ​​the target function; or, if the target function includes a target function identifier, acquire the output value of the target function in response to the mouse pointer hovering position being located in the display area of ​​the target function identifier; or, if the target function includes the target function identifier, acquire the output value of the target function in response to the operation of hovering the mouse pointer in the display area of ​​the target function identifier when the cursor position is located in another function. The target formula further includes at least one cell identifier, and the device further includes: The input value acquisition module is used to acquire the value entered in the cell corresponding to any cell identifier in the target formula when the mouse pointer hovers over the display area of ​​the cell identifier. The input value display module is used to display the value entered in the cell in the table display interface, and to highlight the cell.

13. The apparatus according to claim 12, characterized in that, The output value display module is used for: The output value is displayed in the display area corresponding to the target sub-formula in the table display interface; or... The output value and an indicator mark pointing to the output value from the target sub-formula are displayed in any display area of ​​the table display interface.

14. The apparatus according to claim 12, characterized in that, The output value display module is used to display the target formula in the formula display area of ​​the table display interface; or... The target formula is displayed in the display area where the target cell is located.

15. The apparatus according to claim 12, characterized in that, The formula display module is also used to display the cell identifier corresponding to the target cell in the table display interface; The output value acquisition module is further configured to acquire the output value of the target formula in response to a second preset operation on the cell identifier; The output value display module is also used to display the output value of the target formula in the table display interface.

16. The apparatus according to claim 12, characterized in that, The output value acquisition module is further configured to acquire the output value of the target formula in response to a third preset operation on the target formula; The output value display module is also used to display the output value of the target formula in the table display interface.

17. The apparatus according to claim 12, characterized in that, The output value acquisition module is further configured to, in response to a fourth preset operation on the target formula, acquire the output value of the target formula and the output value of each function in the target formula; The output value display module is also used to display the output value of the target formula and the output value of each function in the table display interface.

18. The apparatus according to claim 12, characterized in that, The device further includes: The cell movement module is used to obtain the identifier of the first cell after the cell has been moved in response to a movement operation on any cell. The identifier replacement module is used to replace the second cell identifier in the target formula with the first cell identifier, wherein the second cell identifier is the cell identifier before the cell was moved.

19. The apparatus according to claim 12, characterized in that, The device further includes: The cell determination module is used to determine the first selected cell among the multiple cells as the target cell in response to a selection operation of multiple cells.

20. The apparatus according to claim 12, characterized in that, The device further includes: The text data acquisition module is used to acquire the text data entered in the target cell in response to the selection operation of the target cell; A conversion module is used to convert the text data into the target formula.

21. The apparatus according to claim 20, characterized in that, The conversion module is used for: The text data is subjected to function recognition to obtain multiple functions in the text data and the reference relationships between the multiple functions. The reference relationship between any two functions indicates that the output value of the referenced function is used as an element in the referenced function. The target formula is determined based on the multiple functions and the reference relationships.

22. The apparatus according to claim 12, characterized in that, The device further includes: The input value acquisition module is used to acquire the value entered in the cell corresponding to the at least one cell identifier; The output value acquisition module is also used to calculate the output value of each function in turn according to the reference relationship between the multiple functions and at least one acquired value.

23. A computer device, characterized in that, The computer device includes a processor and a memory, the memory storing at least one piece of program code, which is loaded and executed by the processor to perform the operations performed in the table display method as described in any one of claims 1 to 11.

24. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores at least one piece of program code, which is loaded and executed by a processor to perform the operations performed in the table display method as described in any one of claims 1 to 11.

25. A computer program product, characterized in that, The computer program product includes computer program code stored in a computer-readable storage medium, a processor of a computer device reads the computer program code from the computer-readable storage medium, and the processor executes the computer program code to cause the computer device to perform the operations described in any one of claims 1 to 11 in the table display method.

Images