Table processing method and device, electronic equipment, computer readable storage medium and computer program product

Abstract

The invention provides a table processing method and device, electronic equipment, a computer readable storage medium and a computer program product. The method comprises the steps of displaying a first table on a first table processing interface; in response to a selection operation for a first part of content in the first table, displaying a first formula matched with the first part of content; in response to a trigger operation of applying the first formula to the first part of content, a first operation result is displayed, and the first operation result is obtained by applying the first formula to the first part of content. According to the invention, the efficiency of applying the formula in the table can be improved.

Description

Technical Field

[0001] This application relates to data processing technology, and more particularly to a method, apparatus, electronic device, computer-readable storage medium, and computer program product for processing tables. Background Technology

[0002] When using spreadsheets, users often need to calculate data using formulas. When referencing a formula, users can enter the cell number. However, if the referenced formula doesn't match the cell content, the formula needs to be edited before it can be applied. Therefore, referencing formulas in spreadsheets is relatively inefficient. Summary of the Invention

[0003] This application provides a table processing method, apparatus, electronic device, computer-readable storage medium, and computer program product that can improve the efficiency of applying formulas in tables.

[0004] The technical solution of this application embodiment is implemented as follows:

[0005] This application provides a method for processing tables, the method including:

[0006] The first table is displayed on the first table processing interface;

[0007] In response to a selection operation on the first part of the content in the first table, a first formula that matches the first part of the content is displayed;

[0008] In response to a trigger operation that applies the first formula to the first part of the content, a first calculation result is displayed, wherein the first calculation result is obtained by applying the first formula to the first part of the content.

[0009] This application provides a form processing apparatus, the apparatus comprising:

[0010] The table display module is used to display the first table in the first table processing interface;

[0011] The formula display module is used to display a first formula that is adapted to the first part of the content in response to the selection operation of the first part of the content in the first table;

[0012] The result display module is configured to display a first calculation result in response to a trigger operation that applies the first formula to the first part of the content, wherein the first calculation result is obtained by applying the first formula to the first part of the content.

[0013] This application provides an electronic device, the electronic device comprising:

[0014] Memory is used to store executable instructions for a computer;

[0015] The processor, when executing computer-executable instructions stored in the memory, implements the table processing method provided in the embodiments of this application.

[0016] This application provides a computer-readable storage medium storing a computer program or computer-executable instructions for implementing the table processing method provided in this application when executed by a processor.

[0017] This application provides a computer program product, including a computer program or computer executable instructions. When the computer program or computer executable instructions are executed by a processor, they implement the table processing method provided in this application.

[0018] The embodiments of this application have the following beneficial effects:

[0019] By selecting the content in the first table that requires the application of formulas, users can intuitively perceive the content for which formulas need to be applied. This is faster and more accurate than existing technologies that require users to manually enter cell references. The first formula is displayed for the selected content, reusing existing formulas and saving users time in editing formulas for different content, thus improving the efficiency of formula application. Attached Figure Description

[0020] Figure 1 This is a schematic diagram of the architecture of the table processing system 100 provided in the embodiments of this application;

[0021] Figure 2 This is a schematic diagram of the structure of the terminal 400 provided in the embodiments of this application;

[0022] Figure 3A This is a first flowchart illustrating the table processing method provided in the embodiments of this application;

[0023] Figure 3B This is a second flowchart illustrating the table processing method provided in the embodiments of this application;

[0024] Figure 3C This is a schematic diagram of the third process of the table processing method provided in the embodiments of this application;

[0025] Figure 3D This is a schematic diagram of the fourth process of the table processing method provided in the embodiments of this application;

[0026] Figure 3E This is a fifth flowchart illustrating the table processing method provided in the embodiments of this application;

[0027] Figure 3F This is a sixth flowchart illustrating the table processing method provided in the embodiments of this application;

[0028] Figure 3G This is a seventh flowchart illustrating the table processing method provided in the embodiments of this application;

[0029] Figure 3H This is the eighth flowchart of the table processing method provided in the embodiments of this application;

[0030] Figure 3I This is a ninth flowchart illustrating the table processing method provided in the embodiments of this application;

[0031] Figure 3J This is a schematic diagram of the tenth process of the table processing method provided in the embodiments of this application;

[0032] Figure 4A This is a schematic diagram of the first application of the table processing method provided in the embodiments of this application;

[0033] Figure 4B This is a second application diagram of the table processing method provided in the embodiments of this application;

[0034] Figure 4C This is a schematic diagram illustrating the third application of the table processing method provided in the embodiments of this application;

[0035] Figure 4D This is a fourth application diagram of the table processing method provided in the embodiments of this application;

[0036] Figure 4E This is a fifth application diagram of the table processing method provided in the embodiments of this application;

[0037] Figure 4F This is a sixth application diagram of the table processing method provided in the embodiments of this application;

[0038] Figure 4G This is a seventh application diagram of the table processing method provided in the embodiments of this application;

[0039] Figure 4H This is an eighth application diagram of the table processing method provided in the embodiments of this application;

[0040] Figure 4I This is a ninth application diagram illustrating the table processing method provided in the embodiments of this application;

[0041] Figure 5 This is a schematic diagram illustrating the principle of training a machine learning model provided in an embodiment of this application;

[0042] Figure 6This is a flowchart illustrating the collection function formula provided in an embodiment of this application;

[0043] Figure 7 This is a flowchart illustrating the application function formula provided in the embodiments of this application.

[0044] It should be noted that the terms "first" and "second" mentioned above are only used to distinguish between different options and do not represent the degree of superiority or inferiority of the options or their priority in the implementation process. Detailed Implementation

[0045] To make the objectives, technical solutions, and advantages of this application clearer, the application will be further described in detail below with reference to the accompanying drawings. The described embodiments should not be regarded as limitations on this application. All other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0046] In the following description, references are made to “some embodiments,” which describe a subset of all possible embodiments. However, it is understood that “some embodiments” may be the same subset or different subsets of all possible embodiments and may be combined with each other without conflict.

[0047] In the following description, the terms "first / second / third" are used merely to distinguish similar objects and do not represent a specific ordering of objects. It is understood that "first / second / third" may be interchanged in a specific order or sequence where permitted, so that the embodiments of this application described herein can be implemented in an order other than that illustrated or described herein.

[0048] In this application embodiment, the terms "module" or "unit" refer to a computer program or part of a computer program that has a predetermined function and works with other related parts to achieve a predetermined goal, and can be implemented wholly or partially using software, hardware (such as processing circuitry or memory), or a combination thereof. Similarly, a processor (or multiple processors or memory) can be used to implement one or more modules or units. Furthermore, each module or unit can be part of an overall module or unit that includes the functionality of that module or unit.

[0049] Unless otherwise specified, "at least one" as used below refers to one or more cases, and "multiple" can refer to two or more cases.

[0050] Unless otherwise defined, all technical and scientific terms used in the embodiments of this application have the same meaning as commonly understood by one of ordinary skill in the art. The terminology used in the embodiments of this application is for the purpose of describing the embodiments of this application only and is not intended to limit this application.

[0051] In the implementation of this application, the collection and processing of relevant data should strictly comply with the requirements of relevant laws and regulations, obtain the informed consent or separate consent of the personal information subject, and carry out subsequent data use and processing within the scope of laws and regulations and the authorization of the personal information subject.

[0052] Before providing a further detailed description of the embodiments of this application, the nouns and terms involved in the embodiments of this application will be explained, and the nouns and terms involved in the embodiments of this application shall be interpreted as follows.

[0053] 1) An electronic spreadsheet is an electronic data sheet that relies on a computer system for access and editing. It is used to organize, store, analyze, and process data in rows and columns. Spreadsheets offer powerful data processing functions, including data entry, formula calculation, chart generation, data filtering, and sorting.

[0054] 2) First table processing interface: The interface on the electronic device containing the first table used to display and process the first table. This can be the interface of a table application, a table app, or the interface in a browser used to display table content in an online table editing scenario.

[0055] 3) Formula identifier is a string or number used to uniquely identify, mark, or reference the first formula in a spreadsheet. It can be a formula name, serial number, location reference, or any other form of information to enable quick identification and access to the formula during data processing, storage, or management.

[0056] 4) Predefined formulas refer to a series of commonly used or standard calculation formulas built into spreadsheet software. These formulas are usually pre-written and can be used directly in the spreadsheet without requiring the user to write them. Predefined formulas typically include basic mathematical operations (such as addition, subtraction, multiplication, and division), statistical operations (such as average, median, and variance), logical operations (such as conditional statements), and text processing (such as string concatenation and replacement).

[0057] 5) Custom formulas refer to formulas written and saved by the user. These formulas are not built into the software but are customized by the user according to their needs. The purpose of custom formulas is to complete specific calculation tasks, such as complex financial calculations, data analysis, and logical judgments based on specific conditions.

[0058] 6) Parameter name refers to the variable name used to represent specific data or values ​​when writing the first formula in spreadsheet software. For example, in the formula: "SUMPRODUCT((A2:A100="Apple")*(B2:B100>0))+SUMPRODUCT((A2:A100="Orange")*(B2:B100>0))", "Apple" and "Orange" are both parameter names.

[0059] 7) Collaborative editing refers to a mode in which multiple terminals (e.g., a first terminal and a second terminal) simultaneously edit a table. In this mode, the table is also called an online table, and the results of the editing operations on the first terminal can be reflected in the table displayed on the second terminal in real time.

[0060] The applicant found that the application of formulas in the forms lacked specificity and applicability, as manifested in the following aspects:

