Table data processing method and apparatus, device, storage medium and computer program

Abstract

Embodiments of the present disclosure provide a table data processing method and apparatus, device and storage medium, the method comprising: displaying a field interface in response to a trigger operation on a field control in a table page; determining a field component and a first field in the field interface; displaying a second field in the table page based on the field component and the first field; and generating second data in a data column corresponding to the second field, which is generated using the field component based on the first data in the data column corresponding to the first field, wherein the field type of the second field is determined according to the field component.

Description

Technical Field

[0001] [Cross - reference to Related Applications] This application claims the priority of a Chinese patent application with the application number 202410797889.4 and the invention title "Table Data Processing Method, Apparatus, Device, and Storage Medium", which was filed with the China National Intellectual Property Administration on June 19, 2024, and the content of which is hereby incorporated by reference in its entirety into this application.

[0002] [Technical Field] Embodiments of the present disclosure relate to the field of computer technology, and particularly to a table data processing method, apparatus, device, and storage medium.

Background Art

[0003] Users can store and manage data using tables. A table may be an online database in the form of a table to realize data storage, analysis, and visualization. The table may include at least one field. The field can be used to ensure the format specification of the content entered in the column by determining that the data of the entire column where the field is located has similar data attributes.

Summary of the Invention

[0004] In a first aspect, according to embodiments of the present disclosure, in response to a trigger operation on a field control in a table page, display a field interface, and determine a field component and a first field in the field interface, and The present invention provides a table data processing method that includes displaying a second field on the table page based on the field component and the first field, and generating second data in a data column corresponding to the second field, which is generated using the field component based on the first data in the data column corresponding to the first field, wherein the field type of the second field is determined according to the field component.

[0005] In a second aspect, according to the embodiments of this disclosure, A display module for displaying the field interface in response to a trigger operation on a field control in a table page, The field interface includes a determination module for determining a field component and a first field, A table data processing device is provided, which includes a processing module for displaying a second field on the table page based on the field component and the first field, and for generating second data in a data column corresponding to the second field, which is generated using the field component based on the first data in the data column corresponding to the first field, wherein the field type of the second field is determined according to the field component.

[0006] In a third aspect, according to the embodiments of the present disclosure, the processor and memory are included. The aforementioned memory stores computer execution instructions, The present invention provides an electronic device that, when the processor executes a computer execution instruction stored in the memory, causes the processor to execute the table data processing method described in the first embodiment and various possible designs of the first embodiment.

[0007] In a fourth aspect, an embodiment of the present disclosure provides a computer-readable storage medium that stores computer execution instructions that, when executed by a processor, implement the table data processing method described in the first aspect and various possible designs of the first aspect.

[0008] In a fifth aspect, an embodiment of the present disclosure provides a computer program product that, when executed by a processor, implements the table data processing method described in the first aspect and various possible designs of the first aspect. [Brief explanation of the drawing]

[0009] To more clearly illustrate the embodiments of this disclosure or the technical concepts in the prior art, the following briefly introduces the drawings that may be used in describing the embodiments or the prior art. Clearly, the drawings in the following description are some embodiments of this disclosure, and those skilled in the art can obtain other drawings based on these without any creative effort. [Figure 1] This is a schematic diagram illustrating an application scene according to an embodiment of the present disclosure. [Figure 2] This is a schematic flowchart of a table data processing method according to an embodiment of the present disclosure. [Figure 3] This is a schematic diagram of a field control according to an embodiment of the present disclosure. [Figure 4] This is a schematic diagram of a field interface according to an embodiment of the present disclosure. [Figure 5] This is a schematic diagram of another table data processing method according to an embodiment of the present disclosure. [Figure 6] This is a schematic diagram of a component selection control according to an embodiment of the present disclosure. [Figure 7] This is a schematic diagram of a field selection control according to an embodiment of the present disclosure. [Figure 8] This is a schematic diagram of another table data processing method according to an embodiment of the present disclosure. [Figure 9] This is a schematic diagram of yet another table data processing method according to an embodiment of the present disclosure. [Figure 10] This is a schematic diagram of another table page according to an embodiment of the present disclosure. [Figure 11] This is a schematic diagram of the structure of a table data processing device according to an embodiment of the present disclosure. [Figure 12] This is a schematic diagram of the hardware structure of an information display device according to an embodiment of the present disclosure. [Modes for carrying out the invention]

[0010] To further clarify the purpose, technical proposals, and advantages of the embodiments of this disclosure, the technical proposals of the embodiments of this disclosure are described below clearly and completely with reference to the drawings of the embodiments of this disclosure. Of course, the embodiments described are only a part of the embodiments of this disclosure, not all of them. All other embodiments obtained by a person skilled in the art without any creative effort based on the embodiments of this disclosure are all within the scope of protection of this disclosure.

