Data processing method and device for spreadsheet, medium and electronic equipment

Abstract

The invention relates to a data processing method and device for a spreadsheet, a medium and electronic equipment, and relates to the technical field of computers.The method comprises the steps that a target sub-sheet is determined through a loading manager according to state information of a state manager associated with multiple sub-sheets included in the spreadsheet, and the target sub-sheet is loaded through the loading manager; and performing data updating on the target sub-table to obtain the updated spreadsheet, so that when the sub-table needing to be updated exists in the multiple sub-tables of the spreadsheet, data updating can be performed on the sub-table which is being used by the user, and data updating is not performed on the sub-table which is not used by the user. Therefore, the data updating speed and smoothness of the spreadsheet are improved, and the system stability of the spreadsheet is enhanced.

Description

Technical Field

[0001] The present disclosure relates to the field of computer technology, and in particular to a method, device, medium and electronic device for processing electronic spreadsheet data. Background Art

[0002] In the related art, when the data of a spreadsheet needs to be updated, the entire spreadsheet is generally updated. However, when a spreadsheet has sub-tables of multiple dimensions, if there is a large amount of data that needs to be updated in the multiple sub-tables, a large amount of data needs to be pulled, resulting in serious blocking problems in the update of the spreadsheet, which greatly affects the system stability of the table and the efficiency of data update, thus bringing a very poor user experience to users. Summary of the invention

[0003] This summary is provided to introduce concepts in a brief form that will be described in detail in the detailed description below. This summary is not intended to identify key features 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, the present disclosure provides a method for processing electronic form data, comprising:

[0005] Determine, by loading the manager, a target sub-table according to the state information of the state manager associated with the plurality of sub-tables included in the electronic table, wherein the target sub-table is a sub-table corresponding to which the state information of the state manager is in an activated state;

[0006] The target subtable is updated with data through the loading manager to obtain an updated electronic table.

[0007] In a second aspect, the present disclosure provides a data processing device for an electronic form, comprising:

[0008] A determination module is configured to determine a target sub-table according to the state information of the state manager associated with a plurality of sub-tables included in the electronic table through the loading manager, wherein the target sub-table is a sub-table corresponding to which the state information of the state manager is in an activated state;

[0009] The updating module is configured to update the data of the target sub-table through the loading manager to obtain an updated electronic table.

[0010] In a third aspect, the present disclosure provides a computer-readable medium having a computer program stored thereon, which, when executed by a processing device, implements the steps of the method described in the first aspect.

[0011] In a fourth aspect, the present disclosure provides an electronic device, including:

[0012] a storage device having a computer program stored thereon;

[0013] A processing device is used to execute the computer program in the storage device to implement the steps of the method described in the first aspect.

[0014] Based on the above technical solution, through the loading manager, the target subtable is determined according to the status information of the status manager associated with multiple subtables included in the electronic form, and the data of the target subtable is updated through the loading manager to obtain an updated electronic form. When there is a subtable that needs to be updated among the multiple subtables of the electronic form, the data of the subtable currently being used by the user can be updated, and the data of the subtable not being used by the user will not be updated, thereby improving the speed and fluency of the electronic form data update and enhancing the system stability of the electronic form.

[0015] Other features and advantages of the present disclosure will be described in detail in the following detailed description. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] The above and other features, advantages and aspects of the embodiments of the present disclosure will become more apparent with reference to the following detailed description in conjunction with the accompanying drawings. Throughout the drawings, the same or similar reference numerals represent 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:

[0017] Figure 1 The present invention is a flowchart of a method for processing data of an electronic form according to some embodiments.

[0018] Figure 2 is a schematic diagram of a spreadsheet according to some embodiments.

[0019] Figure 3 is a flowchart of updating data in a target sub-table based on table data according to some embodiments.

[0020] Figure 4 is a flow chart illustrating adjusting state information of a state manager according to some embodiments.

[0021] Figure 5 is a flow chart illustrating data updating according to some embodiments.

[0022] Figure 6 It is a schematic diagram of the structure of a data processing device for an electronic spreadsheet according to some embodiments.

