A table data processing method, device, equipment and medium

Abstract

The embodiment of the present application discloses a method for processing table data, and sequence verification and a corresponding reference range can be set for any cell (first cell) in the table, and the reference range can include one or more cells. After determining the reference range corresponding to the first cell, the color corresponding to each cell in the reference range is obtained. The target data entered by the user in the first cell is obtained, and it is determined whether the target data matches the data in the second cell in the reference range. If it matches, the target data in the first cell is rendered according to the color corresponding to the second cell. That is, when the target data entered in the first cell matches the data of a cell in the reference range, the target data is rendered using the color corresponding to the cell, so that the user can intuitively know through the color that the target data entered in the first cell meets the sequence verification, thereby improving the user experience.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to a table data processing method, device, equipment and medium. Background Art

[0002] A spreadsheet, also known as an electronic data table, is a cell consisting of a series of rows and columns, which can store values, formulas, or text. Currently, spreadsheets support setting data validation for cells, so that data validation can be used to add certain restrictions to the input data. For example, restricting cells to only allow specific values ​​to be entered. Among them, sequence validation, as a subset of data validation, supports validation of cell text. If the text of a cell is any item in the sequence, it passes the validation.

[0003] In actual applications, in addition to supporting custom sequences, sequence validation also supports referencing cell text in a preset range as a sequence. For example, if the reference range of the sequence validation set for cell x is A1:A3, the text allowed to be entered in cell x is the text corresponding to each cell in A1, A2, and A3.

[0004] However, the current processing method of sequence verification is relatively simple. The data entered by the user is rendered in the cell through verification, which cannot provide better results for the user and affects the user experience. Summary of the invention

[0005] In view of this, the embodiments of the present application provide a table data processing method, device, equipment and medium to render the corresponding color for the text of the cell when it passes the verification, thereby improving the intuitiveness and user experience.

[0006] To achieve the above purpose, the technical solutions provided by the embodiments of the present application are as follows:

[0007] In a first aspect of an embodiment of the present application, a table data processing method is provided, the method comprising:

[0008] In response to a setting operation triggered by a user, obtaining a reference range corresponding to a sequence verification set for a first cell, wherein the reference range includes one or more cells;

[0009] Get the color corresponding to each cell in the reference range;

[0010] In response to an input operation triggered by a user, acquiring target data input by the user in the first cell;

[0011] In response to the target data matching the data in a second cell in the reference range, the target data in the first cell is rendered according to a color corresponding to the second cell, where the second cell is any cell in the reference range.

[0012] In a second aspect of an embodiment of the present application, a table data processing device is provided, the device comprising:

[0013] A first acquisition unit, configured to acquire, in response to a setting operation triggered by a user, a reference range corresponding to a sequence verification set for a first cell, wherein the reference range includes one or more cells;

[0014] A second obtaining unit is used to obtain the color corresponding to each cell in the reference range;

[0015] A third acquisition unit, configured to acquire target data input by the user in the first cell in response to an input operation triggered by the user;

[0016] A rendering unit is used to render the target data in the first cell according to a color corresponding to the second cell in response to the target data matching the data in the second cell in the reference range, where the second cell is any cell in the reference range.

[0017] In a third aspect of the embodiments of the present application, an electronic device is provided, the device comprising: a processor and a memory;

[0018] The memory is used to store instructions or computer programs;

[0019] The processor is used to execute the instructions or computer programs in the memory so that the electronic device executes the table data processing method.

[0020] In a fourth aspect of the embodiments of the present application, a computer-readable storage medium is provided, wherein instructions are stored in the computer-readable storage medium. When the instructions are executed on a device, the device executes the table data processing method.

[0021] In a fifth aspect of the implementation of the present application, a computer program product is provided, wherein the computer program product includes a computer program, and when the computer program is executed by a processor, the processor implements the above-mentioned table data processing method.

[0022] It can be seen that the embodiments of the present application have the following beneficial effects:

[0023] In an embodiment of the present application, for any cell (first cell) in a table, a sequence verification in data verification and a reference range corresponding to the sequence verification can be set for it, and the reference range may include one or more cells. After determining the reference range corresponding to the first cell, the color corresponding to each cell in the reference range is obtained. The target data entered by the user in the first cell is obtained, and it is determined whether the target data matches the data in the second cell in the reference range. If it matches, the target data in the first cell is rendered according to the color corresponding to the second cell. Among them, the second cell is any cell in the reference range. That is, when the target data entered in the first cell matches the data of a cell in the reference range, the target data is rendered using the color corresponding to the cell, so that the user can intuitively know through the color that the target data entered in the first cell meets the sequence verification, thereby improving the user experience. BRIEF DESCRIPTION OF THE DRAWINGS