[0011] To facilitate understanding, the concepts related to the embodiments of this disclosure are explained below.

[0012] Table: An online database in table format, used for storing and managing data.

[0013] Table page: Can be used to display data from a table to the user.

[0014] A field is a "column" in a table, and different field types can be set in a table to ensure the formatting specifications of the content entered in each column. Field types can include normal, business, and advanced types. Normal types can include text, attachment, and official types; business types can include flow, auto-numbering, and progress types; and advanced types can include bidirectional and one-way relationship types.

[0015] Field data: One field data is the data for one line entered in the column where the field is located. The data type of at least one field data is the same as the field type of the field where it is located. For example, in the case of a field whose field type is an attachment file type, the field data corresponding to the field is an attachment file of a type that supports file upload.

[0016] Currently, when the user is in the process of using a table and tries to generate a target field to realize target functions such as text processing and extraction, date and time calculation, format conversion, etc., the user needs to set the target field in the self-editing method. In the actual application process, the self-editing process by the user is complex and the learning cost is high, so the user's usage efficiency is low.

[0017] Embodiments of the present disclosure provide a table data processing method, apparatus, device, and storage medium to solve the problem that the self-editing process is complex and the learning cost is high during the process of the user using a table, resulting in low user usage efficiency. The table data processing method, apparatus, device, and recording medium according to this embodiment respond to a trigger operation on a field control in a table page, display a field interface, determine a field component and a first field in the field interface, display a second field on the table page based on the field component and the first field, and generate second data generated by using the field component based on the first data in the data column corresponding to the first field in the data column corresponding to the second field. The field type of the second field is determined according to the field component. In this way, the user does not need to create it by himself, and only needs to select a target component from multiple preset components to generate a field to realize the corresponding function, and the user's usage efficiency is improved.

[0018] Next, with reference to FIG. 1, examples will be given to describe the application scenarios of the embodiments of the present disclosure.

[0019] FIG. 1 is a schematic diagram of an application scenario according to an embodiment of the present disclosure. Refer to FIG. 1 including a table page. The table page includes an official field and an editing component for editing the official field. In the editing component, a user can input a calculation formula. The official field can calculate the field according to the calculation formula edited by the user to obtain a calculation result in order to realize corresponding functions.

[0020] In the related art, when a user tries to generate a target field to realize target functions such as text processing and extraction, date and time calculation, format conversion, etc. in the process of using a table, the user needs to set the target field in a self-editing manner.

[0021] In the actual application process, the self-editing process by the user is complex and the learning cost is high, so the user's usage efficiency is low.

[0022] To solve the technical problems of the related art, the embodiments of the present disclosure determine a field component and a first field in a field interface, display a second field on a table page based on the field component and the first field, and provide a table data processing method for generating second data in a data column corresponding to the second field. In this way, the user does not need to create it by himself, and only needs to select a target component from multiple preset components to generate a field to realize the corresponding function, improving the user's usage efficiency.

[0023] The technical proposal of this disclosure and how it solves the above technical problems will be described in detail below with reference to specific embodiments. Some of these specific embodiments can be combined with each other, and some embodiments may omit explanation of the same or similar concepts or processes. The embodiments of this disclosure will be described below with reference to the drawings.

[0024] Referring to Figure 2, Figure 2 is a schematic flowchart of a table data processing method according to an embodiment of the present disclosure. The implementing entity of the embodiment of the present disclosure may be a terminal device, or a table data processing device installed on a terminal device. Here, the table data processing device may be implemented based on software, or the table data processing device may be implemented based on a combination of software and hardware, and is not limited to the embodiments of the present disclosure. The table data processing method includes the following S201 to S203.

[0025] S201: In response to a trigger operation on a field control in a table page, display the field interface.

[0026] Table pages can contain field controls.

[0027] The field control can be used to add new fields. By clicking the field control, you can generate a field interface for configuring the new field to be added.

[0028] The trigger operation may be an interaction performed by the user with the field control via a mouse click, touchscreen, or other input device.

[0029] The field control will be explained below with reference to Figure 3.

[0030] Figure 3 is a schematic diagram of a field control according to an embodiment of the present disclosure. Refer to Figure 3, which includes the field control.

[0031] Here, field controls may be represented by the icon "+", or by other icons; they are not limited to these.

[0032] The field interface can be used to specifically configure newly added fields.

[0033] The field interface may include component selection controls, field selection controls, and field name editing windows.

[0034] In response to a trigger operation on a field control in a table page, background code corresponding to the field control can be executed to display the field interface.

[0035] Optionally, the system may display a table page in response to a user's operation to open a table.

[0036] The system may optionally display a table list containing at least one table, and in response to a user's selection of any one table in the table list, display the table page corresponding to that table.

[0037] Furthermore, the terminal device can display the table page based on any executable implementation method, and is not limited to this in the embodiments of this disclosure.

