Table processing method, device, electronic device, and storage medium

Abstract

The present disclosure relates to a computer technology field, and in particular to a table processing method, an apparatus, an electronic device, and a storage medium. A control method provided by an embodiment of the present disclosure includes: determining a target cell; displaying a data editing interface in response to a first operation; determining an optional data set including N optional data, which is a positive integer, based on a second operation on the data editing interface; determining M cell coloring schemes, which is a positive integer equal to or smaller than N, based on the N optional data in response to a first control displayed on the data editing interface being triggered; and associating the M cell coloring schemes with the N optional data, thereby enabling each optional data to be displayed based on the associated cell coloring scheme in the target cell.

Description

Technical Field

[0001] (Reference to Related Application) This application is proposed based on a Chinese patent application with an application number of 202111364825.8, an application date of November 17, 2021, and a title of "Table Processing Method, Apparatus, Electronic Device, and Storage Medium", claims the priority of the Chinese patent application, and incorporates all the contents of the Chinese patent application herein by reference.

[0002] (Technical Field) The present disclosure relates to the field of computer technology, and specifically, to a table processing method, apparatus, electronic device, and storage medium.

Background Art

[0003] In a spreadsheet, a cell with a sequence verification function set can only input values from a specific sequence as options, and the sequence may be derived from user self - definition or from a referenced cell range. The sequence verification function of related spreadsheet products cannot automatically color the options, has a single display form, and cannot better convey the meaning of option content using colors.

Summary of the Invention

[0004] To introduce the concept in a simplified form, a summary part of this invention is provided, and these concepts are described in detail in the detailed description part for implementing the following invention. The summary part of this invention is not intended to identify the key features or essential features of the claimed technical solution, nor is it used to limit the scope of the claimed technical solution.

[0005] In a first aspect, according to one or more embodiments of the present disclosure, determining a target cell, displaying a data editing interface in response to a first operation, Based on a second operation on the data editing interface, determining an option data set including N (N is a positive integer) option data; In response to a first control displayed on the data editing interface being triggered, determining M (M is a positive integer less than or equal to N) cell color schemes based on the N option data; By associating the M cell color schemes with the N option data, enabling each option data to be displayed based on the associated cell color scheme in the target cell, and providing a table processing method including this.

[0006] In a second aspect, according to one or more embodiments of the present disclosure, a cell determination unit for determining a target cell; an interface display unit for displaying a data editing interface in response to a first operation; an option data determination unit for determining an option data set including N (N is a positive integer) option data based on a second operation on the data editing interface; a color scheme determination unit for determining M (M is a positive integer less than or equal to N) cell color schemes based on the N option data in response to a first control displayed on the data editing interface being triggered; a color scheme association unit for enabling each option data to be displayed based on the associated cell color scheme in the target cell by associating the M cell color schemes with the N option data, and providing a table processing device including this.

[0007] In a third aspect, according to one or more embodiments of the present disclosure, there is provided an electronic device including at least one memory and at least one processor, wherein the memory is used for storing program code, and the processor calls the program code stored in the memory to cause the electronic device to execute a table processing method provided by one or more embodiments of the present disclosure.

[0008] In a fourth aspect, according to one or more embodiments of the present disclosure, there is provided a non-transitory computer storage medium storing program code that, when executed by a computer device, causes the computer device to execute a table processing method provided by one or more embodiments of the present disclosure.

[0009] According to one or more embodiments of the present disclosure, in response to triggering of a first control displayed on the data editing interface, a cell color scheme is determined based on option data, the determined cell color scheme is associated with the option data, and each option data is made displayable based on the cell color scheme associated therewith in the target cell, so as to better convey the meaning of the data content by using colors and enhance the distinguishability of the data.

Brief Description of the Drawings

[0010] The above and other features, advantages, and aspects of each embodiment of the present disclosure will become more apparent by referring to the following modes for carrying out the invention in conjunction with the drawings. In all 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 elements and components are not necessarily drawn to scale.

[0011]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Mode for Carrying Out the Invention

[0012] Hereinafter, embodiments of the present disclosure will be described in more detail with reference to the drawings. Although several embodiments of the present disclosure are shown in the drawings, the present disclosure can be realized in various forms and should not be construed as being limited to the embodiments described herein. On the contrary, it should be understood that providing these embodiments is 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 merely illustrative and do not limit the protection scope of the present disclosure.

[0013] It should be understood that the steps described in the embodiments of the present disclosure may be executed in a different order and / or in parallel. Also, additional steps may be included in the embodiments and / or the steps shown may be omitted. The scope of the present disclosure is not limited in this regard.