[0061] 1. When using related technologies to perform calculations using formulas, the formulas need to specify the cells to be calculated. Then, the formulas are applied to calculate the contents of the table. When using formulas in different tables, the formulas need to be edited frequently, which wastes time and effort in the application process.

[0062] 2. In related technologies, the formula library is bound to the table. A formula library used to store custom formulas in one table cannot be reused in another table.

[0063] Based on the above analysis, the applicant found that the table processing methods of related technologies cannot directly call formulas that are compatible with the selected content in different tables. In order to address the above problem, the embodiments of this application provide a table processing method that can improve the efficiency of applying formulas in tables.

[0064] The following describes exemplary applications of the electronic devices provided in the embodiments of this application. These electronic devices can be implemented as various types of terminals such as laptops, tablets, desktop computers, set-top boxes, smartphones, smart speakers, smartwatches, smart TVs, and in-vehicle terminals, or as servers. The following will describe exemplary applications when the electronic device is implemented as a terminal.

[0065] See Figure 1 , Figure 1 This is a schematic diagram of the architecture of the table processing system 100 provided in the embodiments of this application. In order to support the processing application of a table, the terminal (terminal 400-1 and terminal 400-2 are shown as examples) connects to the server 200 through the network 300. The network 300 can be a wide area network or a local area network, or a combination of the two.

[0066] Terminal 400-1 or terminal 400-2 is used to display a first table processing interface on a human-computer interaction interface (human-computer interaction interface 410-1 and human-computer interaction interface 410-2 are shown as examples), display a first table on the first table processing interface, and display a first formula adapted to the first part of the content in response to a selection operation on the first part of the content, and display a first calculation result in response to a trigger operation of applying the first formula to the first part of the content.

[0067] Terminal 400-1 or terminal 400-2 is used to display a first table processing interface on a human-computer interaction interface (human-computer interaction interfaces 410-1 and 410-2 are shown exemplarily). The first table is displayed on the first table processing interface. In response to a selection operation on a first portion of the content in the first table, a query request is sent to server 200. Server 200 is used to query a first formula in a formula library that matches the first portion of the content and return the result to terminal 400-1 or terminal 400-2. Terminal 400-1 or terminal 400-2 displays the first formula that matches the first portion of the content. In response to a trigger operation that applies the first formula to the first portion of the content, a first calculation result is displayed.

[0068] Taking an online spreadsheet scenario as an example, if terminal 400-1 or terminal 400-2 applies the first formula to the first part of the content in the first spreadsheet and displays the first calculation result, it can be synchronized to another terminal via network 300 and server 200.

[0069] In some embodiments, server 200 may be a standalone physical server, a server cluster or distributed system composed of multiple physical servers, or a cloud server providing 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, content delivery networks (CDNs), and big data and artificial intelligence platforms. Terminals and servers can be connected directly or indirectly via wired or wireless communication, which is not limited in this embodiment.

[0070] See Figure 2 , Figure 2 This is a schematic diagram of the structure of the terminal 400 provided in the embodiment of this application. Figure 2 The terminal 400 shown includes at least one processor 460, a memory 450, at least one network interface 420, and a user interface 430. The various components in the terminal 400 are coupled together via a bus system 440. It is understood that the bus system 440 is used to implement communication between these components. In addition to a data bus, the bus system 440 also includes a power bus, a control bus, and a status signal bus. However, for clarity, ... Figure 2 The general labeled all buses as Bus System 440.

[0071] Processor 460 can be an integrated circuit chip with signal processing capabilities, such as a general-purpose processor, a digital signal processor (DSP), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. Among them, the general-purpose processor can be a microprocessor or any conventional processor, etc.

[0072] User interface 430 includes one or more output devices 431 that enable the presentation of media content, including one or more speakers and / or one or more visual displays. User interface 430 also includes one or more input devices 432, including user interface components that facilitate user input, such as a keyboard, mouse, microphone, touch screen display, camera, other input buttons and controls.

[0073] The memory 450 may be removable, non-removable, or a combination thereof. Exemplary hardware devices include solid-state storage, hard disk drives, optical disk drives, etc. The memory 450 may optionally include one or more storage devices physically located away from the processor 460.

[0074] The memory 450 may include volatile memory or non-volatile memory, or both. The non-volatile memory may be read-only memory (ROM), and the volatile memory may be random access memory (RAM). The memory 450 described in this application embodiment is intended to include any suitable type of memory.

[0075] In some embodiments, memory 450 is capable of storing data to support various operations, examples of which include programs, modules, and data structures or subsets or supersets thereof, as illustrated below.

[0076] Operating system 451 includes system programs for handling various basic system services and performing hardware-related tasks, such as the framework layer, core library layer, driver layer, etc., for implementing various basic business functions and handling hardware-based tasks;

[0077] The network communication module 452 is used to reach other electronic devices via one or more (wired or wireless) network interfaces 420, exemplary network interfaces 420 including: Bluetooth, WiFi, and Universal Serial Bus (USB), etc.

[0078] Presentation module 453 is configured to enable the presentation of information (e.g., a user interface for operating peripheral devices and displaying content and information) via one or more output devices 431 (e.g., a display screen, a speaker, etc.) associated with user interface 430;

[0079] The input processing module 454 is used to detect and translate one or more user inputs or interactions from one or more input devices 432.

[0080] In some embodiments, the apparatus provided in this application can be implemented in software. Figure 2 A processing device 455 for a table stored in memory 450 is shown. This device can be software in the form of programs and plug-ins, and includes the following software modules: a table display module 4551, a formula display module 4552, and a result display module 4553. These modules are logically connected and can therefore be arbitrarily combined or further separated according to the functions they implement. The functions of each module will be described below.

[0081] In some embodiments, the terminal or server can implement the table processing method provided in this application by running various computer-executable instructions or computer programs. For example, computer-executable instructions can be microprogram-level commands, machine instructions, or software instructions. Computer programs can be native programs or software modules in an operating system; they can be native applications (APPs), i.e., programs that need to be installed in the operating system to run, such as dedicated table editing APPs or instant messaging APPs; or they can be applets that can be embedded in any APP, i.e., programs that only need to be downloaded to a browser environment to run. In summary, the aforementioned computer-executable instructions can be any form of instruction, and the aforementioned computer programs can be any form of application, module, or plugin.

[0082] The table processing method provided in this application will be described in conjunction with exemplary applications and implementations of the terminals provided in the embodiments of this application.

[0083] See Figure 3A , Figure 3A This is a first flowchart illustrating the table processing method provided in this application embodiment, with the terminal as the main component, and combining... Figure 3A The steps shown are explained.

[0084] In step 101, the first table is displayed on the first table processing interface.

[0085] In some embodiments, the table processing method provided in this application is applied to a first terminal, and the first table processing interface is displayed on the first terminal. The first table can be a local table or an online table. The first table is also referred to as a first table file, and the first table file includes at least one page (sheet).

[0086] In some embodiments, when displaying any page of the first table, steps 102 and 103 may be performed.

[0087] In step 102, in response to a selection operation on the first part of the content in the first table, a first formula that matches the first part of the content is displayed.

[0088] In some embodiments, the first part of the content may be the content of at least one cell in a first table. The type of the first formula includes user-defined formulas and predefined formulas. The first formula includes cell numbers, parameters, parameter values, operators, or functions.

[0089] In some embodiments, Figure 3A Step 102 can be implemented by performing the following pre-operation: in response to the selection operation for the first part of the content in the first table, recommending a first formula that fits the first part of the content based on a pre-trained machine learning model, and displaying the first formula.

[0090] For example, see Figure 5 , Figure 5 This is a schematic diagram illustrating the principle of machine learning model training provided in the embodiments of this application. Figure 5 In this process, the machine learning model can be trained through the following steps: obtaining an initialized machine learning model; obtaining training samples and ground truth labels, where training samples include content samples and formula samples, and ground truth labels represent whether the formula samples are compatible with the content samples; calling the convolutional and fully connected layers of the initialized machine learning model based on the training samples to obtain predicted labels; determining the loss value based on the ground truth labels and predicted labels; and updating the parameters of the initialized machine learning model based on the loss value to obtain a pre-trained machine learning model.

[0091] For example, the machine learning model can be a Transformer model, a Latent Dirichlet Allocation (LDA) model, or a Multilayer Perceptron (MLP). Initializing the representation involves randomly assigning values ​​to the model's parameters, such as assigning all parameters to 0 or all parameters to 1.

[0092] In some embodiments, the loss values ​​of the true label and the predicted label are determined by a loss function, and the loss values ​​are backpropagated to update the parameters of the initialized machine learning model. The process of calculating the loss value and updating the parameters is repeated multiple times until the loss value no longer increases or decreases, at which point the iteration process stops, and a pre-trained machine learning model is formed.

[0093] For example, the loss function can be the mean squared error loss function, the cross-entropy loss function, the multi-label classification loss function, and the triplet loss function.

[0094] For example, backpropagation is implemented using the backpropagation algorithm, which calculates the gradient of each neuron from the output layer to the input layer and updates the neuron's weights and biases based on the gradients. Gradient descent is used to continuously update the parameters, thus reducing the loss value. Various gradient descent algorithms can be used, such as batch gradient descent, stochastic gradient descent, adaptive gradient descent, and momentum gradient descent.

[0095] This application embodiment improves the accuracy and efficiency of formula recommendation by training a machine learning model to recommend a first formula that matches the selected first part of the content.