[0038] S202: In the field interface, determine the field component and the first field.

[0039] Field components can be used to implement target functions such as text processing and extraction, date and time calculation, and format conversion.

[0040] The first field may be a field that already exists in the field interface and requires processing.

[0041] The following explanation of field interfaces will be given with examples, referring to Figure 4.

[0042] Figure 4 is a schematic diagram of a field interface according to an embodiment of the present disclosure. Refer to Figure 4, which includes the field interface.

[0043] The field interface may include one or more of the following: a field name editing window, a component selection control, a field selection control, a cancel control, and a confirmation control.

[0044] The field name editing window can be used to edit the names of fields.

[0045] The component selection control can be used to determine a field component from multiple preset components.

[0046] The field selection control can be used to determine a first field from at least one field in the field interface, which may be a field that requires processing by a field component.

[0047] The cancel control can be used to terminate the field interface.

[0048] Confirmation controls can be used to confirm user selections and / or edits to the editing window.

[0049] Based on editing operations on each control or editing window in the field interface, the user can determine configuration information corresponding to a field, including the first field and field components.

[0050] For example, the first field may be a date type field or an attachment type field.

[0051] In response to user trigger operations on each control in the field interface, the field component and the first field can be determined.

[0052] S203: Based on the field component and the first field, display the second field on the table page and generate the second data in the data column corresponding to the second field.

[0053] The second field can be used to record data processed and generated by the field component, and the field type of the second field is determined according to the field component.

[0054] The second field can also be used to record second data generated when a field component processes the first data in the first field.

[0055] The second data may be data generated using a field component based on the first data in the data column corresponding to the first field.

[0056] In response to the field component selected by the user and the first field, a second field can be generated, the second field can be displayed on the table page, and second data can be generated in the data column corresponding to the second field.

[0057] The embodiments of this disclosure provide a table data processing method that, in response to a trigger operation on a field control in a table page, displays a field interface, determines a field component and a first field in the field interface, displays a second field on the table page whose field type is determined according to the field component based on the field component and the first field, and generates second data in the data column corresponding to the second field, which is generated using the field component based on the first data in the data column corresponding to the first field. In this way, the user does not need to create anything themselves, but only needs to select a target component from multiple preset components and generate fields to realize the corresponding function, thereby improving user efficiency.

[0058] The process (S202) for determining the field component and the first field in the field interface will be described in detail below, with reference to Figure 5, based on the embodiment shown in Figure 2.

[0059] Figure 5 is a schematic diagram of another table data processing method according to an embodiment of the present disclosure. Referring to Figure 5, the flow of the method may include the following S501 to S502.

[0060] S501: In response to the user's input into the component selection control, the selected component is determined to be a field component.

[0061] Component selection controls can be used to display multiple preset components to the user and allow the user to select one of them as a field component.

[0062] Multiple preset components can be used to implement different functions. These preset components may perform text processing, extraction, or splitting; date and time calculation or statistics; format conversion or display; and so on, but are not limited to these functions.

[0063] For example, Table 1 can show multiple preset components and the functions corresponding to each preset component. [Table 1]

[0064] The input operation may be an operation in which the user selects one preset component from among several preset components, or it may be an operation in which the user enters a component name into a component selection control, and the component selection control matches and selects a component that matches the entered component name from among several preset components.

[0065] In response to user input into a component selection control, the component selection control can determine a field component corresponding to the input from multiple preset components and execute background code corresponding to that field component.

[0066] Optionally, in response to user input into a component selection control, the selected component is determined as a field component, background code corresponding to the field component is executed, and multiple configuration controls corresponding to the field component are displayed, including one or more field selection controls and format conversion selection controls.

[0067] The following explanation of component selection controls will be given with reference to Figure 6.

[0068] Figure 6 is a schematic diagram of a component selection control according to an embodiment of the present disclosure. Refer to Figure 6, which includes the component selection control.

[0069] Referring to interface 601, interface 601 includes a component selection control and a control title corresponding to the component selection control, and the user can display interface 602 on the display screen by clicking the component selection control.

[0070] Referring to interface 602, in interface 602, the component selection control can display multiple preset components to the user, and the user can select a field component from among the multiple preset components.

[0071] Referring to interface 603, interface 603 allows the execution of background code corresponding to a field component in response to a user click on the field component, thereby displaying the field selection control to the user.

[0072] Optionally, in response to a user click on a field component, background code corresponding to the field component may be executed to display a field selection control and a format conversion selection control to the user.

[0073] S502: In response to the operation entered in the field selection control, select a first field from at least one field in the field interface.

[0074] A field selection control can be used to display at least one field in a field interface to the user and allow the user to select one of those fields as the first field.

[0075] The input operation may be an operation in which the user selects one of at least one fields, or the user may enter one input field into the field selection control, and the field selection control may match the input field with a field from at least one field that matches the input field as the first field.