[0023] Figure 7 is a schematic diagram of the structure of an electronic device according to some embodiments. DETAILED DESCRIPTION

[0024] Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be implemented in various forms and should not be construed as being limited to the embodiments described herein, which are instead provided for a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are only for exemplary purposes and are not intended to limit the scope of protection of the present disclosure.

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

[0026] The term "including" and its variations used herein are open inclusions, i.e., "including but not limited to". The term "based on" means "based at least in part 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". The relevant definitions of other terms will be given in the following description.

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

[0028] It should be noted that the modifications of "one" and "plurality" mentioned in the present disclosure are illustrative rather than restrictive, and those skilled in the art should understand that unless otherwise clearly indicated in the context, it should be understood as "one or more".

[0029] The names of the messages or information exchanged between multiple devices in the embodiments of the present disclosure are only used for illustrative purposes and are not used to limit the scope of these messages or information.

[0030] Figure 1 FIG. 1 is a flow chart of a method for processing data in an electronic form according to some embodiments. Figure 1 As shown, the embodiment of the present disclosure provides a method for processing electronic form data, which can be executed by an electronic device, specifically, by a device for processing electronic form data, which can be implemented by software and / or hardware and configured in the electronic device. Figure 1 As shown, the method may include the following steps.

[0031] In step 110, a target sub-table is determined by loading a manager according to the state information of the state manager associated with a plurality of sub-tables included in the electronic table, wherein the target sub-table is a sub-table whose state information of the corresponding state manager is in an activated state.

[0032] Here, the electronic table may include multiple sub-tables, that is, a main table may have multiple sub-tables, wherein each sub-table in the electronic table corresponds to a dimension. Figure 2 is a schematic diagram of a spreadsheet according to some embodiments. Figure 2 As shown, the electronic table may include a first subtable 201, a second subtable 202, a third subtable 203, a fourth subtable 204, and a fifth subtable 205. Of course, a subtable may also include a corresponding subtable. Figure 2 As shown, the first subtable 201 may include a subtable 206. The user may also create a subtable belonging to the first subtable 201 through the control 207. It should be understood that Figure 2 For the purpose of describing a spreadsheet with multiple subtables, Figure 2 The text and other text in the cells do not affect the understanding of the technical solution of the present disclosure.

[0033] Each of the plurality of sub-tables may be associated with a corresponding state manager. The state manager is configured to, when an activation operation of the sub-table corresponding to the state manager is detected, set the state information of the state manager from an inactive state to an active state.

[0034] For example, the first subtable 201 is associated with a first state manager, the second subtable 202 is associated with a second state manager, the third subtable 203 is associated with a third state manager, the fourth subtable 204 is associated with a fourth state manager, and the fifth subtable 205 is associated with a fifth state manager.

[0035] It should be understood that the state information of the state manager is an activated state, which means that the subtable corresponding to the activated state is the subtable currently activated and used by the user. The initial state of the state manager is an inactivated state. When the user selects one or more subtables in the electronic form as the form currently operated, the state manager is set from an inactivated state to an activated state. In other words, the target subtable can be understood as the subtable currently being used by the user among multiple subtables. When the user switches from subtable A to subtable B, subtable B is the subtable currently being used by the user, and accordingly, subtable B is the target subtable.

[0036] The loading manager is a component running in the electronic device and used to detect the status information of each status manager and to update the data of the electronic form.

[0037] As some examples, the loading manager may be controlled to periodically detect the state information of each state manager, and determine the target sub-table according to the detected state information.

[0038] As some further examples, when the state information of the state manager changes, the loading manager may be notified, and the loading manager determines the target sub-table according to the state information corresponding to the state manager whose state information has changed.

[0039] In step 120, the target sub-table is updated with data through the loading manager to obtain an updated electronic table.

[0040] Here, after the electronic device determines the target subtable, the electronic device updates the data of the target subtable through the loading manager to obtain an updated electronic table. Updating the data of the target subtable means using the latest table data corresponding to the target subtable to update the target subtable as a whole. It should be understood that the updated electronic table refers to the electronic table after the data of the target subtable is updated.

