Data processing method and apparatus, medium, electronic device, and program product

Abstract

A data processing method, device, medium, electronic equipment and program product, relating to the technical field of computer processing. The method comprises: obtaining at least one first formula result of a first type according to the formula content of a formula column in a table; if the configuration type of the formula result of the first formula column is an option type, for each first formula result, determining a first identifier corresponding to the first formula result according to a first correspondence relationship between the formula result and the identifier; determining the first identifier as the first formula result after type conversion to convert the first formula result into the option type; and filling all the first formula results after type conversion into the formula column. The values in the formula column are converted from the first type to the enumerable option type by using the type conversion capability, which is beneficial to the value flow of the formula column to the subsequent business process, and facilitates the consumption of the formula column by the subsequent business process. Therefore, the performance optimization of the subsequent business process can be realized by means of the enumerable characteristics of the option type.

Description

Technical Field

[0001] This disclosure relates to the field of computer processing technology, and more specifically, to a data processing method, apparatus, medium, electronic device, and program product. Background Technology

[0002] Spreadsheets are data calculation tools that allow you to perform various calculations on the data in a spreadsheet using formulas in formula columns. In related technologies, the values ​​in formula columns can be set to various types such as text, numbers, and dates. These types are the primitive types of the formula column values ​​and are usually not enumerable, which affects the performance of subsequent operations that consume the formula column. Summary of the Invention

[0003] This summary section is provided to briefly introduce the concepts, which will be described in detail in the detailed description section below. This summary section is not intended to identify key or essential features of the claimed technical solution, nor is it intended to limit the scope of the claimed technical solution.

[0004] In a first aspect, this disclosure provides a data processing method, including:

[0005] Based on the formula content configured in the first formula column of the table, obtain at least one first formula result of the first type, wherein the first type is the original type of the formula result of the first formula column;

[0006] In response to the configuration type of the formula result in the first formula column being an option type, for each first formula result, a first identifier corresponding to the first formula result is determined according to the first correspondence between the formula result and the identifier; the first identifier is determined as the first formula result after type conversion, so as to convert the first formula result of the first type into the option type;

[0007] Fill the first formula column with the results of all type conversions.

[0008] Secondly, this disclosure provides a data processing apparatus, comprising:

[0009] The first acquisition module is used to acquire at least one first formula result of a first type according to the formula content configured in the first formula column of the table, wherein the first type is the original type of the formula result of the first formula column;

[0010] The first determining module is configured to, in response to the configuration type of the formula result of the first formula column being an option type, determine a first identifier corresponding to each first formula result based on a first correspondence between the formula result and the identifier; the second determining module is configured to determine the first identifier as the first formula result after type conversion, so as to convert the first formula result of the first type into the option type.

[0011] The fill module is used to fill the first formula column with the first formula results after all type conversions.

[0012] Thirdly, this disclosure provides a computer-readable medium having a computer program stored thereon, which, when executed by a processing device, implements the steps of the data processing method provided in the first aspect of this disclosure.

[0013] Fourthly, this disclosure provides an electronic device, comprising:

[0014] A storage device on which computer programs are stored;

[0015] A processing apparatus for executing the computer program in the storage device to implement the steps of the data processing method provided in the first aspect of this disclosure.

[0016] Fifthly, this disclosure provides a computer program product, including a computer program that, when executed by a processor, implements the steps of the data processing method provided in the first aspect of this disclosure.

[0017] In the above technical solution, firstly, based on the formula content configured in the first formula column of the table, at least one first formula result of the first type is obtained, where the first type is the original type of the formula result in the first formula column. If the configuration type of the formula result in the first formula column is an option type, then for each first formula result, based on the first correspondence between the formula result and the identifier, the first identifier corresponding to that first formula result is determined. The first identifier is determined as the first formula result after type conversion, so as to convert the first formula result of the first type into the option type. All the first formula results after type conversion are filled into the first formula column. In this way, the type conversion capability can be used to convert the values ​​in the first formula column from the first type to the enumerable option type, which is beneficial for the value flow of the formula column to subsequent business processes, and facilitates the consumption of the formula column by subsequent business processes. Thus, the performance optimization of subsequent business processes can be achieved by leveraging the enumerable characteristic of the option type.

[0018] Other features and advantages of this disclosure will be described in detail in the following detailed description section. Attached Figure Description

[0019] The above and other features, advantages, and aspects of the embodiments of this disclosure will become more apparent from the accompanying drawings and the following detailed description. Throughout the drawings, the same or similar reference numerals denote the same or similar elements. It should be understood that the drawings are schematic, and the originals and elements are not necessarily drawn to scale. In the drawings:

[0020] Figure 1 This is a flowchart illustrating a data processing method according to an exemplary embodiment.

[0021] Figure 2 This is a schematic diagram of a second panel according to an exemplary embodiment.

[0022] Figure 3 This is a schematic diagram of a first panel according to an exemplary embodiment.

[0023] Figure 4 This is a schematic diagram illustrating an update option in a first panel according to an exemplary embodiment.

[0024] Figure 5 This is a schematic diagram illustrating an autofill option process according to an exemplary embodiment.

[0025] Figure 6 This is a schematic diagram illustrating a color scheme for setting options via a first panel, according to an exemplary embodiment.

[0026] Figure 7 This is a schematic diagram illustrating a process of a user editing a first correspondence according to an exemplary embodiment.