[0076] In response to an operation entered by the user in a field selection control, the field selection control may determine a selection field corresponding to the entered operation from at least one field in the field interface, and this selection field may be determined as the first field.

[0077] The following explanation of the field selection control will be given with reference to Figure 7.

[0078] Figure 7 is a schematic diagram of a field selection control according to an embodiment of the present disclosure. Refer to Figure 7, which includes the field selection control.

[0079] Referring to interface 701, interface 701 includes a field selection control, a control title corresponding to the field selection control, and a confirmation control. The user can display interface 702 on the display screen by clicking the field selection control.

[0080] Referring to interface 702, in interface 702, the field selection control can display to the user a selection subcontrol corresponding to at least one field in the field interface, and the user can select a target subcontrol from the selection subcontrols corresponding to at least one field, and determine the field corresponding to the target subcontrol as the first field.

[0081] The details of each step in the embodiments of this disclosure can be found by referring to the corresponding steps or operations described in the embodiments of the above method; therefore, any redundant explanations will be omitted.

[0082] The embodiments of this disclosure provide a table data processing method that, in response to an operation entered by the user into a component selection control, determines the selected component as a field component, and in response to an operation entered into the field selection control, selects a first field from at least one field in the field interface. In this way, the user does not need to create anything themselves; they only need to select a target component from multiple preset components and generate fields to realize the corresponding function, thereby improving user efficiency.

[0083] The process (S203) of displaying the second field on the table page based on the field component and the first field will be described in detail below, with reference to Figure 8, above the embodiment shown in Figure 2.

[0084] Referring to Figure 8, which is a schematic diagram of another table data processing method according to an embodiment of the present disclosure. The field interface further includes a field name editing window and a confirmation control, and the table data processing method includes the following S801 to S803.

[0085] S801: Retrieves the target name entered in the field name editing window.

[0086] The field name editing window can be used to edit the field name of the second field.

[0087] The target name may be the name entered by the user in the field name editing window.

[0088] Optionally, in response to an action entered by the user in the field name editing window, the target name entered in the field name editing window may be retrieved.

[0089] Optionally, a preset name corresponding to the field component may be determined in the field name editing window based on the field component, and the target name entered in the field name editing window may be determined based on the preset name.

[0090] For example, the target name is a conversion of a date to a week number.

[0091] S802: In response to a click operation on a confirmation control, generate a second field based on the target name.

[0092] The name of the second field is the target name.

[0093] In response to a click on a confirmation control, background code for the field interface can be executed to generate a second field based on the target name.

[0094] S803: Create binding relationships between the field component, the first field, and the second field so that the field component generates the second data based on the first data, and display the second field on the table page.

[0095] A binding relationship can include a first binding relationship between a first field and a field component, and a second binding relationship between a second field and a field component.

[0096] The first binding relationship may also involve using the first data in the first field as input data for the field component.

[0097] The second binding relationship may be such that the output data of the field component becomes the second data in the second field.

[0098] A first binding relationship between the first field and the field component, and a second binding relationship between the second field and the field component, may be created so that the field component generates second data based on the first data.

[0099] Optionally, you may display the second field on the table page as follows: Create a new column on the table page after the column where the first field is located, and set the field of the new column as the second field.

[0100] Here, the newly added column may consist of data for a single newly added column, and the newly added column may be created in one or more columns after the column where the first field is located on the table page.

[0101] For example, if the newly added column is the fifth column, you may set the field corresponding to the fifth column as the second field.

[0102] The details of each step in the embodiments of this disclosure can be found by referring to the corresponding step or operation description in the embodiments of the above method, so any redundant explanations will be omitted.

[0103] The table data processing method according to the embodiment of this disclosure obtains the target name entered in the field name editing window, and in response to a click operation on the confirmation control, generates a second field whose name is the target name based on the target name, creates a binding relationship between the field component, the first field and the second field so that the field component generates the second data based on the first data, and displays the second field on the table page. In this way, the user does not need to create anything themselves, but only needs to select a target component from multiple preset components and generate fields to realize the corresponding function, improving user efficiency.

[0104] The process (S203) for generating the second data in the data column corresponding to the second field will be described in detail below, with reference to Figure 9, above the embodiment shown in Figure 2.

[0105] Referring to Figure 9, Figure 9 is a schematic diagram of yet another table data processing method according to an embodiment of the present disclosure. The table data processing method includes the following S901 to S903.

[0106] S901: Determine the target data format corresponding to the second field.

[0107] The target data format may be pre-configured or selected and determined by the user, but is not limited to these options.

[0108] Optionally, a preset data format corresponding to a field component may be determined, and a target data format corresponding to a second field may be determined based on the preset data format.