[0096] In some embodiments, see Figure 3B , Figure 3B This is a second flowchart illustrating the table processing method provided in the embodiments of this application. Figure 3A Step 102 can be achieved through Figure 3B Steps 1021A to 1022A are implemented, and the details are explained below.

[0097] In step 1021A, in response to a selection operation on the first part of the content in the first table, the first part of the content is highlighted.

[0098] In some implementations, the selection operation can be a long press on the screen to select or circle the first part of the content in the first table; it can be an operation to select the first part of the content in the first table by entering the position of the first part of the content; or it can be an operation to drag the mouse to select the first part of the content in the first table.

[0099] In some embodiments, highlighting the first portion indicates that the first portion will be used to apply the first formula. The first portion may be highlighted using at least one of the following methods: highlighting, flashing, magnification, bolding, or underlining. The first portion includes at least one parameter name and its corresponding parameter value.

[0100] For example, if the first part is "apple: 10; banana: 20; orange: 30", then the parameter names include apple, banana and orange. The parameter value corresponding to the parameter name apple is 10, the parameter value corresponding to the parameter name banana is 20, and the parameter value corresponding to the parameter value orange is 30.

[0101] In step 1022A, in response to an input operation in the first cell of the first table, a first formula corresponding to the formula identifier entered in the input operation is displayed in a preview control that at least covers the second cell.

[0102] In some embodiments, the preview control can be displayed as a floating layer in the first table processing interface. The first cell and the second cell can be adjacent. The formula identifier can be either a formula name or a serial number. Different formula identifiers correspond to different formulas.

[0103] In some embodiments, the first formula includes at least one parameter name, and the adaptation of the first formula to the first part of the content can be reflected in the fact that the first formula and the first part of the content include the same parameter name.

[0104] Following the example of step 1021A above, the parameter names include apple, banana and orange. The parameter value corresponding to the parameter name apple is 10, the parameter value corresponding to the parameter name banana is 20, and the parameter value corresponding to the parameter value orange is 30. Then the first formula is SUM(apple: 10, banana: 20, orange: 30).

[0105] In some embodiments, see Figure 3C , Figure 3C This is a schematic diagram of the third process of the table processing method provided in the embodiments of this application. Figure 3A Step 102 can also be done through Figure 3C Steps 1021B to 1023B are implemented, and the details are explained below.

[0106] In step 1021B, in response to a selection operation on the first part of the content in the first table, the first part of the content is highlighted.

[0107] In some embodiments, highlighting the first portion indicates that the first portion will be used to apply the first formula.

[0108] In step 1022B, a first formula that matches the content of the first part is retrieved from the formula library.

[0109] In some embodiments, both predefined formulas and user-defined formulas are stored in a formula library. The formula library can be stored on a terminal or a server. If the formula library is stored on the terminal, in response to a selection operation on the first part of the content in the first table, a first formula matching the first part of the content is directly retrieved from the terminal's formula library. If the formula library is stored on the server, in response to receiving a formula query request, the formula query request is sent to the server, so that the server retrieves a first formula matching the first part of the content from the formula library and returns it to the terminal for display.

[0110] In some embodiments, the first part includes at least one parameter name and a corresponding parameter value, see [link to relevant documentation]. Figure 3D , Figure 3D This is a schematic diagram of the fourth process of the table processing method provided in the embodiments of this application. Figure 3C Step 1022B can be achieved through Figure 3D Steps 10221B to 10222B are implemented, and the details are explained below.

[0111] In step 10221B, at least one parameter name is compared with the parameter names included in the formulas in the formula library.

[0112] In some embodiments, at least one parameter name can be compared character by character with the formulas in the formula library to determine whether there is a formula in the formula library that matches all characters of at least one parameter name. If so, the formula that matches exactly is selected.

[0113] For example, if at least one parameter is named apple, and formula A in the formula library is "SUM(apple)", formula B is "AVG(orange)", and formula C is "SUM(banana, pear)", then formula A is a formula that exactly matches at least one parameter name.

[0114] In step 10222B, the formula obtained from the comparison, which includes only at least one parameter name, is taken as the first formula that is adapted to the content of the first part.

[0115] In some embodiments, there may be one or more first formulas. The adaptation characterizes the parameter names included in the first formula as being exactly the same as at least one parameter name.

[0116] In step 1023B, the first formula is displayed in a preview control that covers at least the third cell of the first table.

[0117] In some embodiments, the third cell may or may not be adjacent to the cells occupied by the first part of the content. The number of cells included in the area that at least covers the third cell can adaptively vary according to the length of the first formula; for example, the longer the first formula is, the more cells it includes, i.e., the two are positively correlated.

[0118] For example, if the cells in the area that covers the adjacent third cell are empty and the first formula can be fully displayed, then the first formula is displayed in the area that covers at least the third cell to achieve the following display of the first formula; otherwise, the first formula is displayed in the area that covers the non-adjacent third cells and are all empty cells to avoid the first formula obscuring the content of the first table.

[0119] For example, the first part of the content in the first table is in the range [A1:C3]. If the third cell is C4, then the third cell is adjacent to the first part of the content, and C4 and C5 are empty but can fully display the first formula, then the first formula will be displayed in the area covering C4 and C5. If the third cell is E5, then the third cell is not adjacent to the first part of the content. If E5 to E10 are empty but can fully display the first formula, then the first formula will be displayed in the area covering E5 to E10.

[0120] This application embodiment improves the accuracy of formula search by finding a formula in the formula library that includes only the parameter names in the first part of the content, so that the first formula has the same parameter names as the first part of the content.

[0121] In some embodiments, when there are multiple first formulas adapted to the first part of the content... Figure 3A Step 102, “Display the first formula that adapts to the content of the first part”, can also be achieved by performing the following process: displaying a formula list, wherein the formula list includes multiple first formulas that adapt to the content of the first part.

[0122] In some embodiments, the order of multiple first formulas in the formula list may be determined based on at least one of click-through rate, usage time, or addition time.

[0123] For example, taking click-through rate as an example, if the click-through rate of the first formula D is 60% in a week, the click-through rate of the first formula E is 90% in a week, and the click-through rate of the first formula F is 30% in a week, then the order of multiple first formulas in the formula list can be: formula E, formula D, and formula F.

[0124] In some embodiments, if the sorting order is determined by a combination of click-through rate (CTR), usage time, and addition time, priorities can be set for CTR, usage time, and addition time. If the priority order is CTR, usage time, and addition time, then multiple first formulas are sorted in descending order of CTR; if at least two first formulas have the same CTR, they are sorted in ascending order of usage time; if at least two first formulas have the same usage time, at least one first formula is sorted in ascending order of addition time.

[0125] In step 103, in response to a triggering operation that applies the first formula to the first part of the content, a first calculation result is displayed, wherein the first calculation result is obtained by applying the first formula to the first part of the content.

[0126] In some embodiments, a triggering operation refers to the operation of applying the first formula to the first part of the content by triggering a control or hardware device. This can be achieved by triggering a button in a hardware device (e.g., a keyboard) connected to the terminal displaying the first table processing interface; or by triggering an application control capable of controlling the application of the first formula.

[0127] In some embodiments, the location where the first calculation result is displayed can be a specified location. The location where the first calculation result is displayed can be specified by a location specification operation. For example, the location specification operation can be a cell click operation, and the clicked cell is used as the cell to display the calculation result.

[0128] As an example of step 103, in response to a triggering operation that applies the first formula to the first part of the content, such as clicking the first formula, and a positional operation for a specific cell, such as clicking a specific cell to display the first calculation result in the specific cell, wherein the specific cell is a free cell adjacent to the first part of the content.

[0129] As an example of step 103, in response to an operation specifying the position of a specific cell, such as clicking a specific cell, starting from the specific cell, selecting a first part of the content in the first table and displaying a first formula that matches the first part of the content, in response to a triggering operation that applies the first formula to the first part of the content, displaying the first calculation result in an empty cell adjacent to the first part of the content.

[0130] As an example of step 103, the trigger operation of applying the first formula to the first part of the content can be reused for the calculation of the trigger formula and the specified output position. In this case, the trigger operation can be the operation of clicking a specific cell. The specific cell can be a cell that is adjacent to and free of the first part of the content. In response to the trigger operation, the first calculation result is displayed in the specific cell.

[0131] This application embodiment improves operational efficiency by reusing the trigger operation to calculate the trigger formula and specify the output position, thereby displaying the calculation result in a specific cell.

[0132] In other embodiments, the position where the first calculation result is displayed can be an automatically matched position. As an example, if the first part of the content is a row or a column, the first calculation result is automatically displayed in an empty position in that row or column (e.g., a position adjacent to already displayed content).

[0133] In some embodiments, when there are multiple first formulas adapted to the first part of the content, when displaying multiple formulas adapted to the first part of the content through the above formula list, Figure 3A Step 103, “In response to a trigger operation that applies the first formula to the first part of the content, display the first calculation result”, can be achieved by performing the following process: In response to a selection operation for the target first formula, display the first calculation result, wherein the first calculation result is obtained by applying the target first formula to the first part of the content.

[0134] As an example of steps 101 to 103, when step 102 is implemented via steps 1021A to 1022A, see [link to example]. Figure 4A , Figure 4A This is a schematic diagram illustrating the first application of the table processing method provided in this application embodiment. Figure 4A In the left-hand image, the first table 902 is displayed in the first table processing interface 901. In response to a selection operation on the first portion 903 of the first table 902, in... Figure 4A In the intermediate image, the first part 903 is highlighted, for example, by using a highlighting method. In response to an input operation in the first cell (C8) of the first table 902, the first formula 906 corresponding to the formula identifier 904 (i.e., "Fruit Calculation Formula") entered in the input operation is displayed in the preview control 905, which at least covers the second cell (C9). In response to a trigger operation that applies the first formula 906 to the first part 903, in Figure 4A In the right-hand image, the first calculation result 907 is displayed in the first cell (C8).