[0027] Figure 8 This is a flowchart illustrating a data processing method according to another exemplary embodiment.

[0028] Figure 9 This is a block diagram illustrating a data processing apparatus according to an exemplary embodiment.

[0029] Figure 10 This is a schematic diagram of the structure of an electronic device according to an exemplary embodiment. Detailed Implementation

[0030] Embodiments of this disclosure will now be described in more detail with reference to the accompanying drawings. While some embodiments of this disclosure are shown in the drawings, it should be understood that this disclosure can be implemented in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided to provide a more thorough and complete understanding of this disclosure. It should be understood that the accompanying drawings and embodiments of this disclosure are for illustrative purposes only and are not intended to limit the scope of protection of this disclosure.

[0031] It should be understood that the steps described in the method embodiments of this disclosure may be performed in different orders and / or in parallel. Furthermore, the method embodiments may include additional steps and / or omit the steps shown. The scope of this disclosure is not limited in this respect.

[0032] The term "comprising" and its variations as used herein are open-ended inclusions, meaning "including but not limited to". The term "based on" means "at least partially based on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments". Definitions of other terms will be given in the description below.

[0033] It should be noted that the concepts of "first" and "second" mentioned in this disclosure are used only to distinguish different devices, modules or units, and are not used to limit the order of functions performed by these devices, modules or units or their interdependencies.

[0034] It should be noted that the terms "a" and "a plurality of" used in this disclosure are illustrative rather than restrictive, and those skilled in the art should understand that, unless otherwise expressly indicated in the context, they should be understood as "one or more".

[0035] The names of messages or information exchanged between multiple devices in the embodiments of this disclosure are for illustrative purposes only and are not intended to limit the scope of such messages or information.

[0036] For example, upon receiving a user's active request, a prompt message is sent to the user to explicitly inform them that the requested operation will require the acquisition and use of the user's personal information. This allows the user to independently choose whether to provide personal information to the software or hardware, such as the electronic device, application, server, or storage medium performing the operations of this disclosed technical solution, based on the prompt message.

[0037] As an optional but non-limiting implementation, in response to a user's active request, sending a prompt message to the user can be done via a pop-up window, where the prompt message can be presented in text format. Furthermore, the pop-up window can also include a selection control allowing the user to choose whether to "agree" or "disagree" to provide personal information to the electronic device.

[0038] Meanwhile, it is understood that the data involved in this technical solution (including but not limited to the data itself, the acquisition or use of the data) shall comply with the requirements of relevant laws, regulations and related provisions.

[0039] Figure 1 This is a flowchart illustrating a data processing method according to an exemplary embodiment. For example... Figure 1 As shown, the data processing method may include the following S101~S104.

[0040] In S101, based on the formula content configured in the first formula column of the table, at least one first formula result of the first type is obtained, wherein the first type is the original type of the formula result of the first formula column.

[0041] In this disclosure, the table described above is a multidimensional table. Formula columns refer to data field columns that require calculation. Formula columns use function expressions to establish logical relationships with the underlying data columns, implementing the calculation logic for the underlying data columns. Formula columns can reference each other. A table may include one or more formula columns, where the first formula column can be any formula column in the table.

[0042] The first type is the original data type of the formula result (i.e., the value of the first formula column), such as text, date, number, rating, etc.

[0043] In S102, in response to the configuration type of the formula result of the first formula column being an option type, for each first formula result, a first identifier corresponding to the first formula result is determined based on the first correspondence between the formula result and the identifier.

[0044] In S103, the first identifier is identified as the first formula result after type conversion, so as to convert the first formula result of the first type into the option type.

[0045] like Figure 2 As shown, users can set the value type of the first formula column through the "Field Format" dropdown menu in the second panel of the first formula column, that is, set the type of the formula result of the first formula column. The second panel is the configuration panel for the first formula column, used to configure the formula content (i.e., the calculation formula) and field format (i.e., the configuration type of the formula result of the first formula column). Figure 2 As shown, the "Field Format" dropdown list includes configurable types for the formula result of the first formula column, specifically including text, option, number, date, rating, etc. When the configured type for the formula result of the first formula column is option, the formula result of the first formula column is a value from a predefined set of options, where the option set includes multiple enumerable options.

[0046] The formula result in the first formula column is an option under the option type, and the identifier can be id.

[0047] After the user sets the formula content and field format of the first formula column, the value of the first formula column in the table can be calculated according to the formula content configured in the first formula column to obtain at least one first formula result of the first type, that is, to execute the above S101.

[0048] After obtaining at least one first formula result of the first type, the first calculation result of the first type can be converted into an option type to obtain the type-converted first formula result in the following way: First, for each first formula result in at least one first type, determine the first identifier corresponding to that first formula result based on the first correspondence between the formula result and the identifier. Then, determine the first identifier as the converted first formula result. In this way, the type conversion of the formula result can be quickly achieved based on the first correspondence.

[0049] In S104, fill the first formula column with all the type-converted first formula results.

[0050] After obtaining at least one type-converted first formula result, all type-converted first formula results can be filled into the first formula column. When the configuration type of the formula result in the first formula column is a type other than the option type, if the configuration type is the first type, no type conversion is required. In this case, at least one first formula result of the first type can be directly filled into the first formula column. When the configuration type of the formula result in the first formula column is a type other than the option type, if the configuration type is not the first type, each first formula result is converted to a configuration type to obtain at least one configuration type formula result. Then, at least one configuration type formula result is filled into the first formula column.