[0109] Optionally, the field interface may further include a format selection control that can provide the user with multiple preset data formats corresponding to the field component, and the user may select a target data format from the multiple preset data formats so that the data format of the second field is the target data format.

[0110] S902: Based on the target data format, field components generate a second data corresponding to the first data.

[0111] The second data format is the target data format.

[0112] Each field component converts the first data to the corresponding second data, and then formats the second data based on the target data format to obtain the processed second data.

[0113] Optionally, a field component may generate a second data corresponding to the first data based on the target data format, as follows: The first data is input into the official data corresponding to the field component, output data corresponding to the official data is output, and the output data is converted to the second data based on the target data format.

[0114] Official data may be stored in a field component in the form of code. Official data may include pre-defined formulas.

[0115] S903: Display the second data corresponding to the first data on the table page.

[0116] The second data can be located in the column that is located in the second field.

[0117] For any one of the first data points, the field interface displays the second data point corresponding to that first data point, and the first and second data points are located on the same row, with the first data point located in the column corresponding to the first field, and the second data point located in the column corresponding to the second field.

[0118] The details of each step in the embodiments of this disclosure can be found by referring to the corresponding steps or operations described in the embodiments of the above method; therefore, any redundant explanations will be omitted.

[0119] The embodiments of this disclosure provide a table data processing method that determines a target data format corresponding to a second field, generates second data corresponding to the first data and whose data format is the target data format based on the target data format using a field component, and displays the second data corresponding to the first data on a table page. In this way, the user does not need to create anything themselves; they only need to select a target component from multiple preset components and generate fields to realize the corresponding function, thus improving user efficiency.

[0120] The following explanation will provide an example of the processes S901 to S903, referring to Figure 10.

[0121] Figure 10 is a schematic diagram of another table page according to an embodiment of the present disclosure. Assume that the first field is a date field, the second field is a date conversion field, and the field component is a date conversion component. Refer to Figure 10, which includes the date field and the date conversion field.

[0122] Enter 2024 / 04 / 01 in the second row of the date field. The target data format corresponding to the date conversion field [Table 2] Assuming that this is the decision, Based on the target data format, the date conversion component converts "2024 / 04 / 01" entered in the second row of the date field. [Table 3] Convert to, In the second row of the column where the date conversion field is located [Table 4] Display.

[0123] The details of each step in the embodiments of this disclosure can be found by referring to the corresponding steps or operations described in the embodiments of the above method; therefore, any redundant explanations will be omitted.

[0124] Figure 11 is a schematic diagram of the structure of a table data processing device according to an embodiment of the present disclosure. Referring to Figure 11, the table data processing device 1100 includes a display module 1101, a determination module 1102, and a processing module 1103, where, The display module 1101 is used to display the field interface in response to a trigger operation on a field control in a table page. The determination module 1102 is used in the field interface to determine the field component and the first field. The processing module 1103 is used to display a second field on the table page based on the field component and the first field, and to generate second data in the data column corresponding to the second field, which is generated using the field component based on the first data in the data column corresponding to the first field, and the field type of the second field is determined according to the field component.

[0125] In one embodiment of the present disclosure, the field component is set with official data, and the field component processes the first data based on the official data to generate the second data.

[0126] In one embodiment of the present disclosure, the field interface includes a component selection control and a field selection control, and the decision module 1102 specifically, In response to an operation entered by the user in the component selection control, the selected component is determined to be the field component. It is used to select the first field from at least one field in the field interface in response to an operation entered into the field selection control.

[0127] In one embodiment of the present disclosure, the field interface further includes a field name editing window and a confirmation control, and the processing module 1103 specifically, The target name entered in the field name editing window is obtained, In response to a click operation on the confirmation control, a second field is generated based on the target name, the name of which is the target name. A binding relationship is created between the field component, the first field, and the second field so that the field component generates the second data based on the first data, and this is used to display the second field on the table page.

[0128] In one embodiment of the present disclosure, the processing module 1103 specifically, In the aforementioned table page, create a new column after the column where the first field is located. This is used to set the field of the newly added column to the second field.

[0129] In one embodiment of the present disclosure, the processing module 1103 specifically, Determine the target data format corresponding to the second field, Based on the target data format, the field component generates second data that corresponds to the first data and whose data format is the target data format. This is used to display second data corresponding to the first data on the aforementioned table page.

[0130] In one embodiment of the present disclosure, the processing module 1103 specifically, The first data is input into the official data corresponding to the field component, and output data corresponding to the official data is output. This is used to convert the output data into a second data based on the target data format.

[0131] The apparatus according to this embodiment may also be used to implement the technical proposal of the embodiment of the above method, and since its implementation principle and technical effect are similar, a detailed explanation is omitted in this embodiment.

[0132] To realize the above embodiments, the embodiments of this disclosure further provide electronic devices.