[0041] It is worth noting that while updating the target subtable, the electronic device controls the loading manager not to update the data of other subtables in the electronic table except the target subtable. Among them, other subtables except the target subtable refer to the subtables corresponding to the state manager whose state information of the state manager is in an inactive state. In other words, other subtables except the target subtable can be understood as subtables that are not currently used by the user. Figure 2 As shown, the subtable currently used by the user is the first subtable 201, so the loading manager updates the data of the first subtable 201, but does not update the data of the second subtable 202, the third subtable 203, the fourth subtable 204, and the fifth subtable 205. When the user switches from the first subtable 201 to the second subtable 202, the loading manager updates the data of the second subtable 202.

[0042] It should be noted that updating the target subtable actually means updating the table currently being used by the user according to the user's table usage requirements. The subtable currently being used by the user is updated, while the subtable currently being used by the user is not updated.

[0043] Therefore, through the loading manager, the target subtable is determined according to the status information of the status manager associated with the multiple subtables included in the electronic form, and the data of the target subtable is updated through the loading manager to obtain the updated electronic form. When there is a subtable that needs to be updated among the multiple subtables of the electronic form, the data of the subtable currently being used by the user can be updated, and the data of the subtable not being used by the user will not be updated, thereby improving the speed and fluency of the electronic form data update and enhancing the system stability of the electronic form.

[0044] In some feasible implementations, in step 110, the electronic device may, in response to an activation operation on any sub-table among a plurality of sub-tables, set the state information of a state manager associated with the sub-table to an activated state through a table controller, obtain the state information corresponding to each state manager through a loading manager, and determine the target sub-table based on the state information.

[0045] Here, when the electronic device detects the user's activation operation on any sub-table among the multiple sub-tables, the electronic device sets the state information of the state manager associated with the sub-table from the inactive state to the active state through the table controller. That is, the electronic device sets the state information of the state manager corresponding to the sub-table currently being used by the user to the active state through the table controller. For the sub-table that is not activated by the user, the state information of the corresponding state manager is in the inactive state.

[0046] The state information of the state manager is activated, which means that the subtable corresponding to the state manager is in operation and is being used by the user. The state information of the state manager is in inactive, which means that the subtable corresponding to the state manager is in paused state and has not been activated by the user.

[0047] It should be understood that when the user switches from one subtable A to another subtable B, the table controller sets the state information of the state manager corresponding to the switched subtable B to the activated state and sets the state information of the state manager corresponding to the subtable A to the inactivated state.

[0048] It should be understood that the table controller is a component running in the electronic device and used to update the state information of the state manager. The table controller can receive an activation operation on the electronic form by detecting the user's operation on the view layer of the electronic form.

[0049] The electronic device traverses the state information corresponding to the state managers corresponding to each sub-table by loading the manager, and determines the sub-table whose state information of the state manager is in the activated state as the target sub-table according to the state information of each traversed state manager.

[0050] Therefore, by setting the state information of the state manager associated with each sub-table through the table controller, the loading manager can accurately determine the target sub-table that needs to be updated with data.

[0051] In some feasible implementations, in step 120 , the table data corresponding to the target sub-table may be obtained from the server through the loading manager, and the target sub-table may be updated based on the table data.

[0052] Here, the electronic device can request the table data corresponding to the target subtable from the server through the loading manager, and receive the table data corresponding to the target subtable returned by the server. Then, the electronic device updates the data of the target subtable based on the received table data.

[0053] It should be understood that the table data corresponding to the target subtable may be the full table data of the target subtable, or may refer to the table data of the cells in the target subtable where data has changed. Of course, the table data corresponding to the target subtable refers to the latest table data of the target subtable.

[0054] Exemplarily, the electronic form referred to in the embodiments of the present disclosure may be an online electronic form, the table data of which is stored in a server.

[0055] Therefore, by loading the manager and acquiring the table data corresponding to the target subtable from the server, it is possible to ensure that the electronic table is updated with the latest table data of the target subtable stored in the server.