[0051] In the above technical solution, firstly, based on the formula content configured in the first formula column of the table, at least one first formula result of the first type is obtained, where the first type is the original type of the formula result in the first formula column. If the configuration type of the formula result in the first formula column is an option type, then for each first formula result, based on the first correspondence between the formula result and the identifier, the first identifier corresponding to that first formula result is determined. The first identifier is determined as the first formula result after type conversion, so as to convert the first formula result of the first type into the option type. All the first formula results after type conversion are filled into the first formula column. In this way, the type conversion capability can be used to convert the values ​​in the first formula column from the first type to the enumerable option type, which is beneficial for the value flow of the formula column to subsequent business processes, and facilitates the consumption of the formula column by subsequent business processes. Thus, the performance optimization of subsequent business processes can be achieved by leveraging the enumerable characteristic of the option type.

[0052] In one possible implementation, the above data processing method may further include the following two steps:

[0053] When the configuration type of the formula result in the first formula column is switched to the option type, obtain at least one expected formula result in the first formula column;

[0054] Add each expected formula result from at least one expected formula result to the first panel as an option under the option type.

[0055] In this disclosure, the first panel is the configuration panel of the first correspondence, that is, the configuration panel of the configuration information of the option type of the first formula column. When the configuration type of the formula result of the first formula column is switched to the option type, the option content of the first panel is empty, that is, the options under the option type of the first formula column are empty. At this time, the first panel can be automatically filled according to the expected formula result of the first formula column, that is, each expected formula result in at least one expected formula result is added to the first panel as an option under the option type.

[0056] For example, the expected formula results in the first formula column include 2024 Q1, 2024 Q2, 2024 Q3, and 2024 Q4. These four expected formula results can be added as options under the option type to the first panel, resulting in: Figure 3 The first panel shown.

[0057] In one possible implementation, such as Figure 3 and Figure 4 As shown, if there is no option in the options that matches the formula result, it can be displayed as "Other" in the corresponding position in the first formula column. That is, if there is no identifier corresponding to the first formula result in the first correspondence, the converted first formula result can be "Other".

[0058] In one possible implementation, the above data processing method may further include the following four steps:

[0059] When the first control on the first panel is triggered, at least one second formula result of the first type is obtained according to the formula content configured in the first formula column.

[0060] Add the results of the newly added formulas as options under the option type to the first panel;

[0061] Update the first correspondence based on the results of the newly added formula;

[0062] Re-execute the steps from obtaining at least one first formula result of the first type according to the formula content configured in the first formula column of the table to filling the first formula result after all types are converted into the first formula column, that is, re-execute the above S101~S104.

[0063] In this disclosure, the first panel includes at least one option under an option type, wherein the first panel is as follows: Figure 3 As shown and Figure 4 As shown.

[0064] The first control is used to trigger the update of the option content. The first control can be, for example, a... Figure 4 The "Update Options" button shown allows the user to trigger an update operation on the first correspondence when the formula results in the first formula column contain results not found in the option content of the first panel (i.e., when the values ​​in the first formula column include other options). This achieves a semi-automatic update of the first correspondence. Specifically, when the first control on the first panel is triggered, at least one second formula result of the first type is obtained based on the formula content configured in the first formula column. Then, the newly added formula result is added to the first panel as an option under the option type, where the newly added formula result is a second formula result not found in the first panel. Simultaneously, the first correspondence is updated based on the newly added formula result. Afterward, at least one third formula result of the first type is obtained based on the formula content configured in the first formula column of the table. If the configuration type of the formula result in the first formula column is an option type, each third formula result is converted to an option type according to the updated first correspondence. Finally, all the converted third formula results are filled into the first formula column to complete the update of the first formula column.

[0065] like Figure 5 As shown, the above data processing method can be applied to a user device. The user clicks on the first control in the first panel displayed on the user device, and the calculation service is called to automatically update the first correspondence in the first panel according to the formula result of the first formula column. Then, the user device regenerates the option field configuration information Changeset. Next, the first correspondence in the database is updated according to the Changeset. Finally, the calculation service is called again to recalculate the value of the first formula column according to the updated first correspondence in the database to obtain at least one first formula result of the first type.

[0066] Specifically, such as Figure 5As shown, the user equipment can automatically update the configuration information of the option type of the first formula column in the first panel, i.e., the first correspondence, based on the formula result of the first formula column by calling the computing service: First, the user equipment sends a computing request to the computing service, which instructs to recalculate the value of the first formula column, i.e., to obtain at least one first formula result of the first type based on the formula content configured in the first formula column in the table; after receiving the computing request, the computing service can obtain at least one second formula result of the first type based on the formula content configured in the first formula column in the table, and return at least one second formula result of the first type as an option list to the user equipment; next, the user equipment determines the new formula result based on the option list returned by the computing service; finally, the user equipment automatically fills the first panel with the new formula result as an option under the option type in the first panel.

[0067] The aforementioned Changeset can include newly added formula results. In this case, the newly added formula results and their corresponding identifiers can be added to the configuration information (i.e., the first correspondence) of the option type in the first formula column of the database. This completes the update of the first correspondence in the database.

[0068] In the above implementation, the semi-automatic update of the first correspondence can avoid updating the first correspondence again after the formula has been recalculated, thereby avoiding the process of cyclically recalculating and updating the first correspondence due to automatic triggering of the first correspondence update.