[0135] As an example of steps 101 to 103, when step 102 is implemented via steps 1021B to 1023B, see [link to relevant documentation]. Figure 4B , Figure 4B This is a second application illustration of the table processing method provided in the embodiments of this application. Figure 4B In the left-hand image, the first table 902 is displayed in the first table processing interface 901. In response to a selection operation on the first portion 903 of the first table 902, in... Figure 4B In the intermediate image, the first part 903 is highlighted, for example, by using a highlighting method. A first formula matching the first part 903 is retrieved from the formula library, and the first formula 906 is displayed in a preview control 908 that covers at least the third cell (A9) of the first table. In response to the triggered operation of applying the first formula 906 to the first part 903, in... Figure 4B In the right-hand image, the first calculation result 907 is displayed in the first cell (C8).

[0136] As an example of steps 101 to 103, when step 102 is implemented using the above "Display Formula List", see [link to example]. Figure 4C , Figure 4C This is a schematic diagram illustrating the third application of the table processing method provided in this application embodiment. Figure 4C In the left-hand image, the first table 902 is displayed in the first table processing interface 901. In response to a selection operation on the first portion 903 of the first table 902, in... Figure 4C In the intermediate image, formula list 909 is displayed, which includes multiple first formulas adapted to the content of the first part. In response to a selection operation for a target first formula 910, in Figure 4C The right-hand diagram shows the first calculation result 907, which is obtained by applying the target first formula 910 to the first part 903.

[0137] In this embodiment of the application, when there are multiple first formulas that are adapted to the first part of the content, multiple first formulas are displayed through a formula list, and a target first formula is selected for application, which improves the diversity of formula selection and the completeness of formula display.

[0138] In some embodiments, see Figure 3E , Figure 3E This is a schematic diagram of the fifth process of the table processing method provided in the embodiments of this application. Figure 3C Before step 1022A, "Display the first formula corresponding to the formula identifier entered in the input operation", execute... Figure 3E Steps 201 to 202 are explained in detail below.

[0139] In step 201, the index table is queried based on the formula identifier to obtain the storage location associated with the formula identifier.

[0140] In some embodiments, the index table stores the formula identifier of the formula and the storage location of the formula identifier in the formula library.

[0141] For example, if the index table is {first formula identifier: A1, second formula identifier: A2}, it means that the first formula identifier of the first formula is stored in position A1 of the formula library, and the second formula identifier of the second formula is stored in position A2 of the formula library.

[0142] In step 202, a first formula is retrieved from the formula library based on its storage location. The formula library contains at least one type of formula: custom formulas and predefined formulas. The formula library is used to reuse formulas in different tables.

[0143] In some embodiments, the formula library includes multiple formulas and their corresponding storage locations, where each storage location represents the position of each formula within the formula library. Custom and predefined formulas stored in the formula library can be reused in different tables, which can be multiple pages of a single table file or multiple different table files.

[0144] In some embodiments, each user may have their own formula library, with different names for different users' formula libraries; when the first table is an online table, different users may share a single formula library.

[0145] In some embodiments, see Figure 3F , Figure 3F This is a schematic diagram of the sixth process of the table processing method provided in the embodiments of this application. Figure 3E Step 202 can be achieved through Figure 3F Steps 2021 and 2022 will be implemented, as detailed below.

[0146] In step 2021, based on the first object identifier of the first object logged in in the first table processing interface, the formula library associated with the first object identifier is queried.

[0147] In some embodiments, different objects have different object identifiers, and different object identifiers are associated with different formula libraries.

[0148] For example, the first object of the first object is identified as x1 and associated with formula library 1; the second object of the second object is identified as x2 and associated with formula library 2; and the third object of the third object is identified as x3 and associated with formula library 3.

[0149] This application's embodiments associate formula libraries with object identifiers, with different object identifiers associated with different formula libraries. Joint queries can be performed based on object identifiers and formula identifiers. Compared to the prior art where different custom formulas and the object identifiers of the objects defining the formulas are stored in the same database, even if formula identifiers are duplicated in different formula libraries, there will be no confusion, allowing different objects to edit the same formula identifier in different formula libraries.

[0150] In step 2022, the first formula is retrieved from the formula library associated with the first object identifier based on the storage location.

[0151] In some embodiments, the storage order of formulas in the formula library may be related to at least one of the last usage time, formula creation time, or number of uses. When the formula library uses different storage orders, the storage order of each formula in the formula library may be different.

[0152] This application embodiment associates an object identifier with a formula library and retrieves a first formula from the formula library associated with the first object identifier based on the storage location. This makes the first formula associated with the user, and the user can use the first formula in multiple tables of the logged-in account, realizing cross-table use of formulas. At the same time, different users are associated with different formula libraries, which makes different users isolated and protects user privacy.

[0153] In some embodiments, see Figure 3G , Figure 3G This is a schematic diagram of the seventh process of the table processing method provided in this application embodiment. If there is no first formula adapted to the first part of the content, and the first part of the content includes multiple parameter names and corresponding parameter values, then the following steps are executed: Figure 3G Steps 301 to 303 are explained in detail below.

[0154] In step 301, a second formula is queried from the formula library, including at least some of the multiple parameter names, and the second formula is displayed, wherein the type of the second formula includes at least one of custom formulas and predefined formulas.

[0155] In some embodiments, a second formula may be obtained by querying a formula library that includes at least some of the parameter names and has the highest degree of overlap with the parameter names.

[0156] For example, multiple parameters are named "apple", "banana" and "orange". Formula A is "SUM(apple)" and has an overlap of 33.3% with the parameter names. Formula B is "AVG(apple, pear)" and has an overlap of 33.3% with the parameter names. Formula C is "SUM(apple, banana)" and has an overlap of 66.7% with the parameter names. Since formula C has the highest overlap with the parameter names, it is chosen as the second formula.

[0157] In step 302, in response to the editing operation on the second formula, the first formula formed by the editing is displayed.

[0158] In some embodiments, the editing operation may be to modify the parameter name, operator, or function in the second formula.

[0159] In step 303, in response to the triggering operation of applying the first formula to the first part of the content, the first calculation result is displayed.

[0160] In some embodiments, the triggering operation may be triggering the Enter key on the keyboard connected to the first terminal, or triggering the application button on the first form processing interface.

[0161] For examples of steps 301 to 303, see Figure 4D , Figure 4D This is a fourth application diagram illustrating the table processing method provided in this application embodiment. Figure 4D In the left-hand image, the first table 902 is displayed in the first table processing interface 901. In response to a selection operation on the first part of content 903 in the first table 902, if no first formula matches the first part of content 903, and the first part of content 903 includes multiple parameter names and corresponding parameter values ​​(e.g., parameter name apple and corresponding parameter value 10, parameter name apple and corresponding parameter value 20, parameter name banana and corresponding parameter value 15, and parameter name orange and corresponding parameter value 25), a second formula 911 is retrieved from the formula library, including at least some of the multiple parameter names. For example, the second formula 911 includes the parameter names apple and banana, and the second formula 911 is displayed. In response to an editing operation on the second formula 911, in... Figure 4D The intermediate image shows the first formula 906 formed through editing. In response to the triggering operation of applying the first formula 906 to the first part 903, in... Figure 4D The right-hand image shows the first calculation result, 907.

[0162] As an alternative to steps 301 to 303 above, if no first formula matching the first part of the content is found in the formula library, the similarity between multiple parameter names and multiple formulas in the formula library can be calculated. Based on the similarity, the multiple formulas in the formula library are sorted in descending order of similarity, and the formula with the highest similarity is selected as the second formula. In response to the editing operation on the second formula, the edited first formula is displayed. In response to the triggering operation of applying the first formula to the first part of the content, the first calculation result is displayed.

[0163] For example, at least one parameter name is vectorized to obtain a parameter name feature vector; multiple formulas are vectorized separately to obtain multiple formula feature vectors; cosine similarity, Euclidean distance, Manhattan distance, or Pearson correlation coefficient can be used to calculate the similarity between the parameter name feature vector and the multiple formula feature vectors respectively.

[0164] For example, for each formula feature vector among multiple formula feature vectors, determine the vector product of the parameter name feature vector and the formula feature vector, determine the length product of the length of the parameter name feature vector and the length of the formula feature vector, and determine the ratio of the vector product to the length product as the similarity.

[0165] For example, if the feature vector of the parameter name is m and the feature vector of the formula is n, then the vector product is m*n. The length of the feature vector of the parameter name is |m|, the length of the feature vector of the formula is |n|, and the product of the lengths is |m|*|n|. Therefore, the similarity is (m*n) / (|m|*|n|).

[0166] For example, formula A has a similarity of 90% with at least one parameter name, formula B has a similarity of 30% with at least one parameter name, and formula C has a similarity of 60% with at least one parameter name. Based on the similarity, the formulas in the formula library are sorted in descending order of similarity as follows: formula A, formula C, and formula B. If the preset number is 2, formula A is used as the second formula, and the second formula is edited to obtain the first formula. In response to the trigger operation of applying the first formula to the first part of the content, the first calculation result is displayed.