[0056] Figure 3 FIG. 4 is a flow chart showing how to update data of a target subtable based on table data according to some embodiments. Figure 3 As shown, in some practicable implementations, data in the target subtable may be updated through the following steps.

[0057] In step 301, the data update information corresponding to the target subtable and the version information corresponding to the data update information are obtained from the server through the loading manager;

[0058] Here, the data update information is used to describe the first table area in the target subtable that needs to be updated with data. The first table area may refer to the rows and / or columns in the target subtable where data changes occur, or the first table area may refer to all rows and / or columns in the target subtable, that is, as long as data changes occur in the first table area, all cells can serve as the first table area. Of course, the first table area may also refer to the cells in the target subtable where data changes occur. It should be understood that data changes may refer to changes in the values ​​(text, numbers, pictures, etc.) in the cells, or changes in the calculation logic of the cells, etc. When data changes occur in the first table area of ​​the target subtable, the server generates corresponding data update information and stores the data update information. Of course, the data update information may also be the first table area where data changes are recorded by the server when the user updates the electronic form.

[0059] The version information is used to describe the newness of the data update information. The version information is used by the electronic device to determine whether the data update information corresponding to the version information is data that needs to be updated.

[0060] For example, the version information may be represented by a version number. Whenever the server receives a piece of data update information, the server will incrementally generate the version information corresponding to the data update information. For example, the version information of the first piece of data update information is v0.0.0.0, the version information of the second piece of data update information is v0.0.0.1, and the version information of the third piece of data update information is v0.0.0.2.

[0061] The electronic device can request the data update information and version information corresponding to the target sub-table from the server through the loading manager via the communication connection with the server. The server responds to the request sent by the electronic device by sending the data update information and version information corresponding to the target sub-table to the electronic device, and the electronic device receives the data update information and version information corresponding to the target sub-table sent by the server.

[0062] In step 302, the first table area in the target sub-table that needs to be updated is determined according to the data update information and the version information through the loading manager.

[0063] Here, after acquiring the data update information and version information corresponding to the target subtable, the loading manager of the electronic device may compare the acquired version information with the current version information of the target subtable, and determine that the target subtable needs to be updated when the acquired version information is ahead of the current version information of the target subtable. Accordingly, the loading manager may determine the first table area in the target subtable that needs to be updated according to the data update information in response to the need for data update of the target subtable. That is, when the acquired version information is ahead of the current version information of the target subtable, the first table area is determined from the data update information.

[0064] It should be understood that, when the obtained version information is not ahead of the current version information of the target subtable, it is determined that the target subtable does not need to update data. Accordingly, when the obtained version information is not ahead of the current version information of the target subtable, even if the data update information carries the first table area that needs to be updated, it is not necessary to update the data of the target subtable.

[0065] It should be noted that the obtained version information is not ahead of the current version information of the target subtable, which means that the current table data in the target subtable is newer than the table data corresponding to the obtained version information, and there is no need to update the data of the target subtable.

[0066] In step 303, the table data corresponding to the first table area is obtained from the server through the loading manager.

[0067] Here, after the loading manager determines the first table area, the loading manager can request the server for the table data corresponding to the first table area. The server returns the table data corresponding to the first table area to the loading manager of the electronic device in response to the request sent by the loading manager of the electronic device, and the loading manager receives the table data sent by the server.

[0068] It should be understood that the table data corresponding to the first table area refers to the latest table data in the first table area.

[0069] In step 304, the target sub-table is updated according to the table data corresponding to the first table area through the loading manager.

[0070] Here, after obtaining the table data corresponding to the first table area, the loading manager of the electronic device may update the data of the first table area in the target sub-table to the obtained table data, thereby realizing the data change of the target sub-table.

[0071] Thus, the first table area that needs to be updated can be accurately determined through the data update information and version information, so that the first table area in the target subtable that needs to be updated can be accurately updated. Moreover, by updating the first table area that needs to be updated without updating other table areas where no data changes have occurred, the amount of data update can be reduced, thereby improving the fluency of the electronic form.

