TABLE PROCESSING METHOD, DEVICE, ELECTRONIC DEVICE, AND STORAGE MEDIUM

The method and device associate cell coloring schemes with option data to improve data identification by using color representation in spreadsheet technologies.

JP2024542200AActive Publication Date: 2024-11-13BEIJING ZITIAO NETWORK TECH CO LTD
View PDF 5 Cites 0 Cited by

Patent Information

Application Number
JP2024529505
Authority / Receiving Office
JP · JP
Patent Type
Applications
Current Assignee / Owner
Priority Date
2021-11-17
Filing Date
2022-11-17
Publication Date
2024-11-13
Estimated Expiration
2042-11-17

AI Technical Summary

Technical Problem

Existing spreadsheet technologies lack the ability to automatically color options to better convey the meaning of option content, as they can only optionally enter values from a particular sequence and do not utilize color for data presentation.

Method used

A method and device that determine a target cell, display a data editing interface, and associate cell coloring schemes with option data to enhance data identification through color representation.

Benefits of technology

Enhances data identification by using color to convey the meaning of data content effectively.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 2024542200000001_ABST
    Figure 2024542200000001_ABST
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

Description

[Technical field]

[0001] (Reference to Related Application) This application is proposed based on a Chinese patent application bearing application number 202111364825.8, filing date November 17, 2021, and titled "Table Processing Method, Apparatus, Electronic Device, and Storage Medium", and claims priority to the Chinese patent application, the entire contents of which are hereby incorporated by reference into this application.

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

[0003] In a spreadsheet, a cell with a sequence validation function can only input a value from a specific sequence as an option, and the sequence can be self-defined by the user or can be derived from a range of cells that are quoted. The sequence validation function of the related spreadsheet product cannot automatically color the options, has a single display format, and cannot use colors to better convey the meaning of the option content. Summary of the Invention

[0004] This Summary is provided to introduce concepts in a simplified form, and these concepts are described in detail in the Detailed Description section below. This Summary is not intended to identify key or required features of the claimed technical solutions, nor is it intended to be used to limit the scope of the claimed technical solutions.