[0167] This application embodiment ensures that if the first formula cannot be found in the formula library, a fallback query can be performed. This ensures that a first formula that matches the first part of the content can be obtained by modifying a second formula that includes at least some of the same parameter names as the first part of the content or a second formula that is highly similar to multiple parameter names of the first part of the content.

[0168] In some embodiments, see Figure 3H , Figure 3H This is the eighth flowchart illustrating the table processing method provided in this application embodiment. Figure 3A Before step 102, "Display the first formula that adapts to the content of the first part", execute Figure 3H Steps 401 to 402 are explained in detail below.

[0169] In step 401, a query request carrying the identifier of the target object is sent to the server so that the server can query the first formula that matches the content of the first part in the formula library corresponding to the identifier of the target object. The target object is the object that logs into the first form processing interface.

[0170] In some embodiments, the server can use a preset interface to query the first formula that matches the content of the first part in the formula library corresponding to the identifier of the target object.

[0171] In some embodiments, see Figure 3I , Figure 3I This is a schematic diagram of the ninth process of the table processing method provided in the embodiments of this application. Figure 3H Before step 401, "Send a query request carrying the identifier of the target object to the server", execute... Figure 3I Steps 501 to 503 are explained in detail below.

[0172] In step 501, the first formula that matches the content of the first part is queried from the cached data of the table processing program.

[0173] In some embodiments, the cached data may be a formula for determining a predetermined number of the latest collections based on the collection time; it may be a formula for selecting a preset number of collections from a formula library based on the usage frequency in descending order of usage frequency; or it may be a formula for determining a preset number of collections whose time difference with the current time is less than a time threshold based on the last usage time.

[0174] For example, taking usage frequency as an example, if formula G is used 7 times a week, formula H is used 4 times a week, and formula I is used 9 times a week, the sorting result according to usage frequency from high to low is: formula I, formula G, and formula H. If the preset quantity is 2, then formula I and formula G will be stored in the cache data of the table processing program.

[0175] In step 502, in response to finding a first formula that matches the first part of the content in the cached data, the process proceeds to displaying the first formula that matches the first part of the content.

[0176] In some embodiments, if a first formula that matches the first part of the content is found in the cached data, the first formula that matches the first part of the content is displayed directly.

[0177] In step 503, in response to the failure to find a first formula that matches the first part of the content in the cached data, the process proceeds to sending a query request carrying the identifier of the target object to the server.

[0178] In some embodiments, if a first formula that matches the first part of the content is not found in the cached data, the server then searches for it in the formula library.

[0179] This application embodiment reduces formula query time by setting cached data, allowing direct querying of the first formula that matches the first part of the content from the cached data; if the first formula cannot be found in the cached data, the formula library is then queried, ensuring that the first formula that matches the first part of the content can be successfully returned.

[0180] See also Figure 3HIn step 402, the server returns a first formula that is compatible with the first part of the content.

[0181] In some embodiments, the server may return one or more first formulas and display them in a formula list so that the user can select any one of the first formulas in the formula list for application.

[0182] In some embodiments, the first formula is a custom formula edited and saved in a second table processing interface that processes the second table. The second table processing interface includes formula editing controls, see [link to documentation]. Figure 3J , Figure 3J This is a schematic diagram of the tenth process of the table processing method provided in this application embodiment. Figure 3A Before step 102, "Display the first formula that adapts to the content of the first part", execute Figure 3J Steps 601 to 604 are explained in detail below.

[0183] In step 601, the second table is displayed in the second table processing interface.

[0184] In some embodiments, the second table is a second table file, and the first table processing interface and the second table processing interface are used to process different table files.

[0185] In step 602, in response to a selection operation on the second part of the content in the second table, the second part of the content is highlighted, wherein the second part of the content includes at least one parameter name.

[0186] In some embodiments, there may be one or more second tables, and a second table may have one page or more pages, which is not limited here. When there is only one second table and the second table has only one page, a portion of the content selected from the second table can be used as the second part of the content; when there is only one second table and the second table has multiple pages, a portion of the content can be selected from each of the multiple pages and combined to form the second part of the content; when there are multiple second tables, a portion of the content is selected from each second table as sub-content, and the multiple sub-contents are used as the second part of the content.

[0187] In step 603, in response to an input operation in the formula editing control, a first formula is displayed, wherein the first formula includes at least one parameter name.

[0188] In some embodiments, a formula editing control is displayed in the second table processing interface. At least one parameter name in the first formula is the same as at least one parameter name in the second part of the content.

[0189] In step 604, in response to the triggering operation of the favorite button in the formula editing control, the first formula and the corresponding first formula identifier are saved to the formula library, wherein the formula library is used to reuse the first formula in a table different from the first table.

[0190] In some embodiments, in response to a trigger operation on the favorite button in the formula editing control, an input control is displayed in the second table processing interface; in response to an input operation on the first formula identifier, the first formula identifier is displayed in the input control; and in response to a trigger operation on the confirmation control in the input control, the first formula and the corresponding first formula identifier are saved to the formula library.

[0191] For example, different object identifiers are associated with different formula libraries. Different formula libraries can be maintained for different objects. In this case, the first formula and the first formula identifier are stored in the formula library corresponding to the object identifier of the currently logged-in object. Alternatively, the same formula library can be maintained for all objects. In this case, the first formula, the first formula identifier, and the object identifier of the currently logged-in object are stored in the formula library. The formula library includes the object identifiers of other objects, other custom formulas edited by other objects, and the formula identifiers corresponding to other custom formulas.

[0192] In some embodiments, the first formula identifier may be a custom name of the first formula.

[0193] For examples of steps 601 to 604, see Figure 4E , Figure 4E This is a fifth application illustration of the table processing method provided in the embodiments of this application. Figure 4E In the left-hand image, a second table 913 is displayed in the second table processing interface 912. In response to a selection operation on the second portion 914 of the second table 913, in... Figure 4E In the intermediate image, the second part 914 is highlighted, where the second part 914 includes at least one parameter name, such as apple or orange. The second table processing interface 913 includes a formula editing control 915, which, in response to an input operation in the formula editing control 915, displays a first formula 906, where the first formula 906 includes at least one parameter name, such as apple and orange. In response to a trigger operation on the favorite button 916 in the formula editing control 915, Figure 4EIn the right-hand diagram, an input control 917 is displayed in the second table processing interface 912. In response to an input operation on the first formula identifier 918, the first formula identifier 918 is displayed in the input control 917. In response to a trigger operation on the confirmation control 919 in the input control 917, the first formula 906 and the corresponding first formula identifier 918 (e.g., "fruit calculation formula") are saved to the formula library. The formula library is used to reuse the first formula in different tables.

[0194] In this embodiment, the custom formulas edited and saved in the second table can be applied to the first table, realizing the cross-file use of formulas. Compared with the situation where the first formula is copied from the second table and pasted into the first table before being applied to the first table, the portability of cross-file application of formulas is improved and the application speed of formulas is increased.

[0195] In some embodiments, Figure 3J Before step 604, "Save the first formula and its corresponding first formula identifier to the formula library", the following processing is performed: In response to the formula library including the first formula identifier, a first prompt message is displayed, wherein the first prompt message indicates that the first formula identifier is duplicated with the formula identifier in the formula library; In response to the editing operation on the first formula identifier, the formula identifier of the first formula is updated to the second formula identifier, and the second formula identifier is saved to the formula library; In response to the formula library not including the first formula identifier, the process proceeds to the step of saving the first formula and its corresponding first formula identifier to the formula library.

[0196] In some embodiments, before saving the first formula and its corresponding first formula identifier to the formula library, it is necessary to compare the first formula identifier with the formula identifiers in the formula library. When the first formula identifier is the same as the formula identifier in the formula library, that is, when the formula name is the same, the first formula identifier is changed to the second formula identifier and saved; when the formula name is not the same, the first formula identifier is directly saved to the formula library.

[0197] As an example, see the case where the formula library includes the first formula identifier. Figure 4F , Figure 4F This is a sixth application diagram illustrating the table processing method provided in this application embodiment. Figure 4F In the left-hand image, in response to the formula library including the first formula identifier 918, a first prompt message 920 is displayed. In response to an editing operation on the first formula identifier 918, in Figure 4F In the diagram on the right, the first formula identifier 918 is updated to the second formula identifier 921, and the second formula identifier 921 is saved to the formula library.

[0198] This application's embodiments check for duplicate formula identifiers before saving the formulas, ensuring the uniqueness of the formula identifiers, avoiding the same formula identifier corresponding to two different formulas, and improving the accuracy of the query.

[0199] In some embodiments, Figure 3J Before step 604, "save the first formula and the corresponding first formula identifier to the formula library", the following processing is performed: in response to the first formula identifier 918 not conforming to the naming rules, a second prompt message 922 is displayed; in response to the modification operation of the first formula identifier according to the second prompt message, the first formula and the modified first formula identifier are saved to the formula library, wherein the second prompt message is used to prompt the change of the first formula identifier.

[0200] In some embodiments, before saving the first formula and its corresponding first formula identifier to the formula library, the first formula identifier of the first formula is detected according to a naming rule. The naming rule may allow the formula identifier to include at least two of the following: letters, numbers, and underscores.

[0201] As an example, see the case where the first formula identifier does not conform to the naming rules. Figure 4G , Figure 4G This is a seventh application illustration of the table processing method provided in this application embodiment. Figure 4G In the left-hand image, in response to the first formula identifier 918 not conforming to the naming rules, such as the naming rule "formula identifier includes text and numbers", the second prompt message 922 is displayed. In response to the modification operation on the first formula identifier 918 based on the second prompt message 922, in... Figure 4G The right-hand image shows the modified first formula identifier 923, and the first formula 906 and the modified first formula identifier 923 are saved to the formula library.