[0133] Referring to Figure 12, which is a schematic diagram of the hardware structure of an electronic device according to an embodiment of the present disclosure, the electronic device 1200 may be a terminal device or a server. Here, terminal devices may include, but are not limited to, mobile devices such as mobile phones, laptop computers, digital broadcast receivers, personal digital assistants (abbreviated as PDAs), tablet computers (abbreviated as Portable Android Devices, PADs), portable multimedia players (abbreviated as PMPs), in-vehicle terminals (e.g., in-vehicle navigation terminals), and fixed terminals such as digital TVs and desktop computers. The electronic device shown in Figure 12 is merely an example and does not impose any limitations on the functions and scope of use of the embodiments of the present disclosure.

[0134] As shown in Figure 12, the electronic device 1200 may include a processing unit (e.g., a central processor, graphics processor, etc.) 1201, which can perform various appropriate operations and processes based on a program stored in a read-only memory (ROM) 1202, or a program loaded from a storage device 1208 into a random access memory (RAM) 1203. The RAM 1203 further stores various programs and data necessary for the operation of the electronic device 1200. The processing unit 1201, ROM 1202, and RAM 1203 are connected to each other via a bus 1204. An input / output (I / O) interface 1205 is also connected to the bus 1204.

[0135] Generally, devices such as input devices 1206, including, for example, touchscreens, touchpads, keyboards, mice, cameras, microphones, accelerometers, and gyroscopes; output devices 1207, including, for example, liquid crystal displays (LCDs), speakers, and vibrators; storage devices 1208, including, for example, magnetic tapes and hard disks; and communication devices 1209 can be connected to the I / O interface 1205. The communication device 1209 can allow the electronic device 1200 and other devices to exchange data via wireless or wired communication. Figure 12 shows an electronic device 1200 with various devices, but it should be understood that it is not required to implement or have all of the devices shown. More or fewer devices may be implemented or have all of the devices instead.

[0136] In particular, according to embodiments of the present disclosure, the process described above with reference to the flowchart may be implemented as a computer software program. For example, embodiments of the present disclosure include a computer program product which includes a computer program delivered on a computer-readable medium, the computer program including program code for performing the method shown in the flowchart. In such embodiments, the computer program may be downloaded and installed from a network via a communication device 1209, or installed from a storage device 1208, or installed from a ROM 1202. When the computer program is executed by the processing unit 1201, the above-described functions, limited by the methods of embodiments of the present disclosure, are performed.

[0137] The computer-readable medium in this disclosure may be a computer-readable signal medium, a computer-readable storage medium, or any combination of both. The computer-readable storage medium may be, but is not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of computer-readable storage mediums may include, but are not limited to, an electrical connection having one or more wires, a portable computer magnetic disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact magnetic disk read-only memory (CD-ROM), optical memory device, magnetic memory device, or any suitable combination thereof. In this disclosure, the computer-readable storage medium may be any tangible medium containing or storing a program, the program may be used by or in combination with an instruction execution system, apparatus, or device. In this disclosure, the computer-readable signal medium may include data signals propagated in the baseband or as part of a carrier, which carry computer-readable program code. The data signals propagated in this manner may be in various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. The computer-readable signal medium may be any computer-readable medium other than a computer-readable storage medium, and the computer-readable signal medium may transmit, propagate, or transmit programs for use by or in combination with instruction execution systems, apparatus, or devices. The program code contained on the computer-readable medium may be transmitted by any suitable medium, including but not limited to electric wires, optical cables, RF (radio frequency), or any suitable combination thereof.

[0138] The computer-readable medium described above may be included in the electronic device described above, or it may be a standalone entity not incorporated into the electronic device.

[0139] One or more programs are transported on the computer-readable medium described above, and when the one or more programs are executed by the electronic device, the electronic device is made to execute the method shown in the above embodiment.

[0140] Computer program code for performing the operations of the Disclosure can be organized in one or a variety of programming languages ​​or a combination thereof, and such programming languages ​​include object-oriented programming languages, such as Java®, Smalltalk, and C++, and further include general procedural programming languages, such as the "C" language or similar programming languages. The program code may run entirely on a user computer, partially on a user computer, run as a single standalone software package, partially on a user computer and partially on a remote computer, or run entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user computer via any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or it may be connected to an external computer (for example, connected via the Internet using an Internet service provider).

[0141] The flowcharts and block diagrams in the drawings illustrate system architectures, functions, and operations that can be implemented according to the systems, methods, and computer program products of each embodiment of the present disclosure. In this regard, each block in the flowchart or block diagram may represent a module, program segment, or portion of code, which contains one or more executable instructions for implementing a defined logic function. It should be noted that in some implementations as alternatives, the functions described in the blocks may occur in a different order than those shown in the drawings. For example, two blocks shown consecutively may actually be executed almost in parallel, or in some cases in reverse order, depending on the function. Furthermore, it should be noted that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, may be implemented by a dedicated hardware-based system that performs the defined function or operation, or by a combination of dedicated hardware and computer instructions.