[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 the first operation; determining an optional data set including N optional data items (N being a positive integer) based on a second operation on the data editing interface; determining M cell coloring schemes based on the N option data in response to a first control displayed on the data editing interface being triggered, where M is a positive integer less than or equal to N; and associating the M cell color schemes with the N optional data so that each optional data can be displayed in the target cell based on the associated cell color scheme.

[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 the first operation; an optional data determination unit for determining an optional data set including N optional data (N being a positive integer) based on a second operation on the data editing interface; a color scheme determination unit for determining M cell color schemes based on the N optional data in response to a first control displayed on the data editing interface being triggered, where M is a positive integer equal to or smaller than N; and a color scheme associating unit for associating the M cell color schemes with the N option data so that each option data can be displayed in the target cell based on the associated cell color scheme.

[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 to store 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, in accordance with one or more embodiments of the present disclosure, there is provided a non-transitory computer storage medium having stored thereon program code which, when executed by a computing device, causes the computing device to perform 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 a first control displayed on the data editing interface being triggered, a cell color scheme is determined based on optional data, and the determined cell color scheme is associated with the optional data, such that each optional data can be displayed in the target cell based on the associated cell color scheme, thereby utilizing color to better convey the meaning of data content and enhance the distinctiveness of the data. [Brief description of the drawings]

[0010] The above and other features, advantages and aspects of the embodiments of the present disclosure will become more apparent from the following detailed description taken in conjunction with the drawings, in which the same or similar reference numerals represent the same or similar elements throughout the drawings. It should be understood that the drawings are schematic and that the elements and components are not necessarily drawn to scale.

[0011] [Figure 1] 4 is a flowchart of a table processing method provided by one embodiment of the present disclosure. [Diagram 2] FIG. 2 is a schematic diagram of a data editing interface provided by one embodiment of the present disclosure. [Diagram 3]FIG. 2 is a schematic diagram of an options interface provided by one embodiment of the present disclosure. [Figure 4] 1 is a schematic diagram of a color editing interface provided by one embodiment of the present disclosure. [Diagram 5] FIG. 2 is a structural schematic diagram of a table processing device provided according to another embodiment of the present disclosure. [Figure 6] FIG. 2 is a structural schematic diagram of an electronic device provided according to an embodiment of the present disclosure. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

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

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

[0014] The term "including" and variations thereof as used herein is an open-ended "including", i.e., "including, but not limited to." The term "based on" is "based at least in part on." The term "in one embodiment" refers to "at least one embodiment." The term "another embodiment" refers to "at least one other embodiment." The term "some embodiments" refers to "at least some embodiments." The term "in response to" and related terms refer to one signal or event being influenced to some extent by another signal or event, but not necessarily completely or directly. When event x occurs "in response to" event y, x can be directly or indirectly responsive 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. Additionally, the term "in response to" may also mean "at least in part responsive to."

[0015] The term "determining" broadly encompasses various operations and may include obtaining, computing, calculating, processing, deriving, investigating, looking up (e.g., looking up in a table, database, or other data structure), searching, and similar operations, as well as receiving (e.g., receiving information), accessing (e.g., accessing data in a memory), and similar operations, as well as analyzing, selecting, choosing, establishing, and similar operations. Relevant definitions of other terms are provided below. Relevant definitions of other terms are provided below.

[0016] It should be noted that concepts such as "first" and "second" referred to in this disclosure are intended merely to distinguish different devices, modules or units, and are not intended to limit the order or interdependence of functions performed by these devices, modules or units.

[0017] It should be noted that the modifications "one" and "multiple" referred to in this disclosure are exemplary and not limiting, and should be understood as "one or more" unless the context clearly indicates otherwise, as will be understood by one of ordinary skill in the art.

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

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

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

[0021] Step S110: A target cell is determined.

[0022] The target cells may be cells selected by the user and may also include cells that are configured to be selected by the user. Illustratively, the user may select one or more target cells by an interaction operation such as a single click or drag, or by a formula entered into the target cells.

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

[0024] For example, 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 sign.

[0025] It should be noted that the predetermined indicator may be located within the interface where the table is located, or may be provided on a multi-level interface entered or opened via the interface where the table is located, and the present disclosure is not limited thereto.

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

[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 of at least one cell in a table, a cell data set corresponding to the at least one cell can be referenced as the optional data set. Illustratively, the selection operation of the at least one cell in a table can include a cell formula entered by a user, or a selection operation of a cell in a table.

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

[0030] Step S170: In response to a first control displayed on the data editing interface being triggered, determine M (M is a positive integer equal to or less than N) cell coloring schemes based on the N optional data.

[0031] In some embodiments, the N optional data may correspond to different cell color schemes, where M is equal to N, and multiple data in the N optional data may share one cell color scheme, where M is less than N. It can be understood that the latter situation may occur after the number of optional data exceeds a given cell color scheme.

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

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

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

[0035] Step S190: Associating the M cell color schemes with the N option data, so that each option data can be displayed in the target cell based on the associated cell color scheme.

[0036] By way of example, reference is made to Figure 2, which shows a schematic diagram of a data editing interface 10. 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 self-defined data in the first input box 13 as an optional data set, or can input a cell formula in the first input box 13 or use the cell selection control 14 to select cell data already existing in the table, and reference the cell data corresponding to the cell formula or the selected cell data as an optional data set.

[0038] The system can determine M cell coloring schemes based on the N option data in response to the first control 11 being selected in the box. It is understood that if the first control 11 is not selected in the box, the system does not need to determine a cell coloring scheme.

[0039] According to one or more embodiments of the present disclosure, in response to a first control displayed on the data editing interface being triggered, a cell color scheme is determined based on optional data, and the determined cell color scheme is associated with the optional data, such that each optional data can be displayed in the target cell based on the associated cell color scheme, thereby utilizing color to better convey the meaning of data content and enhance the distinctiveness of the data.

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

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

[0042] For example, 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, and the like, on a predetermined sign.

[0043] Step A2: In response to a user determining target option data from the option interface, fill the target cell with the target option data, and display 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 optional data with the cell color scheme, the user can trigger the display of an option interface by a third operation on the target cell, in which each optional data is displayed with its associated cell color scheme, and the user can select one or more of the optional data to fill the target cell.

[0045] 3, the user can trigger the drop-down control 21 displayed in the target cell 20 to open the option interface 30. The option interface 30 displays option data with different colors (not shown) as background colors (the outline of the background color is shown as a rounded rectangle), which are "Not very urgent", "Not urgent", "General", "Urgent" and "Very urgent", and the user can select one or more of them to fill the target cell 20, and the options filled in the target cell still retain the background color. As shown in FIG. 3, the user currently selects the "Not urgent" option, and "Not urgent" with a background color is filled in the target cell 20.

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

[0047] Step B1: In response to a user inputting one or more of the N pieces of optional data into the target cell, display the input optional data in the target cell in a cell coloring scheme associated with the input optional data.

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

[0049] In some embodiments, the M cell coloring schemes determined in step S170 may be initial cell coloring schemes or default cell coloring schemes automatically set by the system, and the user may also self-define the cell coloring scheme. The user self-defining the cell coloring scheme may include the following steps C1 and C2.

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

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

[0052] In some embodiments, the color editing interface may be displayed in response to a second control displayed in a data editing interface being triggered. By way of example, and with reference to FIGURE 2, a user may open a color editing interface by triggering a second control 12 displayed in a data editing interface 10.

[0053] In some embodiments, the N optional data are displayed in the color selection interface, and each of the optional data corresponds to one color selection indicator. Step C2 further includes steps c21 to c23.

[0054] Step c21: In response to the first color selection indicator corresponding to the first optional data being triggered, display a cell coloring scheme set interface in which a plurality of cell coloring schemes are displayed, the first optional data being any one of the N optional data.

[0055] Step c22: In response to a user's operation on the cell coloring scheme set interface, a first cell coloring scheme is determined.

[0056] Step c23: The first cell coloring scheme is determined as the cell coloring scheme corresponding to the first option data.

[0057] In some embodiments, an initial display color of the first color selection indicator corresponds to one of the M initial cell coloring schemes, and after determining the first cell coloring scheme, the display color of the first color selection indicator corresponds to the first cell coloring scheme.

[0058] 4, five optional data items, namely, "not very urgent", "not urgent", "general", "urgent" and "very urgent", are displayed on the color selection interface 40, and color selection indicators 41, 42, 43, 44 and 45 are displayed on the left side of each optional data item, respectively. The initial colors of the color selection indicators can correspond to the default initial cell color schemes of the five optional data items by the system, respectively, so that the user can easily grasp the cell color schemes currently corresponding to each optional data item.

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

[0060] According to one or more embodiments of the present disclosure, by displaying the N optional data and corresponding color selection indicators in a color selection interface, the colors of the color selection indicators correspond to the current cell color schemes of the optional data, which facilitates the user to holistically combine and compare the cell color schemes corresponding to each optional data.

[0061] Based on similar steps, the user can reselect new cell color schemes for other optional data, and the colors of the color selection indicators corresponding to the other optional data can change accordingly, which will not be described in detail here.

[0062] In some embodiments, when the optional data set references cell data in a table, the N optional data are displayed in the color selection interface according to the arrangement order of the referenced cell data. For example, when the arrangement order of the referenced cell data is A, B, C, D, the optional data A, B, C, D are displayed in the color selection interface in the corresponding order. When the arrangement order of the referenced cell data is changed, the optional data displayed in the color selection interface is changed in the order.

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

[0064] For example, if the arrangement order of the referenced cell data is A, B, C, and D, when the user moves cell data C between cell data A and B by drag-and-drop operation, the cell color scheme is reassociated with option data C corresponding to cell data C, and the cell color schemes associated with other option data (A, B, D) do not change.

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

[0066] For example, if the cited cell data set changes from "A, B, C, D" to "A, B, C, D, E", the option data set correspondingly changes 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 as a result.

[0067] In some embodiments, when a fourth data item is removed from the cell data set, a fourth optional data item corresponding to the fourth data item is removed from the optional data set, and a cell color scheme associated with the fourth optional data item is removed, the fourth data item being data from any one of the cell data sets.

[0068] In some embodiments, when a drag-and-drop operation occurs on a cell within the citation range of a cell, the number of cell color schemes corresponding to the N pieces of optional data does not change, i.e., the number of the determined M cell color schemes does not change, and a new cell color scheme is re-associated with the optional data corresponding to the citation target cell that has been dragged and dropped, and the cell color scheme associated with the optional data corresponding to the citation target cell that has not been dragged and dropped remains unchanged.

[0069] In some embodiments, when a new cell is inserted into the range of a cell (e.g., a new row or a new column is inserted) or the range of a cell is expanded, new optional data is added accordingly and a cell color scheme is associated with the newly added optional data, and the cell color scheme associated with the original optional data remains unchanged.

[0070] In some embodiments, when a new cell is removed from the range of a cell (e.g., a row or column is removed) or the range of a cell is reduced, the corresponding optional data is correspondingly removed and the corresponding cell color scheme is removed, and the cell color scheme associated with the optional data remains unchanged.

[0071] Accordingly, as shown in FIG. 5, according to one 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 the first operation; an optional data determination unit 650 for determining an optional data set including N optional data (N being a positive integer) based on a second operation on the data editing interface; a color scheme determination unit 670 for determining M cell color schemes (M being a positive integer equal to or less than N) based on the N optional data in response to a first control displayed on the data editing interface being triggered; and a color scheme associating unit 690 for associating the M cell color schemes with the N option data so that each option data can be displayed in the target cell based on the associated cell color scheme.

[0072] According to one or more embodiments of the present disclosure, in response to a first control displayed on the data editing interface being triggered, a cell color scheme is determined based on optional data, and the determined cell color scheme is associated with the optional data, such that each optional data can be displayed in the target cell based on the associated cell color scheme, thereby utilizing color to better convey the meaning of data content and enhance the distinctiveness of the data.

[0073] In some embodiments, the table processing device comprises: an option interface display unit for displaying an option interface in response to a third operation on the target cell by a user, and displaying the N option data in the option interface based on the M cell color schemes; and a first target data display unit for, in response to a user determining 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.

[0074] In some embodiments, the table processing device comprises: and a second target data display unit for, in response to a user inputting one or more of the N optional data into the target cell, displaying the input optional data in a cell coloring scheme associated with the input optional data within the target cell.

[0075] In some embodiments, the color scheme determination unit is adapted to determine M initial cell color schemes in response to a first control displayed on the data editing interface being triggered, and the table processing device further comprises: a color selection interface display unit for displaying a color selection interface for editing a cell color scheme for the N optional data; and a second color scheme determining unit for determining a color scheme of the M cells based on a user's operation on the color selection interface.

[0076] In some embodiments, the table processing device comprises: The method further includes a first reassociation unit for reassociating a cell coloring scheme with second optional data corresponding to the second data when a predetermined operation is performed on second data in the cell data set, the predetermined operation being used to adjust a position order of the second data in the cell data set, and the second data being any one of the data of the cell data sets.

[0077] In some embodiments, the table processing device comprises: When third data is newly added to the cell data set, the optional data set further includes a second reassociation unit for adding third optional data corresponding to the third data, and associating a cell coloring scheme with the third optional data.

[0078] In some embodiments, the table processing device comprises: The method further includes a third re-association unit for, when a fourth data is deleted from the cell data set, deleting a fourth optional data corresponding to the fourth data from the optional data set, and deleting a cell coloring scheme associated with the fourth optional data, wherein the fourth data is data of any one of the cell data sets.

[0079] The device embodiment basically corresponds to the method embodiment, so please refer to the description of some of the method embodiments for the relevant parts. The above-described device embodiment is 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. Those skilled in the art can understand and implement it without any creative efforts.

[0080] Accordingly, in accordance with one or more embodiments of the present disclosure, An electronic device including at least one memory and at least one processor, The memory is used to store program code, and the processor provides an electronic device that invokes the program code stored in the memory to cause the electronic device to perform a table processing method provided by one or more embodiments of the present disclosure.

[0081] Accordingly, in accordance with one or more embodiments of the present disclosure, a non-transitory computer storage medium is provided having stored thereon program code that can be executed by a computing device to cause the computing device to perform a table processing method provided by one or more embodiments of the present disclosure.

[0082] Hereinafter, reference is made to FIG. 6, which shows a structural schematic diagram of an electronic device (such as a terminal device or a server) 800 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 media players), in-vehicle terminals (such as in-vehicle navigation terminals), and fixed terminals such as digital TVs and desktop computers. The electronic device shown in FIG. 6 is merely an example and does not limit the functions and scope of use of the embodiments of the present disclosure.

[0083] 6, the electronic device 800 may include a processing unit (e.g., a central processing unit, an image processing unit, etc.) 801, which may perform various appropriate operations and processes based on programs stored in a read-only memory (ROM) 802 or programs loaded from a storage device 808 into a random access memory (RAM) 803. Various programs and data required for operating the electronic device 800 are further stored in the RAM 803. The processing unit 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] Typically, devices such as input devices 806 including touch screens, touch pads, keyboards, mice, cameras, microphones, accelerometers, gyroscopes, etc., output devices 807 including liquid crystal displays (LCDs), speakers, vibrators, etc., storage devices 808 including magnetic tapes, hard disks, etc., and communication devices 809 can be connected to the I / O interface 805. The communication devices 809 can enable the electronic device 800 to communicate wirelessly or via wires with other devices to exchange data. Although FIG. 6 shows electronic device 800 having various devices, it should be understood that it is not required to implement or include all of the devices shown. More or fewer devices may alternatively be implemented or included.

[0085] In particular, according to an embodiment of the present disclosure, the processes described with reference to the flowcharts above may be implemented as a computer software program. For example, an embodiment of the present disclosure includes a computer program product including a computer program carried on a computer-readable medium, the computer program including program code for performing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network by the communication device 809, or installed from the storage device 808, or installed from the ROM 802. When the computer program is executed by the processing device 801, the above-mentioned functions limited to the method of the embodiment of the present disclosure are performed.

[0086] It should be noted that the computer readable medium described in this disclosure may be a computer readable signal medium or a computer readable storage medium or any combination of both. The computer readable storage medium may be, for example, but is not limited to, an electrical, magnetic, optical, electromagnetic, infrared or semiconductor system, apparatus or device, or any combination of the above. More specific examples of the computer readable storage medium may include, but are not limited to, an electrical connection having one or more wires, a portable computer disk, a hard disk, 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 this disclosure, the computer readable storage medium may be any tangible medium that contains or stores a program, which may be used by or in combination with an instruction execution system, apparatus or device. In this disclosure, the computer readable signal medium may include a data signal, either in baseband or as part of a carrier wave, propagated carrying the computer readable program code. Such a propagated data signal may take various forms, including, but not limited to, an electromagnetic signal, an optical signal, or any suitable combination of the above. A computer-readable signal medium may be any computer-readable medium other than a computer-readable storage medium, which may transmit, propagate, or transmit a program for use by or in connection with an instruction execution system, apparatus, or device. A program code contained in a computer-readable medium may be transmitted by any suitable medium, including, but not limited to, electrical wire, optical cable, RF (radio frequency), or the like, or any suitable combination of the above.

[0087] In some embodiments, the client and server may communicate using any network protocol now known or hereafter developed, such as HTTP (HyperText Transfer Protocol), and may communicate with digital data in any form or medium and interconnect (e.g., a communications network). Examples of communications networks include local area networks ("LANs"), wide area networks ("WANs"), internetworks (e.g., the Internet), and end-to-end networks (e.g., ad hoc end-to-end networks), and any networks now known or hereafter developed.

[0088] The computer-readable medium may be included in the electronic device, or may exist independently of the electronic device.

[0089] The computer-readable medium carries one or more programs that, when executed by the electronic device, cause the electronic device to perform the method of the present disclosure.

[0090] Computer program code for carrying out the operations of the present disclosure may be organized in one or more programming languages ​​or combinations thereof, including object-oriented programming languages ​​such as Java, Smalltalk, C++, and the like, as well as 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, 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 by the Internet using an Internet Service Provider).

[0091] The flowcharts and block diagrams in the drawings illustrate 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 flowcharts or block diagrams may represent a module, a program segment, or a portion of code, which includes one or more executable instructions for implementing a certain logical function. It should be noted that in some alternative implementations, the functions depicted in the blocks may be implemented according to a different order than that depicted in the drawings. For example, two successively shown blocks may actually be executed essentially in parallel, or may be executed in the reverse order depending on the function. It should be noted that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, may be implemented in a dedicated hardware-based system that executes a certain function or operation, or may be implemented in a combination of dedicated hardware and computer instructions.

[0092] The units described in the embodiments of the present disclosure may be realized in the form of software or hardware. The names of the units do not necessarily limit the units themselves.

[0093] The functions described herein above may be performed, at least in part, by one or more hardware logic components. For example, and without limitation, typical 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.

[0094] In the context of this disclosure, a machine-readable medium may be a tangible medium, which may include or store a program for use in or in conjunction with an instruction execution system, device, or apparatus. 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 apparatus, or any suitable combination of the above. More specific examples of machine-readable storage media include an electrical connection with 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 disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above.

[0095] According to one or more embodiments of the present disclosure, there is provided a table processing method including: determining a target cell; displaying a data editing interface in response to a first operation; determining an optional data set including N (N is a positive integer) pieces of optional 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 pieces of optional data in response to a first control displayed in the data editing interface being triggered; and associating the M cell color schemes with the N pieces of optional data, thereby enabling each optional data to be displayed based on the associated cell color scheme in the target cell.

[0096] The table processing method provided by one or more embodiments of the present disclosure further includes: in response to a third operation by a user on the target cell, displaying an option interface and displaying the N option data in the option interface based on the M cell color schemes; and in response to a user determining target option data from the option interface, filling the target option data in the target cell 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, in response to a user inputting one or more of the N optional data into the target cell, displaying the input optional data in the target cell in a cell coloring scheme associated with the input optional data.

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

[0099] According to one or more embodiments of the present disclosure, determining M cell color schemes based on the N optional data in response to a first control displayed on the data editing interface being triggered includes determining M initial cell color schemes in response to a first control displayed on the data editing interface being triggered, the method further including displaying a color selection interface for editing cell color schemes for the N optional data, and determining the M cell color schemes based on a user's operation 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 a second control displayed on the data editing interface being triggered.

[0101] According to one or more embodiments of the present disclosure, displaying the N optional data in the color selection interface, each of the optional data corresponding to one color selection indicator, and determining the M cell color schemes based on the user's operation 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 a first color selection indicator corresponding to first optional data being triggered; determining a first cell color scheme in response to the user's operation on the cell color scheme set interface; and determining the first cell color scheme as the cell color scheme corresponding to the first optional data, wherein the first optional data is any one of the N optional data.

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

[0103] According to one or more embodiments of the present disclosure, N is equal to M, and each type of optional data corresponds to a color display scheme.

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

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

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

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

[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 a third data is newly added to the cell data set, adding a third optional data corresponding to the third data to the optional data set, and associating a cell color scheme with the third optional data.

[0110] The table processing method provided by one or more embodiments of the present disclosure further includes, when a fourth data is deleted from the cell data set, deleting a fourth optional data corresponding to the fourth data from the optional data set, and deleting a cell coloring scheme associated with the fourth optional data, wherein the fourth data is data of any one of the cell data sets.

[0111] According to one or more embodiments of the present disclosure, there is provided a table processing device 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 optional data set including N (N is a positive integer) pieces of optional data based on a second operation on the data editing interface; a color scheme determination unit for determining M (M is a positive integer not greater than N) cell color schemes based on the N pieces of optional data in response to a first control displayed on the data editing interface being triggered; and a color scheme association unit for associating the M cell color schemes with the N pieces of optional data, thereby enabling each optional data to be displayed based on the associated cell color scheme in the target cell.

[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 to store program code, and the processor calls 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, a non-transitory computer storage medium is provided having stored thereon program code that, when executed by a computing device, causes the computing device to perform any of the table processing methods provided by one or more embodiments of the present disclosure.

[0114] The above description is merely a description of the preferred embodiments of the present disclosure and the technical principles used. As can be understood by those skilled in the art, the scope of disclosure covered in the present disclosure is not limited to the technical solution consisting of 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 concept of the above disclosure. For example, it should cover (but is not limited to) the technical solutions formed by mutually replacing the above features with technical features having similar functions disclosed in the present disclosure.

[0115] Also, although operations have been described employing a particular order, this should not be understood as requiring that these operations be performed in the particular order shown or in a sequential order. In certain circumstances, multitasking and parallel processing may be advantageous. Similarly, although the above discussion includes details of several specific implementations, these should not be construed as limitations on the scope of the disclosure. Some features that are described in the context of separate embodiments may also be combined and implemented in a single embodiment. Conversely, various features that are described in the context of a single embodiment may also be implemented in multiple embodiments individually or in any suitable subcombination.

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

Claims

1. A method of processing a table, comprising: determining a target cell; displaying a data editing interface in response to the first operation; determining an optional data set including N optional data items, N being a positive integer, based on a second operation on the data editing interface; determining M cell coloring schemes based on the N option data in response to a first control displayed on the data editing interface being triggered, M being a positive integer less than or equal to N; and associating the M cell color schemes with the N optional data, thereby enabling each optional data to be displayed in the target cell based on the associated cell color scheme.

2. displaying an option interface in response to a third operation on the target cell by a user; displaying the N option data in the option interface based on the M cell color schemes; 2. The method of claim 1, further comprising: in response to a user determining 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.

3. 2. The table processing method of claim 1, further comprising, in response to a user inputting one or more of the N optional data into the target cell, displaying the input optional data in the target cell in a cell coloring scheme associated with the input optional data.

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

5. determining M cell coloring schemes based on the N option data in response to a first control displayed in the data editing interface being triggered includes determining M initial cell coloring schemes in response to a first control displayed in the data editing interface being triggered; The method comprises: displaying a color selection interface for editing a cell color scheme for the N optional data; 2. The method of claim 1, further comprising: determining a color scheme for the M cells based on user interaction with the color selection interface.

6. The displaying of the color selection interface includes:

6. The method of claim 5, further comprising displaying the color selection interface in response to a second control displayed in the data editing interface being triggered.

7. Displaying the N pieces of optional data on the color selection interface, each of the N pieces of optional data corresponding to a color selection indicator; determining the M cell coloring schemes based on a user's operation on the color selection interface, displaying a cell coloring scheme set interface, in response to a first color selection indicator corresponding to the first option data being triggered, the cell coloring scheme set interface having a plurality of cell coloring schemes displayed thereon; determining a first cell coloring scheme in response to a user interaction with the cell coloring scheme set interface; determining the first cell coloring scheme as a cell coloring scheme corresponding to the first option data; 6. The table processing method according to claim 5, wherein the first optional data is any one of the N optional data.

8. an initial display color of the first color selection indicator corresponds to one of the M initial cell coloring schemes; 8. The table processing method according to claim 7, wherein after determining a first cell coloring scheme, a display color of the first color selection indicator corresponds to the first cell coloring scheme.

9. 2. The method of claim 1, wherein N and M are equal, and each of the different optional data corresponds to a color display scheme.

10. Determining the M cell coloring schemes includes:

2. The method of claim 1, further comprising determining the M cell coloring schemes from a set of predetermined cell coloring schemes according to a predetermined order.

11. determining an optional data set based on a second operation on the data editing interface includes:

2. The method of claim 1, further comprising, in response to a selection operation of at least one cell in a table, referencing a cell data set corresponding to the at least one cell as the optional data set.

12. Displaying the N pieces of optional data in the color selection interface includes: The table processing method according to claim 7, further comprising, when the option data set references cell data in a table, displaying the N optional data in the color selection interface based on the arrangement order of the referenced cell data.

13. and when a predetermined operation is performed on second data in the cell data set, reassociating a cell color scheme with second option data corresponding to the second data; 12. The table processing method according to claim 11, wherein the predetermined operation is used to adjust the position order of the second data in the cell data set, and the second data is data of any one of the cell data sets.

14. 14. The table processing method according to claim 13, wherein the predetermined operation is a drag-and-drop operation.

15. The table processing method according to claim 11, further comprising, when a third data is newly added to the cell data set, adding a third optional data corresponding to the third data to the option data set, and associating a cell color scheme with the third optional data.

16. If a fourth data item is deleted from the cell data set, a fourth optional data item corresponding to the fourth data item is deleted from the optional data set, and a cell color scheme associated with the fourth optional data item is deleted.

12. The table processing method according to claim 11, wherein the fourth data is data of one of a cell data set.

17. A table processing device, comprising: a cell determination unit for determining a target cell; an interface display unit for displaying a data editing interface in response to the first operation; an optional data determination unit for determining an optional data set including N optional data items, the N optional data items being a positive integer, based on a second operation on the data editing interface; a color scheme determination unit for determining, in response to a first control displayed on the data editing interface being triggered, M cell color schemes, where M is a positive integer less than or equal to N, based on the N option data; and a color scheme associating unit for associating the M cell color schemes with the N option data so that each option data can be displayed in the target cell based on the associated cell color scheme.

18. An electronic device including at least one memory and at least one processor, An electronic device, characterized in that the memory is used to store program code, and the processor is used to call up the program code stored in the memory so that the electronic device executes the method according to any one of claims 1 to 16.

19. A non-transitory computer storage medium having stored thereon program code which, when executed by a computing device, causes said computing device to carry out a method according to any one of claims 1 to 16.

Citation Information

Patent Citations

  • Document output method

    JP1997305354A

  • Document processing device and method

    JP2000268112A

  • Tabular data displaying method, its display device and recording medium

    JP2001312686A

  • Logical CPU division usage heat map representation

    US20130111386A1

  • Custom visualizations in tab groups

    US8375321B2