[0069] In one possible implementation, the above data processing method may further include the following three steps:

[0070] In response to the detection of an editing operation on the first panel, the displayed content of the first panel is adjusted according to the editing operation;

[0071] Update the first correspondence based on the editing operation;

[0072] Re-execute the steps from obtaining at least one first formula result of the first type according to the formula content configured in the first formula column of the table to filling the first formula result after all types are converted into the first formula column, that is, re-execute the above S101~S104.

[0073] In this disclosure, editing operations may include at least one of the following:

[0074] Add at least one new option under the option type;

[0075] Adjust the color scheme of at least one option under the option type.

[0076] For example, when the formula result in the first formula column contains a result that is not in the option content of the first panel, in addition to triggering a semi-automatic update of the option content through the first control, the user can also click... Figure 3 The "Add Options" button shown allows you to manually add one or more options under the option type in the first formula column.

[0077] In addition, to meet users' personalized needs, different color schemes can be set for each option, such as... Figure 6 As shown, users can set the color scheme of at least one option under the option type according to their own preferences through the color palette. Correspondingly, each label in the first formula column can be displayed according to the color scheme of the corresponding option.

[0078] like Figure 7 As shown, when the configuration type is option type, the user can modify the configuration information (i.e., the first correspondence) of the option type in the first formula column through editing operations. After receiving the editing operation, the user device can adjust the display content of the first panel according to the editing operation. For example, if the editing operation is to add an option, the added option will be displayed on the first panel. At the same time, according to the editing operation, the option field configuration information Changeset is generated and sent to the database to update the corresponding first correspondence (i.e., formula meta) in the database. The Changeset can include the added option and / or the adjusted option color scheme. Then, by calling the calculation service, at least one fourth formula result of the first type is obtained according to the formula content configured in the first formula column in the table. If the configuration type of the formula result in the first formula column is option type, the result type is converted according to the formula meta. That is, for each fourth formula result, the first identifier corresponding to the fourth formula result is determined according to the updated first correspondence. The first identifier is determined as the fourth formula result after type conversion to convert the fourth formula result of the first type into the option type. Finally, all the fourth formula results after type conversion are filled into the first formula column to complete the update of the first formula column.

[0079] To facilitate other business operations consuming formula fields as option types, an object reference pool can be set up to store elements from different formula columns. Specifically, in one possible implementation, the above data processing method may further include the following steps:

[0080] The elements in the first formula column of the table are added as storage objects to the object reference pool, which includes the storage objects referenced by the formula content of each of the multiple formula columns.

[0081] To ensure that other business operations can accurately consume formula fields, it is necessary to synchronously update the corresponding stored objects in the object reference pool whenever an element in the formula column changes, thereby guaranteeing the real-time accuracy of the stored objects in the reference pool. Specifically, the above data processing method may also include the following steps:

[0082] When an element in the first formula column is updated, the updated element in the first formula column is synchronously updated to the object reference pool.

[0083] In one possible implementation, the above data processing method may further include the following steps:

[0084] Based on the first type, determine whether the first formula column meets the type conversion conditions;

[0085] If the first formula column meets the type conversion condition, then the configuration type of the formula result in response to the first formula column is the option type. For each first formula result, the first identifier corresponding to the first formula result is determined according to the first correspondence between the formula result and the identifier.

[0086] like Figure 8 As shown, by calling the calculation service, at least one first formula result of the first type can be obtained according to the formula content configured in the first formula column of the table. Then, according to the first type, it is determined whether the first formula column meets the type conversion condition. If the first formula column meets the type conversion condition, the value of the first formula column is converted to an option type. That is, if the configuration type of the formula result of the first formula column is an option type, each first formula result is converted to an option type according to the first correspondence. That is, S102 above includes: when the first formula column meets the type conversion condition, in response to the configuration type of the formula result of the first formula column being an option type, for each first formula result, the first identifier corresponding to the first formula result is determined according to the first correspondence between the formula result and the identifier. Then, the result is retained, that is, all the first formula results after type conversion are filled into the first formula column.

[0087] The first formula result in the first formula column is converted from the first type to the option type only when the type conversion condition is met. This avoids type conversion failures caused by not meeting the type conversion condition, thus avoiding resource waste caused by invalid type conversion operations.

[0088] In one possible implementation, the type conversion condition of the first formula column can be determined based on the first type as follows: if the first type is in the first list, the first formula column is determined to meet the type conversion condition; if the first type is not in the first list, the first formula column is determined not to meet the type conversion condition. The first list includes at least one numeric type that can be converted to an option type.

[0089] In one possible implementation, the above data processing method may further include the following steps:

[0090] If the first formula column does not meet the type conversion conditions, then determine whether the configuration type is consistent with the first type.

[0091] If the configuration type is the same as the first type, then all the results of the first formula will be filled into the first formula column.

[0092] If the configuration type is inconsistent with the first type, then each first formula result will be updated to the first prompt message, and all updated first formula results will be filled into the first formula column.

[0093] In this disclosure, the first prompt message is used to indicate that the configuration type does not match the first formula column, that is, there is a type mismatch error in the configuration type. For example... Figure 9 As shown, if the first formula column does not meet the type conversion condition and the configuration type is consistent with the first type, the result is retained, that is, all first formula results are filled into the first formula column; if the first formula column does not meet the type conversion condition and the configuration type is inconsistent with the first type, the result is changed to a type mismatch error, that is, each first formula result is updated to the first prompt information, and all updated first formula results are filled into the first formula column.