[0072] In some feasible implementations, in step 120, the electronic device may, through a loading manager, divide the target subtable into multiple second table areas according to the number of rows and / or columns of the target subtable, obtain the table data corresponding to the second table area through the loading manager for each second table area, and update the data of the second table area according to the table data.

[0073] Here, the number of rows and / or columns of the target subtable may refer to the number of all rows and / or columns included in the target subtable. For example, if the total number of rows in the target subtable is 10,000, the number of rows in the target subtable is 10,000. If the total number of columns in the target subtable is 10,000, the number of columns in the target subtable is 10,000. Of course, the number of rows and / or columns in the target subtable may also refer to the number of rows and / or columns that need to be updated. For example, the electronic device may determine the number of rows and / or columns in the target subtable based on the first table area carried in the above-mentioned data update information.

[0074] Wherein, each of the second table areas includes a target number of rows and / or columns. The target number can be a preset number, such as 2000 rows. For example, assuming that the number of columns of the target sub-table is 10,000 columns and the target number is 2,000, the number of second table areas is 5. Of course, the number of second table areas can also be preset. Accordingly, the target number can be determined based on the number of divided multiple second table areas and the number of rows and / or columns of the target sub-table. For example, assuming that the number of second table areas is 5 and the number of columns of the target sub-table is 10,000 columns, the target sub-table can be divided into 5 second table areas, each of which includes 2,000 rows.

[0075] For each second table area, the loading manager of the electronic device can obtain the table data corresponding to the second table area, and update the data of the corresponding second table area based on the obtained table data to obtain an updated electronic table. It should be understood that the second table area can also be understood as the first table area described in the above embodiment.

[0076] Exemplarily, the electronic device may update data in the second table areas in sequence. For example, assuming that the number of the second table areas is 5, the data in the second table area with the most rows and / or columns may be updated first, and then the data in the second most front second table area may be updated.

[0077] Of course, in actual application, the electronic device can also update data in multiple second table areas at the same time.

[0078] Therefore, by dividing the target subtable into a plurality of second table areas for data update, reliable and relatively stable logic for updating table data can be provided when the target subtable includes a large number of rows and / or columns, thereby enhancing system stability.

[0079] In some embodiments, after dividing the target sub-table into multiple second table areas, the electronic device can create multiple sub-tasks based on the multiple second table areas through the loading manager, and for each second table area, execute the sub-task corresponding to the second table area through the loading manager to obtain the table data corresponding to the second table area through the sub-task, and update the data of the second table area based on the table data.

[0080] Here, each subtask is used to update data in a second table area. When the subtask is executed, it can be realized that: through the loading manager, the table data of the second table area corresponding to the subtask is requested from the server, and the data of the second table area is updated based on the table data returned by the server.

[0081] It is worth noting that the number of the plurality of subtasks is consistent with the number of the plurality of second table areas. For example, if there are five second table areas, there are five subtasks. Each subtask is used to update data in one second table area.

[0082] Furthermore, it should be noted that after each subtask updates the data in the corresponding second table area, the loading manager of the electronic device will destroy the corresponding subtask.

[0083] Exemplarily, the loading manager may load multiple subtasks into a task queue, and execute the subtasks in the task queue in sequence.

[0084] It should be understood that after all subtasks are completed, the target subtable is determined to complete data update. If a subtask cannot be completed due to communication problems between the electronic device and the server, the subtask can be re-executed after a preset time interval.

[0085] Therefore, by creating corresponding subtasks and updating data through the subtasks, it can be ensured that the data in each second table area can be updated, thereby ensuring that all data in the target subtable can be updated.

[0086] Figure 4 FIG. 1 is a flow chart showing a method of adjusting state information of a state manager according to some embodiments. Figure 4 As shown, the state information of the state manager can be adjusted by following the steps below.

[0087] S401, the form controller receives an activation operation for the electronic form;

[0088] S402, the table controller sends a state instruction to the state manager corresponding to the activation operation;

[0089] S403: The state manager receives the state instruction and sets the state information of the state manager to an activated state.

[0090] It is worth noting that for the detailed description of step S401 to step S403, reference can be made to the relevant description of the above embodiment, which will not be repeated here.