[0202] This application embodiment detects the first formula identifier through naming rules, ensuring the compliance of the formula identifier so that the formula can be successfully stored in the formula library.

[0203] In some embodiments, when the first formula is edited and saved in a first table processing interface on a first terminal, the following process can be performed: synchronizing the first formula to at least one second terminal, wherein the second terminal is used to collaboratively edit the first table with the first terminal, the first formula is applied to a third part of the content, the third part of the content is a portion of the content selected from the first table displayed in a third table processing interface, and the third table processing interface is displayed on the second terminal.

[0204] In some embodiments, the first table may be an online table. Custom formulas entered and saved by the first terminal in the second table can be used by the second terminal in the first table.

[0205] This application embodiment synchronizes the first formula from the first terminal to the second terminal, so that the second terminal can also apply the custom formula of the first terminal. This breaks down the barrier that different terminals cannot directly call each other's custom formulas, and realizes the rapid application of the same custom formula on multiple terminals.

[0206] In some embodiments, where the first table is collaboratively edited by at least a first terminal and a second terminal, Figure 3A Before step 103, "In response to the trigger operation of applying the first formula to the first part of the content, display the first calculation result", the following processing is performed: If an editing operation for the first formula is received in the third table processing interface of the second terminal, and the trigger operation precedes the editing operation, the second terminal is triggered to display a third prompt message in the third table processing interface, wherein the third prompt message is used to indicate that the first formula cannot be edited during use; if the trigger operation is later than the editing operation, a fourth prompt message is displayed in the first table processing interface, wherein the fourth prompt message is used to indicate that the first formula cannot be applied during editing.

[0207] In some embodiments, if the first formula is applied on the first terminal while the first formula is edited on the second terminal, the timing order of the triggering operation of the first terminal and the editing operation of the second terminal is determined, and the operation that occurs first is executed first. When either operation is executed, the first formula is locked, and when the operation is completed, the lock on the first formula is released.

[0208] As an example, see Figure 4H , Figure 4H This is an eighth application diagram illustrating the table processing method provided in this application embodiment. Figure 4H In the left-hand diagram, when an editing operation for the first formula 906 is received in the third table processing interface 924 of the second terminal, if the triggering operation precedes the editing operation, the second terminal is triggered to display a third prompt message 925 in the third table processing interface 924. The third prompt message 925 indicates that the first formula 906 cannot be edited during use. Figure 4H In the right-hand diagram, if the triggering operation is later than the editing operation, a fourth prompt message 926 is displayed in the first table processing interface 901. The fourth prompt message 926 is used to indicate that the first formula 906 cannot be applied during the editing process.

[0209] This application embodiment locks the formula to ensure that when different terminals perform different operations on the same formula, only one operation can be performed at a time. This avoids the situation where multiple operations are performed on the formula at the same time, which may cause the table to crash or freeze. It ensures the uniformity of formula operation within a certain period of time and improves the smoothness of formula operation.

[0210] In some embodiments, the first formula is displayed in the preview control of the table processing interface. Figure 3A After step 103 "Display the first calculation result", the following processing is performed: in response to the editing operation on the first formula in the preview control, the third formula formed by the editing is displayed, and the first calculation result is updated to the second calculation result, wherein the second calculation result is obtained by applying the third formula to the first part of the content.

[0211] In some embodiments, in response to an editing operation on a first formula in a preview control, a third formula formed by the editing is displayed, and in response to a triggering operation that applies the third formula to a first portion of the content, the first calculation result is updated to a second calculation result.

[0212] In some embodiments, the preview control includes an apply button, and the triggering operation for applying the third formula to the first part of the content may be a triggering operation for the apply button.

[0213] As an example, see Figure 4I , Figure 4I This is a ninth application diagram illustrating the table processing method provided in this embodiment of the application. Figure 4I In the left-hand image, in response to an editing operation on the first formula 906 in the preview control 905, Figure 4I The intermediate image shows the edited third formula 927, which is triggered in response to the application of the third formula 927 to the first part of the content 903. Figure 4I In the right-hand diagram, the first calculation result 907 is updated to the second calculation result 928.

[0214] The following will describe an exemplary application of the embodiments of this application in the online form scenario of a document app.

[0215] The embodiments of this application are not limited to online table processing in document apps; they are also applicable in other scenarios, such as table mini-programs in instant messaging apps or browsers that can display and process tables. Furthermore, they are not limited to online tables; they are also applicable to local tables.

[0216] The relevant techniques often involve specifying the cells to be calculated in the formula, and then applying the formula to calculate the contents of the table. When using the formula in different tables, the formula needs to be edited frequently, which wastes time and effort in the application process.

[0217] This application's embodiment indicates the content in the first table that requires formula application through a selection operation, allowing users to intuitively perceive the content for which formulas need to be applied. Compared to existing technologies that require users to manually input cell references, this is faster and more accurate. The selected first part of the content displays an appropriate first formula, reusing existing formulas and saving users time editing formulas for different content, thus improving formula application efficiency.

[0218] See Figure 4E The middle image shows that when a user enters some function formula statements (i.e., the first formula), the user is given the ability to quickly bookmark them. After the user clicks the button (i.e. the bookmark button), the function (i.e., the first formula) can be quickly bookmarked.

[0219] See Figure 4E The right-hand image shows a function collection interface that provides users with a function collection interface after selecting a function formula and activating the collection function. Users can name frequently used function formulas (i.e., the first formula identifier) ​​for easy retrieval and use later.

[0220] See Figure 4A The functions and formulas saved by users can be used in the same way as the functions and formulas preset in the normal product. During the use of the product, users can enter the corresponding Chinese name (i.e., the first formula identifier) ​​after entering the equal sign to find the saved functions (i.e., the first formula), and then click to use them.

[0221] See Figure 6 , Figure 6 This is a flowchart illustrating the collection function formula provided in an embodiment of this application. Taking the terminal as the main component, it will be combined with... Figure 6 Steps 701 to 703 are described below.

[0222] In step 701, in response to an input operation for the function formula name (i.e., the first formula identifier), the input function formula name is obtained.

[0223] In some embodiments, the function formula name is initially verified to determine whether the function formula name conforms to a predetermined format (i.e., naming rules). For example, the predetermined format may contain only letters, numbers, and underscores.

[0224] In step 702, in response to the function formula name conforming to a predetermined format, the function formula name is validated.

[0225] In some embodiments, the function formula name is sent to the server (which may be the server 200 mentioned above), so that after receiving the function formula name, the server queries the database (i.e., the formula library) and determines whether the function formula name already exists. If the function formula name exists, an error message is returned; if the function formula name does not exist, step 703 is executed.

[0226] In step 703, the function formula is saved.

[0227] In some embodiments, a data model is designed to store the collection records of function formulas. This model includes at least a user identifier (ID), a function formula ID, and the collection time. An application programming interface (API) is obtained, through which function formulas can be added to the collection list. In response to receiving a collection request for a function formula, the collection request is sent to the server, so that the server checks whether the user (i.e., the target object) has already collected the function formula. If the function formula has not been collected, a new record is added to the formula library.

[0228] See Figure 7 , Figure 7 This is a flowchart illustrating the application function formula provided in an embodiment of this application. Taking the terminal as the main component, it will combine... Figure 7 Steps 801 to 803 shown will be explained.

[0229] In step 801, in response to an input operation for a function formula name in any cell of the table (i.e., the first cell), the formula list in the formula library is queried.

[0230] In some embodiments, the database includes database tables (formulas) that store detailed information about all function formulas, such as function name, content, and creation time. Each function formula has a unique ID.

[0231] In some embodiments, a list of formulas for saving function formulas can be retrieved via an HTTP GET request using a pre-designed interface. This interface queries the database based on the user ID and returns detailed information about the relevant function formulas.

[0232] In step 802, in response to finding the function formula name in the formula list, the function formula corresponding to the function formula name is returned.

[0233] In step 803, in response to the selection operation on the first part of the table, a function formula is applied to the first part of the table to obtain the calculation result (i.e., the first operation result).

[0234] To improve system performance and reduce database access frequency, caching technology can be used to temporarily store frequently accessed data. When a user requests a function formula, the system first checks if the data exists in the cache. If it does, the data is returned directly; otherwise, a database query is performed.

[0235] At the database level, query efficiency is optimized by creating appropriate indexes, ensuring that relevant data can be quickly located when a user requests a function formula. Simultaneously, query optimization techniques, such as query plan analysis, are used to reduce data retrieval time.

[0236] In a multi-user environment, the system needs to ensure the atomicity, consistency, isolation, and durability of data operations. Transaction management ensures that even in high-concurrency scenarios, user calls to saved function formulas will not cause data conflicts.

[0237] The retrieved data needs to be encapsulated and serialized according to a predefined data transmission format for network transmission. Lightweight data exchange formats such as JavaScript Object Notation (JSON) or Extensible Markup Language (XML) can be used for network transmission.