[0014] As used herein, the term "comprising" and variations thereof are non-limiting "including", i.e., "including... but not limited to...". The term "based on" means "at least partially based on". The term "an embodiment" represents "at least one embodiment". The term "another embodiment" represents "at least one another embodiment". The term "some embodiments" represents "at least some embodiments". The term "in response to" and related terms mean that one signal or event is affected to some extent by another signal or event, but is not necessarily completely or directly affected. When event x occurs "in response to" event y, x can respond directly or indirectly to y. For example, the occurrence of y may ultimately lead to the occurrence of x, but there may be other intermediate events and / or conditions. In other cases, y does not necessarily lead to the occurrence of x, and x may occur even if y has not occurred. Also, the term "in response to" may further mean "at least partially in response to".

[0015] The term "determine" broadly encompasses various operations, including obtaining, calculating, computing, processing, deriving, investigating, looking up (e.g., looking up in a table, database or other data structure), searching, and similar operations, and can also include receiving (e.g., receiving information), accessing (e.g., accessing data in a memory) and similar operations, and operations such as analyzing, selecting, choosing, establishing and similar operations. Related definitions of other terms are given in the following description. Related definitions of other terms are given in the following description.

[0016] Note that the concepts such as "first", "second", etc. mentioned in this disclosure are only for distinguishing different devices, modules or units, and are not for limiting the order or interdependence of the functions performed by these devices, modules or units.

[0017] In addition, the modifiers "one" and "a plurality" mentioned in the present disclosure are exemplary and not limiting. As should be understood by those skilled in the art, unless otherwise clearly specified in the context, it should be understood as "one or a plurality".

[0018] For the purposes of the present disclosure, the phrase "A and / or B" means (A), (B), or (A and B).

[0019] The names of the messages or information that interact between multiple devices in the embodiments of the present disclosure are for illustrative purposes only and are not for limiting the scope of these messages or information.

[0020] Referring to FIG. 1, FIG. 1 shows a flowchart of a table processing method 100 provided according to an embodiment of the present disclosure. The method 100 includes steps S110 to S190.

[0021] Step S110: Determine the target cell.

[0022] The target cell may be a cell selected by the user, or may further include cells set in the same way as those selected by the user. Exemplarily, the user can select one or more target cells by interaction operations such as single-clicking or dragging, or by an expression input into the target cell.

[0023] Step S130: In response to the first operation, display a data editing interface.

[0024] Exemplarily, the first operation includes, but is not limited to, a touch operation, a click operation, a shortcut key operation, a gesture operation, a voice operation, etc. on a predetermined identifier.

[0025] Note that the predetermined identifier may be located within the interface where the table is located, or may be provided in a multi-level interface that enters or opens through the interface where the table is located, and the present disclosure does not limit here.

[0026] Step S150: Based on a second operation on the data editing interface, determine an option data set including N (N is a positive integer) option data.

[0027] Here, the option data is used to be displayed in the determined target cell.

[0028] In some embodiments, in response to a selection operation on at least one cell in the table, the cell data set corresponding to the at least one cell can be cited as the option data set. Exemplarily, the selection operation on at least one cell in the table can include a cell formula input by the user or a selection operation on a cell in the table.

[0029] Exemplarily, a plurality of data corresponding to each of a plurality of cells may be used as a cell data set, or the data in one cell may be divided into a plurality of data according to a predetermined field and used as a cell data set. For example, "A, B, C" displayed in one cell can be divided into data "A", "B", and "C".

[0030] Step S170: In response to the first control displayed on the data editing interface being triggered, determine M (M is a positive integer not greater than N) cell color schemes based on the N option data.

[0031] In some embodiments, the N option data can each correspond to a different cell color scheme. At this time, M is equal to N. A plurality of the data in the N option data can share one cell color scheme. At this time, M is less than N. It can be understood that after the number of option data exceeds a predetermined cell color scheme, the latter situation may occur.

[0032] In some embodiments, a cell color scheme set can be preset, and according to the cell color scheme arrangement order in the cell color scheme set and the data arrangement order in the option data set, a cell color scheme can be correspondingly assigned to each option data in sequence. When the number of option data in the option data set exceeds the number of cell color schemes in the cell color scheme set, the cell color scheme can be reassigned to the excess option data. In other words, the preset cell color scheme set can be repeatedly used.

[0033] In some embodiments, a plurality of cell color scheme sets can be preset, and each cell color scheme set corresponds to a different number of option data. Exemplarily, when the option data set includes three option data, a cell color scheme set including three cell color schemes can be selected.

[0034] In some embodiments, the cell color scheme includes a setting for the background color of the cell and / or a setting for the text color of the cell.

[0035] Step S190: By associating the M cell color schemes with the N option data, each option data can be made displayable in the target cell based on the associated cell color scheme.

[0036] Exemplarily, referring to FIG. 2, FIG. 2 shows a schematic diagram of a data editing interface. In the data editing interface 10, a first control 11, a first input box 13, and a cell selection control 14 are displayed.