[0024] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0025] Figure 1 A flow chart of a client skin processing method provided in an embodiment of the present application;

[0026] Figure 2a A schematic diagram of a page for setting sequence verification provided in an embodiment of the present application;

[0027] Figure 2b A schematic diagram of a scenario for determining a reference scope provided in an embodiment of the present application;

[0028] Figure 2c A schematic diagram of a reference scenario provided for an embodiment of the present application;

[0029] Figure 2d A schematic diagram of another application scenario provided for an embodiment of the present application;

[0030] Figure 2e A color diagram of an editing option provided in an embodiment of the present application;

[0031] Figure 3a A schematic diagram of a rendering effect provided in an embodiment of the present application;

[0032] Figure 3b A schematic diagram of another rendering effect provided in an embodiment of the present application;

[0033] Figure 3c A schematic diagram of display options provided in an embodiment of the present application;

[0034] Figure 4 A schematic diagram of a device structure provided in an embodiment of the present application;

[0035] Figure 5 A schematic diagram of the structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0036] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0037] As a data validation method, sequence validation supports the validation of data entered into a cell. When the data entered into a cell is any item in a specified sequence, the validation passes and the entered data is displayed in the cell; otherwise, the user is prompted that the data entered is illegal. Currently, the way sequence validation reflects the validation results is relatively simple. When the validation passes, the data is displayed in the cell, which cannot give the user an intuitive feeling and affects the user experience.

[0038] Based on this, an embodiment of the present application provides a table data processing method. When performing sequence verification on the data entered in the first cell in the table, if the data entered in the first cell belongs to the data limited by a cell in the reference range corresponding to the sequence verification, the data in the first cell is rendered using the color corresponding to the cell to enhance the rendering effect of the first cell, facilitate user viewing, and improve user experience.

[0039] To facilitate understanding of the technical solution provided by the embodiments of the present application, it will be described below with reference to the accompanying drawings.

[0040] See also Figure 1 , which is a flow chart of a table data processing method provided in an embodiment of the present application, such as Figure 1 As shown, the method may include:

[0041] S101: In response to a setting operation triggered by a user, a reference range corresponding to a sequence verification set for a first cell is obtained.

[0042] In this embodiment, the user can set sequence verification for the first cell in the table, and then obtain the reference range corresponding to the sequence verification, which may include one or more cells. Among them, the selection area corresponding to the reference range can be divided into the following cases: ordinary selection area, row selection area and column selection area. The ordinary selection area refers to the corresponding starting row and ending row, and the expression is [number of columns] [number of rows]: [number of columns] [number of rows]. For example, the selection area corresponding to the reference range is A1: B3; the row selection area refers to the selection area corresponding to the starting row and the ending row, and the number of columns is equal to the number of columns in the table, and the expression is [number of rows]: [number of rows]. For example, the selection area corresponding to the reference range is 3:6, that is, all columns between the 3rd row and the 6th row; the column selection area refers to the corresponding starting column and the ending column, and the number of rows is equal to the number of rows in the table. For example, the selection area corresponding to the reference range is C: E, that is, all rows between the Cth column and the Eth column.

[0043] See also Figure 2a As shown, for the C1 cell in the table, right-click to enter the data validation page, where you can select the validation conditions. For the validation conditions for sequence validation, you can select single selection or multiple selection. Single selection means that the set cell C1 (the first cell) is allowed to enter a single data, and multiple selection means that the set cell C1 is allowed to enter multiple data. After determining the validation conditions, select the reference data in "Option Source" to set the reference range. Figure 2b As shown, the verification condition is "single choice" and the reference range of the referenced data is A1:A4.

[0044] S102: Get the color corresponding to each cell in the reference range.

[0045] After determining the reference range corresponding to the first cell, the color corresponding to each cell in the reference range, that is, the color of the option corresponding to each cell, is obtained. Each cell in the reference range corresponds to an option, so that the first cell can reference the option.

[0046] Specifically, the color corresponding to each cell in the reference range can be obtained in the following two ways: one is, in response to no data being entered into the cells in the reference range, that is, no option is set for the cells in the reference range, the color corresponding to each cell in the reference range is determined according to the preset color configuration rule. For example, randomly configure the color for each cell in the reference range. Figure 2c As shown, the reference range set for cell C1 is A1:A4, but there is currently no data option for A1:A4. After the user selects the "Option Color" control, the system automatically configures different colors for the four cells in A1-A4.