[0238] This application embodiment indicates the content in the first table that requires the application of formulas through a selection operation. This allows users to intuitively perceive the content for which formulas need to be applied, which is faster and more accurate than existing technologies that require users to manually input cell references. It displays the appropriate first formula for the selected first part of the content, reusing existing formulas and saving users time editing formulas for different content, thus improving formula application efficiency. By searching the formula library for formulas that only include the parameter names in the first part of the content, the first formula has the same parameter names as the first part of the content, improving the accuracy of formula lookup. When there are multiple first formulas that adapt to the first part of the content, multiple first formulas are displayed through a formula list, and the target first formula is selected for application, improving the diversity of formula selection and the completeness of formula display. By associating object identifiers with the formula library, the first formula is retrieved from the formula library associated with the first object identifier based on its storage location. This makes the first formula associated with the user, allowing the user to use the first formula in multiple tables of their logged-in account, achieving cross-table use of formulas. Furthermore, different users are associated with different formula libraries, ensuring isolation between different users and protecting user privacy. By setting up cached data, the first formula that matches the content of the first part can be directly queried from the cached data, reducing formula query time. If the first formula cannot be found in the cached data, the formula library is then queried, ensuring that the first formula that matches the content of the first part can be successfully returned. Custom formulas edited and saved in the second table can be applied to the first table, realizing cross-file use of formulas. Compared to the previous method of opening the second table, copying the first formula, and pasting it into the first table, this improves the portability of cross-file application of formulas and increases the speed of formula application. Before saving formulas, the formula identifier is checked for duplicates, ensuring the uniqueness of the formula identifier and preventing the same formula identifier from corresponding to two different formulas, thus improving the accuracy of the query.

[0239] The following description continues to illustrate the exemplary structure of the table processing apparatus 455 provided in the embodiments of this application as a software module. In some embodiments, such as Figure 2 As shown, the software module in the processing device 455 storing the table in the memory 450 may include:

[0240] The table display module 4551 is used to display the first table in the first table processing interface.

[0241] Formula display module 4552 is used to display a first formula that matches the first part of the content in response to a selection operation on the first part of the content in the first table.

[0242] The result display module 4553 is used to display the first calculation result in response to a trigger operation that applies the first formula to the first part of the content. The first calculation result is obtained by applying the first formula to the first part of the content.

[0243] In some embodiments, the formula display module 4552 is further configured to, in response to a selection operation on a first portion of content in a first table, highlight the first portion of content; and, in response to an input operation on a first cell in the first table, display a first formula corresponding to the formula identifier entered in the input operation in a preview control that at least covers a second cell.

[0244] In some embodiments, the formula display module 4552 is further configured to, in response to a selection operation on a first portion of content in a first table, highlight the first portion of content; query a first formula from a formula library that is compatible with the first portion of content; and display the first formula in a preview control that covers at least a third cell of the first table.

[0245] In some embodiments, the first part includes at least one parameter name and a corresponding parameter value. The formula display module 4552 is further configured to compare the at least one parameter name with the parameter names included in the formulas in the formula library; and to use the formula that only includes at least one parameter name obtained from the comparison as the first formula adapted to the first part.

[0246] In some embodiments, when there are multiple first formulas adapted to the first part of the content, the formula display module 4552 is further configured to display a formula list, wherein the formula list includes multiple first formulas adapted to the first part of the content.

[0247] In some embodiments, the formula display module 4552 is further configured to query an index table based on a formula identifier to obtain the storage location associated with the formula identifier; and retrieve a first formula from a formula library based on the storage location, wherein the formulas stored in the formula library include at least one of custom formulas and predefined formulas, and the formula library is used to reuse formulas in different tables.

[0248] In some embodiments, the formula display module 4552 is further configured to query the formula library associated with the first object identifier based on the first object identifier of the first object logged in the first table processing interface; and obtain the first formula from the formula library associated with the first object identifier based on the storage location.

[0249] In some embodiments, if there is no first formula adapted to the first part of the content, and the first part of the content includes multiple parameter names and corresponding parameter values, the formula display module 4552 is further configured to query a second formula from the formula library that includes at least some of the multiple parameter names, and display the second formula, wherein the type of the second formula includes at least one of a custom formula and a predefined formula; in response to an editing operation on the second formula, display the first formula formed by the editing; and in response to a triggering operation that applies the first formula to the first part of the content, display the first calculation result.

[0250] In some embodiments, the formula display module 4552 is further configured to send a query request carrying the identifier of the target object to the server, so that the server queries the formula library corresponding to the identifier of the target object for a first formula that matches the first part of the content, wherein the target object is the object that logs into the first form processing interface; and receive the first formula returned by the server that matches the first part of the content.

[0251] In some embodiments, the formula display module 4552 is further configured to query a first formula that matches the first part of the content in the cached data of the table processing program; in response to finding a first formula that matches the first part of the content in the cached data, proceed to the step of displaying the first formula that matches the first part of the content; in response to not finding a first formula that matches the first part of the content in the cached data, proceed to the step of sending a query request carrying the identifier of the target object to the server.

[0252] In some embodiments, the first formula is a custom formula edited and saved in a second table processing interface that processes the second table. The second table processing interface includes a formula editing control and a formula display module 4552, which is also used to display the second table in the second table processing interface; in response to a selection operation on a second part of the content in the second table, the second part of the content is highlighted, wherein the second part of the content includes at least one parameter name; in response to an input operation in the formula editing control, the first formula is displayed, wherein the first formula includes at least one parameter name; in response to a trigger operation on the save button in the formula editing control, the first formula and the corresponding first formula identifier are saved to the formula library, wherein the formula library is used to reuse the first formula in tables different from the first table.

[0253] In some embodiments, the formula display module 4552 is further configured to, in response to the formula library including a first formula identifier, display a first prompt message, wherein the first prompt message indicates that the first formula identifier is duplicated with a formula identifier in the formula library; in response to an editing operation on the first formula identifier, update the first formula identifier to a second formula identifier and save the second formula identifier to the formula library; and in response to the formula library not including a first formula identifier, proceed to the step of saving the first formula and the corresponding first formula identifier to the formula library.

[0254] In some embodiments, the formula display module 4552 is further configured to, in response to the first formula identifier conforming to the naming rules, proceed to the step of saving the first formula and the corresponding first formula identifier to the formula library; in response to the first formula identifier not conforming to the naming rules, display a second prompt message; and in response to the modification operation of the first formula identifier based on the second prompt message, save the first formula and the modified first formula identifier to the formula library, wherein the second prompt message is used to prompt the change of the first formula identifier.

[0255] In some embodiments, when the first formula is edited and saved in a first table processing interface of a first terminal, the formula display module 4552 is further configured to synchronize the first formula to at least one second terminal, wherein the second terminal is configured to collaboratively edit the first table with the first terminal, the first formula is applied to a third part of the content, the third part of the content is a portion of the content selected from the first table displayed in a third table processing interface, and the third table processing interface is displayed on the second terminal.

[0256] In some embodiments, when there are multiple first formulas adapted to the first part of the content, when multiple formulas adapted to the first part of the content are displayed through the above formula list, the result display module 4553 is further configured to display a first calculation result in response to a selection operation for the target first formula, wherein the first calculation result is obtained by applying the target first formula to the first part of the content.

[0257] In some embodiments, the result display module 4553 is further configured to, when receiving an editing operation for the first formula in the third table processing interface of the second terminal, if the triggering operation precedes the editing operation, trigger the second terminal to display a third prompt message in the third table processing interface, wherein the third prompt message is used to indicate that the first formula cannot be edited during use; if the triggering operation follows the editing operation, display a fourth prompt message in the first table processing interface, wherein the fourth prompt message is used to indicate that the first formula cannot be applied during editing.

[0258] In some embodiments, the result display module 4553 is further configured to display a third formula formed by editing the first formula in a preview control of a table processing interface, in response to an editing operation on the first formula in the preview control, and update the first calculation result to a second calculation result, wherein the second calculation result is obtained by applying the third formula to the first part of the content.

[0259] This application provides a computer program product, which includes a computer program or computer-executable instructions stored in a computer-readable storage medium. A processor of an electronic device reads the computer-executable instructions from the computer-readable storage medium and executes the computer-executable instructions, causing the electronic device to perform the processing method described in the table above in this application embodiment.

[0260] This application provides a computer-readable storage medium storing computer-executable instructions or a computer program. When the computer-executable instructions or the computer program are executed by a processor, the processor will execute the processing method of the table provided in this application, for example, such as... Figure 3A The table shown is processed in this way.

[0261] In some embodiments, the computer-readable storage medium may be a memory such as RAM, ROM, flash memory, magnetic surface memory, optical disk, or CD-ROM; or it may be a variety of devices including one or any combination of the above-mentioned memories.

[0262] In some embodiments, computer-executable instructions may take the form of programs, software, software modules, scripts, or code, written in any form of programming language (including compiled or interpreted languages, or declarative or procedural languages), and may be deployed in any form, including as stand-alone programs or as modules, components, subroutines, or other units suitable for use in a computing environment.

[0263] As an example, computer-executable instructions may, but do not necessarily, correspond to files in a file system. They may be stored as part of a file that holds other programs or data, for example, in one or more scripts in a Hyper Text Markup Language (HTML) table, in a single file dedicated to the program in question, or in multiple co-located files (e.g., files that store one or more modules, subroutines, or code sections).

[0264] As an example, computer-executable instructions can be deployed to execute on a single electronic device, or on multiple electronic devices located at one location, or on multiple electronic devices distributed across multiple locations and interconnected via a communication network.