[0094] Figure 9 This is a block diagram illustrating a data processing apparatus according to an exemplary embodiment. Figure 9 As shown, the data processing device 300 includes:

[0095] The first acquisition module 301 is used to acquire at least one first formula result of a first type according to the formula content configured in the first formula column of the table, wherein the first type is the original type of the formula result of the first formula column;

[0096] The first determining module 302 is configured to, in response to the configuration type of the formula result of the first formula column being an option type, determine a first identifier corresponding to the first formula result for each first formula result based on a first correspondence between the formula result and the identifier; the second determining module 303 is configured to determine the first identifier as the first formula result after type conversion, so as to convert the first formula result of the first type into the option type.

[0097] Fill module 304 is used to fill the first formula column with the first formula results after all type conversions.

[0098] In the above technical solution, firstly, based on the formula content configured in the first formula column of the table, at least one first formula result of the first type is obtained, where the first type is the original type of the formula result in the first formula column. If the configuration type of the formula result in the first formula column is an option type, then for each first formula result, based on the first correspondence between the formula result and the identifier, the first identifier corresponding to that first formula result is determined. The first identifier is determined as the first formula result after type conversion, so as to convert the first formula result of the first type into the option type. All the first formula results after type conversion are filled into the first formula column. In this way, the type conversion capability can be used to convert the values ​​in the first formula column from the first type to the enumerable option type, which is beneficial for the value flow of the formula column to subsequent business processes, and facilitates the consumption of the formula column by subsequent business processes. Thus, the performance optimization of subsequent business processes can be achieved by leveraging the enumerable characteristic of the option type.

[0099] Optionally, the data processing device 300 further includes:

[0100] The re-acquisition module is used to re-acquire at least one second formula result of the first type according to the formula content when the first control on the first panel is triggered, wherein the first panel is the configuration panel of the first correspondence, and the first panel includes at least one option under the option type;

[0101] The first adding module is used to add the newly added formula result as an option under the option type to the first panel, wherein the newly added formula result is the second formula result that is not located in the first panel;

[0102] The first update module is used to update the first correspondence relationship based on the result of the newly added formula;

[0103] The first triggering module is used to trigger the first acquisition module 301 to acquire at least one first formula result of the first type according to the formula content configured in the first formula column of the table.

[0104] Optionally, the data processing device 300 further includes:

[0105] An adjustment module is configured to, in response to detecting an editing operation on the first panel, adjust the display content of the first panel according to the editing operation, wherein the first panel is the configuration panel of the first correspondence;

[0106] The second update module is used to update the first correspondence relationship according to the edit operation;

[0107] The second triggering module is used to trigger the first acquisition module 301 to acquire at least one first formula result of the first type according to the formula content configured in the first formula column of the table.

[0108] Optionally, the editing operation includes at least one of the following:

[0109] Add at least one new option under the aforementioned option type;

[0110] Adjust the color scheme of at least one option under the aforementioned option type.

[0111] Optionally, the data processing device 300 further includes:

[0112] The second acquisition module is used to acquire at least one expected formula result of the first formula column when the configuration type is switched to the option type;

[0113] The second adding module is used to add each of the at least one expected formula results as an option under the option type to the first panel, wherein the first panel is the configuration panel of the first correspondence.

[0114] Optionally, the data processing device 300 further includes:

[0115] The storage module is used to add the elements in the first formula column of the table as storage objects to the object reference pool, wherein the object reference pool includes the storage objects referenced by the formula content of multiple formula columns.

[0116] Optionally, the data processing device 300 further includes:

[0117] The third update module is used to synchronously update the updated elements in the first formula column to the object reference pool when the elements in the first formula column are updated.

[0118] Optionally, the data processing device 300 further includes:

[0119] The third determining module is used to determine whether the first formula column satisfies the type conversion condition based on the first type.

[0120] The first determining module 302 is configured to, when the first formula column satisfies the type conversion condition, respond to the configuration type of the formula result of the first formula column being an option type, and for each first formula result, determine the first identifier corresponding to the first formula result based on the first correspondence between the formula result and the identifier.

[0121] Optionally, the third determining module is used to determine that the first formula column satisfies the type conversion condition if the first type is located in the first list, wherein the first list includes at least one numeric type that can be converted to the option type.

[0122] Optionally, the filling module 304 is further configured to fill all the first formula results into the first formula column if the first formula column does not meet the type conversion condition and the configuration type is consistent with the first type.

[0123] Optionally, the data processing device 300 further includes:

[0124] The fourth update module is used to update each first formula result with a first prompt message if the first formula column does not meet the type conversion condition and the configuration type is inconsistent with the first type. The first prompt message is used to indicate that the configuration type does not match the first formula column.

[0125] The filling module 304 is also used to fill all the updated first formula results into the first formula column.

[0126] The following is for reference. Figure 10 The diagram illustrates a structural schematic of an electronic device (e.g., a terminal device or a server) 600 suitable for implementing embodiments of the present disclosure. The terminal device in the embodiments of the present disclosure may include, but is not limited to, mobile terminals such as mobile phones, laptops, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), in-vehicle terminals (e.g., in-vehicle navigation terminals), and fixed terminals such as digital TVs and desktop computers. Figure 10 The electronic device shown is merely an example and should not be construed as limiting the functionality and scope of the embodiments disclosed herein.