[0037] The user can input custom data into the first input box 13 as an option data set, or input a cell formula into the first input box 13, or select cell data already existing in the table using the cell selection control 14, so as to cite the cell data corresponding to the cell formula or the selected cell data as an option data set.

[0038] The system can determine M cell color schemes based on the N option data in response to the first control 11 being selected by a box. It is understood that when the first control 11 is not selected by a box, it may not be necessary to determine a cell color scheme.

[0039] According to one or more embodiments of the present disclosure, in response to the first control displayed on the data editing interface being triggered, a cell color scheme is determined based on option data, and the determined cell color scheme is associated with the option data, and each option data is made displayable based on the associated cell color scheme in the target cell, so as to better convey the meaning of the data content using colors and enhance the distinguishability of the data.

[0040] In some embodiments, method 100 further includes step A1 and step A2.

[0041] Step A1: In response to a third operation by the user on the target cell, an option interface is displayed, and in the option interface, the N option data is displayed based on the M cell color schemes.

[0042] Exemplarily, the third operation includes, but is not limited to, a touch operation, a click operation, a shortcut key operation, a gesture operation, a voice operation, etc. on a predetermined identifier.

[0043] Step A2: In response to the user determining the target option data from the option interface, filling the target cell with the target option data, and displaying the target option data in the target cell with a cell color scheme associated with the target option data.

[0044] In this embodiment, after associating the option data with the cell color scheme, the user can trigger the display of the option interface by a third operation on the target cell. In the option interface, each option data is displayed with a cell color scheme associated therewith. The user can select one or more of the option data to fill the target cell.

[0045] Exemplarily, referring to FIG. 3, the user can open the option interface 30 by triggering the drop-down control 21 displayed in the target cell 20. In the option interface 30, option data with different colors (the colors are not shown) as the background color (the outline of the background color is shown as a rounded rectangle) are displayed, which are "not very urgent", "not urgent", "general", "urgent", and "very urgent" respectively. The user can select one or more of them to fill into the target cell 20, and the background color remains reserved for the option filled in the target cell. As shown in FIG. 3, when the user currently selects the "not urgent" option, the "not urgent" with the background color is filled into the target cell 20.

[0046] In some embodiments, the method 100 further includes step B1.

[0047] Step B1: In response to the user inputting one or more of the N option data into the target cell, the input option data is displayed in the target cell with a cell color scheme associated with the input option data.

[0048] In this embodiment, the user can input option data into the target cell, and the input option data is automatically displayed in the target cell with an associated cell color scheme.

[0049] In some embodiments, the M cell color schemes determined in step S170 may be initial cell color schemes or default cell color schemes automatically installed by the system, and the user can further customize the cell color scheme. The user's customization of the cell color scheme can include the following steps C1 and C2.

[0050] Step C1: Display a color selection interface for editing the cell color scheme for the N option data.

[0051] Step C2: Update the M cell color schemes based on the user's operation on the color selection interface.

[0052] In some embodiments, the color editing interface can be displayed in response to the triggering of a second control displayed on the data editing interface. Exemplarily, referring to FIG. 2, the user can open the color editing interface by triggering the second control 12 displayed on the data editing interface 10.

[0053] In some embodiments, the N option data is displayed on the color selection interface, and each of the option data corresponds to one color selection label. Step C2 further includes steps c21 to c23.

[0054] Step c21: In response to the triggering of a first color selection label corresponding to first option data, display a cell color scheme set interface in which a plurality of cell color schemes are being displayed. The first option data is any one of the N option data.

[0055] Step c22: Determine a first cell color scheme in response to an operation by the user on the cell color scheme set interface.

[0056] Step c23: Determine the first cell color scheme as the cell color scheme corresponding to the first option data.

[0057] In some embodiments, the initial display color of the first color selection label corresponds to one of the M initial cell color schemes. After determining the first cell color scheme, the display color of the first color selection label corresponds to the first cell color scheme.

[0058] Referring to FIG. 4, on a color selection interface 40, five option data respectively indicating "not very urgent", "not urgent", "general", "urgent", and "very urgent" are displayed. On the left side of each option data, color selection labels 41, 42, 43, 44, and 45 are respectively and correspondingly displayed. The initial colors of the color selection labels can respectively correspond to the default initial cell color schemes of these five option data by the system. In this way, it becomes easier for the user to understand the cell color scheme corresponding to each option data currently.