[0047] The other is to determine the color set by the user for each cell in the reference range in response to data entered into the cells in the reference range and the setting operation triggered by the user. That is, if there are options in the cells in the reference range, the user can set the color corresponding to the options in each cell. Specifically, when there are options in the cells in the reference range, the system can also pre-configure the color for each option in the reference range, and on this basis, the user can modify the color of each option in the reference range. For example Figure 2d As shown, the reference range set for cell C1 is A1:A4 and the options for A1-A4 are 1-4 respectively. The user can enter the page for editing the option color by clicking the option color editing control in the data validation page. On this page, the color configured by the system for each option can be displayed. For example, option 1 is blue, option 2 is red, option 3 is green, and option 4 is yellow. The user can display the color palette by clicking the drop-down control before the option to configure the color for the option through the color palette. For example Figure 2e As shown, the color palette is displayed by triggering the drop-down control of option 1.

[0048] S103: In response to an input operation triggered by the user, obtaining target data input by the user in the first cell.

[0049] S104: In response to the target data matching the data in the second cell in the reference range, the target data in the first cell is rendered along the edge corresponding to the second cell.

[0050] In this embodiment, after setting the reference range of the sequence verification corresponding to the first cell, the user can enter the target data in the first cell. The target data may be data within the reference range or may not be data within the reference range. Furthermore, the user can enter one target data in the first cell, such as when the verification condition is single selection, or can enter multiple target data in the first cell, such as when the verification condition is multiple selection. For each target data entered by the user in the first cell, the target number will be verified according to the data of each cell in the preset reference range. If the target data matches the data in a cell (the second cell) within the reference range, the target data in the first cell will be rendered according to the color corresponding to the cell.

[0051] Optionally, in response to the target data matching the data in the second cell in the reference range, the target data is rendered according to the color corresponding to the second cell and a preset rendering method. The rendering method is used to indicate the presentation form of the target data in the first cell. For example, the rendering method may include wrapping the target data with a capsule, and the color of the capsule is the color corresponding to the second table. Of course, other rendering methods are also possible, and this application does not limit this. For example Figure 3aAs shown, the user enters the target data 2 in the cell C1 option, and through sequence verification, it is determined that it matches the data 2 in the cell A2 in the reference range, so a capsule is rendered in cell C1 to wrap the data 2, and the color of the capsule is the same as the color corresponding to the data 2 in A2.

[0052] It should be noted that in actual applications, after configuring the color of the options for each cell in the preset range, the color of the referenced cell option will be displayed in the first cell only when the option of the cell in the referenced range is referenced, and the color of the option is usually not displayed in the original cell. Figure 3a The color of the A2 option is displayed through a pill, and the corresponding color is not displayed in the A2 cell.

[0053] Another example Figure 3b As shown, when the verification condition corresponding to cell C1 is multiple selection, multiple target data 1, 2, and 3 can be entered in C1. Through verification, it is determined that the target data 1 matches the data of A1, the target data 2 matches the data of A2, and the target data 3 matches the data of A3. Then, they are rendered in C1 respectively, and the color of the capsule wrapping the target data 1 is the color corresponding to A1, the color of the capsule wrapping the target data 2 is the color corresponding to A2, and the color of the capsule wrapping the target data 3 is the color corresponding to A3.

[0054] Optionally, when the user enters the target data in the first cell, he can enter it manually or select the required data through the drop-down method. Specifically, when setting the reference range of the sequence verification of the first cell, you can select "Show drop-down control" to display the drop-down control in the first cell. By clicking the drop-down control, you can view the data corresponding to each cell in the reference range. For example Figure 2b and Figure 3c As shown in the figure, if you select Show drop-down arrow, a drop-down arrow will be displayed in cell C1. Through the drop-down arrow, you can view the data 1-4 in the reference range, and the user can select from them. Figure 3c As shown, the options viewed through the drop-down arrow have been rendered based on the color of the cell. After the user selects any of the options, the option can be directly displayed in C1.

[0055] Optionally, when viewing the options that can be entered through the drop-down control, the user can also use the search control in the option page to search for the option that the user wants to enter. If the option that the user wants to enter is within the reference range, the option is directly displayed; if the option that the user wants to enter is not within the reference range, the user is prompted that the option that the user is looking for does not exist.