[0127] like Figure 10 As shown, electronic device 600 may include a processing device (e.g., a central processing unit, a graphics processor, etc.) 601, which can perform various appropriate actions and processes according to a program stored in read-only memory (ROM) 602 or a program loaded from storage device 608 into random access memory (RAM) 603. RAM 603 also stores various programs and data required for the operation of electronic device 600. Processing device 601, ROM 602, and RAM 603 are interconnected via bus 604. Input / output (I / O) interface 605 is also connected to bus 604.

[0128] Typically, the following devices can be connected to I / O interface 605: input devices 606 including, for example, touchscreens, touchpads, keyboards, mice, cameras, microphones, accelerometers, gyroscopes, etc.; output devices 607 including, for example, liquid crystal displays (LCDs), speakers, vibrators, etc.; storage devices 608 including, for example, magnetic tapes, hard disks, etc.; and communication devices 609. Communication device 609 allows electronic device 600 to communicate wirelessly or wiredly with other devices to exchange data. Although Figure 10 An electronic device 600 with various devices is shown; however, it should be understood that it is not required to implement or possess all of the devices shown. More or fewer devices may be implemented or possessed alternatively.

[0129] In particular, according to embodiments of this disclosure, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, embodiments of this disclosure include a computer program product comprising a computer program carried on a non-transitory computer-readable medium, the computer program containing program code for performing the methods shown in the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network via a communication device 609, or installed from a storage device 608, or installed from a ROM 602. When the computer program is executed by the processing device 601, it performs the functions defined in the methods of embodiments of this disclosure.

[0130] It should be noted that the computer-readable medium described in this disclosure can be a computer-readable signal medium or a computer-readable storage medium, or any combination thereof. A computer-readable storage medium can be, for example,—but not limited to—an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of a computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer 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 disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof. In this disclosure, a computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. In this disclosure, a computer-readable signal medium can include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such propagated data signals can take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. A computer-readable signal medium can be any computer-readable medium other than a computer-readable storage medium, which can send, propagate, or transmit a program for use by or in connection with an instruction execution system, apparatus, or device. The program code contained on the computer-readable medium can be transmitted using any suitable medium, including but not limited to: wires, optical fibers, RF (radio frequency), etc., or any suitable combination thereof.

[0131] In some implementations, clients and servers can communicate using any currently known or future-developed network protocol such as HTTP (Hypertext Transfer Protocol) and can interconnect with digital data communication (e.g., communication networks) of any form or medium. Examples of communication networks include local area networks (“LANs”), wide area networks (“WANs”), the Internet (e.g., the Internet of Things), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future-developed networks.

[0132] The aforementioned computer-readable medium may be included in the aforementioned electronic device; or it may exist independently and not assembled into the electronic device.

[0133] The aforementioned computer-readable medium carries one or more programs. When the electronic device executes the aforementioned one or more programs, the electronic device causes the following: Based on the formula content configured in the first formula column of the table, it obtains at least one first formula result of a first type, wherein the first type is the original type of the formula result in the first formula column; in response to the configuration type of the formula result in the first formula column being an option type, for each first formula result, it determines a first identifier corresponding to the first formula result based on a first correspondence between the formula result and the identifier; it determines the first identifier as a type-converted first formula result to convert the first formula result of the first type into the option type; and it fills all type-converted first formula results into the first formula column.

[0134] Computer program code for performing the operations of this disclosure can be written in one or more programming languages ​​or a combination thereof, including but not limited to object-oriented programming languages ​​such as Java, Smalltalk, and C++, as well as conventional procedural programming languages ​​such as the "C" language or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving remote computers, the remote computer can be connected to the user's computer via any type of network—including a local area network (LAN) or a wide area network (WAN)—or can be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0135] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of this disclosure. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, can be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions.

[0136] The modules described in the embodiments of this disclosure can be implemented in software or in hardware. The name of a module does not necessarily limit the module itself; for example, a fill module can also be described as "a module that fills the first formula result after all type conversions into the first formula column".

[0137] The functions described above in this document can be performed at least in part by one or more hardware logic components. For example, exemplary types of hardware logic components that can be used, without limitation, include: field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard products (ASSPs), system-on-a-chip (SoCs), complex programmable logic devices (CPLDs), and so on.

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

[0139] According to one or more embodiments of this disclosure, Example 1 provides a data processing method, including:

[0140] Based on the formula content configured in the first formula column of the table, obtain at least one first formula result of the first type, wherein the first type is the original type of the formula result of the first formula column;

[0141] In response to the configuration type of the formula result in the first formula column being an option type, for each first formula result, a first identifier corresponding to the first formula result is determined according to the first correspondence between the formula result and the identifier; the first identifier is determined as the first formula result after type conversion, so as to convert the first formula result of the first type into the option type;

[0142] Fill the first formula column with the results of all type conversions.

[0143] According to one or more embodiments of this disclosure, Example 2 provides the method of Example 1, the data processing method further comprising:

[0144] When the first control on the first panel is triggered, at least one second formula result of the first type is obtained again according to the formula content, wherein the first panel is the configuration panel of the first correspondence, and the first panel includes at least one option under the option type;

[0145] The newly added formula result is added as an option under the option type to the first panel, wherein the newly added formula result is the second formula result that is not located in the first panel;

[0146] Update the first correspondence based on the result of the newly added formula;

[0147] Re-execute the step of obtaining at least one first formula result of a first type based on the formula content configured in the first formula column of the table, up to the step of filling the first formula results after converting all types into the first formula column.