[0059] Referring to FIG. 4, when the user triggers the first color selection label 41, for example, clicks on the first color selection label 41 or aligns the cursor with the first color selection label, the cell color scheme setting interface 50 is displayed, and a plurality of cell color schemes 51 can be displayed on the cell color scheme setting interface 50. The user can select one of the cell color schemes as the cell color scheme for the "not very urgent" which is the first option data. After the user selects a cell color scheme, the color of the first color selection label can be changed to correspond to the cell color scheme selected by the user from the initial cell color scheme. When the user clicks the "OK" button or the "Back" button in the color selection interface 40, the modification of the cell color scheme by the user is saved.

[0060] According to one or more embodiments of the present disclosure, by displaying the N option data and the corresponding color selection labels on the color selection interface, the color of the color selection label corresponds to the current cell color scheme of the option data, making it easy for the user to comprehensively combine and compare the cell color schemes corresponding to each option data.

[0061] Based on similar steps, the user can re-select a new cell color scheme for other option data, and the color of the color selection label corresponding to the other option data can change accordingly, which will not be described in detail here.

[0062] In some embodiments, when the option data set quotes the cell data in the table, the N option data is displayed on the color selection interface based on the arrangement order of the quoted cell data. Exemplarily, when the arrangement order of the quoted cell data is A, B, C, D in sequence, the option data A, B, C, D are correspondingly displayed on the color selection interface in sequence. When the arrangement order of the quoted cell data changes, the option data displayed on the color selection interface changes in sequence.

[0063] In some embodiments, when a predetermined operation is performed on the second data in the cell data set, the cell color scheme is re-associated with the second option data corresponding to the second data. The predetermined operation is used to adjust the positional order of the second data in the cell data set, and the second data is any one of the data in the cell data set.

[0064] Exemplarily, when the array order of the cited cell data is A, B, C, D in sequence, when the user moves cell data C between cell data A and B by a drag-and-drop operation, the cell color scheme is re-associated with option data C corresponding to cell data C, and the cell color schemes associated with the other option data (A, B, D) do not change thereby.

[0065] In some embodiments, when a third data is newly added to the cell data set, a third option data corresponding to the third data is added to the option data set, and the cell color scheme is associated with the third option data.

[0066] Exemplarily, when the cited cell data set is changed from "A, B, C, D" to "A, B, C, D, E", correspondingly, the option data set is changed from "A, B, C, D" to "A, B, C, D, E", and the cell color scheme is associated with the newly added option data E, and the cell color schemes associated with the other option data (A, B, C, D) do not change thereby.

[0067] In some embodiments, when a fourth data is deleted from the cell data set, the fourth option data corresponding to the fourth data is deleted from the option data set, and the cell color scheme associated with the fourth option data is deleted. The fourth data is any one of the data in the cell data set.

[0068] In some embodiments, when a drag-and-drop operation occurs on a cell within the reference range of cells, the number of cell color scheme corresponding to the N option data remains unchanged, that is, the number of determined M cell color schemes remains unchanged. A new cell color scheme is newly associated with the option data corresponding to the dragged-and-dropped reference target cell, and the cell color scheme associated with the option data corresponding to the reference target cell that has not been dragged-and-dropped is maintained so as not to change.

[0069] In some embodiments, when a new cell is inserted into the reference range of cells (for example, a new row or a new column is inserted), or when the reference range of cells is expanded, new option data is added accordingly, and a cell color scheme is associated with the newly added option data, and the cell color scheme associated with the original option data is maintained so as not to change.

[0070] In some embodiments, when a new cell is deleted from the reference range of cells (for example, a row or a column is deleted), or when the reference range of cells is reduced, the corresponding option data is deleted accordingly, and the corresponding cell color scheme is deleted, and the cell color scheme associated with the option data is maintained so as not to change.

[0071] Accordingly, as shown in FIG. 5, according to an embodiment of the present disclosure, a cell determination unit 610 for determining a target cell, an interface display unit 630 for displaying a data editing interface in response to a first operation, an option data determination unit 650 for determining an option data set including N (N is a positive integer) option data based on a second operation on the data editing interface, In response to the triggering of the first control displayed on the data editing interface, a color scheme determination unit 670 for determining M (where M is a positive integer less than or equal to N) cell color schemes based on the N option data, A table processing apparatus 600 including a color scheme association unit 690 for associating the M cell color schemes with the N option data so that each option data can be displayed based on the associated cell color scheme in the target cell.

[0072] According to one or more embodiments of the present disclosure, in response to the triggering of the first control displayed on the data editing interface, a cell color scheme is determined based on option data, and the determined cell color scheme is associated with the option data, so that each option data can be displayed based on the associated cell color scheme in the target cell, thereby better conveying the meaning of the data content using colors and enhancing the discriminability of the data.

[0073] In some embodiments, the table processing apparatus An option interface display unit for displaying an option interface in response to a third operation by the user on the target cell, and displaying the N option data based on the M cell color schemes in the option interface, A first target data display unit for filling the target cell with the target option data in response to the user determining the target option data from the option interface, and displaying the target option data in the target cell with the cell color scheme associated with the target option data.