[0056] It can be seen that for any cell (first cell) in the table, the sequence verification in the data validation and the reference range corresponding to the sequence verification can be set, and the reference range can include one or more cells. After determining the reference range corresponding to the first cell, the color corresponding to each cell in the reference range is obtained. The target data entered by the user in the first cell is obtained, and it is determined whether the target data matches the data in the second cell in the reference range. If it matches, the target data in the first cell is rendered according to the color corresponding to the second cell. Among them, the second cell is any cell in the reference range. That is, when the target data entered in the first cell matches the data of a cell in the reference range, the target data is rendered using the color corresponding to the cell, so that the user can intuitively know through the color that the target data entered in the first cell meets the sequence verification, thereby improving the user experience.

[0057] Optionally, in this embodiment, when configuring colors for cells in a reference range, the data structure of the colors corresponding to the cells in the reference range can be an array, such as a one-dimensional array or a two-dimensional array. The position of the color corresponding to the second cell in the array is determined by the second cell and the upper left cell in the reference range. That is, the position of the second cell color in the array is determined by the relative position of the second cell and the upper left cell in the reference range.

[0058] Specifically, the array row identifier of the color corresponding to the second cell is the difference between the row number of the second cell and the row number of the third table, and the array list identifier is the difference between the column number of the second table and the column number of the third table, and the third table is the upper left corner cell of the reference range. For example, if the reference range is B2:C4, the color corresponding to C4 is color[2][1], where 2=4-2, 1=CB=2-1, and the color corresponding to B2 is color[0][0].

[0059] It should be noted that in this embodiment, the position of the cell color is determined by relative position, so that when the size of the reference range changes, the color of the cells in the reference range can be adjusted as little as possible and efficiently. Specifically, in response to the change in the size of the reference range, the colors corresponding to the cells in the reference range are adjusted in batches. Among them, the change in the size of the reference range refers to the addition and deletion of rows in the reference range, resulting in a change in the size of the reference range. For example, taking the cell color as a two-dimensional array, the size of the reference range is n rows and m columns, to delete the i-th row, it is only necessary to move the color of the ni row forward.

[0060] Optionally, when the position of the reference range changes, such as cutting and pasting, dragging, adding or deleting rows outside the reference range, there is no need to adjust the cell color because the position of the cell color is the position of the cell relative to the upper left cell of the reference range.

[0061] Among them, the change in the size of the reference range may include the change in the size of the common selection, the change in the size of the row selection, and the change in the size of the column selection. Specifically, the change in the size of the common selection includes adding and deleting rows and columns in the common selection. The change in the size of the row selection may include modifying the number of rows in the row selection and the change in the number of columns of the sub-table where the row selection is located, wherein the change in the number of columns of the sub-table where the row selection is located may include: adding and deleting columns in the sub-table where the row selection is located and the change in the sub-table where the row selection is located, and the number of columns of the changed sub-table is different from that of the atomic table. The change in the size of the column selection may include modifying the number of columns in the column selection and the change in the number of rows of the sub-table where the column selection is located, wherein the change in the number of rows of the sub-table where the column selection is located may include: adding and deleting rows in the sub-table where the column selection is located and the change in the sub-table where the column selection is located, and the number of rows of the changed sub-table is different from that of the atomic table.

[0062] Based on the above method embodiment, the embodiment of the present application provides a table data processing device, which will be described below in conjunction with the accompanying drawings.

[0063] See also Figure 4 , which is a structural diagram of a table data processing device provided in an embodiment of the present application, such as Figure 4 As shown, the device 400 may include: a first acquisition unit 401 , a second acquisition unit 402 , a third acquisition unit 403 and a rendering unit 404 .

[0064] A first acquisition unit 401 is used to acquire a reference range corresponding to a sequence verification set for a first cell in response to a setting operation triggered by a user, where the reference range includes one or more cells;

[0065] The second acquisition unit 402 is used to acquire the color corresponding to each cell in the reference range;

[0066] A third acquisition unit 403 is used to acquire target data input by the user in the first cell in response to an input operation triggered by the user;

[0067] The rendering unit 404 is used to render the target data in the first cell according to the color corresponding to the second cell in response to the target data matching the data in the second cell in the reference range, where the second cell is any cell in the reference range.

[0068] In a specific implementation, the rendering unit 404 is specifically used to render the target data in response to the target data matching the data in the second cell in the reference range according to the color corresponding to the second cell and a preset rendering method, and the rendering method is used to indicate the presentation form of the target data in the first cell.

[0069] In a specific implementation manner, the rendering method includes using a capsule to wrap the target data, and the color of the capsule is the color corresponding to the second table.