[0148] According to one or more embodiments of this disclosure, Example 3 provides the method of Example 1, the data processing method further comprising:

[0149] In response to detecting an editing operation on the first panel, the display content of the first panel is adjusted according to the editing operation, wherein the first panel is the configuration panel of the first correspondence;

[0150] Update the first correspondence relationship according to the editing operation;

[0151] Re-execute the step of obtaining at least one first formula result of a first type based on the formula content configured in the first formula column of the table, up to the step of filling the first formula results after converting all types into the first formula column.

[0152] According to one or more embodiments of this disclosure, Example 4 provides the method of Example 3, wherein the editing operation includes at least one of the following:

[0153] Add at least one new option under the aforementioned option type;

[0154] Adjust the color scheme of at least one option under the aforementioned option type.

[0155] According to one or more embodiments of this disclosure, Example 5 provides the method of Example 1, the data processing method further comprising:

[0156] When the configuration type is switched to the option type, at least one expected formula result of the first formula column is obtained;

[0157] Each of the at least one expected formula results is added as an option under the option type to the first panel, wherein the first panel is the configuration panel for the first correspondence.

[0158] According to one or more embodiments of this disclosure, Example 6 provides a method of any one of Examples 1-5, wherein the data processing method further includes:

[0159] The elements in the first formula column of the table are added as storage objects to the object reference pool, wherein the object reference pool includes the storage objects referenced by the formula content of multiple formula columns.

[0160] According to one or more embodiments of this disclosure, Example 7 provides the method of Example 6, the data processing method further comprising:

[0161] When an element in the first formula column is updated, the updated element in the first formula column is synchronously updated to the object reference pool.

[0162] According to one or more embodiments of this disclosure, Example 8 provides the method of Example 1, the data processing method further comprising:

[0163] Based on the first type, determine whether the first formula column satisfies the type conversion condition;

[0164] If the first formula column satisfies the type conversion condition, then the step of configuring the formula result in response to the first formula column as an option type is executed, and for each first formula result, the first identifier corresponding to the first formula result is determined according to the first correspondence between the formula result and the identifier.

[0165] According to one or more embodiments of this disclosure, Example 9 provides the method of Example 8, wherein determining whether the first formula column satisfies the type conversion condition based on the first type includes:

[0166] If the first type is in the first list, then the first formula column is determined to satisfy the type conversion condition, wherein the first list includes at least one numeric type that can be converted to the option type.

[0167] According to one or more embodiments of this disclosure, Example 10 provides the method of Example 8, the data processing method further comprising:

[0168] If the first formula column does not meet the type conversion condition and the configuration type is consistent with the first type, then all the results of the first formula are filled into the first formula column.

[0169] According to one or more embodiments of this disclosure, Example 11 provides the method of Example 8, the data processing method further comprising:

[0170] If the first formula column does not meet the type conversion condition and the configuration type is inconsistent with the first type, then each first formula result is updated with a first prompt message, wherein the first prompt message is used to indicate that the configuration type does not match the first formula column;

[0171] Fill all the updated results of the first formula into the first formula column.

[0172] According to one or more embodiments of this disclosure, Example 12 provides a data processing apparatus, including:

[0173] The first acquisition module is used to acquire at least one first formula result of a first type according to the formula content configured in the first formula column of the table, wherein the first type is the original type of the formula result of the first formula column;

[0174] The first determining module is configured to, in response to the configuration type of the formula result of the first formula column being an option type, determine a first identifier corresponding to each first formula result based on a first correspondence between the formula result and the identifier; the second determining module is configured to determine the first identifier as the first formula result after type conversion, so as to convert the first formula result of the first type into the option type.

[0175] The fill module is used to fill the first formula column with the first formula results after all type conversions.

[0176] According to one or more embodiments of the present disclosure, Example 13 provides a computer-readable medium having a computer program stored thereon that, when executed by a processing device, implements the steps of the data processing method described in any one of Examples 1-11.

[0177] According to one or more embodiments of this disclosure, Example 14 provides an electronic device comprising:

[0178] A storage device on which computer programs are stored;

[0179] A processing device for executing the computer program in the storage device to implement the steps of the data processing method described in any one of Examples 1-11.

[0180] According to one or more embodiments of the present disclosure, Example 15 provides a computer program product including a computer program that, when executed by a processor, implements the steps of the data processing method described in any one of Examples 1-11.

[0181] The above description is merely a preferred embodiment of this disclosure and an explanation of the technical principles employed. Those skilled in the art should understand that the scope of this disclosure is not limited to technical solutions formed by specific combinations of the above-described technical features, but should also cover other technical solutions formed by arbitrary combinations of the above-described technical features or their equivalents without departing from the above-described concept. For example, technical solutions formed by substituting the above features with (but not limited to) technical features disclosed in this disclosure that have similar functions.

[0182] Furthermore, while the operations are described in a specific order, this should not be construed as requiring these operations to be performed in the specific order shown or in a sequential order. In certain environments, multitasking and parallel processing may be advantageous. Similarly, while several specific implementation details are included in the above discussion, these should not be construed as limiting the scope of this disclosure. Certain features described in the context of individual embodiments may also be implemented in combination in a single embodiment. Conversely, various features described in the context of a single embodiment may also be implemented individually or in any suitable sub-combination in multiple embodiments.

Claims