[0074] In some embodiments, the table processing apparatus In response to the user inputting one or more of the N option data into the target cell, a second target data display unit is further included for displaying the input option data in the cell color scheme associated with the input option data within the target cell.

[0075] In some embodiments, the color scheme determination unit is used to determine M initial cell color schemes in response to the triggering of a first control displayed on the data editing interface, and the table processing device a color selection interface display unit for displaying a color selection interface for editing a cell color scheme for the N option data, and a second color scheme determination unit for determining the M cell color schemes based on the user's operation on the color selection interface are further included.

[0076] In some embodiments, the table processing device further includes a first re-association unit for re-associating a cell color scheme with second option data corresponding to the second data when a predetermined operation is performed on the second data in the cell data set, the predetermined operation is used to adjust the positional order of the second data in the cell data set, and the second data is any one data in the cell data set.

[0077] In some embodiments, the table processing device when a third data is newly added to the cell data set, the option data set further includes a second re-association unit for adding third option data corresponding to the third data and associating a cell color scheme with the third option data.

[0078] In some embodiments, the table processing device When the fourth data is deleted from the cell data set, a third re-association unit is further included to delete the fourth option data corresponding to the fourth data from the option data set and to delete the cell color scheme associated with the fourth option data, and the fourth data is any one of the data in the cell data set.

[0079] For the embodiments of the apparatus, since they basically correspond to the embodiments of the method, reference may be made to the description of a part of the embodiments of the method for related parts. The embodiments of the apparatus described above are merely illustrative, and the modules described as separate modules may or may not be separate. Some or all of the modules can be selected according to actual needs to achieve the purpose of the technical solution of this embodiment. A person skilled in the art can understand and implement it without creative efforts.

[0080] Accordingly, according to one or more embodiments of the present disclosure, an electronic device including at least one memory and at least one processor, wherein the memory is used to store program code, and the processor is configured to call the program code stored in the memory to cause the electronic device to execute the table processing method provided by one or more embodiments of the present disclosure.

[0081] Accordingly, according to one or more embodiments of the present disclosure, there is provided a non-transitory computer storage medium storing program code that can be executed by a computer device to cause the computer device to execute the table processing method provided by one or more embodiments of the present disclosure.

[0082] Hereinafter, referring to FIG. 6, it shows a schematic diagram of the structure of an electronic device (for example, a terminal device or a server) 800 suitable for implementing an embodiment of the present disclosure. The terminal device in the embodiment of the present disclosure can include mobile terminals such as mobile phones, notebook computers, digital broadcast receivers, PDAs (Personal Digital Assistants), PADs (tablet computers), PMPs (Portable Media Players), in-vehicle terminals (for example, in-vehicle navigation terminals), etc., and fixed terminals such as digital TVs and desktop computers, but is not limited thereto. The electronic device shown in FIG. 6 is only an example and does not limit the functions and usage ranges of the embodiments of the present disclosure.

[0083] As shown in FIG. 6, the electronic device 800 can include a processing device (for example, a central processing unit, an image processing device, etc.) 801, and can execute various appropriate operations and processes based on a program stored in a read-only memory (ROM) 802 or a program loaded from a storage device 808 into a random access memory (RAM) 803. In the RAM 803, various programs and data required for operating the electronic device 800 are further stored. The processing device 801, the ROM 802, and the RAM 803 are connected to each other via a bus 804. An input / output (I / O) interface 805 is also connected to the bus 804.

[0084] Normally, devices such as an input device 806 including a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc., an output device 807 including a liquid crystal display (LCD), a speaker, a vibrator, etc., a storage device 808 including a magnetic tape, a hard disk, etc., and a communication device 809 can be connected to the I / O interface 805. The communication device 809 can enable the electronic device 800 to communicate with other devices wirelessly or wiredly to exchange data. Although FIG. 6 shows an electronic device 800 having various devices, it should be understood that it is not required to implement or include all of the shown devices. More or fewer devices may alternatively be implemented or included.

[0085] In particular, according to the embodiments of the present disclosure, the process described with reference to the above flowchart may be implemented as a computer software program. For example, embodiments of the present disclosure include a computer program product including a computer program carried on a computer-readable medium, and the computer program includes 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 by a communication device 809, or installed from a storage device 808, or installed from a ROM 802. When the computer program is executed by a processing device 801, the above functions limited to the method of the embodiments of the present disclosure are executed.