[0091] Figure 5 FIG. 4 is a flowchart of data updating according to some embodiments. Figure 5 As shown, data can be updated by following the steps below.

[0092] S501, the loading manager detects the state information corresponding to each state manager;

[0093] S502, the loading manager requests the server for data update information and version information corresponding to the state manager whose state information is in the activated state;

[0094] S503, the server returns data update information and version information to the loading manager;

[0095] S504, the loading manager receives data update information and version information;

[0096] S505, the loading manager verifies the version information;

[0097] S506, when the version information indicates that there is a need to update, the loading manager requests the server for table data corresponding to the data update information;

[0098] S507, the server returns the table data to the loading manager;

[0099] S508: The loading manager receives and updates the table data.

[0100] The loading manager is a component running in the electronic device for updating the data of the electronic form. The loading manager can detect the state information corresponding to each state manager, and after detecting the state manager whose state information is an activated state, execute steps S502 to S508 to update the data. Of course, the loading manager can update the data by executing the corresponding subtask.

[0101] Figure 6 FIG. 1 is a schematic diagram of a structure of a data processing device for an electronic table according to some embodiments. Figure 6 As shown, the embodiment of the present disclosure provides a data processing device 600 for an electronic form, and the data processing device 600 for an electronic form includes:

[0102] The determination module 601 is configured to determine a target sub-table according to the state information of the state manager associated with a plurality of sub-tables included in the electronic table through the loading manager, wherein the target sub-table is a sub-table corresponding to which the state information of the state manager is in an activated state;

[0103] The updating module 602 is configured to update the data of the target sub-table through the loading manager to obtain an updated electronic table.

[0104] Optionally, the determining module 601 includes:

[0105] A setting unit configured to, in response to an activation operation on any sub-table among the plurality of sub-tables, set the state information of the state manager associated with the sub-table to an activated state through the table controller;

[0106] The determination unit is configured to obtain the state information corresponding to each state manager through the loading manager, and determine the target subtable according to the state information.

[0107] Optionally, the updating module 602 is specifically configured to:

[0108] The table data corresponding to the target subtable is obtained from the server through the loading manager, and the target subtable is updated based on the table data.

[0109] Optionally, the updating module 602 is specifically configured to:

[0110] Obtaining data update information corresponding to the target subtable and version information corresponding to the data update information from a server through the loading manager, wherein the data update information is used to describe a first table area in the target subtable that needs to be updated;

[0111] Determining, by the loading manager, a first table area in the target subtable that needs to be updated with data according to the data update information and the version information;

[0112] Obtaining, through the loading manager, table data corresponding to the first table area from the server;

[0113] The target subtable is updated with data through the loading manager according to the table data corresponding to the first table area.

[0114] Optionally, the updating module 602 includes:

[0115] a division unit configured to divide the target subtable into a plurality of second table areas according to the number of rows and / or columns of the target subtable through the loading manager, wherein each of the second table areas includes a target number of rows and / or columns;

[0116] The updating unit is configured to obtain, for each second table area, table data corresponding to the second table area through the loading manager, and update data of the second table area according to the table data.

[0117] Optionally, the electronic form data processing device 600 further includes:

[0118] A creation module, configured to create a plurality of subtasks according to the plurality of second table areas through the loading manager, wherein each of the subtasks is used to update data on one of the second table areas;

[0119] The division unit is specifically configured as follows:

[0120] For each second table area, the loading manager executes a subtask corresponding to the second table area, so as to obtain table data corresponding to the second table area through the subtask, and update data of the second table area according to the table data.

[0121] Optionally, the updating module 602 is further configured to:

[0122] The loading manager is controlled not to update data in other sub-tables except the target sub-table in the electronic table.

[0123] The functional logic executed by each functional module in the data processing device 600 of the electronic form has been described in detail in the part about the method, and will not be repeated here.

[0124] Reference below Figure 7, which shows a schematic diagram of the structure of an electronic device (e.g., terminal device) 700 suitable for implementing the 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, notebook computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), vehicle-mounted terminals (e.g., vehicle-mounted navigation terminals), etc., and fixed terminals such as digital TVs, desktop computers, etc. Figure 7 The electronic device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.