[0265] In summary, through the embodiments of this application, the selection operation indicates the content in the first table that requires the application of formulas, allowing users to intuitively perceive the content for which formulas need to be applied. This is faster and more accurate than existing technologies that require users to manually input cell references. Displaying the appropriate first formula for the selected first part of the content reuses existing formulas, saving users time editing formulas for different content and improving formula application efficiency. By searching the formula library for formulas that only include the parameter names in the first part of the content, the first formula shares the same parameter names with the first part of the content, improving the accuracy of formula lookup. When there are multiple first formulas that adapt to the first part of the content, multiple first formulas are displayed through a formula list, and the target first formula is selected for application, improving the diversity of formula selection and the completeness of formula display. By associating object identifiers with the formula library, and retrieving the first formula from the formula library associated with the first object identifier based on its storage location, the first formula is associated with the user. Users can use the first formula in multiple tables of their logged-in account, achieving cross-table use of formulas. Furthermore, different users are associated with different formula libraries, ensuring isolation between users and protecting user privacy. By setting up cached data, the first formula that matches the content of the first part can be directly queried from the cached data, reducing formula query time. If the first formula cannot be found in the cached data, the formula library is then queried, ensuring that the first formula that matches the content of the first part can be successfully returned. Custom formulas edited and saved in the second table can be applied to the first table, realizing cross-file use of formulas, improving the portability of cross-file application of formulas, and improving the speed of formula application. Before saving formulas, the formula identifier is checked for duplicates, ensuring the uniqueness of the formula identifier and avoiding the same formula identifier corresponding to two different formulas, thus improving the accuracy of the query.

[0266] The above description is merely an embodiment of this application and is not intended to limit the scope of protection of this application. Any modifications, equivalent substitutions, and improvements made within the spirit and scope of this application are included within the scope of protection of this application.

Claims

1. A method for processing tables, characterized in that, The method includes: The first table is displayed on the first table processing interface; In response to a selection operation on the first part of the content in the first table, a first formula that matches the first part of the content is displayed; In response to a trigger operation that applies the first formula to the first part of the content, a first calculation result is displayed, wherein the first calculation result is obtained by applying the first formula to the first part of the content.

2. The method according to claim 1, characterized in that, The step of displaying a first formula adapted to the first part of the content in response to a selection operation on the first part of the content in the first table includes: In response to a selection operation on the first part of the content in the first table, the first part of the content is highlighted; In response to an input operation in the first cell of the first table, a first formula corresponding to the formula identifier entered in the input operation is displayed in a preview control that at least covers the second cell.

3. The method according to claim 2, characterized in that, Before displaying the first formula corresponding to the formula identifier entered by the input operation, the method further includes: Based on the formula identifier, the index table is queried to obtain the storage location associated with the formula identifier; The first formula is retrieved from the formula library based on the storage location, wherein the formula library stores at least one type of custom formula and predefined formula, and the formula library is used to reuse in different tables.

4. The method according to claim 3, characterized in that, The step of retrieving the first formula from the formula library based on the storage location includes: Based on the first object identifier of the first object logged in in the first table processing interface, query the formula library associated with the first object identifier; The first formula is retrieved from the formula library associated with the first object identifier based on the storage location.

5. The method according to claim 1 or 2, characterized in that, The step of displaying a first formula adapted to the first part of the content in response to a selection operation on the first part of the content in the first table includes: In response to a selection operation on the first portion of the content in the first table, the first portion of the content is highlighted, and Search the formula library for the first formula that matches the content of the first part; The first formula is displayed in a preview control that covers at least the third cell of the first table.

6. The method according to claim 5, characterized in that, The first part includes at least one parameter name and its corresponding parameter value; The step of querying the formula library for a first formula that matches the content of the first part includes: Compare the at least one parameter name with the parameter names included in the formulas in the formula library; The formula obtained from the comparison that includes only the name of at least one parameter will be used as the first formula that is compatible with the first part of the content.

7. The method according to any one of claims 1 to 4, characterized in that, When there are multiple first formulas that adapt to the first part of the content, displaying the first formulas that adapt to the first part of the content includes: Display a formula list, wherein the formula list includes multiple first formulas adapted to the content of the first part; The response to the triggering operation of applying the first formula to the first part of the content, displaying the first calculation result, includes: In response to a selection operation for a target first formula, a first calculation result is displayed, wherein the first calculation result is obtained by applying the target first formula to the first part of the content.

8. The method according to claim 1, characterized in that, If no formula exists that matches the first part of the content, and the first part of the content includes multiple parameter names and corresponding parameter values, the method further includes: Query the formula library for a second formula that includes at least a portion of the plurality of parameter names, and display the second formula, wherein the type of the second formula includes at least one of custom formulas and predefined formulas; In response to the editing operation on the second formula, the first formula resulting from the editing is displayed; In response to a trigger operation that applies the first formula to the first part of the content, the first calculation result is displayed.

9. The method according to claim 1, characterized in that, The first formula is displayed in the preview control of the table processing interface. After displaying the first calculation result, the method further includes: In response to the editing operation on the first formula in the preview control, the third formula formed by the editing is displayed, and the first calculation result is updated to a second calculation result, wherein the second calculation result is obtained by applying the third formula to the first part of the content.

10. The method according to claim 1, characterized in that, Before displaying the first formula adapted to the first portion of the content, the method further includes: A query request carrying the identifier of the target object is sent to the server so that the server can query the formula library corresponding to the identifier of the target object to find the first formula that matches the first part of the content, wherein the target object is the object that logs into the first table processing interface; Receive the first formula returned by the server that is compatible with the first part of the content.

11. The method according to claim 10, characterized in that, Before sending a query request carrying the identifier of the target object to the server, the method further includes: Query the cached data of the table processing program for the first formula that matches the content of the first part; In response to finding a first formula that matches the first part of the content in the cached data, proceed to the step of displaying the first formula that matches the first part of the content; In response to the failure to find a first formula that matches the first part of the content in the cached data, the process proceeds to the step of sending a query request carrying the identifier of the target object to the server.

12. The method according to claim 1 or 2, characterized in that, The first formula is a custom formula that is edited and saved in the second table processing interface, which includes formula editing controls. Before displaying the first formula adapted to the first portion of the content, the method further includes: The second table is displayed in the second table processing interface; In response to a selection operation on the second part of the content in the second table, the second part of the content is highlighted, wherein the second part of the content includes at least one parameter name; In response to an input operation in the formula editing control, the first formula is displayed, wherein the first formula includes the at least one parameter name; In response to a trigger operation on the favorite button in the formula editing control, the first formula and its corresponding first formula identifier are saved to the formula library, wherein the formula library is used to reuse the first formula in a table different from the first table.

13. The method according to claim 12, characterized in that, Before saving the first formula and its corresponding first formula identifier to the formula library, the method further includes: In response to the formula library including the first formula identifier, a first prompt message is displayed, wherein the first prompt message indicates that the first formula identifier is duplicated with a formula identifier in the formula library; In response to an editing operation on the first formula identifier, the first formula identifier is updated to a second formula identifier, and the second formula identifier is saved to the formula library; If the formula library does not include the first formula identifier, proceed to the step of saving the first formula and the corresponding first formula identifier to the formula library.

14. The method according to claim 13, characterized in that, Before saving the first formula and its corresponding first formula identifier to the formula library, the method further includes: In response to the first formula identifier conforming to the naming rules, proceed to the step of saving the first formula and the corresponding first formula identifier to the formula library; In response to the first formula identifier not conforming to the naming rules, a second prompt message is displayed. In response to the modification operation of the first formula identifier based on the second prompt message, the first formula and the modified first formula identifier are saved to the formula library, wherein the second prompt message is used to prompt the modification of the first formula identifier.

15. The method according to any one of claims 1 to 4, characterized in that, When the first formula is edited and saved in the first table processing interface of the first terminal, the method further includes: The first formula is synchronized to at least one second terminal, wherein the second terminal is used to collaboratively edit the first table with the first terminal, the first formula is applied to a third part of the content, the third part of the content is a portion of the content selected from the first table displayed in a third table processing interface, and the third table processing interface is displayed in the second terminal.

16. The method according to any one of claims 1 to 4, characterized in that, When the first table is collaboratively edited by at least a first terminal and a second terminal, before displaying the first calculation result in response to a trigger operation that applies the first formula to the first portion of the content, the method further includes: When an editing operation for the first formula is received in the third table processing interface of the second terminal, If the triggering operation precedes the editing operation, the second terminal is triggered to display a third prompt message in the third table processing interface, wherein the third prompt message is used to indicate that the first formula cannot be edited during use; If the triggering operation is later than the editing operation, a fourth prompt message is displayed in the first table processing interface, wherein the fourth prompt message is used to indicate that the first formula cannot be applied during the editing process.

17. A form processing apparatus, characterized in that, The device includes: The table display module is used to display the first table in the first table processing interface; The formula display module is used to display a first formula that is adapted to the first part of the content in response to the selection operation of the first part of the content in the first table; The result display module is configured to display a first calculation result in response to a trigger operation that applies the first formula to the first part of the content, wherein the first calculation result is obtained by applying the first formula to the first part of the content.

18. An electronic device, characterized in that, The electronic device includes: Memory is used to store executable instructions for a computer; A processor, when executing computer-executable instructions stored in the memory, implements the table processing method according to any one of claims 1 to 16.

19. A computer-readable storage medium storing computer-executable instructions or a computer program, characterized in that, When the computer-executable instructions or computer program are executed by a processor, they implement the table processing method according to any one of claims 1 to 16.

20. A computer program product comprising computer-executable instructions or a computer program, characterized in that, When the computer-executable instructions or computer program are executed by a processor, they implement the table processing method according to any one of claims 1 to 16.

Images