[0086] Note that the computer-readable medium described in the present disclosure may be a computer-readable signal medium, a computer-readable storage medium, or any combination of the above two. The computer-readable storage medium may be, for example, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the above, but is not limited thereto. More specific examples of the computer-readable storage medium may include, but are not limited to, electrical connections having 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 fibers, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the above. In the present disclosure, the computer-readable storage medium may be any tangible medium that includes or stores a program, and the program can be used by or in combination with an instruction execution system, apparatus, or device. In the present disclosure, the computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave carrying computer-readable program code. Such a propagated data signal can take various forms, including, but not limited to, electromagnetic signals, optical signals, or any suitable combination of the above. The computer-readable signal medium may be any computer-readable medium other than the computer-readable storage medium, and the computer-readable signal medium can transmit, propagate, or transmit a program used by or in combination with an instruction execution system, apparatus, or device. The program code included in the computer-readable medium can be transmitted via any suitable medium, and the medium includes, but is not limited to, electric wires, optical cables, RF (radio frequency), etc., or any suitable combination of the above.

[0087] In some embodiments, the client side and the server can communicate using any currently known or future-developed network protocol, such as HTTP (HyperText Transfer Protocol), and can communicate with digital data in any form or medium (e.g., communication network) to interconnect. Examples of communication networks include local area networks ("LAN"), wide area networks ("WAN"), the Internet network (e.g., the Internet), and end-to-end networks (e.g., ad hoc end-to-end networks), and any network currently known or future-developed.

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

[0089] One or more programs are carried on the computer-readable medium, and when the one or more programs are executed by the electronic device, the electronic device is caused to execute the method of the present disclosure described above.

[0090] Computer program code for performing the operations of the present disclosure can be programmed in one or more programming languages or combinations thereof, which include object-oriented programming languages such as Java, Smalltalk, C++, and further include 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, executed as an independent package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer by 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., connected via the Internet using an Internet service provider).

[0091] The flowcharts and block diagrams in the drawings illustrate the possible architectures, functions, and operations of systems, methods, and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagram can represent a module, program segment, or part of code that includes one or more executable instructions for realizing a given logical function. It should be noted that in some alternative embodiments, the functions assigned to the blocks may be realized in an order different from the order shown in the drawings. For example, two consecutively shown blocks may actually be executed basically in parallel, or may be executed in the reverse order depending on the function. It should be noted that each block in the block diagram and / or flowchart diagram, and combinations of blocks in the block diagram and / or flowchart, may be realized by a dedicated hardware-based system for performing a given function or operation, or may be realized by a combination of dedicated hardware and computer instructions.

[0092] The units described in the embodiments of the present disclosure may be implemented in the form of software or in the form of hardware. The name of a unit does not limit the unit itself in some cases.

[0093] The functions described above in this specification can be executed at least partially by one or more hardware logic components. For example, without limitation, typical types of hardware logic components that can be used include field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), system on chips (SOCs), complex programmable logic devices (CPLDs), and the like.

[0094] In the context of the present disclosure, a machine-readable medium may be a tangible medium and may comprise or store a program used in or coupled to an instruction execution system, apparatus, or device. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium include electrical connections by one or more leads, 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 disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0095] According to one or more embodiments of the present disclosure, determining a target cell, displaying a data editing interface in response to a first operation, determining an option data set including N (N is a positive integer) option data based on a second operation on the data editing interface, determining M (M is a positive integer less than or equal to N) cell color schemes based on the N option data in response to a first control displayed on the data editing interface being triggered, and associating the M cell color schemes with the N option data to enable each option data to be displayed based on the associated cell color scheme in the target cell, thereby providing a table processing method.

[0096] The table processing method provided by one or more embodiments of the present disclosure further includes displaying an option interface in response to a third operation by the user on the target cell, displaying the N option data based on the M cell color schemes in the option interface, filling the target cell with the target option data in response to the user determining the target option data from the option interface, and displaying the target option data in the target cell with the cell color scheme associated with the target option data.

[0097] The table processing method provided by one or more embodiments of the present disclosure further includes displaying, within the target cell, the input option data with the cell color scheme associated with the input option data in response to the user inputting one or more of the N option data into the target cell.

[0098] According to one or more embodiments of the present disclosure, the cell color scheme includes settings for the background color of the cell and / or settings for the text color of the cell.

[0099] According to one or more embodiments of the present disclosure, determining M cell color schemes based on the N option data in response to triggering of a first control displayed on the data editing interface includes determining M initial cell color schemes in response to triggering of the first control displayed on the data editing interface. The method further includes displaying a color selection interface for editing the cell color scheme for the N option data, and determining the M cell color schemes based on an operation of the user on the color selection interface.

[0100] According to one or more embodiments of the present disclosure, displaying the color selection interface includes displaying the color selection interface in response to triggering of a second control displayed on the data editing interface.