1. A data processing method, characterized in that, include: Based on the formula content configured in the first formula column of the table, at least one first formula result of the first type is obtained, wherein the first type is the original type of the formula result of the first formula column, the second panel is the configuration panel of the first formula column, used to configure the formula content and configuration type of the first formula column, and the first formula result is determined by calculating the value of the first formula column in the table based on the formula content configured in the first formula column; In response to the configuration type of the formula result in the first formula column being an option type, for each first formula result, a first identifier corresponding to the first formula result is determined according to the first correspondence between the formula result and the identifier; the first identifier is determined as the first formula result after type conversion, so as to convert the first formula result of the first type into the option type; Fill the first formula column with all the converted results. The data processing method further includes: When the first control on the first panel is triggered, at least one second formula result of the first type is obtained again according to the formula content, wherein the first panel is the configuration panel of the first correspondence, and the first panel includes at least one option under the option type; The newly added formula result is added to the first panel as an option under the option type, wherein the newly added formula result is the second formula result that is not located in the first panel; Update the first correspondence based on the result of the newly added formula; Re-execute the step of obtaining at least one first formula result of a first type based on the formula content configured in the first formula column of the table, up to the step of filling the first formula results after converting all types into the first formula column.

2. The data processing method according to claim 1, characterized in that, The data processing method further includes: In response to detecting an editing operation on the first panel, the display content of the first panel is adjusted according to the editing operation, wherein the first panel is the configuration panel of the first correspondence; Update the first correspondence relationship according to the editing operation; Re-execute the step of obtaining at least one first formula result of a first type based on the formula content configured in the first formula column of the table, up to the step of filling the first formula results after converting all types into the first formula column.

3. The data processing method according to claim 2, characterized in that, The editing operation includes at least one of the following: Add at least one new option under the aforementioned option type; Adjust the color scheme of at least one option under the aforementioned option type.

4. The data processing method according to claim 1, characterized in that, The data processing method further includes: When the configuration type is switched to the option type, at least one expected formula result of the first formula column is obtained; Each of the at least one expected formula results is added as an option under the option type to the first panel, wherein the first panel is the configuration panel for the first correspondence.

5. The data processing method according to any one of claims 1-4, characterized in that, The data processing method further includes: The elements in the first formula column of the table are added as storage objects to the object reference pool, wherein the object reference pool includes the storage objects referenced by the formula content of multiple formula columns.

6. The data processing method according to claim 5, characterized in that, The data processing method further includes: When an element in the first formula column is updated, the updated element in the first formula column is synchronously updated to the object reference pool.

7. The data processing method according to claim 1, characterized in that, The data processing method further includes: Based on the first type, determine whether the first formula column satisfies the type conversion condition; If the first formula column satisfies the type conversion condition, then the step of configuring the formula result in response to the first formula column as an option type is executed, and for each first formula result, determining the first identifier corresponding to the first formula result according to the first correspondence between the formula result and the identifier is performed.

8. The data processing method according to claim 7, characterized in that, The step of determining whether the first formula column satisfies the type conversion condition based on the first type includes: If the first type is in the first list, then the first formula column is determined to satisfy the type conversion condition, wherein the first list includes at least one numeric type that can be converted to the option type.

9. The data processing method according to claim 7, characterized in that, The data processing method further includes: If the first formula column does not meet the type conversion condition and the configuration type is consistent with the first type, then all the results of the first formula are filled into the first formula column.

10. The data processing method according to claim 7, characterized in that, The data processing method further includes: If the first formula column does not meet the type conversion condition and the configuration type is inconsistent with the first type, then each first formula result is updated with a first prompt message, wherein the first prompt message is used to indicate that the configuration type does not match the first formula column; Fill all the updated results of the first formula into the first formula column.

11. A data processing apparatus, characterized in that, include: The first acquisition module is used to acquire at least one first formula result of a first type according to the formula content configured in the first formula column in the table, wherein the first type is the original type of the formula result of the first formula column, and the second panel is the configuration panel of the first formula column, used to configure the formula content and configuration type of the first formula column, and the first formula result is determined by calculating the value of the first formula column in the table according to the formula content configured in the first formula column; The first determining module is configured to, in response to the configuration type of the formula result of the first formula column being an option type, determine a first identifier corresponding to each first formula result based on a first correspondence between the formula result and the identifier; the second determining module is configured to determine the first identifier as the first formula result after type conversion, so as to convert the first formula result of the first type into the option type. The fill module is used to fill the first formula column with all the converted first formula results; The data processing device further includes: The re-acquisition module is used to re-acquire at least one second formula result of the first type according to the formula content when the first control on the first panel is triggered, wherein the first panel is the configuration panel of the first correspondence, and the first panel includes at least one option under the option type; The first adding module is used to add the newly added formula result as an option under the option type to the first panel, wherein the newly added formula result is the second formula result that is not located in the first panel; The first update module is used to update the first correspondence relationship based on the result of the newly added formula; The first triggering module is used to trigger the first acquisition module to acquire at least one first formula result of the first type according to the formula content configured in the first formula column of the table.

12. A computer-readable medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processing device, it implements the steps of the data processing method according to any one of claims 1-10.

13. An electronic device, characterized in that, include: A storage device on which computer programs are stored; A processing device for executing the computer program in the storage device to implement the steps of the data processing method according to any one of claims 1-10.

14. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by a processor, it implements the steps of the data processing method according to any one of claims 1-10.

Images