[0125] like Figure 7 As shown, the electronic device 700 may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 701, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 702 or a program loaded from a storage device 708 into a random access memory (RAM) 703. In the RAM 703, various programs and data required for the operation of the electronic device 700 are also stored. The processing device 701, the ROM 702, and the RAM 703 are connected to each other via a bus 704. An input / output (I / O) interface 705 is also connected to the bus 704.

[0126] Typically, the following devices may be connected to the I / O interface 705: an input device 706 including, for example, a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; an output device 707 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; a storage device 708 including, for example, a magnetic tape, a hard disk, etc.; and a communication device 709. The communication device 709 may allow the electronic device 700 to communicate with other devices wirelessly or by wire to exchange data. Although Figure 7 The electronic device 700 is shown with various devices, but it should be understood that it is not required to implement or possess all the devices shown. More or fewer devices may be implemented or possessed instead.

[0127] In particular, according to an embodiment of the present disclosure, the process described above with reference to the flowchart can be implemented as a computer software program. For example, an embodiment of the present disclosure includes a computer program product, which includes a computer program carried on a non-transitory computer-readable medium, and the computer program contains program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network through a communication device 709, or installed from a storage device 708, or installed from a ROM 702. When the computer program is executed by the processing device 701, the above-mentioned functions defined in the method of the embodiment of the present disclosure are executed.

[0128] It should be noted that the computer-readable medium disclosed above may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present disclosure, a computer-readable storage medium may be any tangible medium containing or storing a program that may be used by or in combination with an instruction execution system, device or device. In the present disclosure, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, in which a computer-readable program code is carried. This propagated data signal may take a variety of forms, including but not limited to an electromagnetic signal, an optical signal, or any suitable combination of the above. The computer readable signal medium may also be any computer readable medium other than a computer readable storage medium, which may send, propagate or transmit a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the computer readable medium may be transmitted using any suitable medium, including but not limited to: wires, optical cables, RF (radio frequency), etc., or any suitable combination of the above.

[0129] In some embodiments, the electronic device and the server may communicate using any currently known or future developed network protocol such as HTTP (HyperText Transfer Protocol), and may be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), an internet (e.g., the Internet), and a peer-to-peer network (e.g., an ad hoc peer-to-peer network), as well as any currently known or future developed network.

[0130] The computer-readable medium may be included in the electronic device, or may exist independently without being incorporated into the electronic device.

[0131] The computer-readable medium carries one or more programs. When the one or more programs are executed by the electronic device, the electronic device: determines the target sub-table through the loading manager according to the status information of the status manager associated with the multiple sub-tables included in the electronic table, wherein the target sub-table is the sub-table whose corresponding status information of the status manager is in the activated state; and updates the data of the target sub-table through the loading manager to obtain an updated electronic table.

[0132] Computer program code for performing the operations of the present disclosure may 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, C++, and conventional procedural programming languages, such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate 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 a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0133] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present disclosure. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some implementations as replacements, the functions marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0134] The modules involved in the embodiments described in the present disclosure may be implemented by software or hardware, wherein the name of a module does not, in some cases, limit the module itself.

[0135] The functions described above herein may be performed at least in part by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), complex programmable logic devices (CPLDs), and the like.

[0136] In the context of the present disclosure, a machine-readable medium may be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, device, or equipment. 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, device, or equipment, or any suitable combination of the foregoing. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0137] The above description is only a preferred embodiment of the present disclosure and an explanation of the technical principles used. Those skilled in the art should understand that the scope of disclosure involved in the present disclosure is not limited to the technical solutions formed by a specific combination of the above technical features, but should also cover other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the above disclosed concept. For example, the above features are replaced with the technical features with similar functions disclosed in the present disclosure (but not limited to) by each other to form a technical solution.