[0070] In a specific implementation, the second acquisition unit 402 is specifically used to determine the color corresponding to each cell in the reference range according to a preset color configuration rule in response to no data being entered into the cells in the reference range; and to determine the color set by the user for each cell in the reference range in response to data being entered into the cells in the reference range and a setting operation triggered by the user.

[0071] In a specific implementation, the data structure of the colors corresponding to the cells in the reference range is an array.

[0072] In a specific implementation, the position of the color corresponding to the second cell in the array is determined by the second cell and the upper left corner cell in the reference range.

[0073] In a specific implementation, the array row identifier of the color corresponding to the second cell is the difference between the row number of the second table and the row number of the third table, and the array column identifier is the difference between the column number of the second table and the column number of the third table, and the third table is the upper left cell of the reference range.

[0074] In a specific implementation, the selection area corresponding to the reference range is a common selection area, a row selection area or a column selection area. The common selection area refers to the selection area corresponding to the starting row and column and the ending row and column, the row selection area refers to the selection area corresponding to the starting row and the ending row, and the column selection area refers to the selection area corresponding to the starting column and the ending column.

[0075] In a specific implementation, the change in the size of the reference range refers to the addition or deletion of rows and columns in the common selection area, the change in the number of rows in the row selection area or the change in the number of columns in the sub-table where the row selection area is located, the change in the number of columns in the column selection area or the change in the number of rows in the sub-table where the column selection area is located.

[0076] In a specific implementation, the device further includes: an adjustment unit;

[0077] The adjustment unit is specifically used to batch adjust the colors corresponding to the cells in the reference range in response to a change in the size of the reference range.

[0078] In a specific implementation, the verification conditions of the sequence verification include single selection and multiple selection, the single selection is used to indicate that a single data is allowed to be entered in the first cell, and the multiple selection is used to indicate that multiple data are allowed to be entered in the first cell.

[0079] It should be noted that the implementation of each unit in this embodiment can refer to the relevant description in the above method embodiment, and this embodiment will not be repeated here.

[0080] See also Figure 5 , which shows a schematic diagram of the structure of an electronic device 500 suitable for implementing the embodiment of the present application. The electronic device in the embodiment of the present application may include but is not limited to mobile terminals such as mobile phones, laptop computers, digital broadcast receivers, PDAs (Personal Digital Assistants), PADs (portable android devices), PMPs (Portable Media Players), vehicle-mounted terminals (such as vehicle-mounted navigation terminals), etc., and fixed terminals such as digital TVs (televisions), desktop computers, etc. Figure 5 The electronic device shown is merely an example and should not bring any limitation to the functions and scope of use of the embodiments of the present application.

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

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

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

[0084] The electronic device provided in the embodiment of the present application and the table data processing method provided in the above embodiment belong to the same inventive concept. The technical details not fully described in this embodiment can be referred to the above embodiment, and this embodiment has the same beneficial effects as the above embodiment.

[0085] An embodiment of the present application provides a computer-readable medium having a computer program stored thereon, wherein when the program is executed by a processor, the table data processing method as described in any of the above embodiments is implemented.

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

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

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

[0089] The computer-readable medium carries one or more programs. When the one or more programs are executed by the electronic device, the electronic device executes the table data processing method.

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

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

[0092] The units involved in the embodiments described in this application may be implemented by software or hardware. The name of a unit / module does not limit the unit itself in some cases. For example, a voice data acquisition module may also be described as a "data acquisition module".

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

[0094] In the context of the present application, a machine-readable medium may be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, device, or equipment. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or equipment, or any suitable combination of the foregoing. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0095] It should be noted that the various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments, and the same or similar parts between the various embodiments can be referred to each other. For the system or device disclosed in the embodiment, since it corresponds to the method disclosed in the embodiment, the description is relatively simple, and the relevant parts can be referred to the method part description.

[0096] It should be understood that in the present application, "at least one (item)" means one or more, and "plurality" means two or more. "And / or" is used to describe the association relationship of associated objects, indicating that three relationships may exist. For example, "A and / or B" can mean: only A exists, only B exists, and A and B exist at the same time, where A and B can be singular or plural. The character " / " generally indicates that the objects associated before and after are in an "or" relationship. "At least one of the following" or similar expressions refers to any combination of these items, including any combination of single or plural items. For example, at least one of a, b or c can mean: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", where a, b, c can be single or multiple.

[0097] It should also be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the presence of other identical elements in the process, method, article or device including the elements.