[0101] According to one or more embodiments of the present disclosure, displaying the N option data on the color selection interface, where each option data corresponds to one color selection label, and determining the M cell color schemes based on an operation of the user on the color selection interface includes displaying a cell color scheme set interface in which a plurality of cell color schemes are displayed in response to triggering of a first color selection label corresponding to a first option data, determining a first cell color scheme in response to an operation of the user on the cell color scheme set interface, and determining the first cell color scheme as the cell color scheme corresponding to the first option data, where the first option data is any one of the N option data.

[0102] According to one or more embodiments of the present disclosure, the initial display color of the first color selection label corresponds to one of the M initial cell color schemes, and after determining the first cell color scheme, the display color of the first color selection label corresponds to the first cell color scheme.

[0103] According to one or more embodiments of the present disclosure, N is equal to M, and various option data respectively correspond to one color display scheme.

[0104] According to one or more embodiments of the present disclosure, determining the M cell color schemes includes determining the M cell color schemes from a predetermined set of cell color schemes in a predetermined order.

[0105] According to one or more embodiments of the present disclosure, determining an option data set based on a second operation on the data editing interface includes citing, as the option data set, a cell data set corresponding to the at least one cell in response to a selection operation of at least one cell in the table.

[0106] According to one or more embodiments of the present disclosure, displaying the N option data on the color selection interface includes displaying the N option data on the color selection interface based on the arrangement order of the cited cell data when the option data set cites cell data in the table.

[0107] The table processing method provided by one or more embodiments of the present disclosure further includes re-associating a cell color scheme with second option data corresponding to the second data when a predetermined operation is performed on the second data in the cell data set, where the predetermined operation is used to adjust the positional order of the second data in the cell data set, and the second data is any one data in the cell data set.

[0108] According to one or more embodiments of the present disclosure, the predetermined operation is a drag-and-drop operation.

[0109] The table processing method provided by one or more embodiments of the present disclosure further includes, when newly adding third data to the cell data set, adding third option data corresponding to the third data to the option data set, and associating a cell color scheme with the third option data.

[0110] The table processing method provided by one or more embodiments of the present disclosure further includes, when deleting fourth data from the cell data set, deleting fourth option data corresponding to the fourth data from the option data set, and deleting the cell color scheme associated with the fourth option data, where the fourth data is any one of the data in the cell data set.

[0111] According to one or more embodiments of the present disclosure, there is provided a table processing apparatus including a cell determination unit for determining a target cell, an interface display unit for displaying a data editing interface in response to a first operation, an option data determination unit for determining an option data set including N (N is a positive integer) option data based on a second operation on the data editing interface, a color scheme determination unit for determining M (M is a positive integer less than or equal to N) cell color schemes based on the N option data in response to a first control displayed on the data editing interface being triggered, and a color scheme association unit for making each option data displayable based on the cell color scheme associated with the target cell by associating the M cell color schemes with the N option data.

[0112] According to one or more embodiments of the present disclosure, there is provided an electronic device including at least one memory and at least one processor, wherein the memory is used for storing program code, and the processor is configured to call the program code stored in the memory to cause the electronic device to execute any of the table processing methods provided by one or more embodiments of the present disclosure.

[0113] According to one or more embodiments of the present disclosure, there is provided a non-transitory computer storage medium storing program code that, when executed by a computer device, causes the computer device to execute any of the table processing methods provided by one or more embodiments of the present disclosure.

[0114] The above description is merely an explanation of the preferred embodiments of the present disclosure and the technical principles used. As will be understood by those skilled in the art, the scope of the disclosure covered by the present disclosure is not limited to the technical solutions formed by specific combinations of the above technical features. Without departing from the concept of the above disclosure, other technical solutions formed by arbitrarily combining the above technical features or their equivalent features should also be encompassed simultaneously. For example, technical solutions formed by mutually replacing the above features with technical features having similar functions disclosed in the present disclosure (but not limited thereto) should be encompassed.

[0115] Also, although each operation has been described in a specific order, it should not be understood that these operations are required to be executed in the specific order or sequential order shown. In certain environments, multitasking and parallel processing may be advantageous. Similarly, although the above considerations include multiple specific implementation details, these should not be construed as limitations on the scope of the present disclosure. Some features described in the context of individual embodiments may be further combined and implemented in a single embodiment. Conversely, various features described in the context of a single embodiment may be implemented in multiple embodiments individually or in any suitable sub-combination.

[0116] Although the subject matter has been described using language specific to structural features and / or methodological acts, it should be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or acts described above. On the contrary, the specific features and acts described above are merely exemplary forms for implementing the claims.

Claims