[0142] The units referred to in the descriptions of the embodiments of this disclosure may be implemented in software or in hardware. Herein, the names of the units are not limited in any case to the units themselves; for example, the first acquisition unit may be described as "a unit that acquires at least two Internet Protocol addresses."

[0143] The functions described above in this specification may be performed by at least some of one or more hardware logic components. For example, typical types of hardware logic components that can be used include, but are not limited to, field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard products (ASSPs), systems on chips (SOCs), and composite programmable logic circuits (CPLDs).

[0144] In the context of this disclosure, a machine-readable medium may be a tangible medium that contains or stores a program for use by or in combination with an instruction execution system, apparatus, or device. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any appropriate combination of the above. More specific examples of machine-readable storage media include one or more wire-based electrical connections, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fibers, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any appropriate combination of the above.

[0145] In the first aspect, according to one or more embodiments of the present disclosure, In response to a trigger operation on a field control in a table page, display the field interface, In the aforementioned field interface, the field component and the first field are determined, The present invention provides a table data processing method that includes displaying a second field on the table page based on the field component and the first field, and generating second data in a data column corresponding to the second field, which is generated using the field component based on the first data in the data column corresponding to the first field, wherein the field type of the second field is determined according to the field component.

[0146] According to one or more embodiments of the present disclosure, the field component is configured with official data, and the field component processes the first data based on the official data to generate the second data.

[0147] According to one or more embodiments of the present disclosure, the field interface includes a component selection control and a field selection control, and the determination of a field component and a first field in the field interface is as follows: In response to an operation entered by the user in the component selection control, the selected component is determined to be the field component, This includes selecting the first field from at least one field in the field interface in response to an operation entered into the field selection control.

[0148] According to one or more embodiments of the present disclosure, the field interface further includes a field name editing window and a confirmation control, and the second field is displayed on the table page based on the field component and the first field. To obtain the target name entered in the aforementioned field name editing window, In response to a click operation on the confirmation control, a second field is generated whose name is the target name based on the target name, This includes creating a binding relationship between the field component, the first field, and the second field, such that the field component generates the second data based on the first data, and displaying the second field on the table page.

[0149] According to one or more embodiments of this disclosure, displaying the second field on the table page is: In the aforementioned table page, a new column is created after the column where the first field is located, This includes setting the field of the newly added column to the second field.

[0150] According to one or more embodiments of the present disclosure, generating second data in a data column corresponding to the second field is: Determining the target data format corresponding to the second field, Based on the target data format, the field component generates second data that corresponds to the first data and whose data format is the target data format. This includes displaying a second data corresponding to the first data on the table page.

[0151] According to one or more embodiments of the present disclosure, generating second data corresponding to the first data by the field component based on the target data format is: The first data is input into the official data corresponding to the field component, and output data corresponding to the official data is output. This includes converting the output data into a second data based on the target data format.

[0152] In a second aspect, according to one or more embodiments of the present disclosure, A display module for displaying the field interface in response to a trigger operation on a field control in a table page, The field interface includes a determination module for determining a field component and a first field, A table data processing device is provided, which includes a processing module for displaying a second field on the table page based on the field component and the first field, and for generating second data in a data column corresponding to the second field, which is generated using the field component based on the first data in the data column corresponding to the first field, wherein the field type of the second field is determined according to the field component.

[0153] According to one or more embodiments of the present disclosure, the field component is configured with official data, and the field component processes the first data based on the official data to generate the second data.

[0154] According to one or more embodiments of the present disclosure, the field interface includes a component selection control and a field selection control, and the decision module specifically, In response to an operation entered by the user in the component selection control, the selected component is determined to be the field component. It is used to select the first field from at least one field in the field interface in response to an operation entered into the field selection control.

[0155] According to one or more embodiments of the present disclosure, the field interface further includes a field name editing window and a confirmation control, and the processing module specifically includes: The target name entered in the field name editing window is obtained, In response to a click operation on the confirmation control, a second field is generated whose name is the target name, based on the target name. A binding relationship is created between the field component, the first field, and the second field so that the field component generates the second data based on the first data, and this is used to display the second field on the table page.

[0156] According to one or more embodiments of this disclosure, the processing module specifically: In the aforementioned table page, create a new column after the column where the first field is located. This is used to set the field of the newly added column to the second field.

[0157] According to one or more embodiments of this disclosure, the processing module specifically: Determine the target data format corresponding to the second field, Based on the target data format, the field component generates second data that corresponds to the first data and whose data format is the target data format. This is used to display second data corresponding to the first data on the aforementioned table page.