[0098] The steps of the method or algorithm described in conjunction with the embodiments disclosed herein may be implemented directly using hardware, a software module executed by a processor, or a combination of the two. The software module may be placed in a random access memory (RAM), a memory, a read-only memory (ROM), an electrically programmable ROM, an electrically erasable programmable ROM, a register, a hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.

[0099] The above description of the disclosed embodiments enables those skilled in the art to implement or use the present application. Various modifications to these embodiments will be apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present application. Therefore, the present application will not be limited to the embodiments shown herein, but will conform to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A table data processing method, characterized in that: The method comprises: In response to a setting operation triggered by a user, a reference range corresponding to a sequence verification set for a first cell is obtained, the reference range includes one or more cells, and a verification condition of the sequence verification includes a single selection and a multiple selection, the single selection is used to indicate that a single data entry is allowed in the first cell, and the multiple selection is used to indicate that multiple data entry is allowed in the first cell; Get the color corresponding to each cell in the reference range; In response to an input operation triggered by a user, acquiring target data input by the user in the first cell; In response to the target data matching the data in a second cell in the reference range, the target data in the first cell is rendered according to a color corresponding to the second cell, the second cell being any cell in the reference range.

2. The method according to claim 1, characterized in that In response to the target data matching the data in the second cell in the reference range, rendering the target data in the first cell according to the color corresponding to the second cell includes: In response to the target data matching the data in the second cell in the reference range, the target data is rendered according to the color corresponding to the second cell and a preset rendering method, where the rendering method is used to indicate the presentation form of the target data in the first cell.

3. The method according to claim 2, characterized in that The rendering method includes using a capsule to wrap the target data, and the color of the capsule is the color corresponding to the second cell.

4. The method according to claim 1, characterized in that The method of obtaining the color corresponding to each cell in the reference range includes: In response to no data being input into the cells within the reference range, determining the color corresponding to each cell within the reference range according to a preset color configuration rule; In response to data being input into cells within the reference range and a setting operation triggered by the user, a color set by the user for each cell within the reference range is determined.

5. The method according to any one of claims 1 to 4, characterized in that: The data structure of the corresponding colors of the cells in the reference range is an array.

6. The method according to claim 5, characterized in that The position of the color corresponding to the second cell in the array is determined by the second cell and the upper left cell in the reference range.

7. The method according to claim 6, characterized in that The array row identifier of the color corresponding to the second cell is the difference between the row number of the second cell and the row number of the third cell, and the array column identifier is the difference between the column number of the second cell and the column number of the third cell. The third cell is the upper left corner cell of the reference range.

8. The method according to claim 1, characterized in that The selection area corresponding to the reference range is a common selection area, a row selection area or a column selection area. The common selection area refers to the selection area corresponding to the starting row and column and the ending row and column, the row selection area refers to the selection area corresponding to the starting row and the ending row, and the column selection area refers to the selection area corresponding to the starting column and the ending column.

9. The method according to claim 8, characterized in that The change in the size of the reference range refers to the addition or deletion of rows and columns in the common selection area, the change in the number of rows in the row selection area or the change in the number of columns in the subtable where the row selection area is located, the change in the number of columns in the column selection area or the change in the number of rows in the subtable where the column selection area is located.

10. The method according to claim 9, characterized in that The method further comprises: In response to a change in the size of the reference range, colors corresponding to cells in the reference range are adjusted in batches.

11. A table data processing device, characterized in that: The device comprises: A first acquisition unit is configured to, in response to a setting operation triggered by a user, acquire a reference range corresponding to a sequence verification set for a first cell, wherein the reference range includes one or more cells, and a verification condition of the sequence verification includes a single selection and a multiple selection, wherein the single selection is used to indicate that a single data entry is allowed in the first cell, and the multiple selection is used to indicate that multiple data entry is allowed in the first cell; A second obtaining unit is used to obtain the color corresponding to each cell in the reference range; A third acquisition unit, configured to acquire target data input by the user in the first cell in response to an input operation triggered by the user; A rendering unit is used to render the target data in the first cell according to a color corresponding to the second cell in response to the target data matching the data in the second cell in the reference range, where the second cell is any cell in the reference range.

12. An electronic device, characterized in that: The device comprises: a processor and a memory; The memory is used to store instructions or computer programs; The processor is used to execute the instructions or computer programs in the memory so that the electronic device executes the table data processing method according to any one of claims 1 to 10.

13. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores instructions, and when the instructions are executed on a device, the device executes the table data processing method according to any one of claims 1 to 10.

Images