[0138] In addition, although each operation is described in a specific order, this should not be understood as requiring these operations to be performed in the specific order shown or in a sequential order. Under certain circumstances, multitasking and parallel processing may be advantageous. Similarly, although some specific implementation details are included in the above discussion, these should not be interpreted as limiting the scope of the present disclosure. Some features described in the context of a separate embodiment can also be implemented in a single embodiment in combination. On the contrary, the various features described in the context of a single embodiment can also be implemented in multiple embodiments individually or in any suitable sub-combination mode.

[0139] Although the subject matter has been described in language specific to structural features and / or method logic actions, it should be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or actions described above. On the contrary, the specific features and actions described above are merely example forms of implementing the claims. Regarding the device in the above embodiment, the specific manner in which each module performs the operation has been described in detail in the embodiment related to the method, and will not be elaborated here.

Claims

1. A method for processing data of an electronic spreadsheet, characterized in that: include: Determine, by loading the manager, a target sub-table according to the state information of the state manager associated with the plurality of sub-tables included in the electronic table, wherein the target sub-table is a sub-table corresponding to which the state information of the state manager is in an activated state; The target subtable is updated with data through the loading manager to obtain an updated electronic table.

2. The method according to claim 1, characterized in that The step of determining the target sub-table by loading the manager according to the state information of the state manager associated with the plurality of sub-tables included in the electronic table comprises: In response to an activation operation on any sub-table among the plurality of sub-tables, setting, by the table controller, state information of a state manager associated with the sub-table to an activated state; The state information corresponding to each state manager is obtained by loading the manager, and the target subtable is determined according to the state information.

3. The method according to claim 1, characterized in that The step of updating the target subtable with the loading manager to obtain an updated electronic table includes: The table data corresponding to the target subtable is obtained from the server through the loading manager, and the target subtable is updated based on the table data.

4. The method according to claim 3, characterized in that The step of obtaining table data corresponding to the target subtable from a server through the loading manager, and updating data of the target subtable based on the table data includes: Obtaining data update information corresponding to the target subtable and version information corresponding to the data update information from a server through the loading manager, wherein the data update information is used to describe a first table area in the target subtable that needs to be updated; Determining, by the loading manager, a first table area in the target subtable that needs to be updated with data according to the data update information and the version information; Obtaining, through the loading manager, table data corresponding to the first table area from the server; The target subtable is updated with data through the loading manager according to the table data corresponding to the first table area.

5. The method according to claim 1, characterized in that The step of updating the target subtable with the loading manager to obtain an updated electronic table includes: By means of the loading manager, the target subtable is divided into a plurality of second table areas according to the number of rows and / or columns of the target subtable, wherein each of the second table areas includes a target number of rows and / or columns; For each second table area, the table data corresponding to the second table area is obtained through the loading manager, and data of the second table area is updated according to the table data.

6. The method according to claim 5, characterized in that The method further comprises: Creating a plurality of subtasks according to the plurality of second table areas through the loading manager, wherein each of the subtasks is used to update data in one of the second table areas; For each second table area, obtaining table data corresponding to the second table area through the loading manager, and updating data of the second table area according to the table data, includes: For each second table area, the loading manager executes a subtask corresponding to the second table area, so as to obtain table data corresponding to the second table area through the subtask, and update data of the second table area according to the table data.

7. The method according to any one of claims 1 to 6, characterized in that The method further comprises: The loading manager is controlled not to update data in other sub-tables except the target sub-table in the electronic table.

8. A data processing device for an electronic spreadsheet, characterized in that: include: A determination module is configured to determine a target sub-table according to the state information of the state manager associated with a plurality of sub-tables included in the electronic table through the loading manager, wherein the target sub-table is a sub-table corresponding to which the state information of the state manager is in an activated state; The updating module is configured to update the data of the target sub-table through the loading manager to obtain an updated electronic table.

9. A computer readable medium having a computer program stored thereon, characterized in that: When the program is executed by a processing device, the steps of the method described in any one of claims 1 to 7 are implemented.

10. An electronic device, characterized in that: include: a storage device having a computer program stored thereon; A processing device, configured to execute the computer program in the storage device to implement the steps of the method according to any one of claims 1 to 7.

Images