[0158] According to one or more embodiments of this disclosure, the processing module specifically: The first data is input into the official data corresponding to the field component, and output data corresponding to the official data is output. This is used to convert the output data into a second data based on the target data format.

[0159] In a third aspect, according to one or more embodiments of the present disclosure, the present invention includes at least one processor and memory, The aforementioned memory stores computer execution instructions, The present invention provides an electronic device that, when the computer execution instruction stored in the memory is executed by the at least one processor, causes the at least one processor to execute the table data processing method described in the first embodiment and various possible designs of the first embodiment.

[0160] In a fourth aspect, according to one or more embodiments of the present disclosure, a computer-readable storage medium is provided which stores computer execution instructions that, when executed by a processor, implement the table data processing method described in the first aspect and various possible designs of the first aspect.

[0161] In a fifth aspect, according to one or more embodiments of the present disclosure, a computer program product is provided which, when executed by a processor, implements the table data processing method described in the first aspect and various possible designs of the first aspect.

[0162] The above description is merely an explanation of preferred embodiments and the technical principles in which the present disclosure is applied. Those skilled in the art will understand that the scope of the disclosure is not limited to technical solutions formed by specific combinations of the above technical features, but encompasses other technical solutions formed by any combination of the above technical features or their equivalents, without departing from the disclosed concepts. For example, technical solutions in which the above features are replaced with similar functional technical features disclosed (but not limited to) in this disclosure.

[0163] While the operations are described in a specific order, this should not be understood as requiring them to be performed in a particular order or sequence. In certain environments, multitasking and parallel processing may be advantageous. Similarly, while the above discussion includes some specific implementation details, these should not be understood as limiting the scope of this disclosure. Some features described in the context of a single embodiment may be implemented in combination within a single embodiment. Conversely, various features described in the context of a single embodiment may be implemented in multiple embodiments, either individually or in any suitable subcombination.

[0164] Although this topic has been described using terminology specific to structural features and / or the logical operation of the method, it should be understood that the topic limited to the attached claims is not limited to the specific features or operations described above. Rather, the specific features and operations described above are merely illustrative forms of realizing the claims.

Claims

1. A method for processing table data, In response to a trigger operation on a field control in a table page, display the field interface, In the aforementioned field interface, the field component and the first field are determined, A table data processing method comprising: displaying a second field on the table page based on the field component and the first field; and generating second data in a data column corresponding to the second field, which is generated using the field component based on the first data in the data column corresponding to the first field, wherein the field type of the second field is determined according to the field component.

2. The method according to claim 1, wherein official data is set in the field component, and the field component processes the first data based on the official data to generate the second data.

3. The field interface includes a component selection control and a field selection control, and determining the field component and the first field in the field interface is: In response to an operation entered by the user in the component selection control, the selected component is determined to be the field component, The method according to claim 1 or 2, further comprising selecting the first field from at least one field in the table page in response to an operation entered in the field selection control.

4. The field interface further includes a field name editing window and a confirmation control, and the second field is displayed on the table page based on the field component and the first field. To obtain the target name entered in the aforementioned field name editing window, In response to a click operation on the confirmation control, a second field is generated whose name is the target name based on the target name, The method according to any one of claims 1 to 3, comprising creating a binding relationship between the field component, the first field and the second field such that the field component generates the second data based on the first data, and displaying the second field on the table page.

5. Displaying the second field on the table page means In the aforementioned table page, a new column is created after the column where the first field is located, The method according to claim 4, further comprising setting the field of the newly added column to the second field.

6. Generating the second data in the data column corresponding to the second field is: Determining the target data format corresponding to the second field, Based on the target data format, the field component generates second data that corresponds to the first data and whose data format is the target data format, The method according to any one of claims 1 to 5, further comprising displaying second data corresponding to the first data on the table page.

7. Based on the target data format, generating second data corresponding to the first data using the field component is: The first data is input into the official data corresponding to the field component, and output data corresponding to the official data is output. The method according to claim 6, comprising converting the output data into a second data based on the target data format.

8. A table data processing device, A display module for displaying the field interface in response to a trigger operation on a field control in a table page, The field interface includes a determination module for determining a field component and a first field, A table data processing device that displays a second field on the table page based on the field component and the first field, and includes a processing module for generating second data in a data column corresponding to the second field, which is generated using the field component based on the first data in the data column corresponding to the first field, wherein the field type of the second field is determined according to the field component.

9. An electronic device, including a processor and memory, The aforementioned memory stores computer execution instructions, An electronic device that, when the processor executes a computer execution instruction stored in the memory, causes the processor to execute the table data processing method described in any one of claims 1 to 7.

10. A computer-readable storage medium that stores computer execution instructions that, when executed by a processor, realize the table data processing method described in any one of claims 1 to 7.

11. A computer program product comprising a computer program that, when executed by a processor, implements the table data processing method described in any one of claims 1 to 7.

Images