1. A table processing method, comprising determining a target cell, displaying a data editing interface in response to a first operation, determining an option data set including N option data which are positive integers based on a second operation on the data editing interface, determining M cell color schemes which are positive integers less than or equal to N based on the N option data in response to a first control displayed on the data editing interface being triggered, associating the M cell color schemes with the N option data to enable each option data to be displayed based on the associated cell color scheme in the target cell, displaying an option interface in response to a third operation by the user on the target cell, displaying the N option data based on the M cell color schemes in the option interface, further comprising filling the target cell with the target option data and displaying the target option data in the target cell in the cell color scheme associated with the target option data in response to the user determining the target option data from the option interface, or further comprising displaying the input option data in the target cell in the cell color scheme associated with the input option data within the target cell in response to the user inputting one or more of the N option data into the target cell, Determining the option data set based on the second operation on the data editing interface includes citing, as the option data set, a cell data set corresponding to the at least one cell in response to a selection operation on at least one cell in the table, A table processing method, characterized by the above.

2. The table processing method according to claim 1, wherein the cell color scheme includes settings for the background color of the cell and / or settings for the text color of the cell.

3. Determining M cell color schemes based on the N option data in response to a first control displayed on the data editing interface being triggered In response to a first control displayed on the data editing interface being triggered, determining M initial cell color scheme schemes, The table processing method is displaying a color selection interface for editing a cell color scheme for the N option data, further comprising determining the M cell color schemes based on an operation by a user on the color selection interface. The table processing method according to claim 1.

4. Displaying the color selection interface includes, in response to a second control displayed on the data editing interface being triggered, displaying the color selection interface. The table processing method according to claim 3.

5. displaying the N option data on the color selection interface, each of the option data corresponding to one color selection label, Determining the M cell color schemes based on an operation by the user on the color selection interface includes, in response to a first color selection label corresponding to first option data being triggered, displaying a cell color scheme set interface on which a plurality of cell color schemes are displayed; determining a first cell color scheme in response to an operation by the user on the cell color scheme set interface; determining the first cell color scheme as the cell color scheme corresponding to the first option data. The first option data is any one of the N option data. The table processing method according to claim 3.

6. An initial display color of the first color selection label corresponds to one of the M initial cell color schemes, After determining the first cell color scheme, a display color of the first color selection label corresponds to the first cell color scheme. The table processing method according to claim 5.

7. N is equal to M, and each type of option data corresponds to one color display scheme, respectively. The table processing method according to claim 1.

8. Determining the M cell color schemes Determining the M cell color schemes according to a predetermined order from a predetermined set of cell color schemes, characterized by including: The table processing method according to claim 1.

9. Displaying the N option data on the color selection interface, When the option data set quotes cell data in a table, displaying the N option data on the color selection interface based on the array order of the quoted cell data, characterized by including: The table processing method according to claim 5.

10. When a predetermined operation is performed on the second data in the cell data set, further including re-associating a cell color scheme with the second option data corresponding to the second data, The predetermined operation is used to adjust the positional order of the second data in the cell data set, and the second data is any one of the data in the cell data set, characterized by: The table processing method according to claim 1.

11. The table processing method according to claim 10, characterized in that the predetermined operation is a drag-and-drop operation.

12. When a third data is newly added to the cell data set, adding a third option data corresponding to the third data to the option data set, and further including associating a cell color scheme with the third option data, characterized by:

13. When a fourth data is deleted from the cell data set, deleting the fourth option data corresponding to the fourth data from the option data set, and further deleting the cell color scheme associated with the fourth option data, The fourth data is any one of the data in the cell data set, characterized by: The table processing method according to claim 1.

14. A cell determination unit for determining a target cell, An interface display unit for displaying a data editing interface in response to a first operation, An option data determination unit for determining an option data set including N option data that are positive integers based on a second operation on the data editing interface, In response to triggering of a first control displayed on the data editing interface, a color scheme determination unit for determining M cell color schemes which are positive integers not exceeding N based on the N option data; a color scheme association unit for making each option data displayable in the target cell based on the associated cell color scheme by associating the M cell color schemes with the N option data; In response to a third operation by a user on the target cell, an option interface is displayed; in the option interface, displaying the N option data based on the M cell color schemes; and an option interface display unit used for filling the target cell with the target option data and displaying the target option data in the target cell in the cell color scheme associated with the target option data in response to the user determining the target option data from the option interface; or a second target data display unit used for displaying, in the target cell, the input option data in the cell color scheme associated with the input option data in response to the user inputting one or more of the N option data into the target cell; The option data determination unit is further used for citing, as the option data set, a cell data set corresponding to the at least one cell in response to a selection operation on at least one cell in the table; A table processing device.

15. An electronic device including at least one memory and at least one processor, wherein the memory is used for storing program code, and the processor is used for calling the program code stored in the memory so that the electronic device executes the method according to any one of Claims 1 to 13. An electronic device.

16. A non-transitory computer storage medium, characterized in that program code for causing a computer device to execute the method according to any one of Claims 1 to 13 is stored therein when the computer device executes the program.

Images